1. Utilizing the data set assigned to you (below) in the "data sets" folder. Identify the appropriate dependent variable from the columns listed (what are you trying to measure?). Use Excel to run a correlation matrix and regression analysis.

2. From the correlation matrix state independent variables in descending order of strength of correlation and if the correlation is positive or negative for each variable.

3. After running the regression state the p-value and if the null hypothesis is accepted or rejected for each independent variable.

4. Explain your findings as if you were talking to someone who has never taken a statistics course (tell a story).

Data set assignment:

If your last name starts with A - G, use the Heating data set

If your last name starts with H - N, use the New England data set

If your last name starts with O - S, use the Teacher Salaries dataset

If your last name starts with T - Z, use the Roofing Sales data set

i) Protected View This file originated from an Internet location and might be unsafe. Click for more de i Protected View This file originated from an Internet location and might be unsafe. Click for more det: i) Protected View This file originated from an Internet location and might be unsafe. Click for more de i Protected View This file originated from an Internet location and might be unsafe. Click for more det