In: Operations Management
In your spreadsheet calculate the estimated the line maintenance expense that would be predicted by the quadratic regression function for each company in the sample . Plot these values on your graph (Connected with line) along with the original data and the orginal regression line.
Phone Services Data Collected from 12 companies
Customers (in 1000s) | Line Maint. Expense (in $1000s) |
25.3 | 484.6 |
36.4 | 672.3 |
37.9 | 839.4 |
45.9 | 694.9 |
53.4 | 836.4 |
66.8 | 681.9 |
78.4 | 1,037.0 |
82.6 | 1,095.6 |
93.8 | 1,563.1 |
97.5 | 1,377.9 |
105.7 | 1,711.7 |
124.3 | 2,138.6 |
Plot the data on a Scatter chart using Excel chart tools
Add Trendline, by right clicking on any data point on the chart.
Right click on the trend line and click Format trendline.
In the Trendline options, select Polynomial
Check box Display Equation on chart