1. According to some highly unscientific research done by a UK department store chain and reported in Marie Clare magazine (http://ow.ly/9Dxvy) shopping is good for you: they found that the average women spends 150 minutes and walks 2.6 miles when she shops, burning off around 385 calories. In contrast, men spend only about 50 minutes shopping, covering 1.5 miles. This was based on strapping a pedometer on a mere 10 participants. Although the actual data was unavailable, some simulated data based on the reported means are below.

Gender	Time	Distance
Female	22	1.40
Female	140	1.81
Female	160	1.96
Female	183	3.02
Female	245	4.82
Male	15	0.16
Male	30	0.40
Male	37	1.36
Male	65	1.99
Male	103	3.61

1. Enter the three variables and values for each as listed above into Excel and save them as LastName_ShoppingExercise.xlsx.
2. In MS Excel,
   1. Calculate the measures of central tendency for Time and Distance.
   2. Calculate the standard deviation for Time and Distance.
   3. Calculate the correlation (R squared) between Time and Distance.

In MS Word,

1. Interpret the data using the measures of central tendency and standard deviation.
2. Based on the correlation, explain the relationship between time and distance.