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

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:

• 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?

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

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### I need the writer to re-write —- follow the format,

I need the writer to re-write —- follow the format, the ideas, the length, and the structure of the example attached  If I approve

### You are to choose one theme or concept from the

You are to choose one theme or concept from the week’s assigned materials (ATTACHED) which you think could be helpful to you in your role

### 14. The Psychomotor Domain Behaviors in this domain involve a wide

14. The Psychomotor Domain Behaviors in this domain involve a wide variety of motor skills dependent upon physical ability and the coordination of movement.

### DO NOT utilize ‘outside sources’ to answer any of these

DO NOT utilize ‘outside sources’ to answer any of these questions: you are expected to use the class materials, and to cite information appropriately!  Down

### Modify the Guessing game from chapters 6-7 to play with

Modify the Guessing game from chapters 6-7 to play with 2 players instead of 1 player by showing input and stats for player 1 and

### What does it mean for a company to manage diversity

What does it mean for a company to manage diversity effectively? How would you know if a company is doing a good job of

### Assignment 1 Q1. There are various languages, some are better

Assignment 1 Q1. There are various languages, some are better for data visualization than others.  Please review the basics of Python, SAS, R, and SQL.

### Describe your interest in the psychiatric program concentration to which

Describe your interest in the psychiatric program concentration to which you are applying.  How do you see the Master’s program helping you meet your career

### A New Marketing Opportunity The CEO of your firm has

A New Marketing Opportunity The CEO of your firm has just announced that the organization is considering two diverse strategies to increase business: marketing healthcare

### Select ONE of the following fugal agents for your assignment.

Select ONE of the following fugal agents for your assignment. Aspergillus, Tinea pedis, Candida albicans, Coccidioides, Pneumocystis jirovecii, Blastomyces, Cryptococcus neoformans, Histoplasma, Tinea corporis Step

### I will preface this assignment by saying that I am

I will preface this assignment by saying that I am a huge National Geographic fan, (the magazine more than the TV channel…we don’t watch much

### Scenario You have worked as a healthcare administrator for an

Scenario You have worked as a healthcare administrator for an assisted living facility for the past 10 years. In your role as administrator, your organization

New questions