Question

Correlation &Regression


Considering \(Y\) as a dependent variable, a regression model is applied with three independent variables \(\mathrm{X} 1 \mathrm{X} 2\) and \(\mathrm{X} 3 .\) The results of the regression analysis are shown below:

image.png

Answer the following:

1. Define \(\mathrm{R}\) and \(\mathrm{R}\) Square.

2. What is the significance of \(\mathrm{F}\) test.

3. Which variable has the highest impact on Y.

4. Write the regression equation.

5. Calculate \(Y\) if \(X_{1}=10, X_{2}=20\) and \(X_{3}=5\)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1. \(\mathrm{R}=\) Correlation coefficient

\(\mathrm{R}\) is a statistical measure of the strength of the relationship between the relative movements of two variables.

Here, \(\mathrm{R}=0.969\)

Therefore, \(96.9 \%\) of strength in the relationship between two variables.

R square= coefficient of determination.

R square measures the proportion of variation in dependent variable is explained by independent variables.

Here, \(\mathrm{R}\) square \(=0.939\)

Hence, 0.939 proportion of variation in \(y\) is explained by \(x 3, x 4\) and \(x 5 .\)

2. The significance F gives the probability that the model is wrong.

Statistically, the significance \(\mathrm{F}\) is the probability that the null hypothesis is our regression model cannot be rejected.

3. X4 variable has the highest impact on y. Because t significance is less than alpha sonwe reject null hypothesis and support the claim. Also \(\beta\) corresponding \(\times 4\) is greater than other \(\beta\) 's.

4. The regression equation is,

$$ y=35.681-0.654 * x 3+0.233 * x 4+0.115 * x 5 $$

5. \(X 1=10, x 2=20, x 3=5\)

$$ y=35.681-0.654^{*} 5=32.41 $$

answered by: 2freepe
Add a comment
Know the answer?
Add Answer to:
Correlation &Regression
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • In the simple linear regression equation, (y a+ bx+ e), the a is the... O A....

    In the simple linear regression equation, (y a+ bx+ e), the a is the... O A. independent variable O B. slope of the fitted line C. dependent variable O D.y-intercept Reset Selection Question 2 of 5 1.0 Points In the simple linear regression equation, (y a+bx+ e) the y is the O A. independent variable O B. dependent variable O C. slope of the fitted line D. y-intercept Question 3 of 5 1.0 Points The R2 for a regression model...

  • A researcher uses two regression models to seek answers to two research questions. These models a...

    A researcher uses two regression models to seek answers to two research questions. These models are: Y1 = Bo1 + B11X1 Y2 = Bo2 + B12X1 + B22X12 Test the null hypotheses for both models. Use the results of your analyses to recommend an appropriate model. In each of the above two cases, state your null and alternative hypotheses, decision criteria, decision and conclusion. The level of significance is 5%. The data for this study are presented in the table...

  • 18 QueSLIVIT TO Based on the following regression output, what is the equation of the regression...

    18 QueSLIVIT TO Based on the following regression output, what is the equation of the regression line? Regression Statistics Multiple R 0.99313 0.98630 R Square Adjusted R Square Standard Error 0.98238 2.94802 10 Observations ANOVA df SS MS Significance F Regression 4379.182 2189.591 251.943 0.0000 Residual 7 60.836 8.691 9 Total 4440.017 Coefficients Standard Error t Stat P-value Lower 95% 14.169 3.856 3.674 Intercept 0.008 5.050 X Variable 1 0.985 0.114 8.607 0.000 0.714 X Variable 0.995 0.057 17.498 0.000...

  • I have to submit a term paper which involves conducting a regression and correlation analysis on ...

    I have to submit a term paper which involves conducting a regression and correlation analysis on any topic of my choosing. The paper must be based on yearly data for any economic or business variable, for a period of at least 20 years. The following also must be included in the paper: • The term paper should distinguish between dependent and independent variables; determine the regression equation by the least squares method; plot the regression line on a scatter diagram;...

  • Regression Variables Entered/Removeda Model Variables Entered Variables Removed Method 1 Warranty_Yearsb . Enter a. Dependent Variable:...

    Regression Variables Entered/Removeda Model Variables Entered Variables Removed Method 1 Warranty_Yearsb . Enter a. Dependent Variable: Number_of_people_mentioned b. All requested variables entered. Model Summary Model R R Square Adjusted R Square Std. Error of the Estimate 1 .503a .253 .251 .95930 a. Predictors: (Constant), Warranty_Years ANOVAa Model Sum of Squares df Mean Square F Sig. 1 Regression 80.590 1 80.590 87.574 .000b Residual 237.425 258 .920 Total 318.015 259 a. Dependent Variable: Number_of_people_mentioned b. Predictors: (Constant), Warranty_Years Coefficientsa Model Unstandardized...

  • Dummy Variable Regression: Choose any metric variable as the dependent variable (you can use the ...

    Dummy Variable Regression: Choose any metric variable as the dependent variable (you can use the same one that you used in Part A) and choose gender as an independent variable. Also choose one more metric variable as an additional independent variable. Once again, however, you must sort through the metric independent variables until you find one that, along with gender, produces a significant F-calc. Use alpha = .05 here as well.   You only need to report the model that produced...

  • Oliò Description and Requirements Computer Lab Assignment #9 1. Use Excel and the "Restaurant" da...

    oliò Description and Requirements Computer Lab Assignment #9 1. Use Excel and the "Restaurant" data set file located in D2L for this assignment 2. For each class (Class 1 to 14), consider the number of customers for day 7. Call this new variable, day data, as X1. Consider the number of waiters/waitresses as variable X2.Consider the customer satisfaction as vanable Y In another word, create a table for variables Y, X.X2 Dependent Variable: Y Independent Variables: X,X2 3. Find a...

  • 12: A researcher for MLMO (Malco Lifestyle Merchandise for Oligarchs) is attempting to explain the dependent...

    12: A researcher for MLMO (Malco Lifestyle Merchandise for Oligarchs) is attempting to explain the dependent variable of solid gold toilet Sales (in $1000s) in its 30 nationwide stores using multiple regression analysis. In the model, the researcher includes such independent variables as Price (advertised price per unit in $1000s), Competitors' Advertising Expenditures ($1000s), FloorSpace (in square meters), and whether the store is in the South (1 = south; 0 = elsewhere). For the following multiple regression output, answer the...

  • What information does R (that is, r-squared) provide in general about the fit of a regression...

    What information does R (that is, r-squared) provide in general about the fit of a regression model? It is exactly equal to the correlation between X and Y. It tells us the proportion of variability in the dependent variable, Y, that is explained by the model. It tells us the proportion of variability in the independent variable, X, that is explained by the model We should keep choosing different independent variables until R equals 1 O The closer R is...

  • 1. Which of the following is correct? A. In correlation analysis there are two variables and...

    1. Which of the following is correct? A. In correlation analysis there are two variables and both are dependent B. I n correlation analysis there are two variables and both are independent C. I n regression analysis there are two variables and both are dependent D: In regression analysis there are two variables and both are independent 2. measures the strength of linear association between two variables. A. Regressor B. Regressand C. Correlation coefficient D. None 3. the independent variables....

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
ADVERTISEMENT