help

Instructions: In this project, you will use Microsof Excel to estimale cost functions, As was the case with the Demand Project from earlicr in the term, you will need the "Analysis ToolPak" to do this. The data you will need is the Excel file "cost_data fall_2023 xlsx" in the "Cost Project" module on D2L. The data contains information on the quantity of energy output produced at a given plant within a large energy corporation and the aswociated total cost for that plant. Please submit your re zression output and plots withis an Excel workbook (with yoar name incladed in the name of the file). Subenit your answers to the rest of the questions as a Word document or PDF (with your name included in the name of the flie). Bioth files can be uploaded to the "Cost Project" Dropbox on the D2L vite. 1. Perform a linear regression where average cost is the dependent variable and where quantity and quantity squared ace the explanatory variables, Use the line plot fit ogtion to make a ples of the ketual and perdicted average cost values. 2. What shape does the estimated average cot curve have? How do you interpect this? 3. If a plant now has to produce is whole eimber increments, what outpot level minimites average cos? 4. If a new plant produces 22 ueits, what is the predicted average coas? 5. Given your estimales, by how mach would a manager expect TOTAL. COST to change if output were increased from 17 to 19 units? 6. Using logic similar to what you used in part 5 above, what is the estimated madginal cont of the 21th unit? Be clear about how you calculate this 73.6650.22182.6442.5854.18192.6353.8975.2939.78130.02102.57116.13122.0438.8561.2331.9760.42223.3910.884.3620.192.915.4520.575.3411.192.4517.3415.0116.2416.732.317.401.387.2321.80118.3319.05407.478.4929.75423.2628.55125.215.98300.68225.22263.69279.985.3354.691.8952.25475.226.7711.519.0514.629.939.3610.096.7316.267.506.837.157.2916.838.2823.258.3610.25 Instructions: In this project, you will use Microsof Excel to estimale cost functions, As was the case with the Demand Project from earlicr in the term, you will need the "Analysis ToolPak" to do this. The data you will need is the Excel file "cost_data fall_2023 xlsx" in the "Cost Project" module on D2L. The data contains information on the quantity of energy output produced at a given plant within a large energy corporation and the aswociated total cost for that plant. Please submit your re zression output and plots withis an Excel workbook (with yoar name incladed in the name of the file). Subenit your answers to the rest of the questions as a Word document or PDF (with your name included in the name of the flie). Bioth files can be uploaded to the "Cost Project" Dropbox on the D2L vite. 1. Perform a linear regression where average cost is the dependent variable and where quantity and quantity squared ace the explanatory variables, Use the line plot fit ogtion to make a ples of the ketual and perdicted average cost values. 2. What shape does the estimated average cot curve have? How do you interpect this? 3. If a plant now has to produce is whole eimber increments, what outpot level minimites average cos? 4. If a new plant produces 22 ueits, what is the predicted average coas? 5. Given your estimales, by how mach would a manager expect TOTAL. COST to change if output were increased from 17 to 19 units? 6. Using logic similar to what you used in part 5 above, what is the estimated madginal cont of the 21th unit? Be clear about how you calculate this 73.6650.22182.6442.5854.18192.6353.8975.2939.78130.02102.57116.13122.0438.8561.2331.9760.42223.3910.884.3620.192.915.4520.575.3411.192.4517.3415.0116.2416.732.317.401.387.2321.80118.3319.05407.478.4929.75423.2628.55125.215.98300.68225.22263.69279.985.3354.691.8952.25475.226.7711.519.0514.629.939.3610.096.7316.267.506.837.157.2916.838.2823.258.3610.25