Copy the question in excel and solve it in excel please I don\'t want it to be w

Question

Copy the question in excel and solve it in excel please I don't want it to be written in word I want in EXCEL Sheet Only Question #4 (LO3 10 marks The heights (in inches) of 30 adult males are listed below. 70 72 71 70 69 73 69 68 70 71 67 71 70 74 69 68 71 71 71 72 69 71 68 67 73 70 71 68 A. Construct a frequency distribution table using four classes. B. Construct a frequency histogram using four classes. C. Construct a relative frequency histogram using four classes. D. Construct a frequency Polygon using four classes. E. Construct a Ogive using four classes Frequency Tally Relative Percentage Cumulative Midpoint Class Class Boundary Frequency 67-68 69.70 10 71-72 10 73-74 Totals 30

Explanation / Answer

Sol:

the distance from the upper limit of the first class to the lower limkit of the second class is 68-67=1

Half this distance=0.5

first class lower boundary=67-0.5=66.5

first class upper boundary=68+0.5=68.5

class frequency tally Relative Frequenccy Percentage cumulative freq Midpoint m clas sboundary 67-68 6 IIII/   I =6/30-0.2 0.2*100=20 6 67+68/2=67.5 66.5-68.5 69-70 10 IIII/   IIII/ =10/30=0.333 0.333*100=33.3 6+10=16 69+70/2=69.5 68.5-70.5 71-72 10 IIII/ IIII/ =10/30=0.333 0.333*100=33.3 6+10+10=26 71+72/2=71.5 70.5-72.5 73-74 4 IIII =4/30=0.133 0.133*100=13.3 6+10+10+4=30 73+74/2=73.5 72.5-74.5 totals 30 100

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---