For these review exercises, download and open the file StatisticsReview.xlsx.
Each trial in an experiment consisted of flipping eight coins and recording the number of heads. The experiment included 200 trials with the results recorded in column A on the "Eight Coins" worksheet.
A. Find the five-number summary, the mean, and the standard deviation.
B. Generate an ungrouped frequency distribution and a chart illustrating the frequency distribution. Set the chart title to "Flipping Eight Coins", the horizontal axis title to "Number of Heads", and the vertical axis title to "Frequency".
The data below is taken from a study of 4000 year old Egyptian skulls. The values are the nasal heights of the skulls measured in millimeters. Enter this data in column A of the "Skulls" worksheet.
49 48 50 44 54 56 48 48 51 51 50 53 51 50 51 54 50 53 50 49 51 47 53 50 49 55 53 48 54 46
A. Find the five-number summary, the mean, and the standard deviation.
B. Prepare an ungrouped frequency distribution. As has been our custom, enter the label "n=" at the bottom of the x column and a summation formula at the bottom of the f column. Make sure the sum of the frequencies corresponds to the number of skulls in this sample. Create a chart illustrating the frequency distribution.
The worksheet "TV Hours" contains the results of a television viewing study. The study included three random samples. One sample consisted of grade school children, the second of college age adults, and third of adults fifty years old or older. Each subject reported the number of hours of television they watched per week.
A. For each sample, find the five-number summary, the mean, and the standard deviation.
B. For each sample, generate a grouped frequency distribution based on the midpoint values indicated. For each sample generate a chart illustrating the frequency distribution.
To see my solutions, download and open the file StatisticsReviewDone.xlsx.