In: Statistics and Probability
1. What would the regression output (analysis) look like using this multiple regression equation and the following data?
Daily Gross Revenue= total daily income+b1*daily tour income+b2*number of tourists+b3*Friday+b4*Saturday
2. What's the multiple regression equation with the numbers from the output?
Years | Weekend | Daily Tour Income | Number of Tourists | Daily Gross Revenue | Total Daily Income |
1 | Friday | 3378 | 432 | 4838.95 | 8216.95 |
1 | Saturday | 1198 | 139 | 3487.78 | 4685.78 |
1 | Sunday | 3630 | 467 | 4371.3 | 8001.3 |
2 | Friday | 4550 | 546 | 6486.48 | 11036.48 |
2 | Saturday | 2467 | 198 | 3437.39 | 5904.39 |
2 | Sunday | 3593 | 452 | 4571.43 | 8164.43 |
3 | Friday | 898 | 119 | 2515.15 | 3413.15 |
3 | Saturday | 2812 | 342 | 5462.11 | 8274.11 |
3 | Saturday | 2650 | 321 | 5498.89 | 8148.89 |
4 | Friday | 3230 | 402 | 5071.14 | 8301.14 |
4 | Saturday | 4798 | 523 | 8051.43 | 12849.43 |
4 | Sunday | 3253 | 353 | 4291.95 | 7544.95 |
5 | Friday | 2848 | 347 | 4545 | 7393 |
5 | Saturday | 4632 | 534 | 8865.01 | 13497.01 |
5 | Sunday | 3767 | 412 | 4710.64 | 8477.64 |
6 | Friday | 4499 | 529 | 10752.74 | 15251.74 |
6 | Saturday | 3868 | 422 | 6435.63 | 10303.63 |
6 | Sunday | 2489 | 288 | 3389.37 | 5878.37 |
7 | Friday | 3448 | 367 | 6129.58 | 9577.58 |
7 | Saturday | 3612 | 406 | 7357.12 | 10969.12 |
7 | Sunday | 1937 | 216 | 2121.76 | 4058.76 |
8 | Friday | 2548 | 294 | 4738.86 | 7286.86 |
8 | Saturday | 2833 | 317 | 4141.98 | 6974.98 |
8 | Sunday | 2214 | 284 | 4878.35 | 7092.35 |
9 | Friday | 1520 | 169 | 4102.49 | 5622.49 |
9 | Saturday | 4322 | 462 | 8639.55 | 12961.55 |
9 | Sunday | 1833 | 203 | 3946.71 | 5779.71 |
10 | Friday | 2271.63 | 235 | 4236.31 | 6507.94 |
10 | Saturday | 2407.88 | 266 | 5613.27 | 8021.15 |
10 | Sunday | 1772.17 | 182 | 5580.17 | 7352.34 |
11 | Friday | 1494 | 177 | 3833.52 | 5327.52 |
11 | Saturday | 1998 | 213 | 3986.57 | 5984.57 |
11 | Sunday | 1388 | 165 | 2721.56 | 4109.56 |
12 | Friday | 1925 | 190 | 3952.19 | 5877.19 |
12 | Saturday | 2695 | 243 | 6281.3 | 8976.3 |
12 | Sunday | 1525 | 172 | 3356.14 | 4881.14 |
13 | Friday | 1725 | 187 | 3822.59 | 5547.59 |
13 | Saturday | 2450 | 253 | 4141.75 | 6591.75 |
13 | Sunday | 1407.5 | 173 | 3312.41 | 4719.91 |
14 | Friday | 2394 | 242 | 4571.5 | 6965.5 |
14 | Saturday | 3012 | 311 | 6363.3 | 9375.3 |
14 | Sunday | 2058 | 239 | 3502.22 | 5560.22 |
15 | Friday | 2427 | 267 | 5881.13 | 8308.13 |
15 | Saturday | 3189 | 336 | 10409.13 | 13598.13 |
15 | Sunday | 2109 | 178 | 4955.05 | 7064.05 |
16 | Friday | 2244 | 184 | 4347.41 | 6591.41 |
16 | Saturday | 3195 | 274 | 4935.17 | 8130.17 |
16 | Sunday | 1017 | 114 | 3486.27 | 4503.27 |
17 | Friday | 3470 | 325 | 6290.99 | 9760.99 |
17 | Saturday | 5323 | 478 | 13132.55 | 18455.55 |
17 | Sunday | 2345 | 242 | 5014.45 | 7359.45 |
18 | Friday | 1671 | 177 | 2740.23 | 4411.23 |
18 | Saturday | 2321.94 | 246 | 4423.31 | 6745.25 |
18 | Sunday | 1542 | 182 | 2650.48 | 4192.48 |
SUMMARY OUTPUT | Force Constant to Zero | |||||||
FALSE | ||||||||
Regression Statistics | ||||||||
Multiple R | 1.000 | |||||||
R Square | 1.000 | Goodness of Fit >= 0.80 | ||||||
Adjusted R Square | 1.000 | |||||||
Standard Error | 0.000 | |||||||
Observations | 54 | |||||||
ANOVA | ||||||||
df | SS | MS | F | P-value | ||||
Regression | 5 | 242415180.7 | 48483036.13 | 7.69082E+31 | 0.000 | |||
Residual | 48 | 3.02593E-23 | 6.30401E-25 | |||||
Total | 53 | 242415180.7 | Confidence Level | |||||
0.95 | 0.99 | |||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 99% | Upper 99% | |
Intercept | 3.33226E-12 | 3.23284E-13 | 10.30751203 | 0.000 | 2.68225E-12 | 3.98227E-12 | 2.47E-12 | 4.2E-12 |
Total Daily Income | 1 | 9.08269E-17 | 1.101E+16 | 0.000 | 1 | 1 | 1 | 1 |
Daily Tour Income | -1 | 5.11073E-16 | -1.95667E+15 | 0.000 | -1 | -1 | -1 | -1 |
Number of Tourists | -3.85742E-15 | 3.45594E-15 | -1.116172333 | 0.270 | -1.0806E-14 | 3.0912E-15 | -1.3E-14 | 5.41E-15 |
Friday | -3.98354E-14 | 2.74974E-13 | -0.144869383 | 0.885 | -5.92709E-13 | 5.13038E-13 | -7.8E-13 | 6.98E-13 |
Saturday | 2.36042E-13 | 3.07759E-13 | 0.766969037 | 0.447 | -3.82749E-13 | 8.54833E-13 | -5.9E-13 | 1.06E-12 |
Sunday | 0 | 0 | 0 | 1.000 | 0 | 0 | 0 | 0 |
y = 0 +1*Total Daily Income -1*Daily Tour Income -0*Number of Tourists -0*Friday +0*Saturday +0*Sunday |