Question: Main Post: Export your daily weather summary from the last month for your city or ZIP code, or a nearby city, using NOAA's Climate Data

Main Post: Export your daily weather summary from the last month for your city or ZIP code, or a nearby city, using NOAA's Climate Data Online Search.

  1. Open the data in Excel and select one of the quantitative weather variables to analyze. (Avoid using precipitation data.)
  2. For the variable selected, run the Descriptive Statistics->Summary statistics, available in the Excel Data Analysis Tools, or use the individual Excel functions to calculate the measures listed below. Review the directions for opening the data analysis toolpak.
  3. Share the summary table or the following descriptive measures:
    • Mean
    • Median
    • Mode
    • Maximum
    • Minimum
    • Sample standard deviation
  4. Calculate and share the 1st and 3rd quartiles for the variable using the "quartile.inc" function in Excel.
  5. Clearly state the 5-number summary for the variable (Minimum, Quartile 1, Median, Quartile 3, Maximum) in your post.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!