Explore BrainMass

Explore BrainMass

    Regression Analysis of Test Scores and Stress

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    See attached.

    7. 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, 8:50 pm ad1c9bdddf


    Solution Summary

    Step by step method for regression analysis is discussed here. Regression coefficients, coefficient of determination, scatter diagram and significance of regression model are explained in the solution. This solution is presented in an attached Excel file, Word file and PDF copy.