Question: 5- There are 500 client records in the first worksheet of the Excel file (provided for this assignment) who have shopped many special products from


5- There are 500 client records in the first worksheet of the Excel file (provided for this assignment) who have shopped many special products from an e-Business website. Each record includes data on types of product purchased (between 1-5), purchase amount ($), age, gender, family size of the customer, whether the client has a membership and whether the customer has a discount card. a) Develop a multiple regression model to predict the spend amount based on other variables in the data set. Write the final equation and interpret the coefficients of the model and explain the accuracy of the model? b) What would be your recommendation to improve the accuracy of this model or improve the simplicity of the model while the accuracy is not significantly impacted
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
