Which statistic (mean, median, or mode) do you think is the best measure of center for the temperature information for the city you chose?

Assignment Details
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 Microsoft Excel site.
Click here to download your assignment. This document has the questions and places for you to provide your answers.
Complete the assignment steps outlined below tracking your answers in the assignment document.
Make sure you submit your work in an edited MS Excel document.
Assignment Steps
Click here for the U.S. Climate Data Web site. 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
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 how they impact the mean, median, mode, and range you found in Step 3?
Discuss the shape of your graph (normal distribution, skewness, etc.).
Reference
U.S. Climate Data. (2020). Retrieved from https://www.usclimatedata.com/
Microsoft. (2020). Excel for Windows training. Retrieved from https://support.microsoft.com/en-us/office/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb
Please submit your assignment.
For assistance with your assignment, please use your text, Web resources, and all course materials.
The following are some tips if you have problems submitting your assignment:
Resave in the proper format per the Assignment Detail instructions, and resubmit.
Submit with a different Web browser.
Submit from a different computer.
Call Technical Support at 877-221-5800, Menu Option 2. They are open 24/7.
If you are still having difficulties after trying steps 1 to 4, please contact your course instructor.
Make sure you submit this assignment by the listed due date. Late deductions will apply for this assignment as follows:
Assignments submitted within 7 calendar days after the stated due date: 10% penalty of total assignment points.
Assignments submitted 8 to 14 calendar days after the stated due date: 20% penalty of total assignment points.
Assignments submitted 15 to 21 calendar days after the stated due date: 30% penalty of total assignment points.
Assignments submitted 22 to 28 calendar days after the stated due date: 40% penalty of total assignment points.
No assignments, including late assignments, will be accepted after the end of the course unless an approved Incomplete has been granted.
Grading Rubric
Component Points
Step 1
City is identified.
/3 pts.
Step 2
Temperatures for each month are listed.
/6 pts.
Step 3
Mean, median, mode, and range are accurate for the data provided.
Mean (4 points)
Median (4 points)
Mode (4 points)
Range (4 points)
/16 pts.
Step 4
Visual representation of the data is provided using a bar graph or line graph.
Data appropriately matches the type of graph. (3 pts)
Graph is appropriately formatted to be legible. (3 pts)
Graph axis are labeled correctly. (3 pts)
Graph has a key or legend. (3 pts)
Graph is inserted properly into sheet. (3 pts)
/15 pts.
Step 5
Question is thoughtfully answered about which measure of center is best for the data set.
Provides a thoughtful answer for the best central measure. (5 points)
Provides a rationale behind the decision. (4 points)
Communicates content information accurately and/or logically. (3 points)
Connects to key content concepts. (3 points)
/15 pts.
Step 6
Question is thoroughly and correctly answered regarding whether there are any unusual data values and how they impact the statistics.
Provides a thoughtful answer for impact of data outliers. (5 points)
Provides a rationale behind the decision. (4 points)
Communicates content information accurately and/or logically. (3 points)
Connects to key content concepts. (3 points)
/15 pts.
Total /70 pts.

Calculate your order
Pages (275 words)
Standard price: \$0.00
Client Reviews
4.9
Sitejabber
4.6
Trustpilot
4.8
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.