We are doing regression analysis for business analytics class and I am having a hard time reading...
We are doing regression analysis for business analytics class and I am having a hard time reading this data. Please help.
| SUMMARY OUTPUT | ||||||||
| Regression Statistics | ||||||||
| Multiple R | 0.999964 | |||||||
| R Square | 0.999928 | |||||||
| Adjusted R Square | 0.9999248 | |||||||
| Standard Error | 267.074107 | |||||||
| Observations | 48 | |||||||
| ANOVA | ||||||||
| df | SS | MS | F | Significance F | ||||
| Regression | 2 | 44576676715 | 2.23E+10 | 312474.2 | 6.1672E-94 | |||
| Residual | 45 | 3209786.045 | 71328.58 | |||||
| Total | 47 | 44579886501 | ||||||
| Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
| Intercept | -42159057 | 121894.4727 | -345.865 | 1.04E-78 | -42404564.6 | -4.2E+07 | -42404565 | -41913548 |
| Avg Customers | 4010.18173 | 11.54551185 | 347.3369 | 8.57E-79 | 3986.92788 | 4033.436 | 3986.92788 | 4033.4356 |
| Avg Annual Bill | 196.956207 | 29.07304657 | 6.774529 | 2.2E-08 | 138.400085 | 255.5123 | 138.400085 | 255.51233 |
Homework Answers
The estimated multiple regression equation is :
estimated y variable = -42159057 + 4010.18173*Avg Customers + 196.956207*Avg Annual Bill
Coefficient of determination R2 = 0.999928 = 99.9928%
99.9928% of variation in response variable (y) can be explained by the above regression equation.
Add Answer to:
We are doing regression analysis for business analytics class and I am having a hard time reading...
Hi I was wondering if i could have some help with some distribution questions. 1. show...
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...
1.Based on the table above, how to intepret this regression analysis? 2. When we need to...
1.Based on the table above, how to intepret this regression
analysis?
2. When we need to look at the adjusted r2 and why?
3. How to conduct the hypothesis test?
0 Regression Statistics 1 Multiple R 2 R Square 3 Adjusted RS 0.853658537 0,97530483 0.951219512 4 Standard Err 0.191273014 5 Observation 6 7 ANOVA Significance F 0.220863052 df SS MS 0.713414634 0.356707 9 Regression 0 Residual 1 Total 2. 9.75 1 0.036585366 0.036585 0.75 2 Lower 95 % 3 Coefficients...
What is the coefficient? What is the standard error? What is the z-statistic? Is the coefficient...
What is the coefficient?
What is the standard error?
What is the z-statistic?
Is the coefficient sufficiently different from zero? How about
one? Explain.
SUMMARY OUTPUT Regression Statistics Multiple R 0.58175248 R Square 0.33843594 Adjusted R S 0.31393357 Standard Err 1.1991813 Observations 29 ANOVA df SS MS Significance F 0.000932269 Regression 1 19.86268888 19.86268888 13.8123745 Residual 38.82696629 27 1.438035789 Total 58.68965517 28 Coefficients Standard Error P-value t Stat Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -0.0202247 0.223805467 -0.090367404...
In relation to the below output from the Regression Analysis of the S&P/ASX200 Index (X) and...
In relation to the below output from the Regression Analysis of the S&P/ASX200 Index (X) and from the company ABC Shares derived from weekly data over a 12 month period, can you please explain the key measures and what this all means eg. Number of Observations, R Square, Value of the Slope and the P-Value of the Slope etc. SUMMARY OUTPUT Regression Statistics Multiple R 0.045274332 R Square 0.002049765 Adjusted R Square -0.01790924 Standard Error 0.023996449 Observations 52 ANOVA df...
HW # 5 Linear Regression: Use Data Analysis in Excel to conduct the Regression Analysis to...
HW # 5 Linear Regression: Use Data Analysis in Excel to conduct the Regression Analysis to reproduce the excel out put below (Note: First enter the data in the next page in an Excel spreadsheet) Home Sale Price: The table below provides the Excel output of a regression analysis of the relationship between Home sale price(Y) measured in thousand dollars and Square feet area (x): SUMMARY OUTPUT Dependent: Home Price ($1000) Regression Statistics Multiple R 0.691 R Square 0.478 Adjusted...
Calculate the 95% prediction interval of y when x=5 using the 2000 pairs Mean of x...
Calculate the 95% prediction interval of y when x=5 using the 2000 pairs Mean of x = 4.51 Regression Statistics Multiple R 0.012848 R Square 0.000165 Adjusted R Square -0.00034 Standard Error 2.869737 Observations 2000 ANOVA df SS MS F Significance F Regression 1 2.716416 2.716416 0.329847 0.565814 Residual 1998 16454.31 8.235388 Total 1999 16457.02 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 4.509054 0.119572 37.70997 1.7E-235 4.274555 4.743552574 4.274555 4.743553 X 0.012884...
Dep.= % WRK Indep.= % MGT SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R...
Dep.= % WRK Indep.= % MGT SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations ANOVA Significance df SS MS F F Regression 102.1488 148.9539 Residual Total 12.0000 Standard Coefficients Error t Stat P-value Lower 95% Upper 95% Intercept % MGT 0.4543 SE CI CI PI PI Predicted Predicted Lower Upper Lower Upper x0 Value Value 95% 95% 95% 95% 67.0000 67.8474 65.8779 69.8169 72.0000 70.1189 68.2003 72.0375 76.0000 71.9361 69.7884 74.0838 Dep.= % MGT...
SUMMARY OUTPUT Regression Statistics Multiple R 0.99806038 R Square 0.996124522 Adjusted R Square 0.995155653 Standard Error...
SUMMARY OUTPUT Regression Statistics Multiple R 0.99806038 R Square 0.996124522 Adjusted R Square 0.995155653 Standard Error 387.1597665 Observations 16 ANOVA df SS MS F Significance F Regression 3 4.62E+08 1.54E+08 1028.131 9.91937E-15 Residual 12 1798712 149892.7 Total 15 4.64E+08 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 1946.802039 504.1819 3.861309 0.002263 848.2839829 3045.32 848.284 3045.32 XRay (x1) 0.038577091 0.013042 2.957935 0.011966 0.010161233 0.066993 0.010161 0.066993 BedDays (x2) 1.039391967 0.067556 15.38573 2.91E-09 0.892201042 1.186583...
Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.72 0.51 0.38 99.45...
Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.72 0.51 0.38 99.45 6 Anova df SS MS F Significance F 0.11 1 41497.60 41497.60 4.20 Regression Residual 4 39561.23 9890.31 Total 5 81058.83 t Stat P-value Coefficients Standard Error 1423.60 564.95 2.52 0.07 Intercept X Variable 1 Lower 95% Upper 95% -144.96 2992.16 -0.11 0.72 Lower 95.0% Upper 95.0% -144.96 2992.16 -0.11 0.72 0.31 0.15 2.05 0.11 Assume that Craig's Fresh and Hot Pancake Restaurant does...
Multiple Regression Analysis This information is taken from 80 homes recently sold along the Gulf of...
Multiple Regression Analysis This information is taken from 80 homes recently sold along the Gulf of Mexico coast.Analyze the data to discover which of the variable have a statistically significant influence on the sales price. A. Write out the equation for the model you develop B, Interpret the equation as a model and the meaning of the information for each variable in your "best" model C.Interpret the confidence intervals for each of the statistically significant variables Use the data provided...
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...
1.Based on the table above, how to intepret this regression
analysis?
2. When we need to look at the adjusted r2 and why?
3. How to conduct the hypothesis test?
0 Regression Statistics 1 Multiple R 2 R Square 3 Adjusted RS 0.853658537 0,97530483 0.951219512 4 Standard Err 0.191273014 5 Observation 6 7 ANOVA Significance F 0.220863052 df SS MS 0.713414634 0.356707 9 Regression 0 Residual 1 Total 2. 9.75 1 0.036585366 0.036585 0.75 2 Lower 95 % 3 Coefficients...
What is the coefficient?
What is the standard error?
What is the z-statistic?
Is the coefficient sufficiently different from zero? How about
one? Explain.
SUMMARY OUTPUT Regression Statistics Multiple R 0.58175248 R Square 0.33843594 Adjusted R S 0.31393357 Standard Err 1.1991813 Observations 29 ANOVA df SS MS Significance F 0.000932269 Regression 1 19.86268888 19.86268888 13.8123745 Residual 38.82696629 27 1.438035789 Total 58.68965517 28 Coefficients Standard Error P-value t Stat Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept -0.0202247 0.223805467 -0.090367404...
Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.72 0.51 0.38 99.45 6 Anova df SS MS F Significance F 0.11 1 41497.60 41497.60 4.20 Regression Residual 4 39561.23 9890.31 Total 5 81058.83 t Stat P-value Coefficients Standard Error 1423.60 564.95 2.52 0.07 Intercept X Variable 1 Lower 95% Upper 95% -144.96 2992.16 -0.11 0.72 Lower 95.0% Upper 95.0% -144.96 2992.16 -0.11 0.72 0.31 0.15 2.05 0.11 Assume that Craig's Fresh and Hot Pancake Restaurant does...
Most questions answered within 3 hours.
-
Consider the reaction, C3 H8 + O2 --> CO2 + H2O. How many
moles of O2...
asked 1 hour ago -
You and your opponent both roll a fair die. If you both roll the
same number,...
asked 1 hour ago -
In a study of the accuracy of fast food drive-through orders,
Restaurant A had 257 accurate...
asked 1 hour ago -
Identify and describe in detail the four categories of
institutions that could be included in a...
asked 1 hour ago -
In python
class Customer:
def __init__(self, customer_id, last_name, first_name, phone_number, address):
self._customer_id = int(customer_id)
self._last_name =...
asked 1 hour ago -
What is an example of a limitation in implementing a new
ERP system and how it...
asked 1 hour ago -
In a section of 9.7cm of an artery with a radius of 2.6mm there
is a...
asked 1 hour ago -
the two carboxylic acid groups of aspartic acid have different
acidities with pKa values of 2.1...
asked 1 hour ago -
Would CuCO3 aqueous salt combined with calcium chloride
form a solid precipitate? If so, what would...
asked 1 hour ago -
How do ECM Solutions assist in embedding a culture of continuous
improvement in an organization? (Project...
asked 1 hour ago -
Directions
These directions introduce the idea of Essential Questions.
Since this may be a new concept...
asked 1 hour ago -
1.b. Fiscal policy is said to suffer from ‘crowding out’.
Explain what this means and why...
asked 2 hours ago