SUMMARY OUTPUT |
||||
Regression Statistics |
||||
Multiple R |
? |
|||
R Square |
0.84869 |
|||
Adjusted R Square |
0.83054 |
|||
Standard Error |
0.43435 |
|||
Observations |
? |
|||
ANOVA |
||||
df |
SS |
MS |
F |
|
Regression |
3 |
26.4558 |
? |
? |
Residual |
? |
4.7166 |
? |
|
Total |
? |
? |
||
Coefficients |
Standard Error |
t Stat |
P-value |
|
Intercept |
-0.5753 |
0.4786 |
-1.2020 |
0.2406 |
Number of cases |
-0.0028 |
0.1674 |
-0.0165 |
0.9870 |
Distance |
0.1006 |
0.1423 |
0.7069 |
0.4862 |
Delivery charges |
1.0481 |
0.1192 |
8.7940 |
0.0000 |
Multiple R | 0.92124372 | |||
R Square | 0.84869 | |||
Adjusted R Square | 0.83054 | |||
Standard Error | 0.43435 | |||
Observations | 29 | |||
ANOVA | ||||
df | SS | MS | F | |
Regression | 3 | 26.456 | 8.8186 | 46.7423568 |
Residual | 25 | 4.7166 | 0.1887 | |
Total | 28 | ? | ||
Coefficients | Standard Error | t Stat | P-value | |
Intercept | -0.5753 | 0.4786 | -1.202 | 0.2406 |
Number of cases | -0.0028 | 0.1674 | -0.017 | 0.987 |
Distance | 0.1006 | 0.1423 | 0.7069 | 0.4862 |
Delivery charges | 1.0481 | 0.1192 | 8.794 | 0 |
y = -0.5753 - 0.0028*x1 + 0.1006*x2 + 1.0481*x3
The hypothesis being tested is:
H0: β1 = 0
H1: β1 ≠ 0
The p-value is 0.987.
Since the p-value (0.987) is greater than the significance level (0.05), we fail to reject the null hypothesis.
Therefore, we cannot conclude that the slope is significant.
The hypothesis being tested is:
H0: β2 = 0
H1: β2 ≠ 0
The p-value is 0.4862.
Since the p-value (0.4862) is greater than the significance level (0.05), we fail to reject the null hypothesis.
Therefore, we cannot conclude that the slope is significant.
The hypothesis being tested is:
H0: β3 = 0
H1: β3 ≠ 0
The p-value is 0.0000.
Since the p-value (0.000) is less than the significance level (0.05), we can reject the null hypothesis.
Therefore, we can conclude that the slope is significant.
The hypothesis being tested is:
H0: β1 = β2 = β3 = 0
H1: At least one βi ≠ 0
The p-value is 0.0000.
Since the p-value (0.000) is less than the significance level (0.05), we can reject the null hypothesis.
Therefore, we can conclude that the model is significant.
1. A soft drink bottler is analyzing the vending machine serving routes in his distribution system....
You estimate the demand function for soft drinks using a multiple regression model. The MS Excel printout for the regression follows: SUMMARY OUTPUT Regression Statistics Multiple R 0.835478305 R Square 0.698023997 Adjusted R Square 0.677434724 Standard Error 38.26108281 Observations 48 ANOVA df SS MS F Significance F Regression 3 148889.8565 49629.95217 33.9023141 1.64557E-11 Residual 44 64412.06016 1463.910458 Total 47 213301.9167 Coefficients Standard Error t Stat P-value Intercept 514.2669369 113.3315243 4.537721874 4.36383E-05 6 pack price 242.9707509 43.52628127 5.582161944 1.38245E-06 mean temp...
Hi I was wondering if i could have some help with some distribution questions. 1. show where zero and one fall on a normal distribution based on thedata. 2.is the coefficient sufficiently different than zero? explain 3. is the coefficient sufficiently different than one? explain. Regression Statistics Multiple R 0.806174983 0.649918103 R Square Adjusted R Square Standard Error Observations 0.636952107 13.57635621 29 ANOVA Significance F E SS MS df 9238.877183 9238.877 50.12481 1.30123E-07 Regression Residual 4976.571093 184.3174 27 14215.44828 Total...
11. (35 pts) An agent for a real estate company wanted to predict the monthly rent for one- bedroom apartments, based on the size of the apartment (see summary output below). Using the results, identify the coefficient of determination, r2, and interpret its meaning. SUMMARY OUTPUT Regression Statistics Multiple R 0.354314 R Square 0.125539 Adjusted R Square 0.106529 Standard Error 186.0407 Observations 48 ANOVA df Regression Residual Total 1 46 47 Significance SS MS F F 228565.2 228565.2 6.603807 0.013481439...
Valle Crucis Corporation wanted to determine the relationship between its monthly operating costs and a potential cost driver, machine hours. The output of a regression analysis showed the following information (note: only a portion of the regression analysis results is presented here): (Click the icon to view the portion of the regression analysis.) What is the variable cost per unit answers are rounded)? O A. $2,946 O B. $.98 OC. $.05 OD. $.72 Data Table SUMMARY OUTPUT Regression Statistics Multiple...
SUMMARY OUTPUT Regression Statistics Multiple R 0.818616296 R Square 0.67013264 Adjusted R Square 0.658351663 Standard Error 9.16867179 Observations 30 ANOVA df SS MS F Significance F Regression 1 4781.80995 4781.80995 56.8826 3.2455E-08 Residual 28 2353.807187 84.06454239 Total 29 7135.617137 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 28.21496731 3.739591617 7.544932763 3.22E-08 20.55476114 35.87517349 Dividend 2.367177613 0.313863719 7.542055589 3.25E-08 1.724256931 3.010098296 c. You run a regression analysis using Data Analysis to answer the following question: Is stock selling...
1.a. Conduct a two-sample t-test to find out if there is a significant difference between U.S. stock returns and U.S. corporate bond returns using the monthly data covering the sample period 1980-2017. 1.b. Conduct a two-sample t-test to find out if there is a greater returns for U.S. stock as compared to U.K. stock returns using the monthly data covering the sample period 1980-2017. 2. Estimate a multiple linear regression relationship with the U.K. stock returns as the dependent variable,...
Valle Crucis Corporation wanted to determine the relationship between its monthly operating costs and a potential cost driver, machine hours. The output of a regression analysis showed the following information (note: only a portion of the regression analysis results is presented here) (Click the icon to view the portion of the regression analysis ) What is closest to the total cost if the firm uses 4,200 machine hours? i Data Table O A. $12 372,975 38 OB. $2,945 95 O...
Step 1 For each of the independent variables contained in the regression model in Step 1, test their statistical significance. In testing statistical significance of a regression coefficient, you have to justify your choice of one or two tail test. (PLEASE SHOW ALL WORKING) SUMMARY OUTPUT Regression Statistics Multiple R 0.31179522 0.097216259 R Square Adjusted R Square0.08877902 Standard Error 15.42093465 Observations 649 ANOVA df MS Significance F Regression 6 16440.370442740.0617411.52229408 2.87685E-12 Residual 642 152670.9547 237.8052254 Total 648 169111.3251 P-value Coefficients...
Kerri Tran, owner of Flower Hour, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Tran wants to set the delivery fee based on the distance driven to deliver the flowers. Tran wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. Flower Hour does a regression analysis on the next year's...
ANOVA problem, data given! Please help 8 pts D Question 1 A researcher is interested to find out how the engine displacement, vehicle weight, and the type of transmission [i.e. automatic & manual] affect the automobile gasoline mileage. Type of transmission is represented by one dummy variable: automatic (-1, if transmission is automatic; 0, if transmission is manual) Part of the raw data and the regression output of 40 different car models are given below. Displacementícubic Weightlb) in) Automobile Miles/gallon...