I am working to complete a linear regression chart that solves for…

  

Question

Answered step-by-step

Asked by LiaKCross

I am working to complete a linear regression chart that solves for…

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?monthEspresso advertising1987$1,050 21,412$1,500 31,020$1,000 41,140$1,250 51,322$1,500 61,399$1,500 7 $1,350 

Engineering & Technology

Industrial Engineering

Operations Management
FPX 5016

Share QuestionEmailCopy link

Comments (0)