Question: THE DATA SET IS IN EXCEL FORMAT…..SEE ATTACHED FILE….Perform a correlation matrix on the entire data set. Specifically, your team is interested in looking at variable correlations that exhibit strong correlation at the α = 0.01. These will be shaded a strong yellow color, if you use MegaStat® to perform your correlation matrix

If there are no correlations at the α = 0.01 level, then look at correlations that exhibit at the α = 0.05 level. These are the light yellow shaded regions in the output from MegaStat.

. When you have identified variable pairs that appear to be strongly correlated, perform a pair-wise linear regression analysis on the respective data columns to obtain the best fit slope and intercept for your data parings.

1. Indicate which variable pairings exhibit strong correlation at the α = 0.01. If no variable combinations exhibit strong correlation at the α = 0.01 level, then indicate which ones exhibit correlation at the α = 0.05 level.
2. Indicate whether these are positive or negative correlations.
3. Describe how the variables interact. When one gets larger, does the other get larger or smaller?
4. Next, perform a linear regression analysis on the pair-wise variables that exhibit strong correlation.
5. Identify the slope and intercept of the linear regression line.
6. Interpret the meaning of the slope
7. Use this simple model to make a prediction of these variables 10 years into the future (from when the data was gathered). Do these predictions seem reasonable to your team, why or why not?

Price: $2.99

Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document