1. please complete the following chart.

Participant	X	Y	XY	X^2	Y^2
1	3	1
2	2	1
3	5	1
4	7	4
5	4	7
6	5	2
7	5	3
8	3	2
9	9	2
10	6	4
11	6	4
12	8	5
13	5	5
14	5	3
15	5	1
16	7	2
17	5	4
18	2	5
19	6	4
20	8	7
21	5	3
22	10	6
Sums

1. Using the collected data, copy and paste the scatterplot created in Excel.

1. Show calculation for r and write a sentence with regards to its meaning with the given values.

1. State the hypotheses, show the calculation for t, draw and shade the curve, and make a decision about the null hypothesis.

1. Show work to calculate a and b and the equation of best fit it produces. Include the scatterplot with the matching equation from Excel.

1. Determine an appropriate x value and use the equation from question 9 to predict the y-value.

1. Show the work to calculate r^2 and discuss its meaning with regards to the problem.

1. Show the work to calculate Sest.

1. find the 95% prediction interval when the x-value from question 10 is used. Please state the interval and confidence is sentence format.