Instructions

Use MS Excel or Google Sheets to complete the computational questions.

Use the data provided in airquality .xlsxto complete the following tasks.

The dataset contains daily air quality measurements in New York, May to September 1973. More about the variables can be found here https://www.rdocumentation.org/packages/datasets/versions/3.6.2/topics/airquality

1. Watch the one of following videos to add the data analysis add-in toolpak to Excel:

https://www.youtube.com/watch?v=_yNxLFagKgw

https://www.youtube.com/watch?v=B60rozw34Sc

1. Using the Data Analysis tool in Excel, provide descriptive statistics for the four numerical variables of ozone, temp, wind, and solar.
2. Using the Data Analysis tool in Excel, calculate the pairwise correlation between the four variables of ozone, temp, wind, and solar. Provide this correlation matrix.
3. Use the following scale to interpret the results.

Re-arrange your correlation coefficients in the following table to fill in the blanks:

Correlation Type: N Relationship Strength Coefficient positiveegative Ozone vs 1 Temperature Ozone vs 2 Solar Ozone vs 3 Wind