Assignment Steps
. This Web site provides climate data for every city in the United States. Select your hometown or your dream city in the United States. You will then locate the average high temperature information for the city you have chosen for each month of the year.
Steps 1-3: In your spreadsheet, identify the city and provide data for the monthly average high temperatures for all 12 months. Calculate by hand or using Excel formulas and then list the following items:
- The mean for your data
- The median for your data
- The mode for your data
- The range for your data
Step 4: Further, to visually represent your data, include 1 of the following 2 graphs in your spreadsheet:
- Line graph Or Bar graph
Step 5: Use the textbox in your spreadsheet to answer the following questions regarding your data:
- Which statistic (mean, median, or mode) do you think is the best measure of center for the temperature information for the city you chose? Why?
Step 6: Use the textbox in your spreadsheet to answer the following questions regarding your data:
- Are there any unusual data values?
- If so, how do they impact the descriptive statistics you found?
- If not, describe the data from your visual representation.
