Question: COMPUTER ASSIGNMENT 2 The data set for this computer assignment can be found under RESOURCES in the COURSE INTRO. MODULE. Profit and Sales for Food

COMPUTER ASSIGNMENT 2 The data set for this computer assignment can be found under RESOURCES in the COURSE INTRO. MODULE. Profit and Sales for Food and Non-food Problem [Instructions] Provide the following analyses in EXCEL - DATA ANALYSIS: A correlation matrix for all variables. Scatter plots of the dependent variables and each independent variable. Standard regression output including the estimated regression function, an ANOVA table, and residual output. A scatter plot of the standardized residuals and predicted Y (fitted Y). The VIF for each independent variable. Conduct the following analysis in 'R' (via SHINY interface) and cut and paste the results into your EXCEL spreadsheet. The three model tests: Breusch-Pagan, Lilliefors, and Durbin-Watson D. [Data] Table: Profit and Sales for Food and Non-food Items for Ten Supermarkets Store Number Profits ($ thousands) Y Sales of Foods ($ tens of thousands) X1 Sales of Non-foods ($ tens of thousands) X2 1 20 305 35 2 15 130 98 3 17 189 83 4 9 175 76 5 16 101 93 6 27 269 77 7 35 421 44 8 7 195 57 9 22 282 31 10 23 203 92 [Questions] (a) Specify the correlation

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!