The Correlation Between Distance Travelled And Spending
The research was done for a high school competition where teams were given a data set of grocery store transactions and asked to pull interesting information out of the data. Our approach was to determine whether the approximate distance between the customer's home and the store had any impact on their spending, the hypothesis being that the greater the distance, the more the customer would spend over an extended period of time (three years). The reasoning behind this was that customers who travelled greater distances to reach a specific store would likely be motivated to buy more in order to justify the greater journey. The primary tools we used to test our hypothesis were Statistical Analysis Software (SAS) and Microsoft Excel. Our results obtained contradicted the initial hypothesis; it was found that shoppers who live closer to the stores spend much more than those who live further away.