Question
1. estimate a linear cost function
2. estimate a quadratic cost function
3. estimate a cubric cost function
1 A B с D 1 Cost data for a lumber mill 2 3 TC 4 11 5 32 2 6 93 3 7 248 4 8 575 5 9 1176 6 10 2177 7 11 3728 8 12 6003 9 13 9
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer

The graph is drawn below which is made on excel .Using the add trendline feature the equation linear ,quadratic ,cubic can be estimated .

Folowing is the lienar trend with equation written on it

200000 y = 6776.4x - 36975 R2 = 0.758 150000 100000 -Series1 -Linear (Series1) -Linear (Series1) 50000 0 0 5 10 15 20 25 -500

Folowing is the Quadratic trend with equation written on it

60000 50000 y = 408.29x2 -7698x + 34543 40000 30000 -Series1 – Poly. (Series1) 20000 10000 0 0 5 10 15 20 25 -10000

Folowing is the cubicr trend with equation written on it

60000 50000 40000 y = 31x2 - 800.71x2 + 6983.6x-2014 R2 = 0.9998 30000 -Series1 – Poly. (Series1) 20000 10000 0 0 5 10 15 20

We can see that cubic equation satisifed it as R square value is near one .This is the best estimating equation of the data given .

Have a good day !

Add a comment
Know the answer?
Add Answer to:
1. estimate a linear cost function 2. estimate a quadratic cost function 3. estimate a cubric...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • I. Output (Q) and Total Cost (TC) numbers are given in cost.xls. Use this data and...

    I. Output (Q) and Total Cost (TC) numbers are given in cost.xls. Use this data and answer the following questions: Note: Students are expected to read and understand the material in Units 9 and 10 before attempting the following problems. 1. Estimate a Linear Cost function. Type the estimated equation here 2. Estimate a Quadratic Cost function. Type the estimated equation here 3. Estimate a Cubic cost function. Type the estimated equation here 4. For the best fitting model derive...

  • Use the create_matrix function from the tutorial file, along with a function a (i, j) (which...

    Use the create_matrix function from the tutorial file, along with a function a (i, j) (which you will have to create) to produce the following 17 × 17 matrix. Then find its determinant. 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 5 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 6 6 1 1 1 1 1 1 1 1 1 1 1...

  • Use the create_matrix function from the tutorial file, along with a function a (i, j) (which...

    Use the create_matrix function from the tutorial file, along with a function a (i, j) (which you will have to create) to produce the following 17 × 17 matrix. Then find its determinant. 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 5 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 6 6 1 1 1 1 1 1 1 1 1 1 1...

  • Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16...

    Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16 10 17 14 14 16 7 10 12 19 15 16 14 9 12 21 13 10 16 12 16 13 17 17 13 14 18 11 12 15 16 13 18 16 17 12 12 14 9 11 14 19 13 11 17 11 13 15 14 18 18 18 12 10 11 13 14 11 14 18 13 13 19 17 14...

  • Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16...

    Cork price: 16 10 15 10 17 11 14 13 11 14 11 16 18 16 10 17 14 14 16 7 10 12 19 15 16 14 9 12 21 13 10 16 12 16 13 17 17 13 14 18 11 12 15 16 13 18 16 17 12 12 14 9 11 14 19 13 11 17 11 13 15 14 18 18 18 12 10 11 13 14 11 14 18 13 13 19 17 14...

  • Use a bivariate linear regression trend model to estimate this trend equation: SALES = a +...

    Use a bivariate linear regression trend model to estimate this trend equation: SALES = a + b(TIME) Is the sign of b what you would expect? Is b significantly different from zero? What is the coefficient of determination for this model? Explain your answers. Date Sales Time Mar-12 3,372.5 1 Jun-12 3,472.7 2 Sep-12 3,534.8 3 Dec-12 3,602.6 4 Mar-13 3,675.1 5 Jun-13 3,725.4 6 Sep-13 3,749.0 7 Dec-13 3,772.4 8 Mar-14 3,794.1 9 Jun-14 3,826.5 10 Sep-14 3,877.8 11...

  • E G H 1 Outsourcing Problem 2 3 OUTSOURCE Variable Cost $12.00 /unit Fixed Cost $0.00...

    E G H 1 Outsourcing Problem 2 3 OUTSOURCE Variable Cost $12.00 /unit Fixed Cost $0.00 MANUFACTURE Variable Cost $10.00 /unit Fixed Cost $5,000.00 4 5 6 7 8 1200 units Volume Cost of Manufacturing Cost of Outsourcing What is the best option? 9 10 11 12 13 14 15 16 17 18 19

  • 0.5 points QUESTION 44 5. 2. 3. Front view Correctly label the female reproductive system: 1....

    0.5 points QUESTION 44 5. 2. 3. Front view Correctly label the female reproductive system: 1. 2. 3. 4. and 5,. 2.5 points QUESTION 45 7. 15. 14 8. 13. 9 12. 10. 11 Side view Correctly label the female reproductive system: 6. 7. 8 9, 10, 11, 12. 13, 14. 15. NOTE: #8, 10, and 12 are not part of the reproductive system 5 points QUESTION 46 2. 11 10. 9. S1de view 7. Correctly label the male reproductive...

  • Suppose there are 100 identical firms in the market and the luggage industry is perfectly competitive....

    Suppose there are 100 identical firms in the market and the luggage industry is perfectly competitive. What does the market supply curve look like? 20 19 18 17 16 15 14 13 12 11 A 10 9 8 7 6 5 4 20 19 18 17 16 15 14 13 12 11 A 10 8 7 6 2 1 0 0 0 1 2 3 4 5 6 7 8 9 10 11 12 0 1 2 3 4 5...

  • Game   Point_Differential   Assists   Rebounds   Turnovers   Personal_Fouls 1   15   15   38   11   9 2   36   20   43 &

    Game   Point_Differential   Assists   Rebounds   Turnovers   Personal_Fouls 1   15   15   38   11   9 2   36   20   43   8   13 3   16   21   29   7   13 4   45   22   46   11   11 5   12   11   40   7   22 6   -10   10   31   13   26 7   11   19   45   11   7 8   12   16   32   16   14 9   3   16   27   18   15 10   19   9   34   17   17 11   40   16   41   9   17 12   44   12   29   9   22 13   16  ...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT