ABC Enterprises is a company in which employees must frequently travel for business meetings with clients inside their city limits. Currently, each employee is allotted 40 dollars each day to cover meals while on the road. They are reimbursed for gas and other expenses in a separate budget, so the 40 dollars is only for meals. Employees have complained that this amount is not enough, especially if they had several meetings per day, and HR wanted to investigate. A survey was given to get recommendations for a new daily meal allotment. Although not all responded, 49% of employess did.

The company is trying to keep the most people happy with the meal allowance than it can. The vice president hypothesizes that the older employees are the ones who want more money for meals than the younger ones. We are going to look at whether or not there is evidence to support this claim. If the claim is true, then the company is thinking about having a smaller allowance and sending the younger employees out more than the older ones.

Recommended Amount	Male/Female	Age
150	M	20
40	M	21
40	F	24
50	F	22
160	F	37
55	F	33
55	F	23
50	M	29
55	F	31
60	F	25
70	F	40
55	M	42
50	M	32
40	M	26
55	F	30
60	M	34
50	M	27
55	F	31
140	F	44
75	F	30
90	M	29
50	M	31
125	M	29
55	F	28
45	F	37
60	F	22
55	M	46
55	M	27
55	M	37
65	F	55
45	F	25
50	M	44
50	F	27
55	F	47
65	F	25
55	M	33
55	F	41
55	F	44
50	F	25
50	M	51
100	F	35
70	M	38
55	F	25
75	F	29
75	F	35
55	F	24
50	M	41
55	F	61
90	F	22
55	M	37
60	M	29
70	F	40
50	F	33
90	F	23
100	M	48
90	F	44
75	F	33
80	M	51
70	F	57
50	F	60
80	F	63
50	F	52
55	M	67
40	M	55

• make a 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.
• 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 36-year-old employee would want.
• Use the trendline equation to figure out how much money an 91-year-old employee would want.
• Now, use the coefficient of determination (the r squared value) to calculate r. Using The Guildford Rule of Thumb, how would you interpret the strength of the linear relationship?
• Given the r value and knowing whether you are interpolating or extrapolating (find out what these things are before answering), how much confidence do you have in the amount of money calculated for the 36 year old? What about for the 91 year old?