Question

The data in the table is the number of absences for 7 students and their corresponding grade.

Number of Absences 1 2 2 3 5 6 7

Grade 3.8 3.8 2 1.8 1.7 1.6 1.6

Table Step 4 of 5 : Construct the 98% confidence interval for the slope. Round your answers to three decimal places.

USING EXCEL-------USING EXCEL-------------USING EXCEL

Answer 1

Regression output is given below

First of all, Input the Number of absence in column A and Grades in column B of excel sheet

Then go to

After selecting the regression

Select Column B (grades) for Input Y range

Select Column A (number of absences) for Input X range

Check the Confidence level mark and change it to 98%, then select the output options as "New workbook"

You will get the Regression output which is posted above

Output data shows that slope = -0.332 and 98% confidence interval for slope is (-0.774 , 0.109)