HomeworkLib
Question

4. Part of an Excel output relating X (independent variable) and Y (dependent variable) is shown...

4. Part of an Excel output relating X (independent variable) and Y (dependent variable) is shown below.

Fill in all the blanks marked with "?". Summary Output Regression Statistics

Multiple R ?

R Square ?

Adjusted R Square 0.8125

Standard Error 1.3693064

Observations 7

ANOVA

df SS MS F Significance F

Regression ? 50.625 ? ? ?

Residual ? 9.375 ?

Total 6 60

Coefficients Standard Error. t Stat P-value Lower 95%

Intercept 13.75 1.398341. 9.833082 0.0001853 10.15555

x -1.125 0.216506 ? ? - 1.68155

What is estimated regression equation

Perform a t test and determine whether or not x and y are related .Use. 0.05 level of signifiance

Perform a F test and determine whether the model is significant.Use. 0.05 level of signifiance

Calculate and interpret the coefficient of determination. What is the correlation between two variables?

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

0 0
Add a comment
Know the answer?
Add Answer to:
4. Part of an Excel output relating X (independent variable) and Y (dependent variable) is shown...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Part of an Excel output relating 15 observations of X (independent variable) and Y (dependent variable)...

    Part of an Excel output relating 15 observations of X (independent variable) and Y (dependent variable) is shown below. Provide the values for a-e shown in the table below. (See section 15.5) Summary Output ANOVA df SS MS F Significance F Regression 1 2.7500 -d- -e- 0.632 Residual -a- -b- 11.45 Total 14 -c- A Company has recorded data on daily demand for its product (y in thousands of units) and the unit price (x in hundreds of dollars). A...

  • Q 10: Shown below is a portion of an Excel output for regression analysis relating Y...

    Q 10: Shown below is a portion of an Excel output for regression analysis relating Y (dependent variable) and X (independent variable). Degrees of Freedom Regression 205 Residual 53.28 Total 341.33 SS Coefficients Standard Error t Stat p-value Intercept 53.90 6.7105 8.0379 0.001 Volume 4.06 0.8724 4.6505 0.009 the estimated regression equation that relates (Y) to (X)? ce the coefficient of determination between Y and X. e result.

  • 5. Summary of regression between a dependent variable y and two independent variables X, and x2...

    5. Summary of regression between a dependent variable y and two independent variables X, and x2 is as follows. Please complete the table: SUMMARY OUTPUT Regression Statistics Multiple R 0.9620 R Square R2E? Adjusted R Square 0.9043 Standard Error 12.7096 Observations 10 ANOVA F Significance F F=? Overall p-value=? Regression Residual Total 2 df of SSE MS MSR=? MSE? 14052.1550 1130.7450 SSTE? MSE? 9 Coefficients -18.3683 Standard Error 17.9715 t Stat -1.0221 Intercept ty=? 2.0102 4.7378 0.2471 0.9484 P-value 0.3408...

  • Below you are given a partial computer output based on a sample of 8 observations, relating...

    Below you are given a partial computer output based on a sample of 8 observations, relating an independent variable (x) and a dependent variable (y). Coefficient Standard Error 7.032 0.184 t-Stat -1.3456 4.1793 Intercept Analysis of Variance SOURCE Regression Error (Residual) 400 138 a. Develop the estimated regression line. b. At a = 0.05, perform an F test. C. Determine the coefficient of determination.

  • The following regression output was generated based on a sample of utility customers. The dependent variable...

    The following regression output was generated based on a sample of utility customers. The dependent variable was the dollar amount of the monthly bill and the independent variable was the size of the house in square feet. SUMMARY OUTPUT Multiple R 0.149769088 R Square 0.02243078 Adjusted R Square -0.012482407 Standard Error 16.72762259 Observations 30   ANOVA df SS MS F Regression 1 179.7725274 179.7725 0.642473 Residual 28 7834.774007 279.8134 Total 29 8014.546534 Coefficients Standard Error t Stat    P-value Intercept 66.44304169...

  • Below you are given a partial computer output based on a sample of 21 observations, relating...

    Below you are given a partial computer output based on a sample of 21 observations, relating an independent variable (x) and a dependent variable (y). Coefficient Standard Error 1.181 Intercept 30.139 0.022 X -0.252 Analysis of Variance SOURCE SS Regression 1,759.481 259.186 Error Develop the estimated regression line At a 0.05, perform an F test. Determine the coefficient of determination. a. b. c. d. Determine the coefficient of correlation.

  • The data shown below for the dependent variable, y, and the independent variable, x, have been...

    The data shown below for the dependent variable, y, and the independent variable, x, have been collected using simple random sampling. X 10 15 11 19 18 17 5 17 18 y 9070 30 8020 30 5060 40 40 a. Develop a simple linear regression equation for these data. b. Calculate the sum of squared residuals, the total sum of squares, and the coefficient of determination c. Calculate the standard error of the estimate. d. Calculate the standard error for...

  • Following a regression analysis output : SUMMARY OUTPUT Regression Statistics Multiple R 0.719422 R Square Adjusted...

    Following a regression analysis output : SUMMARY OUTPUT Regression Statistics Multiple R 0.719422 R Square Adjusted R Square 0.477366 Standard Error Observations 14 ANOVA df SS MS F Regression 1 3.028885709 Residual 12 2.823257148 Total 13 5.852142857 Coefficients Standard Error t Stat P-value Intercept 1.157091 0.566482479 0.063699302 Satisfaction with Speed of Execution 0.636798 0.177478218 0.003726861 Group of answer choices R Square is 0.517 Standard error is 0.386 Residuals are 2.823 F-test is 11.87 R Square is 0.517 Standard error is...

  • 5- Interpret the coefficient of determination (R-squared) and the F test. SUMMARY OUTPUT Regression Statistics Multiple...

    5- Interpret the coefficient of determination (R-squared) and the F test. SUMMARY OUTPUT Regression Statistics Multiple R 0.8811 R Square 0.7764 Adjusted R Square 0.7205 Standard Error 14.7724 Observations 16 ANOVA df SS MS F Regression 3 9091.7392 3030.5797 13.8874 Residual 12 2618.7008 218.2251 Total 15 11710.44 Coefficients Standard Error t Stat P-value Intercept 29.1385 174.7427 0.1668 0.8703 PFH -2.1236 0.3405 -6.2361 0.0000 PR 1.0345 0.4667 2.2164 0.0467 M 3.0871 0.9993 3.0892 0.0094

  • A regression model relating x, number of salespersons at a branch office, to y, annual sales...

    A regression model relating x, number of salespersons at a branch office, to y, annual sales at the office (in thousands of dollars) provided the following computer output from a regression analysis of the data. Where n total=26. a. Write the estimated regression equation (to whole number). y=_____+_____x b. Compute the F statistic and test the significance of the relationship at a .05 level of significance. (to 2 decimals) F-value ____ p-value is _______, we _________ h0 c. Compute the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT