Question 2

A supermarket manager is interested in customer transactions to assist with budgeting as well as product placement throughout the store. Of particular interest to the manager is how long the customer spends in the store and whether the customer uses a self-service register for their transaction. Data has been collected from 50 customers and is provided in the file FAT 1 Version B data.xlsx.

a) (i) Use Excel to produce a linear regression for the proportion of all customers who use a self service register and use a 98% confidence level.

(<Upload Table on Moodle>)

(ii) State and interpret the 98% confidence interval for the proportion of all customers who use a self-service register.