Preliminary Analysis of Data
Data Analysis Home

Data Set 1

Problem 2

Return to Introduction


On-Line Glossary

Excel How To...

last modified on 1/22/07

email comments to harvey@depauw.edu or william.otto@maine.edu

Problem 1

One approach to this problem is to collect a sample of pennies (perhaps from your change jar) and to measure the mass of each penny. Open Data Set 1, using the link on the left, which is an Excel file containing the masses for 32 pennies. Note that the data consists of one response (the mass of the penny) and one factor (each penny's ID number).

Task 1. Characterize the data quantitatively by calculating the mean and standard deviation. (Use the link on the left for help with using Excel.) In several sentences, explain the meaning of these two values and what they suggest about this set of data.

Task 2. Characterize the data visually by creating a scatterplot with mass on the y-axis and the ID number on the x-axis. Be sure to scale the axes so that the data occupies most of the available space. In several sentences, explain what information this graph conveys about the data. In what ways do your quantitative and visual characterizations of the data provide similar and/or different information about the data?

Task 3. The visual presentation of the data should strike you as interesting and unusual. Look carefully at your graph of the data. What does it suggest about this sample of pennies? (If you are stuck, try this hint). Can you think of factor(s) that might explain the variation in the mass of these 32 pennies?

Task 4. Estimate the uncertainty in measuring the mass of a single penny. For example, if a penny has a mass of 2.512 g, is the uncertainty in its mass 0.1 g, 0.01 g, 0.001 g or 0.0001 g? Compare your estimate for the uncertainty in a penny's mass with your calculated standard deviation. Is this comparison consistent with your conclusions from Task 3? Explain.

After completing these tasks, proceed to Problem 2.