Question: STAGE 8: DEVELOPING A SIMPLE PREDICTION MODEL Ms. Moore comes to Phil's office to talk about how Phil predicts the overall sales of this product
STAGE 8: DEVELOPING A SIMPLE PREDICTION MODEL Ms. Moore comes to Phil's office to talk about how Phil predicts the overall sales of this product will be. Phil states that this may depend on one or several factors. Ms. Moore asks Phil to perform some prediction model and provide scenarios. Phil's Next Task: Stage 8 Based on his research on competitors, Phil has created a data file that shows the factors that impact "Total Sales". This data file named total sales has 30 data points/records that presents how three factors may have impacted "Total Sales" at past (for competitors). To perform sales prediction, Phil wants to start with a simple model. He wants to see if Humidity impacts "Total Sales". He creates a simple regression model using excel. In a report format, Phil presents the regression equation along with the details explaining each component of the regression equation so that Ms. Moore understands everything
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
