Explore BrainMass
Share

Explore BrainMass

    Correlation/Linear Regression

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

    1. Construct a scatter plot using excel for the given data. Determine whether there is a positive linear correlation, negative linear correlation, or no linear correlation. Complete the table and find the correlation coefficient r.

    a. The data below are the ages and systolic blood pressure (measured in millimeters of mercury) of 9 randomly selected adults.

    Age, x 38 41 45 48 51 53 57 61 65
    Pressure, y 116 120 123 131 142 145 148 150 152

    Part 1: Scatter plot

    Part 2: Type of correlation (positive linear correlation, negative linear correlation, or no linear correlation)

    Part 3: Complete the table and find the correlation coefficient r.

    x y xy x2 y2
    38 116
    41 120
    45 123
    48 131
    51 142
    53 145
    57 148
    61 150
    65 152

    Use the last row of the table to show the column totals.
    n = 9

    r =

    2. Construct a scatter plot using excel for the given data. Determine whether there is a positive linear correlation, negative linear correlation, or no linear correlation. Complete the table and find the correlation coefficient r. The data for x and y is shown below.

    x 11 -6 8 -3 -2 1 5 -5 6 7
    y -5 -3 4 1 -1 -2 0 2 3 -4

    Part 1: Scatter plot

    Part 2: Type of correlation (positive linear correlation, negative linear correlation, or no linear correlation)

    Part 3: Complete the table and find the correlation coefficient r.
    Answer
    x y xy x2 y2
    11 -5
    -6 -3
    8 4
    -3 1
    -2 -1
    1 -2
    5 0
    -5 2
    6 3
    7 -4

    Use the last row of the table to show the column totals.
    n = 10

    r =

    3. Using the r calculated in problem 1 test the significance of the correlation coefficient using  = 0.01 and the claim  = 0. Use the 7-steps hypothesis test shown at the end of this project.
    Answer:
    1. H0 :  = 0
    Ha :   0
    2.  =
    3. Find t
    4. t0 =
    5. Rejection region:
    6. Decision:
    7. Interpretation:

    Linear Regression

    4. The data below are the ages and systolic blood pressure (measured in millimeters of mercury) of 9 randomly selected adults.

    Age, x 38 41 45 48 51 53 57 61 65
    Pressure, y 116 120 123 131 142 145 148 150 152

    a. Find the equation of the regression line for the given data. Round the line values to the nearest two decimal places.

    b. Using the equation found in part a, predict the pressure when the age is 50. Round to the nearest year.

    Instruction to copy a graph from Excel to a Word document
    1. Create the graph in Excel.
    2. Put your mouse in the graph area and left click. You will see little black boxes top, bottom, sides and the corners. (If desired, you can resize your graph by dragging these boxes with your mouse.)
    3. With the boxes showing, choose EDIT COPY from the top menu.
    4. Go to the Word document, place your mouse pointer when you want the graph and choose EDIT PASTE form the top menu.
    5. Save your document.

    Guidelines -- Hypothesis Testing Steps:
    1. State H0 and Ha.
    2. Specify the level of significance alpha .
    3. Find the test statistic using the given data.
    4. Find the critical value(s) t0. Use the method specified in the problem statement.
    5. Define the rejection region using critical value(s)
    6. Make a decision to reject or fail to reject the null hypothesis.
    7. Interpret the decision in the context of the original claim.

    © BrainMass Inc. brainmass.com April 1, 2020, 4:47 pm ad1c9bdddf
    https://brainmass.com/math/graphs-and-functions/correlation-linear-regression-264015

    Attachments

    Solution Preview

    Correlation
    1. Construct a scatter plot using excel for the given data. Determine whether there is a positive linear correlation, negative linear correlation, or no linear correlation. Complete the table and find the correlation coefficient r.

    a. The data below are the ages and systolic blood pressure (measured in millimeters of mercury) of 9 randomly selected adults.

    Age, x 38 41 45 48 51 53 57 61 65
    Pressure, y 116 120 123 131 142 145 148 150 152

    Part 1: Scatter plot

    Part 2: Type of correlation (positive linear correlation, negative linear correlation, or no linear correlation)

    Positive correlation

    Part 3: Complete the table and find the correlation coefficient r.

    x y xy x2 y2
    38 116
    41 120
    45 123
    48 131
    51 142
    53 145
    57 148
    61 150
    65 152

    x y xy x2 y2
    38 116 4408 1444 13456
    41 120 4920 1681 14400
    45 123 5535 2025 15129
    48 131 6288 2304 17161
    51 142 7242 2601 20164
    53 145 7685 2809 21025
    57 148 8436 3249 21904
    61 150 9150 3721 22500
    65 152 9880 4225 23104
    Sum 459 1227 63544 24059 168843

    Use the last row of the table to show the ...

    Solution Summary

    The solution examines correlation/linear regression guidelines.

    $2.19