Age	Requested Amount	Male or Female Requested
55	80	M
24	50	M
22	90	M
32	75	M
25	97	F
47	55	M
39	55	M
26	350	M
30	75	F
28	75	F
48	50	M
53	50	F
33	55	F
27	80	M
54	50	M
45	75	M
38	70	F
55	50	F
49	55	M
26	70	F
61	55	F
63	75	F
59	50	M
46	75	M
22	75	M
21	75	M
36	70	M
31	70	M
47	55	M
50	70	F
21	75	F
26	65	M
25	85	F
45	55	M
51	55	F
50	55	F
24	65	F
37	55	M
30	80	M
54	40	M
57	55	M
60	50	M
61	55	M
49	50	M
39	60	M
55	50	M
47	50	F
51	55	M
38	75	F
44	50	M
58	60	F
60	50	F
51	60	M
43	55	M

• scatter diagram with trendline from the data in that tab. Include the equation of the line on the graph (under "more options") along with the r squared value (coefficient of determination). Include the diagram in your post (you can attach your Excel spreadsheet).
• What is a trendline, and how does it help us interpret the data?
• Discuss the slope of that trendline. Is it positive, negative, undefined, or 0? What does it mean?
• Use the trendline equation to figure out how much money a 39-year-old employee would want. Are you interpolating or extrapolating in this instance? Why?
• Use the trendline equation to figure out how much money an 85-year-old employee would want. Are you interpolating or extrapolating in this instance? Why?
• What is more reliable - interpolation or extrapolation - and why?
• What is the r value for our data set, and what does it tell you about the strength of the relationship?
• Given interpolation, extrapolation, and r values, how much trust do you put into the answers for the 39 and 85 year old? Explain.