Question: 2.Revise your regression model to predict customer value from a simple regression model to a multiple regression model by using TENURE, AGE, ORDERS as your

2.Revise your regression model to predict customer value from a simple regression model to a multiple regression model by using TENURE, AGE, ORDERS as your predictors (If using Excel, these columns will need to become adjacent to each other)

3.Note that one of the three predictors is not a statistically significant predictor (How do you determine which one?).

4.Adjust the model* so that it includes only the two variables that are statistically significant

5.What is the equation of your final multiple regression model with the two predictors?

6.What is the predicted value for a 25 year old, that has placed 2 orders?

7.What is the goodness of fit measure for your model? Is it a good model?

use excel to solve: https://docs.google.com/spreadsheets/d/13mpVqtzdkQsPaL2X3e2RhhFH_6qE9jsD/edit?usp=sharing&ouid=108337750659823752451&rtpof=true&sd=true

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!