Qualify Pair-Wise Association

Size of correlation coefficient	Strength of correlation
.91 until 1.00 or -.91 until -1.00	Very Strong
.71 until .90 or -.71 until -.90	Strong
.51 until .70 or -.51 until -.70	Moderate
.31 until .50 or -.31 until -.50	Weak
.01 until .30 or -.01 until -.30	Very Weak
.00	No Correlation

Part I: For air quality dataset, calculate the pair-wise associations between the four continuous variables and qualify each value in terms of the strength and type of relationship. Complete the following table:

Correlation between	Value	Positive or Negative?	Strength
Ozone	-	-	-
Solar and Ozone	-	-	-
Wind and Ozone	-	-	-
Temperature and Ozone	-	-	-
Solar and Wind	-	-	-
Solar and Temperature	-	-	-
Wind and Temperature	-	-	-

Part II: Using Excel, conduct a simple linear regression to test the model of ozone being a function of temperature. Report your results and interpret them.

Summarize your results, upload your Excel spreadsheet in your submission.

Below is the EXCEL spreadsheet

https://lmscontent.embanet.com/RC/MPH/PBH600/Docs/RC_MPH_PBH_600_Excel_Assignment_Data.xlsx