Studies have shown that the frequency with which shoppers browseInternet retailers is related to the frequency with which theyactually purchase products and/or services online. The followingdata show respondents age and answer to the question “How manyminutes do you browse online retailers per week?”
| Age (X) | Time (Y) |
| 34 | 123,556.00 |
| 17 | 92,425.00 |
| 42 | 250,908.00 |
| 35 | 204,540.00 |
| 19 | 77,897.00 |
| 43 | 197,012.00 |
| 51 | 195,126.00 |
| 50 | 177,100.00 |
| 22 | 83,230.00 |
| 58 | 140,012.00 |
| 48 | 265,296.00 |
| 35 | 189,420.00 |
| 39 | 235,872.00 |
| 39 | 230,724.00 |
| 59 | 238,655.00 |
| 40 | 138,560.00 |
| 60 | 259,680.00 |
| 22 | 93,208.00 |
| 33 | 91,212.00 |
| 36 | 153,216.00 |
| 28 | 77,308.00 |
| 22 | 56,496.00 |
| 28 | 106,652.00 |
| 44 | 242,748.00 |
| 54 | 195,858.00 |
| 30 | 178,560.00 |
| 28 | 190,876.00 |
| 16 | 98,528.00 |
| 52 | 169,572.00 |
| 22 | 79,420.00 |
| 28 | 167,928.00 |
| 35 | 215,705.00 |
| 50 | 146,350.00 |
1. Use Data > Data Analysis > Correlation to compute thecorrelation check the Labels checkbox. Show work in excel.
2. Use the excel function =CORREL to compute the correlation. Ifanswer for #1 and 2 do not agree, there is an error. Show work inexcel.
