Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Linear Regression Each week,you will be asked to respond to the prompt or prompts in the discussion forum. Your initial post should be75-150words in length,and

Linear Regression

Each week,you will be asked to respond to the prompt or prompts in the discussion forum. Your initial post should be75-150words in length,and is due on Sunday.By Tuesday,you should respond to two additional posts from your peers.

In this class, we have been working with the following scenario quite often:

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 given here. Make sure you use this worksheet:
  • WEEK 7 Discussion
  • This includes the variable of age next to the requested dollar amount.
  • Create 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? Whatdoes 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?
Age Recommended Amount Male/Female
62 50 F
51 60 M
51 60 M
38 50 M
44 75 F
58 110 M
60 75 M
50 75 M
37 50 M
60 55 F
49 70 F
64 75 F
36 80 F
31 85 F
53 85 F
46 60 F
22 45 M
50 75 M
58 80 F
30 50 F
47 85 M
58 50 F
60 60 F
64 75 F
27 70 M
48 45 M
52 50 M
61 75 F
31 55 M
59 50 M
46 55 F
22 135 F
21 50 M
25 60 F
51 70 M
23 80 F
33 75 F
63 60 F
34 55 F
37 55 F
30 60 F
40 70 F
38 100 M
55 60 M
69 65 F
23 45 F
57 40 M
24 40 M
31 50 M
49 50 F
39 65 F
61 70 M
59 90 F

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Applications For The Management, Life And Social Sciences

Authors: Ronald J. Harshbarger, James J. Reynolds

12th Edition

978-1337625340

More Books

Students also viewed these Mathematics questions

Question

2. Darwins notes in biology.

Answered: 1 week ago

Question

Explain the meaning of an "insured" in an insurance contract.

Answered: 1 week ago