Using the Class Preparation dataset provided:

a.Generate a scatterplot of the two variables using Excel between the variables "y = Test Scores (percentage)" and "x = Study time (hours)". (2 points)

i.Label this scatterplot as Scatterplot 1a. Provide an appropriate title for the chart and labels for both axes.

ii.Describe the relationship depicted on the scatterplot.

b.Identify outlier/s and delete it/them (simply remove the values, do not replace with zero). (2 points)

i.Show the new scatterplot and label as Scatterplot 1b.

ii.Describe the pattern that emerges. What might this relationship imply? Be careful not to infer cause and effect

c.Compute the Pearson's correlation coefficient between the two variables (while outlier is deleted) and explain the correlation obtained. Refer to both the strength and direction of the correlation in your interpretation. Include the correlation table. (2 points)

d.Calculate the correlation in terms of r-squared (coefficient of determination) and interpret the r-squared. Be careful not to infer cause and effect.(2 points)

Information

TEST SCORES- STUDY TIME 85 -3 87- 4 74- 3 95- 6 76- 3 66- 1.5 90- 4 38- 0.25 39- 0.5 59- 1 85- 4 72- 1.5 78- 1.5 93- 5 86- 3 69- 1 78- 2.5 72- 2 92 -2 100- 0 43- 1.5 42 -3 97-3.5 88 -3 66- 2 97- 6 96- 3 85-2.5 86- 2 59 -12 85- 3 81 -3 87 -0.5 86 -3 62- 2 83- 3.5 32 -1 50 -2 92 -2 44 -2 64 -1 86 -4 77 -3 78 -2 93 -2.5 27 -0 93 -2 95 -3.5 46 -2