Explore BrainMass
Share

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.
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.
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.

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.

https://brainmass.com/math/graphs-and-functions/correlation-linear-regression-264015

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