14 Feb In this assignment, you will be collecting data about the temperature patterns in your city. You will be calculating mean, media
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.)
Temperature
| 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? | 15 points | ||
| 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.) | 15 points | ||
| Enter your response to the questions in Step 6 in this box: |
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.