Question: In this assignment, your learning on predictive analysis is tested on the series of data. You are required to analyse data by applying the techniques

 In this assignment, your learning on predictive analysis is tested onthe series of data. You are required to analyse data by applyingthe techniques you have learned in regression analysis.Please include the excel file.

In this assignment, your learning on predictive analysis is tested on the series of data. You are required to analyse data by applying the techniques you have learned in regression analysis.

Please include the excel file.

\fProblem description: It you are the manager of a grocery company with5D stores across the city. The excel file contains data on thedemand for grocery delivery: Delivery {'r} is the number of delivery per

\fProblem description: It you are the manager of a grocery company with 5D stores across the city. The excel file contains data on the demand for grocery delivery: Delivery {'r} is the number of delivery per month Price [11} is the average price of a delivery Income in} is average income in the neighbourhood 't'ou are required to use the Microsoft Excel package {the data analysis section} to finish the specific tasks below. Task 3: [3 marks} Estimate the regression model for #delivery {1'} against price {x1} and income {:2}. What does the H- souare say about the model? Why is the H-souare in this model higher than the model in taslc 2 [both in terms of statistical and economics principles? Comment on the coefficients of price and income. Why is the coefficient of price different in this model than the one in task 2 {both in terms of statistical and economics principles? What is the trade-off between income and price

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 Economics Questions!