Question: I am working to complete a linear regression chart that solves for the amount of espresso beans I will need in month 7 if my

I am working to complete a linear regression chart that solves for the amount of espresso beans I will need in month 7 if my advertising cost is $1,350. Using excel my equation is populating as y=54.571x+1022.3. Espresso in on the Y axis, and Advertising is on the x axis. In our text Operations Management for Leaders, it list the equation as Y=a+bx. Some of my peers found 1,255 or 1,253 pounds of espresso beans needed. my excel is saying 1404.297, can you advise which is correct?

month Espresso advertising
1 987 $1,050
2 1,412 $1,500
3 1,020 $1,000
4 1,140 $1,250
5 1,322 $1,500
6 1,399 $1,500
7 $1,350

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!