# math writing

In this assignment, you will be collecting data about the temperature patterns in your city. You will be calculating mean, media, mode and range. You will also be using this data to create a graph and discuss what you learned from the visual representation of data. You will complete this work in a Microsoft Excel file. If you need assistance with Excel, explore the

Don't use plagiarized sources. Get Your Custom Essay on
math writing
Just from \$13/Page

Microsoft Excel site

.

2. Complete the assignment steps outlined below tracking your answers in the assignment document.
3. Make sure you submit your work in an edited MS Excel document.

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 the monthly temperature data for your chosen city, create 1 of the following 2 graphs in your spreadsheet:

• Line graph Or Bar graph

• 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?

• Are there any unusual data values (like outliers)?
• If so, explain how they impact the mean, median, mode, and range you found in Step 3?
• Discuss the shape of your graph (normal distribution, skewness, etc.)

15 points

15 points