Question

In: Statistics and Probability

1. What would the regression output (analysis) look like using this multiple regression equation and the...

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

Solutions

Expert Solution

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


Related Solutions

How would you differentiate among multiple discriminant analysis, regression analysis, logistic regression analysis, and analysis of...
How would you differentiate among multiple discriminant analysis, regression analysis, logistic regression analysis, and analysis of variance and demonstrate statistical significance for each?
When reviewing the regression analysis output the statistics that must be evaluated the equation to describe...
When reviewing the regression analysis output the statistics that must be evaluated the equation to describe the statistical relationship between one or more predictor variables and the response variable. The p-value for each term tests the null hypothesis that the coefficient is equal to zero (no effect). A low p-value (<0.05) indicates that you can reject the null hypothesis. An analyst that has a low p-value is likely to be a meaningful addition to your model because changes in the...
1. What is meant by collinearity in multiple regression analysis? 2.What is the significance of the...
1. What is meant by collinearity in multiple regression analysis? 2.What is the significance of the correlation coefficient (r)? 3. How do researchers attribute cyclical movements in a time series?
Propose a regression equation you would like to estimate. Write out the equation and define the...
Propose a regression equation you would like to estimate. Write out the equation and define the dependent and independent variables, and indicate how you would measure them. What type of data would you use and, as a result, what is an observation in your dataset? Finally, why would you want to estimate this regression – what would be the purpose/insight?
Regression equation for Case 3.0: SUMMARY OUTPUT Regression Statistics Multiple R 0.957 R Square 0.915 Adjusted...
Regression equation for Case 3.0: SUMMARY OUTPUT Regression Statistics Multiple R 0.957 R Square 0.915 Adjusted R Square 0.908 Standard Error 5.779 Observations 52 ANOVA df SS MS F Significance F Regression 4 16947.86487 4236.9662 126.8841 1.45976E-24 Residual 47 1569.442824 33.392401 Total 51 18517.30769 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 39.08190 15.31261 2.55227 0.014012 8.27693 69.88687 X-Price -7.37039 0.98942 -7.44921 1.71E-09 -9.36084 -5.37994 Y-Price -5.42813 0.33793 -16.06289 1.03E-20 -6.10796 -4.74831 Z-Price 4.05067 0.33949 11.93173 7.95E-16...
DEFINE THE COMPONENTS OF A GENERAL MULTIPLE REGRESSION EQUATION. IN A MULTIPLE REGRESSION ANOVA TABLE, THE...
DEFINE THE COMPONENTS OF A GENERAL MULTIPLE REGRESSION EQUATION. IN A MULTIPLE REGRESSION ANOVA TABLE, THE DEGREES OF FREDOM FOR THE REGRESSION IS EQUAL TO: THE TEST TO CONFIRM WHETHER THE DEPENDENT VARIABLE CAN BE ESTIMATED WITHOUT RELYING ON THE INDEPENDENT VARIABLES IS REFERRED TO AS: WHAT STATISITIC WOULD WE USE FOR TESTING TO SEE IF AT LEAST ONE INDEPENDENT REGRESSION COEFFICIENTS IS SIGNIFICANT? TO TEST INDEPENDENT VARIABLES INDIVIDUALLY TO DETERMINE WHETHER THE REGRESSION COEFFICIENTS DIFFER FROM ZERO WOULD BE:...
DEFINE THE COMPONENTS OF A GENERAL MULTIPLE REGRESSION EQUATION. IN A MULTIPLE REGRESSION ANOVA TABLE, THE...
DEFINE THE COMPONENTS OF A GENERAL MULTIPLE REGRESSION EQUATION. IN A MULTIPLE REGRESSION ANOVA TABLE, THE DEGREES OF FREDOM FOR THE REGRESSION IS EQUAL TO: THE TEST TO CONFIRM WHETHER THE DEPENDENT VARIABLE CAN BE ESTIMATED WITHOUT RELYING ON THE INDEPENDENT VARIABLES IS REFERRED TO AS: WHAT STATISITIC WOULD WE USE FOR TESTING TO SEE IF AT LEAST ONE INDEPENDENT REGRESSION COEFFICIENTS IS SIGNIFICANT? TO TEST INDEPENDENT VARIABLES INDIVIDUALLY TO DETERMINE WHETHER THE REGRESSION COEFFICIENTS DIFFER FROM ZERO WOULD BE:...
Below you are given a partial computer output from a multiple regression analysis based on a...
Below you are given a partial computer output from a multiple regression analysis based on a sample of 16 observations. Coefficients Standard Error Constant 12.924 4.425 x1 -3.682 2.630 x2 45.216 12.560 Analysis of Variance Source of Variation Degrees of Freedom Sum of Squares Mean Square F Regression 4853 2426.5 Error 485.3 ​ Carry out the test of significance for the variable x1 at the 1% level. The null hypothesis should be options: be tested for β₃ instead. be rejected....
Using the existing regression equation, what would you predict the revenue of a team to be...
Using the existing regression equation, what would you predict the revenue of a team to be if the coach’s salary is .5 million and the winning percentage is 30 percent? Select one: a. 12 Million b. 14.8 Million c. 15.0 Million d. 14.2 Million e. Cannot be determined from the data. School Revenue %Wins Salary Alabama 6.5 61 1.00 Arizona 16.6 63 0.70 Arkansas 11.1 72 0.80 Boston College 3.4 80 0.53 California 6.0 68 0.85 Cincinnati 5.7 61 0.18...
Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and...
Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and determine the predicted total sales value if the number of promotions is 6. Is there a significant relationship? Clearly explain your reasoning using the regression results. Number of Promotions Total Sales 3 2554 2 1746 11 2755 14 1935 15 2461 4 2727 5 2231 14 2791 12 2557 4 1897 2 2022 7 2673 11 2947 11 1573 14 2980
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT