This preview shows page 1. Sign up to view the full content.
Unformatted text preview: /. Then use Excel to calculate the average mass and the standard deviation for each year, using the AVERAGE() and STDEV() spreadsheet functions. Finally, calculate the standard deviation for ALL the pennies, considered as a single large sample. Use Excel to prepare a chart showing the average mass vs. year. Also, prepare a second chart showing the standard deviation vs. year. Discussion: In your discussion section address the following questions: How does the standard deviation among the pennies in a given year compare with the standard deviation among all the pennies (all years)? What can you conclude from this? Describe in one sentence any trend observed in the variation of average mass with mint year. Describe in one sentence any trend observed in the variation of the standard deviation with mint year. Give a possible explanation for these trends and discuss how your observations support this explanation....
View Full Document
- Spring '07