1. Fifty children were diagnosed with leukemia during the past year. The weight of each child was recorded (in pounds) at the time of diagnosis. Listed are the weights listed from lightest to heaviest: 20, 22, 23, 26, 27, 28, 28, 29, 30, 31, 31, 32, 33, 34, 35, 37, 38, 39, 40, 41, 42, 42, 43, 43, 44, 45, 47, 48, 48, 49, 49, 51, 52, 52, 52, 54, 55, 56, 58, 58, 58, 60, 61, 62, 63, 64, 65, 67, 68, 70.

a. Calculate the mean, median, and mode.

b. Calculate the variance and standard deviation computed from a frequency distribution with a class interval of one.

c. Calculate the weights that are one standard deviation above and one standard deviation below the mean.

d. Calculate the weights that are two standard deviations above and two standard deviations below the mean.

2) Find the variance for the following values: 300, 400, 150, 510, 430, 611

3) Use the STDEV function to find the standard deviation for the heights (in cm) of 12 students in a class: 170, 160, 165, 161, 163, 164, 170, 164, 163, 170, 166, 165

4) Using the following data of patient's length of stay for diverticulitis who had a partial bowel resection performed calculate the following: Mean, median and mode. 5, 7, 9, 4, 6, 5, 7, 3, 6, 6, 4, 5, 5, 7, 7, 3

5) Compute the mean for the following values by hand and show your work, then compute the mean in excel and show the formula you used.

5, 6, 7, 1, 2, 5, 6, 7, 1, 9, 33, 2, 9