Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You run a regression in Excel to help you forecast labor requirements, where x ( Sales ) and Y ( Headcount ) . In the

You run a regression in Excel to help you forecast labor requirements, where x(Sales) and Y(Headcount).
In the Excel output the slope =.8 and the y-intercept =.5.
How many workers would be needed if you expect 7(million) in sales?
[Y is entered in the regression input data in '000s, e.g.,1=1,000]
5,100
cannot be determined
6,100
5,600
image text in transcribed

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

Purchasing and Supply Chain Management

Authors: Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

5th edition

538476427, 538476423, 978-0538476423

More Books

Students also viewed these General Management questions