The following is part of regression output produced by Excel ( for Y vs X1 and...

The following is part of regression output produced by Excel ( for Y vs X1 and X2):

Y

12.9 6.1 1.1 39.7 3.4 5.9 8.9 15 7.3

X1

0.9 0.8 1.0 0.3 0.4 0.7 0.71 0.5 0.9

X2

4.2 3.1 1.2 15.7 2.5 0.7 5.0 6.4 3.0

A) write out the estimated regression equation showing that depends on X1 and X2.

b)if. X1=0.58 and X2=7.0, what is the value predicted for y

c)write the number which is the standard error of the regressions

d) which of the above value is the value of coefficient of multiple determination

e) if asked to do a simpler analysis by using only one of the two variables X1 and X2, which variable would be used?

Expert Solution

milcah answered 1 year ago

Using Excel generate a simple regression model with Y as the dependent variable and X1 and...

Using Excel generate a simple regression model with Y as the dependent variable and X1 and X2 as the independent variables in the attached spreadsheet. Write the following from the output: Intercept: Coefficients of Independent variable: R-square: Significance F: Based on the model generated, forecast profits for a firm with X1= Based on the model generated, forecast profits for a firm with x1=250 and X2=100. Evaluate the predictability of the model using explanatory language that someone who does not have...

The multiple regression model is estimated in Excel and part of the output is provided below....

The multiple regression model is estimated in Excel and part of the output is provided below. ANOVA df SS MS F Significance F Regression 3 3.39E+08 1.13E+08 1.327997 0.27152899 Residual 76 6.46E+09 85052151 Total 79 6.8E+09 Question 8 (1 point) Use the information from the ANOVA table to complete the following statement. To test the overall significance of this estimated regression model, the hypotheses would state there is between attendance and the group of all explanatory variables, jointly. there is...

Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable)...

Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). ANOVA df SS Regression 1 39947.80 Residual (Error) 10 8280.81 Total 11 48228.61 Coefficients Standard Error t Stat P-value Intercept 69.190 26.934 2.569 0.02795 X 2.441 0.351 6.946 0.00004 1. What is the estimated regression equation that relates Y to X? (2 Points) 2. Is the regression relationship significant? Use the p-value approach and alpha = 0.05 to answer this question. (2...

(27 pts total) What follows is hypothetical Excel output for doing regression of y on x....

(27 pts total) What follows is hypothetical Excel output for doing regression of y on x. The regression equation is: ^y = 54:6429 + 0:9451x Source DF SS MS F P Regression 1 130.0396 130.0396 20.7812 0.0019 Residual Error Total 9 180.1000 (a) (3 pts) Complete the ANOVA table above by lling in the \Residual Error" row above. (b) (6 pts) What are the values of the regression standard error s and the coecient of determination r2? (c) (6 pts)...

3.Below is the regression input and output (from Excel) for the regression in which the percentage...

3.Below is the regression input and output (from Excel) for the regression in which the percentage change in the exchange rate is the dependent variable (Y) and the inflation differential (inflation rate home – inflation rate foreign) is the independent variable (X). According to the Purchasing Power Parity theory, the hypothesized coefficients (null hypothesis) in the regression are 0 (intercept coefficient) and 1 (inflation differential coefficient). The directions for Problem Set 1 instruct you to first read sections of the...

The final part of the multiple regression output is the coefficients table that represents the following:...

The final part of the multiple regression output is the coefficients table that represents the following: The unstandardized regression coefficient (B). The standardized regression coefficient (beta or β). t and p values. All the above. Three correlation coefficients are displayed in the coefficients table. They include the following: The zero order correlation coefficient. The partial correlation coefficient. The part correlation coefficient. All of the above. If the value for tolerance is acceptable, one should proceed with interpreting the: Model summary....

The following is part of the computer output from a regression of monthly returns on Waterworks...

The following is part of the computer output from a regression of monthly returns on Waterworks stock against the S&P 500 Index. A hedge fund manager believes that Waterworks is underpriced, with an alpha of 2% over the coming month. Standard Deviation Beta R-square of Residuals 0.75 0.65 0.06 (i.e., 6% monthly) Now suppose that the manager misestimates the beta of Waterworks stock, believing it to be 0.50 instead of 0.75. The standard deviation of the monthly market rate of...

Generate and provide the full regression output using x1, x2, their squared terms, and their interaction, as 'x' variables against the 'y' variable.

X1 X2 Y 10 3 2002 5 14 1747 8 4 1980 7 4 1902 6 7 1842 7 6 1883 4 21 1697 11 4 2021 5 12 1750 6 8 1832 5 18 1795 7 4 1917 8 5 1943 6 9 1830 5 12 1786 A. Generate and provide the full regression output using x1, x2, their squared terms, and their interaction, as 'x' variables against the 'y' variable.

Use Excel to estimate a simple linear regression model for the following data (Y is a...

Use Excel to estimate a simple linear regression model for the following data (Y is a dependent variable and X is an independent variable): Y X 0 -2 0 -1 1 0 1 1 3 2 Fill in Multiple Blanks: What is the slope of the estimated line? In your answer, show one (1) digit to the right of the decimal point, for example, 1.0, 1.2. Apply the appropriate rounding rule if necessary. What is the Y-intercept?

The following table contains results from the regression of sales price (y) on lot size (x1),...

The following table contains results from the regression of sales price (y) on lot size (x1), number of bedrooms (x2), number of bathrooms(x3) and number of storeys (x4). Sales price is the dependent variable and x1,x2,x3,x4 are independent variables. R2 = 0.54 F= stat = 48.3235 p value and F - stat of 1.18E - 88 n > 30. a. Write down the least square prediction equation b.use R2 to check the validity of the model. c use " t-stat"...

Question