STAT$319$ Lab$2($Manually and EXCEL$)$

MATH$101,$ MATH$102$ and ENG$101$ scores of $30$ students are given below.

$\backslash$table$[[$ID No$,$Math$101,$Math$102,$ENG$101],[111,70,80,29],[112,80,85,34],[113,65,76,34],[114,66,77,35],[115,70,80,37],[116,73,83,40],[117,73,83,41],[118,79,88,41],[119,80,87,43],[120,83,90,44],[121,83,90,45],[122,43,43,47],[123,45,60,47],[124,45,60,54],[125,45,60,61],[126,45,60,61],[127,45,60,61],[128,50,62,62],[129,50,62,63],[130,50,62,67],[131,51,63,67],[132,53,66,70],[133,53,67,73],[134,54,69,75],[135,55,70,77],[136,56,71,80],[137,57,72,82],[138,58,74,84],[139,59,75,86],[140,60,76,88]]$

a$)$ Construct $3$ Stem and Leaf plots for MATH$101,$ MATH$102$ and ENG$101$ scores.

b$)$ Prepare $3$ frequency tables for $3$ scores $(9$ classes each$).$ Find the relative frequency and the cumulative relative frequency.

c$)$ Draw histograms for the scores and comment on the shape of the distribution. Also draw Frequency polygon and Cumulative Frequency plot separately.

$2.$ Monthly average rainfall data for city AA are given below. Prepare Bar chart and Pie chart.

$\backslash$table$[[$Month$,$January,February,March,April,May,June$],[$Rainfall $(mm),100,120,150,180,200,300],[$Month$,$July,August,September,October,November,December$],[$Rainfall $(mm),320,280,200,150,120,100]]$