Mary Sue wants to know if there is a connection between attendance at craft fairs and the number of exhibitors who have booths at the fair. For a random sample of seven local craft fairs, she chose a random day of the fair and recorded the number of exhibitors. In the data below, x represents the number of exhibitors and y represents the attendance in hundreds of people.
x 35 55 75 95 100 135 150
y 1.2 2.1 4.2 5.4 5.8 6.2 9.5
a) Draw the scatter diagram for the data.
b) Calculate the sample correlation coefficient, r.
c) Calculate the coefficient of determination, r2.
d) What does the coefficient of determination tell you about the variation in attendance and the variation in the number of exhibitors?
This solution conducts a regression analysis of the data on the attendance of people and analyzes the coefficient of determination. All steps are shown in an Excel file.