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
Get step-by-step solutions from verified subject matter experts
