Statistics

Ave23
excelpartreference.xlsx
Home>Mathematics homework help>Statistics homework help>Statistics

Q1

Dealer Number Sedan Sales SUV sales Dealership Size Profit
1 336 42 42 480
2 156 118 26 360 SUMMARY OUTPUT
3 227 100 32 400
4 210 91 19 220 Regression Statistics
5 121 112 34 380 Multiple R 0.9726496698
6 323 92 55 640 R Square 0.9460473802
7 505 53 67 840 Adjusted R Square 0.9393033027
8 234 68 14 160 Standard Error 49.1528057882
9 338 37 48 520 Observations 10
10 244 110 38 560
ANOVA
df SS MS F Significance F
Dealership Size Regression 1 338912.01346518 338912.01346518 140.2782489959 0.0000023687
Residual 8 19327.9865348201 2415.9983168525
Mean 37.5 Total 9 358240
Standard Error 5.1386336273
Median 36 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Mode ERROR:#N/A Intercept 8.1775720598 40.8805850186 0.2000355928 0.846444075 -86.0932260427 102.4483701622 -86.0932260427 102.4483701622
Standard Deviation 16.2497863234 Dealership Size 11.9419314117 1.008275941 11.8439118958 0.0000023687 9.6168429224 14.2670199011 9.6168429224 14.2670199011
Sample Variance 264.0555555556
Kurtosis -0.2563844505
Skewness 0.3638559554
Range 53 Sedan Sales SUV sales Dealership Size Profit
Minimum 14 Sedan Sales 1
Maximum 67 SUV sales -0.7393694987 1
Sum 375 Dealership Size 0.7981537521 -0.4033037181 1
Count 10 Profit 0.7706123491 -0.2767076605 0.9726496698 1

Q2

Dealer Number Sedan Sales SUV sales Dealership Size Profit
1 336 42 42 480
2 156 118 26 360 SUMMARY OUTPUT
3 227 100 32 400
4 210 91 19 220 Regression Statistics
5 121 112 34 380 Multiple R 0.885038694
6 323 92 55 640 R Square 0.7832934899
7 505 53 67 840 Adjusted R Square 0.7213773442
8 234 68 14 160 Standard Error 105.3110631565
9 338 37 48 520 Observations 10
10 244 110 38 560
ANOVA
df SS MS F Significance F
Regression 2 280607.059837968 140303.529918984 12.6508761279 0.0047375287
Residual 7 77632.9401620324 11090.4200231475
Total 9 358240
Sedan Sales SUV sales
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Mean 269.4 Mean 82.3 Intercept -504.8693751823 253.9415732788 -1.9881320284 0.0871309076 -1105.3457778449 95.6070274804 -1105.3457778449 95.6070274804
Standard Error 34.9011938669 Standard Error 9.5137911593 Sedan Sales 2.2570573841 0.4723935015 4.7779179369 0.0020171343 1.1400242542 3.3740905141 1.1400242542 3.3740905141
Median 239 Median 91.5 SUV sales 4.2869758919 1.7329681618 2.4737764873 0.0425966546 0.1891573492 8.3847944346 0.1891573492 8.3847944346
Mode ERROR:#N/A Mode ERROR:#N/A
Standard Deviation 110.3672656784 Standard Deviation 30.0852492465
Sample Variance 12180.9333333333 Sample Variance 905.1222222222
Kurtosis 1.2491441005 Kurtosis -1.4803422241
Skewness 0.9067382362 Skewness -0.4407829055
Range 384 Range 81
Minimum 121 Minimum 37
Maximum 505 Maximum 118
Sum 2694 Sum 823
Count 10 Count 10