30.2k views
1 vote
As a simple example, consider the historical data for a certain plant. Enter the data into EXCEL and analyze it to answer the following items. 5 6 7 8 9 10 11 Production in 10,000) units: Overhead costs (in $1,000): 12 11.1 14 15 15.4 15.2 17.4 Provide the sample-based estimates for the model parameters. (Round your answers to three decimal places.) û = + Х (d) Use the model to predict the overhead cost associated with the production of 80,000 units. (Round your answer to two decimal places.) The actual overhead cost was $15,000 when 80,000 units were produced (See the raw data above). Calculate the residual. (Round your answer to two decimal places.) $ ta (e) Use the model to predict the overhead cost associated with the production of 90,000 units. (Round your answer to five decimal places.) thousands of dollars The actual overhead cost was $15,400 when 90,000 units were produced (See the raw data above). Calculate the residual. (Round your answer to five decimal places.) thousands of dollars

User Craftsman
by
8.0k points

1 Answer

3 votes

Answer:

The linear equation is, y = 6.9286 + 0.9214

Explanation:

User Maynza
by
8.3k points