In this assignment, you will be collecting data about the

 

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.

  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:

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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

HU Substance and Drug Abuse Discussion Nursing Assignment Help

I’m working on a health & medical question and need guidance to help me learn. The Stauffer et al. article and Glidden-Tracey article introduce several terms used when assessing substance use. Additionally, the DSM 5 differentiates among severity levels of substance use compared to the old diagnoses of abuse/dependence. Currently,

Week 2 Assignment – Case Study: Acceptable Use Policy Instructions

  Week 2 Assignment – Case Study: Acceptable Use Policy Instructions The acceptable use policy (AUP) is a very important policy within organizations to define acceptable employee behavior when accessing company resources. There are also legal implications within AUPs. Use an existing AUP that you are familiar with, such as

Target Customers and Segmentation

Part 2:             Target Customers and Segmentation, and Positioning   Global problem: Availability of a clean, reliable water source in areas of intense water pollution and drought not requiring trips to water sources.   Destination market: Northern California   Product: Cloudfisher https://www.aqualonis.com/cloudfisher   Instructions: Using this information answer the following

I need help with this question,conducting a SWOT analysis is

I need help with this question,conducting a SWOT analysis is a way to determine your strengths and weaknesses as well as those external opportunities and threats related to your role as leader. A SWOT analysis is used for strategic planning. Complete your readings for the week focusing on “The SWOT

The Death Penalty is a hard area to talk about

 The Death Penalty is a hard area to talk about since many people have strong feelings on the issue. For this discussion board I want you to state the arguments for the death penalty AND against the death penalty. Then you can state your feelings on the death penalty and

Reflection and Discussion Forum Week 3 Reflection and Discussion Forum

  Reflection and Discussion Forum Week 3 Reflection and Discussion Forum Week 3Assigned Readings:Chapter 6. Products: Goods and Services.Chapter 7. Brands.Chapter 8. New Products and Innovation.Initial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or

APA Format 1) Minimum 6 full pages (No word count

  APA Format  1) Minimum 6 full pages (No word count per page)- Follow the 3 x 3 rule: minimum three paragraphs per page            Part 1: minimum 1 page            Part 2: minimum 1 page            Part 3: minimum 1 page            Part 4: minimum 1 page            Part 5: minimum 1 page            Part

M.S. Psychology Week 1:Database Development Submit the SPSS database that

 M.S. Psychology Week 1:Database DevelopmentSubmit the SPSS database that contains your program evaluation variables. No data should be entered at this stage; you are only setting up the variables at this time.Your database should contain the following variables: Participant ID number Program ID Group (applicable only if you will be

Discussion : Given the readings and assignments in the course,

Discussion :   Given  the readings and assignments in the course, identify and briefly  discuss two important concepts from this course that are applicable to  your degree.    ***Standard for all discussion posts:   Please make your initial post and two response posts substantive. A substantive post will do at least two of

Accounting is the process of recording, summarizing, analyzing, and reporting financial transactions of a business or organization. It provides vital

Accounting is the process of recording, summarizing, analyzing, and reporting financial transactions of a business or organization. It provides vital information to various stakeholders, including investors, creditors, management, and government agencies, enabling them to make informed decisions. Here’s a breakdown of key aspects within accounting: Financial Statements: These are the

see attachment  Module 6:  Content Mastery Test Instructions After studying and reviewing

see attachment  Module 6:  Content Mastery Test Instructions After studying and reviewing the concepts and practices of correlation and simple linear regression, solve the following exercise using Excel: 1. The following sample observations were randomly selected: X:        5          3          6          3          4          4          6          8 Y:        13        15        7          12       

Select a country and industry and apply Porter’s diamond of

Select a country and industry and apply Porter’s diamond of national advantage framework to the industry and the country you have chosen.  Based on the four points of the diamond, are firms likely to be successful?  Is there any chance of governmental variables at play in your industry or country?

In chapter 12, the author introduces issues to address when

In chapter 12, the author introduces issues to address when integrating blockchain apps with legacy applications. Which of the differences between blockchain and legacy systems discussed in chapter 12 do you think would be the one that carries the most risk? How could this risk be realized? (Give at least