correlation

Using the Email marketing (EMMA) dataset (attached), build a simple regression model that predicts “Total customer value” (Y) from “Tenure” (X). . . 

1. Use the Excel capabilities for Simple Regression (hint: data -> scatterplot -> fit trendline)
2. Use the algebra that we walked through to come up with the simple regression equation. You will need the following components to determine the slope ‘b’ and intercept ‘a’ values of the equation:

• Correlation, r (you can use Excel’s CORR( ) function to calculate this),
• Standard deviations for X and Y (use population standard deviations, stdev.p( ),
• Means for X and Y,

1. What would you conclude about the relationship and ability to predict Value from Tenure? 

Note: that answers to ‘1’ and ‘2’ above should all match if calculated correctly.