|
Exercise 3-24 |
|
Name: |
Solution |
|||||||
|
|
|
|
|
|
|
|
||||
|
|
Fill in the correct data in the gray-shaded cells and run a |
|||||||||
|
|
regression in Excel. Excel may have different answers |
|||||||||
|
|
than the solution manual due to the precision of Excel. |
|||||||||
|
|
|
|
|
|
|
|
||||
|
a. |
Number of Shipments Received |
|
Cost of Receiving Reports |
|
||||||
|
|
|
|
|
|
||||||
|
|
|
|
|
|
||||||
|
|
|
|
|
|
||||||
|
|
|
|
|
|
||||||
|
|
|
|
|
|
||||||
|
|
|
|
|
|
||||||
|
|
|
|
|
|
||||||
|
Number of Shipments |
||||||||||
|
Y = a + bX |
|
|
||||||||
|
X=165 |
|
|
|
|||||||
|
|
|
|
|
|||||||
Place New Order
It's Free, Fast & Safe
"Looking for a Similar Assignment? Order now and Get a Discount!
