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.
- Open the data in Excel and select one of the quantitative weather variables to analyze. (Avoid using precipitation data.)
- 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.
- Share the summary table or the following descriptive measures:
- Mean
- Median
- Mode
- Maximum
- Minimum
- Sample standard deviation
- Calculate and share the 1st and 3rd quartiles for the variable using the "quartile.inc" function in Excel.
- 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
Get step-by-step solutions from verified subject matter experts
