C/ST/10. Supermarket customer statistics

A statistical dataset on 30 customers of a supermarket is made up using MS Excel random function. The dataset includes weekly expenditure, perception of the supermarket expensiveness, time spent at the check-out, and the time spent driving to the supermarket. A matrix is composed from the data to be used in linear regression model. Regression coefficients are calculated first as the solution of the corresponding matrix equation and then using Eviews and MS Excel. All three ways of calculation give the same result as expected. Consumer loyality is tested by testing the independence of expenditure and the price perception. The effect of driving time on the expenditure is assessed.