According to some highly unscientific research done by a UK department store chain and reported in Marie
Fantastic news! We've Found the answer you've been seeking!
Question:
- 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 |
- Enter the three variables and values for each as listed above into Excel and save them as LastName_ShoppingExercise.xlsx.
- In MS Excel,
- Calculate the measures of central tendency for Time and Distance.
- Calculate the standard deviation for Time and Distance.
- Calculate the correlation (R squared) between Time and Distance.
Posted Date: