Answer to Question #308508 in Statistics and Probability for Aarti

Question

Consider the following sample. It contains the weights of 25 participants:

55, 57, 58, 43, 62, 67, 71, 69, 66, 51, 72, 62.5, 58.5, 61, 72.5, 75, 44, 48, 49, 49.5, 49, 62, 66, 71, 58.

Calculate and plot the following using MS-Excel.

Write the formula and show the steps.

a. Variance 

b. Standard deviation

c. Histogram

d. Ogive

Note: For histogram and ogive use bins numbers as 40, 45, 50, 55, 60, 65, 70     

Answer 1

The answer to your question is provided in the image: