# Regression Equation and Variables

It is recommended that you use the computer EXCEL sheet attached to help you answer the following questions: Write the answers in the provided space. An answer saying "see attached page" is not an option. There are almost no calculations. Most of the answers are on the EXCEL spreadsheet.

X Y

Stress Test

Score Score

6.5 81

4.0 96

2.5 93

7.2 70

8.1 63

3.4 84

5.5 73

sum 37.2 560

Given the above data for a regression analysis answer the following questions.

A. What is the independent and what is the dependent variable?

B. Develop the simple linear regression equation.

C. Find (Calculate) the Correlation Coefficient.

D. What percent of the total variation is explained by the regression equation?

E. What is the value of Y6 ? i.e. what is the expected test score with a stress level of 6.0?

© BrainMass Inc. brainmass.com June 3, 2020, 6:21 pm ad1c9bdddfhttps://brainmass.com/statistics/regression-analysis/regression-equation-and-variables-56904

#### Solution Summary

This Solution contains calculations to aid you in understanding the Solution to these questions.