Using Excel enter the data

1. The following is data for the hours studied by students and the exam scores they received on their exams:

Hours studied (x): 10 11 15 14 8 5 13 3 12 2 7 9

Exam Score (y): 74 77 93 81 54 66 72 50 78 45 89 72

1)Using Excel enter the data in a spread sheet and make a scatter plot for these data (2)

Add the line of best feet (1)

Add the equation of the line of best feet (1)

Add a title to the scatter plot and label the axes (3)

Instructions: a) Select both columns

b) On Insert tab. click on scatter plot and choose the first one.

c) Right click on one of the dots and select “Add a trend line”

d) In the Add a trend line dialog box displayed, select Linear and Display the equation on the chart, close.

2) Describe the direction , form and strength of the plot (1)

3) Find the correlation coefficient. (1)

(Hint) In Formulas tab, select more functions, Statistical, in the list box choose Correl.

b) In the dialog box that will be displayed, in array 1 : select the first column, in array 2 : select the second column. Then click ok

II) In the table are displayed protein content of 14 different cereals.