An educator wants to see how the number of absences for a student in their class affects the student's final grade. The data obtained from a sample are shown in the Excel Workbook. Perform a complete regression analysis by performing, showing, and documenting all the following steps:

a) Draw the scatter plot and compute the correlation coefficient

b) State the hypotheses

c) Test the hypotheses at = 0.05 (use Table I)

d) Determine the regression line equation if r is significant

e) Plot the regression line on the scatter plot (if appropriate)

f) Summarize the results

the data shown below

	No. Absences (x)	10	12	2	0	8	5
	Final Grade (y)	70	65	96	94	75	82