Studies have shown that the frequency with which shoppers browse Internet

retailers is related to the frequency with which they actually purchase products and/or services online. The following data show respondents age and answer to the question “How many minutes do you browse online retailers per week?”

Column-1 Column-2
Age (X) Time (Y)
23 513

51 207

45 201

33 405

56 141

61 141

39 297

23 501

22 531

46 273

53 147

34 381

20 591

18 609

22 519

1 Use Data > Data Analysis > Correlation to compute the correlation checking the Labels checkbox.

2 Use the Excel function =CORREL to compute the correlation. If answers for #1 and 2 do not agree, there is an error.

3 The strength of the correlation motivates further examination.
a) Insert Scatter (X, Y) plot linked to the data on this sheet with Age on the horizontal (X) axis.
b) Add to your chart: the chart name, vertical axis label, and horizontal axis label.
c) Complete the chart by adding Trendline and checking boxes

Place Equations on chart
Place R-squared on chart

4 Read directly from the chart:
a) Intercept =
b) Slope =
c) R2 =

5 Perform Data > Data Analysis > Regression.

6 Read the standard error in the regression output?

7 Based on the regression output, what is the equation of the regression line?

8 Use Excel to predict the number of minutes spent by a 40-year old shopper. Enter = followed by the regression formula.
Enter the intercept and slope into the formula by clicking on the cells in the regression output with the results.

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"