Paperanswers
Call free: +1 763 309 4299
Order now

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
Order Essay

Microsoft Excel site

.

  1. Click here to download your assignment. This document has the questions and places for you to provide your answers.
  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

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.)

Temperature

15 points

15 points

Temperature
Unit 8 Individual Project
Complete all the information in the BLUE cells. Make sure you show all your work.
Name:
Date:
Step 1:
Identify the city you chose. The city must be listed on: https://www.usclimatedata.com/ 		3 points
Name of City
Step 2:
List the average high temperatures for each month for your chosen city below. 		6 points
January
February
March
April
May
June
July
August
September
October
November
December
Step 3:
Calculate the values below. 		16 points
Show your work below:
Mean for your data
Median for your data
Mode for your data
Range for your data
Step 4:
Create an Excel graph of the data (a bar graph or line graph) using the instructions provided and insert in the blue box below. 		15 points
* Select all data from Step 2.
* Click on the Insert tab at the top of the page to choose your graph from the Recommended Charts section.
Use this link for help with creating your graph: https://support.microsoft.com/en-us/office/excel-for-windows-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb
Insert the graph you created of your temperature data here:
Step 5:
Which statistic (mean, median, or mode) do you think is the best measure of center for the temperature information of the city you chose? Why?
Enter your response to the questions in Step 5 in this box:
Step 6:
1. Are there any unusual data values (like outliers)? If so, explain how they impact the mean, median, mode and range found in Step 3.
2. Discuss the shape of your graph (Normal Distribution, Skewness, etc.)
Enter your response to the questions in Step 6 in this box:

Calculate your order price
Pages (550 words)
Approximate price: -
Calculator

Calculate the price of your paper

Total price:$26

Free features

  • Formatting (APA, MLA, Harvard, Chicago/Turabian)
  • Bibliography
  • Title page
  • Upload custom grading criteria

Additional services

  • Part-by-part payment
  • Links to used sources
  • Review your writer’s samples
  • Charts and PowerPoint slides
Our features

We've got everything to become your favourite writing service

Money back guarantee

Your money is safe. Even if we fail to satisfy your expectations, you can always request a refund and get your money back.

Confidentiality

We don’t share your private information with anyone. What happens on our website stays on our website.

Our service is legit

We provide you with a sample paper on the topic you need, and this kind of academic assistance is perfectly legitimate.

Get a plagiarism-free paper

We check every paper with our plagiarism-detection software, so you get a unique paper written for your particular purposes.

We can help with urgent tasks

Need a paper tomorrow? We can write it even while you’re sleeping. Place an order now and get your paper in 8 hours.

Pay a fair price

Our prices depend on urgency. If you want a cheap essay, place your order in advance. Our prices start from $11 per page.

Need a better grade?
We've got you covered.

Order your paper