# correlation

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

Use the Excel capabilities for Simple Regression (hint: data – scatterplot – fit trendline)

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 Excels CORR( ) function to calculate this),

Standard deviations for X and Y (use population standard deviations, stdev.p( ),

Means for X and Y,

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.