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) |
| 13 | 5662 |
| 19 | 4549 |
| 16 | 3772 |
| 44 | 1872 |
| 32 | 2799 |
| 52 | 1355 |
| 39 | 1966 |
| 15 | 5682 |
| 40 | 1602 |
| 53 | 1186 |
| 48 | 1832 |
| 37 | 2253 |
| 36 | 2241 |
| 42 | 1001 |
| 30 | 2474 |
| 42 | 1943 |
| 28 | 3021 |
| 11 | 5682 |
| 32 | 2192 |
| 39 | 1784 |
| 23 | 2707 |
| 37 | 1801 |
| 17 | 4827 |
| 11 | 2693 |
| 18 | 4340 |
| 50 | 1399 |
| 52 | 1593 |
| 9 | 9154 |
| 41 | 1504 |
| 26 | 2627 |
| 30 | 2575 |
| 32 | 2711 |
| 53 | 2368 |
10) Use Data > Data Analysis > Correlation to compute thecorrelation checking the Labels checkbox.
11) Use the Excel function =CORREL to compute the correlation.If answers for #1 and 2 do not agree, there is an error.
12) The strength of the correlation motivates furtherexamination.
a) Insert Scatter (X, Y) plot linked to the data on this sheetwith Age on the horizontal (X) axis.
b) Add to your chart: the chart name, vertical axis label, andhorizontal axis label.
c) Complete the chart by adding Trendline and checking boxes
13) Read directly from the chart:
a) Intercept =
b) Slope =
c) R2 =
Perform Data > Data Analysis > Regression.
14) Highlight the Y-intercept with yellow. Highlight the Xvariable in blue. Highlight the total standard error in orange
SUMMARY OUTPUT
