A study by the Department of Transportation of city about the effect of bus ticket prices on the number of passengers produced the following results:

(data given in cells A17 to C27)

a) Develop an equation in MS Excel for the relationship between Ticket price (cents) and number of passengers per 100 miles. (1 mark)

b) Interpret the slope of the regression line in your words. (1.5 marks)

c)Interpret the R square in your words. (1.5 marks)

d) Predict the number of passengers per 100 miles if the ticket price was 50 cents. (1 mark)

Obs no Ticket price (cents) Number of Passengers per 100 miles 1 25 800 2 30 780 3 35 780 4 40 660 5 45 640 6 50 600 7 55 620 8 60 620 9 65 600 10 70 540