Before beginning this assignment, review the following websites to learn how to install and use the Analysis ToolPak in Excel:
Load the Analysis ToolPak in Excel
Use the Analysis ToolPak to Perform Complex Data Analysis
Descriptive Statistics in Excel
To begin this assignment, review the following:
Daily air quality measurements in New York, May to September 1973, were measured and saved in the air quality dataset (EXCEL).
For this assignment, complete the following tasks based on the air quality dataset:
Using Excel, calculate descriptive statistics for the variables ozone, solar, wind, and temp (temperature).
Using Excel, create a scatter plot for each of the four measurements: ozone, solar, wind, and temp.
Once you have completed all the tasks, write a paragraph describing your results. Submit your responses in a Word document to be graded. Be sure to upload your Excel spreadsheet in your submission.