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

Evaluation: the making of judgments about the value, for some

      Evaluation: the making of judgments about the value,   for some purpose, of ideas, works, solutions, methods, material, etc. Judgments in terms of internal evidence: Evaluation   of a communication from such evidence as logical accuracy, consistency, and   other internal criteria.   Judgments in terms of external criteria: Knows the   criteria customarily

Diversification of Monotypic Crested Wheatgrass and Smooth Brome Stands:

Description In this literature review, I need to synthesize previous attempts to restore and diversify monotypic stands of the exotic cool-season grasses crested wheatgrass and smooth brome. I will provide relevant articles summarizing past attempts. Secondly, since most of these past attempts are largely unsuccessful, I need to make a

You will submit a paper on ‘How has my classes

You will submit a paper on ‘How has my classes in Biology influenced my understanding and ability to deal with the present pandemic’.    * The assignment is due April. 8, 2022.  You can submit the paper earlier.    *  The paper must be typed (800 words).    *  You

How does PET scan work? State how they are different

How does PET scan work? State how they are different from MRI and functional magnetic resonance imaging (fMRI). Why is radioactively labeled glucose often used as a metabolic tracer? What does it mean if glucose is being absorbed or used in one area more than another?   PET scans expose

Overview Working capital management is critical to an organization’s ability

Overview Working capital management is critical to an organization’s ability to meet its short-term obligations. When proposing new projects or investment ideas for corporations, it is critical to consider working capital red flags such as excess credit use by the business or a low cash balance. Managing such issues early

In 2010 the U.S. Congress passed a historic new health

In 2010 the U.S. Congress passed a historic new health care program known as the Patient Protection and Affordable Care Act (ACA), commonly nicknamed Obamacare. The program promised to cover millions of Americans who were currently uninsured with affordable health insurance. However, in 2018, under the administration of President Trump,

This is the discussion question read chapter 10 and the

  This is the discussion question read chapter 10 and the other documents attached below. Answer the question below in one page only The CQ Researcher article for this week focuses on mental health and the issue of mandated treatment. Currently in California the The Lanterman-Petris-Short Act allows for civil

No plagiarism Part 1 (100 Points) At the second meeting

No plagiarism    Part 1 (100 Points) At the second meeting of the e-marketing team initiative, President Learner has selected you to formulate a marketing plan for the university. Send him your revised marketing plan that you developed for IP 1. It is acceptable to use either PowerPoint or Word for

Please read 1 Corinthians 14:33 and respond to the following

Please read 1 Corinthians 14:33 and respond to the following in an original post of no less than 200 words: Due Thursday 02/17/2022 Is God a God over order or chaos? Explain. Do you agree with some previous mathematicians who have proposed that math is actually searching for the patterns

(1) Composition and Benefits, Within the Discussion Board area, write

(1) Composition and Benefits,  Within the Discussion Board area, write 400–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas: Discuss the purpose of

HCS 443 Health and Medical Discussion Nursing Assignment Help

Can you help me understand this Health & Medical question? What impact does aging have on the physical processes? As a health care administrator, how will that influence services provided to those who are aging? Provide details.  Expert Solution Preview Introduction: Aging is a natural and inevitable process that affects

1. What type of market should be considered for these

1.   What type of market should be considered for these services or products: A spray that combines pain relief and protection for cuts and scrapes? A.   Micro-market B.   Mass-market C.   Untapped markets D.   Targeted markets E.   Redefined market 2.   What type of market should be considered for these services or