# 27) The total blood cholesterol concentrations, in mg/dL, are shown below for a randomsample of six people. In the table below, x is the age of the subject and y is the subject'stotal cholesterol concentration. Find the 95% prediction interval when x = 58 years.27)x (age)364958696371204256194257245y (mg/dL)209A) Regression line: y = 1.82x +122.5Standard error of the estimate: sest= 16.51184Prediction interval for y(58): 159

Question
1 views
check_circle

Step 1

27)

Excel Procedure for Regression:

• Enter the data for x and y in Excel sheet.
• Go to Data
• Click on Data Analysis.
• Select ‘Regression’ and click on ‘OK’
• Select the column of y under ‘Input Y Range’.
• Select the column of x under ‘Input X Range’.
• Click on ‘OK’.

Excel Output:

Step 2

From the output, the regression equation is Y=122.506444+1.820697x.

The standard error of the estimate is 16.51184 and it is calculated below:

From the Excel output, the residual mean sum of squares is 272.6408264.

Step 3

The 95% prediction interval for x=58 is (179,279) and it is calculated below:

The pre...

### Want to see the full answer?

See Solution

#### Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in