Categories

# Multiple Linear Regression Model to Predict Ice Cream-sales

Connect with Assignment Expert Now

Congratulation on getting a job as a data scientist at a well-known ice cream company! Your boss has just acquired data about ice cream sales in different cities of twocountries, and she is interested in learning how to increase sales. She is also interestedin learning something new about ice cream sales. So, she wants you to figure it all out.As part of this project, you will complete exploratory data analysis, hypothesis testing,modelling, and prediction.You are given a dataset on ice cream sales. The data is collected by surveying ice creamshops in two countriestemperature in a location in a location in Country A relative to the average temperaturein a location in a location in Country B. Test the hypothesis and explain the result.

C. Modelling: Develop a multiple linear regression model to predict ice creamsales using all explanatory variables. The outcome variable and the explanatory variablescan be existing variables in the dataset or new variables you create based on existingvariables.

1. What is your regression equation?

2. What are the interpretations of all your coefficients?

3. All else being equal, what is the predicted difference between ice cream salesin a location in Country B in Spring compared to Autumn? How would thepredicted difference between ice cream sales in Spring and Autumn be inCountry A?

4. All else being equal, what is the predicted change in ice cream sales if the temperature goes up 5 degrees and price goes up by £0.25 at the same time?

5. What percentage of the variance is described by the model?

6. Is this model statistically significant at a 10% significance level?

7. What are the confidence intervals of coefficients on explanatory variables at a 95% confidence level? Explain what they mean.

8. Explain if your data meets the regression conditions.

D. Prediction: What is the predicted value of ice cream sales in a location in Country B where the average income of residents is £30,000 when the temperature is 3degrees in Winter, and the average price per serving of ice cream is £5? Also, quantify theuncertainty around this prediction using an appropriate interval at 90% confidence interval.

This IT Assignment has been solved by our IT Experts at TVAssignmentHelp. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

• Posted on : January 06th, 2020