The data below are from a study conducted by a consumer researchgroup on the fuel efficiency (rated based on city miles per gallon)of the 30 top-selling U.S. automobiles.
23 20 16 13 34 27
24 10 16 12 34 26
14 31 15 12 16 36
18 22 15 19 28 38
10 16 14 23 19 44
1. Enter the data into a spreadsheet. Be sure to clearly labeland neatly format your spreadsheet.
2. Calculate the sum of these data two different ways: a. Bywriting your own formula. Clearly label the result. b. By using theSUM spreadsheet function. Clearly label the result
. 3. Use the COUNT function to calculate the N of this sampledata set. Clearly label the result.
4. Calculate the arithmetic average (mean) of these data bywriting your own formula. Clearly label.
5. Create a new column of data in which you subtract the meanfuel efficiency from each individual fuel efficiency score (i.e.,MPG – mean). Be sure to use the proper relative and absolutereferences (indicated with $ signs) to perform thesecalculations.
6. Now compute the sum, N, and mean of your new (MPG – mean)scores.
7. Create one more new column of data in which you square eachof the (MPG – mean) scores. 8. Finally, compute the sum, N, andmean of your new (MPG – mean)^2 scores
