Question

Use Data> Data Analysis> Correlation to compute the correlation checking the Labels checkbox Use the Excel function =CORREL t

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
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Age (X) |Time (Y) 1851 11.) 984 841 1063 883 12.) 1044 13.) 985 902 1040 918 976 728 859 960 893 709 786 463 Time (Y) 2 Age (009 5 8 1 2492122213 241653 901233 455555 556 678 012 345 3 3 3 3-3 3 2

16) Intercept = 1334

17) Slope = -18.613

18) Coefficient of determination (R^{2}) = 0.71421 SUMMARY OUTPUT 2 Regression Statistics 4 Multiple R 5 R Square 6 Adjusted R Square 0.704942691 7 Standard Error 8 Observati

Add a comment
Know the answer?
Add Answer to:
Use Data> Data Analysis> Correlation to compute the correlation checking the Labels checkbox Use ...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT