Question

In the following regression, X = total assets ($ billions), Y = total revenue ($ billions),...

In the following regression, X = total assets ($ billions), Y = total revenue ($ billions), and n = 64 large banks.

R2 0.519
Std. Error 6.977
n 64
ANOVA table
Source SS df MS F p-value
Regression 3,260.0981 1 3,260.0981 66.97 1.90E-11
Residual 3,018.3339 62 48.6828
Total 6,278.4320 63
Regression output confidence interval
variables coefficients std. error t Stat p-value Lower 95% Upper 95%
Intercept 6.5763 1.9254 3.416 .0011 2.7275 10.4252
X1 0.0452 0.0055 8.183 1.90E-11 0.0342 0.0563


(a) Write the fitted regression equation.
  
yˆy^ = _________ + _____________  X

(b-1) State the degrees of freedom for a two-tailed test for zero slope, and use Appendix D to find the critical value at α = .05. (Round t critical value to 3 decimal places.)
  

Degrees of freedom   
tcrit ±



  

(c-1) Calculate t. (Round your answer to 3 decimal places.)
  
tcalc _____________

(e-1) Calculate t2 and F. (Round your answers to the nearest whole number.)
  

t2
Fcalc


(e-2) Calculate R2   


(e-3) What is the percentage of variation in total revenue explained by total assets? (Round your answer to 1 decimal place.)
  
The percentage of variation in total revenue explained by total assets is  %-----

Homework Answers

Answer #1

I have answered the question below

Please up vote for the same and thanks!!!

Do reach out in the comments for any queries

Answer:

ANOVA table

Source

SS

df

MS

F

p-value

Regression

3,260.0981

1

3,260.0981

66.97

1.90E-11

Residual

3,018.3339

62

48.6828

Total

6,278.4320

63

Regression Output

confidence interval

variables

coefficients

std. error

t(df = 62)

p-value

95% lower

95% upper

Intercept

6.5763

1.9254

3.416

.0011

2.7275

10.4252

X1

0.0452

0.0055

8.183

1.90E-11

0.0342

0.0563

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The linear regression equation, Y = a + bX, was estimated. The following computer printout was...
The linear regression equation, Y = a + bX, was estimated. The following computer printout was obtained: Given the above information, the value of the R2 statistic indicates that 0.3066% of the total variation in X is explained by the regression equation. 30.66% of the total variation in X is explained by the regression equation. 0.3066% of the total variation in Y is explained by the regression equation. 30.66% of the total variation in Y is explained by the regression...
Below is a regression using X = average price, Y = units sold, n = 20...
Below is a regression using X = average price, Y = units sold, n = 20 stores.      R2 0.200     Std. Error 26.128     n 20     ANOVA table   Source SS df MS F p-value   Regression 3,080.89     1        3,080.89 4.51      .0478       Residual 12,288.31     18        682.68   Total 15,369.20     19          Regression output confidence interval   variables coefficients std. error t (df = 18) p-value 95% lower 95% upper   Intercept 614.9300     51.2343     12.002      .0000   ...
In regression analysis, the total variation in the dependent variable, measured by the total sum of...
In regression analysis, the total variation in the dependent variable, measured by the total sum of squares (SST), can be decomposed into two parts: the amount of variation that can be explained by the regression model, and the remaining unexplained variation. True False In employing the randomised block design of ANOVA, the primary interest lies in reducing the within-treatments variation in order to make easier to detect differences between the treatment means. True False If we reject the null hypothesis,...
Consider the following table: Source SS DF MS Test Statistic Regression 2268.92268.9    1134.451134.45 2.82.8 Error...
Consider the following table: Source SS DF MS Test Statistic Regression 2268.92268.9    1134.451134.45 2.82.8 Error ??       Total 6325.56325.5 1212 Copy Data Step 1 of 9: Calculate the Sum of Squared Error. Round your answer to two decimal places, if necessary. Step 2 of 9: Calculate the Degrees of Freedom among Regression. Step 3 of 9: Calculate the Degrees of Freedom among Error. Step 4 of 9: Calculate the Mean Squared Error. Round your answer to two decimal...
Consider the following table: Source SS DF MS Test Statistic Regression 2268.9    1134.45 2.8 Error...
Consider the following table: Source SS DF MS Test Statistic Regression 2268.9    1134.45 2.8 Error ?       Total 6325.5 12 Copy Data Step 1 of 9: Calculate the Sum of Squared Error. Round your answer to two decimal places, if necessary. Step 2 of 9: Calculate the Degrees of Freedom among Regression. Step 3 of 9: Calculate the Degrees of Freedom among Error. Step 4 of 9: Calculate the Mean Squared Error. Round your answer to two decimal...
In the simple linear regression model estimate Y = b0 + b1X A. Y - estimated...
In the simple linear regression model estimate Y = b0 + b1X A. Y - estimated average predicted value, X – predictor, Y-intercept (b1), slope (b0) B. Y - estimated average predicted value, X – predictor, Y-intercept (b0), slope (b1) C. X - estimated average predicted value, Y – predictor, Y-intercept (b1), slope (b0) D. X - estimated average predicted value, Y – predictor, Y-intercept (b0), slope (b1) The slope (b1) represents A. the estimated average change in Y per...
Study the following Minitab output from a regression analysis to predict y from x. a. What...
Study the following Minitab output from a regression analysis to predict y from x. a. What is the equation of the regression model? b. What is the meaning of the coefficient of x? c. What is the result of the test of the slope of the regression model? Let α = .10.Why is the t ratio negative? d. Comment on r2 and the standard error of the estimate. e. Comment on the relationship of the F value to the t...
efer to the ANOVA table for this regression. Source d.f. SS MS Regression 3 1,196,410 398,803...
efer to the ANOVA table for this regression. Source d.f. SS MS Regression 3 1,196,410 398,803 Error 26 379,332 14,590 Total 29 1,575,742 Picture Click here for the Excel Data File (a) State the degrees of freedom for the F test for overall significance. The degrees of freedom for regression are and for error . (b) Use Appendix F to look up the critical value of F for ? = .05. (Round your answer to 2 decimal places.) F.05 (c-1)...
Refer to the ANOVA table for this regression. Source d.f. SS MS Regression 3 1,154,649 384,883...
Refer to the ANOVA table for this regression. Source d.f. SS MS Regression 3 1,154,649 384,883 Error 18 349,308 19,406 Total 21 1,503,957 (a) State the degrees of freedom for the F test for overall significance. The degrees of freedom for regression are _____ and for error _____. (b) Use Appendix F to look up the critical value of F for α = .05. (Round your answer to 2 decimal places.) F.05 ________ (c-1) Calculate the F statistic. (Round your...
X Y 1 50 8 57 11 43 16 18 20 18 Use the estimated regression...
X Y 1 50 8 57 11 43 16 18 20 18 Use the estimated regression equation is y = 61.5 – 2.21x. A). Compute the Mean Square Error Using Equation. S^2 = MSE = SSE/(n-2) B). Compute The Standard Error of the estimate using equation. S = SQRT(MSE) = SQRT[SSE/(n-2)] C). Compute the estimated Standard Deviation of b1 using equation. Sb1 = S/SQRT[SUM(x-(x-bar))^2] D). Use the t-test to test the following hypothesis (α = 0.05) H0: β1 = 0...