Age (X) Time (Y)

11 1851

12 984

12 841

14 1063

14 883

14 1044

15 985

18 902

19 1040

20 918

20 976

22 728

26 859

28 960

28 893

30 709

30 786

42 463

43 560

43 791

45 591

47 440

49 258

49 250

50 480

51 919

52 262

53 184

53 231

54 246

55 205

59 163

64 300

11)

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

12)

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

The strength of the correlation motivates further examination.

13)

a) Insert Scatter (X, Y) plot linked to the data on this sheet with Age on the horizontal (X) axis.

14)

b) Add to your chart: the chart name, vertical axis label, and horizontal axis label.

15)

c) Complete the chart by adding Trendline and checking boxes

Read directly from the chart:

16)

a) Intercept =

17)

b) Slope =

18)

Perform Data > Data Analysis > Regression. Highlight the Y-intercept with yellow. Highlight the X variable in blue. Highlight the standard error in orange

PLEASE SHOW HOW TO COMPUTE ALL EXCEL FUNCTIONS THOROUGHLY AND EXPLANATION OF ANSWERS. THANK YOU!