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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started