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 3. The strength of the correlation motivates further examination. a. Insert Scatter (X,Y) plot linked...

50.1K

Verified Solution

Question

Basic Math

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

3. The strength of the correlation motivates furtherexamination.

a. Insert Scatter (X,Y) plot linked to the data on this s heetwith 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:Display Equation on chart & Display R-squared value onchart

4. Read directly from the chart:

a. Intercept =

b. Slope =

c. R2 =

Perform Data > Data Analysis > Regression

5. Highlight the Y-Intercept with yellow. Highlight the Xvariable in blue. Highlight the R Square in orange.

Answer & Explanation Solved by verified expert
4.4 Ratings (815 Votes)
3 5 The scatterplot is4 a Intercept 39030b Slope 33426c R2 04703The regression result    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students