Business Finance Homework Help

I’m working on a data analytics multi-part question and need an explanation and answer to help me learn.

Part 1 (75 word)

ABC Enterprises is a growing company in which employees must frequently travel for business. Currently, each employee is allotted 30 dollars each day to cover all meals. Employees have complained that this is not enough, especially when traveling to some of the more costly cities and countries. A survey was taken to get recommendations for a new allotment. Although not all responded, the response rate was good.

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.

• Open the Excel spreadsheet. Make sure are looking at the Week 7 tab. This includes the variable of age next to the requested dollar amount.
• Create 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 84-year-old employee would want.
• How much trust do you put into the answer for 5 and 6? How does the coefficient of determination and the simple correlation coefficient (r) provide you with some input on your response?

part 2

Week 7 Assignment

1.What is a least squares regression line? What does regression tell us?

2.Why is it dangerous to extrapolate outside the experimental region?

3.Given the following

Book	Pages (x variable)	Price (y variable)
A	525	$7.50
B	615	$8.15
C	550	$7.95
D	685	$9.50
E	525	$7.55
F	600	$8.00
G	487	$6.95

a.Create a scatter diagram which shows the trendline (this is the regression line) and provides the coefficient of determination?

b.What is the equation of the trendline from the graph?

c.According to the equation of the trendline from your graph, if a book had 617 pages, how much should it cost?

d.According to the equation of the trendline from your graph, if a book costs $9.62, how many pages should it have?

4.You are presented with four values for Pearson’s product moment correlation coefficient ( r ). Which one shows the strongest relationship? Why?

a.0

b.0.19

c.0.59

d.-0.99