Select your hometown ( Montgomery Alabama ) or your dream city in the United States.

Select your hometown ( Montgomery Alabama ) or your dream city in the United States.

Select your hometown ( Montgomery Alabama ) 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.

Use the first site for reference

Reference

U.S. Climate Data. (2020). Retrieved from http://track.smtpsendemail.com/9064971/c?p=jziEPzXQJAo6xMyOiXYKuu8WxoACK9XF6XUWkElMZ8HBD5b6rclfOodTsIK9dKGx8wh55gKuGf6_jbQ1tr08Zk55u6ziHd68mrF2ilRuG-7lqY29rEL0merK2o2QE0BuXUQJGVxAT2Izx7gRY_1chg==

Microsoft. (2020). Excel for Windows training. Retrieved from http://track.smtpsendemail.com/9064971/c?p=KK4a11UW1Sqr5n2zm2bqws-HxeL-ZAnrF7U-SdWOeQ91InP1R7Pe8kG3kPVejrzrPCH8WnUDJlMjmEPtaooFn6K4U8ivDcSZ9cXf_uW-Aiipl4Kg5w8YLWFJnl3iHZGaJH6U_PeRHRFEd1h09iVnoQ2QD1n2v4BNA_7Yk_U9WbngcCc9S1GX1jWhPqxg4QGDoJd-VQi76xWlQvdSFrRBhQ7puygAC5PxgYva4Yum2z82utXmm2D2HSJHeJdwX7Qo

MATH125 U8 IP Template 2101C.