Question: 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

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: I used NYC Laguardia

  • 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 representthe monthly temperaturedata for your chosen city, create 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 (like outliers)?
  • If so, explain howthey impact themean, median,mode, and rangeyou found in Step 3?
  • Discussthe shape of your graph (normal distribution, skewness, etc.).

https://www.usclimatedata.com/climate/new-york-la-guardia-arpt/new-york/united-states/usny1000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!