.............

\fQuestion 1 DATA worksheet 1st column Selected Sydney household 2nd column (Transport) Annual total transport costs per household (in $10005) Question 2 DATA worksheet 1st column (Individuals) Individuals who participated in the study 2nd column (After) Purchase rating after viewing the new TV commercial 3rd column (Before) Purchase rating before viewing the new TV commercial Question 3 DATA worksheet 1st column (Rating) Rating on a scale from 1 to 10 on the service and products 2nd column (Amount Spent) Amount (in dollars) spent by the customers in the department store Question 3 (6 marks) Marks All work for this question must be done in the worksheet named Question 3 Data. This worksheet can be found in the data le Data Set& 2020.3.xlsx. Customers at a large department store were asked to rate the service and products purchased on a scale from 1 to 10, with 10 being the highest. The amount that they spent was also recorded. Is there an evidence of a relationship between the customer rating and the amount that they spent? (a) Using Excel, obtain a linear regression output.* [2] (b) Determine the linear regression equation that may be used to predict the amount spent by the customers at department store based on their ratings on service and products purchased. [1] (c) Interpret the slope of the linear regression line. [1] (d) State and interpret the coefcient of determination. [2]