Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Estimate the learning curve from production and cost data. Data is given below: Estimating the simple learning curve Using the data provided, create any new
Estimate the learning curve from production and cost data. Data is given below:
- Estimating the simple learning curve
- Using the data provided, create any new variables needed to estimate the learning curve as a simple regression. What is the dependent (Y) variable? What is the regressor (X)?
- Plot the relationship between your X and Y variables and discuss.
- Run the learning curve regression and interpret the results, referring to the table of output. What does the regression tell you about any learning effect? Use words that a layperson could understand.
- Taking another look
- The production manager believes that cost efficiency has improved due to experience in production (learning). But she notes that unit costs are also directly a function of current production, and that because production ramped up over time, there may be a confounding effect on the learning curve estimate. Explain briefly what she might have in mind. Which direction would the bias go- that is, is the simple regression's learning effect overestimated or underestimated? Might the bias go in either direction? If so, what about costs would determine the direction of the bias?
- Address the manager's concern using multiple regression to control for the confounding effect. Explain what variable or variables you add to the simple learning curve and why.
- Interpret the results and compare the estimated learning effect with what was obtained in #1 (simple regression). Include and refer to regression tables. Was the manager correct? Explain what is going on.
- Yet another look
- An engineer suggests that learning occurs simply with the passage of time, not with output experience. Add a regressor to your regression from #2 to test his conjecture. Discuss the table of results. Is the engineer correct? Explain carefully.
Requirements:
- Using the data delivered in the downloadable above, deliver a report in the form of a Word or PDF document
- In discussing regression results, always interpret the the estimates in words (such as, "this coefficient indicates that a 1% increase in price is associated with a 5% reduction in quantity, other variables held constant"), make sure to consider both economic (size of effect) and statistical significance, and discuss goodness of fit (adjusted R-squared).
- Make comparisons between regression results where called for, and cite specific evidence from results to answer the questions.
Data:
Monthly production and cost data for a machine | |||
Variable | Definition | ||
month | sequence of months since beginning of production | ||
q | quantity produced in that month | ||
cost | total cost of all units produced in that month, in dollars |
month | q | cost |
1 | 21 | 333540.94 |
2 | 51 | 408674.53 |
3 | 51 | 620608.19 |
4 | 9 | 210845.23 |
5 | 55 | 492494.75 |
6 | 22 | 216455.23 |
7 | 13 | 184409.75 |
8 | 40 | 182010.69 |
9 | 14 | 213098.23 |
10 | 10 | 201228.41 |
11 | 16 | 158400.41 |
12 | 15 | 169656.97 |
13 | 24 | 194213.42 |
14 | 20 | 251545.22 |
15 | 41 | 394777.06 |
16 | 21 | 177385.17 |
17 | 35 | 293163.13 |
18 | 58 | 552672.00 |
19 | 51 | 361720.44 |
20 | 46 | 536971.00 |
21 | 54 | 517110.81 |
22 | 50 | 325373.31 |
23 | 37 | 257186.95 |
24 | 28 | 185652.08 |
25 | 37 | 189189.78 |
26 | 61 | 414943.06 |
27 | 45 | 368184.84 |
28 | 29 | 310034.03 |
29 | 49 | 236670.09 |
30 | 60 | 339970.34 |
31 | 36 | 295902.66 |
32 | 67 | 654628.13 |
33 | 46 | 294579.50 |
34 | 35 | 246857.25 |
35 | 68 | 478070.38 |
36 | 48 | 490993.69 |
37 | 56 | 351727.47 |
38 | 40 | 425364.00 |
39 | 59 | 581216.50 |
40 | 34 | 204943.53 |
41 | 50 | 250813.28 |
42 | 51 | 434830.97 |
43 | 28 | 146158.95 |
44 | 41 | 246549.03 |
45 | 41 | 392116.75 |
46 | 63 | 445888.22 |
47 | 53 | 349943.03 |
48 | 61 | 391099.13 |
49 | 60 | 584898.31 |
50 | 33 | 285947.72 |
51 | 61 | 591917.81 |
52 | 47 | 368670.22 |
53 | 39 | 387581.47 |
54 | 51 | 232734.94 |
55 | 60 | 421448.41 |
56 | 32 | 303257.28 |
57 | 41 | 325229.72 |
58 | 64 | 297445.78 |
59 | 42 | 155247.91 |
60 | 63 | 426471.69 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started