In: Economics
An important application of regression analysis in accounting is
in the estimation of cost. By collecting data on volume and cost
and using the least squares method to develop an estimated
regression equation relating volume and cost, an accountant can
estimate the cost associated with a particular manufacturing
volume. Consider the following sample of production volumes and
total cost data for a manufacturing operation.
Production Volume (units) | Total Cost ($) |
400 | 4,800 |
450 | 5,800 |
550 | 6,200 |
600 | 6,700 |
700 | 7,200 |
750 | 7,800 |
STEP 1:
Copy the data given in the question
STEP 2:
Paste it into the MS-Escel
STEP 3:
Go to Data > Data Analysis > Regression
STEP 4:
Input the data in X and Y segments > Tick on the output that you need > Press Apply
You will get the detailed table as:
TO UNDERSTAND THE TABLE, REFER THE FOLLOWING TABLE