Summer 2, 2018 Sample Data for Supermarket Profits. Profit dollars) 20 Supermark
ID: 2908968 • Letter: S
Question
Summer 2, 2018 Sample Data for Supermarket Profits. Profit dollars) 20 Supermarket Food Sales Nonfood Sales Store Size square feet) 35 Number (tens of thousands (tens of thousands (thousands of (thousands of of dollars) of dollars) 305 130 189 175 101 269 421 195 282 203 35 98 83 76 93 27 16 28 46 4 16 27 35 57 40 32 10 23 1. Describe the Skewness and Kurtosis of each variable See an example of the table below: Table 2: Summary statistics for the quarterly series Statistic Mean Std. Dev In ER 3.8416 4.3551 20.1439 3.5474 1.0830 0.7043 0.2585 0.7365 16622 0.1951 Skewness 0.2932-04532 -0.1282 0.0673 0.3238 0.1870 1.8808 17895 1.7175 2.3089 1.4557 In SP 4.2515 0.5362 In IP n CPI In MM ?? 2.0376 Jarque-Bera 6.719874 8.1022" 8.8002"474 13.3611" 2. Run a multiple regression using the above data. (With profit as the dependent variable) 3. Interpret your results for (1) and (2). 4. In writing your paper, you should start by indicating the purpose of the study. Also, discuss the methodology and conclusions.Explanation / Answer
1.
2.
Coefficients:
Estimate Std. Error t value Pr(>|t|)
FOOD.SALES -0.001950 0.009891 -0.197 0.849292
NONFOOD.SALES 0.013464 0.013991 0.962 0.367931
STORE.SIZE 0.597159 0.077531 7.702 0.000116 ***
---
Thus the multiple regression curve is
Profit = -0.0019 Food sales + 0.0135 Nonfood sales + 0.597 Store size
Multiple R-squared: 0.9947, Adjusted R-squared: 0.9924
3.Since Adjusted R-squared is 0.99.This implies that about 99% variation in dependent variable (Profit) is shown by the independent variables (Food sales,Non Food sales and Store size). Hence the model is a good fit.
THANK YOU
Statistic FOOD NONFOOD SALES STORSIZE PROFIT Mean 227 68.6 31.4 19.1 Std.Dev 94.01064 24.99422 13.49238 8.292567 Skewness 0.812619 -0.45189 0.383001 0.410959 Kurtosis 0.738015 -1.48155 -0.23304 0.292093Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.