E5-8 (Static) Estimating Cost Behavior Using Scattergraph Method [LO 5-2] Mountain Dental Services is a specialized dental practice whose only service is filling cavities. Mountain has recorded the following for the past nine months: Number of Month Cavities Filled Total Cost January 625 $5,600 February 700 6,000 March 500 4,500 April 425 4,100 May 450 4,500 June 300 3,200 July 375 3,500 August 550 4,900 September 575 5,400 Required: 1. Create a scattergraph using Mountain's activity and cost information and draw a line on the graph that you believe has the best fit. Instructions: 1. Click on a point to the right of the graph. 2. Click within the graph to place the point, 3. To enter exact coordinates, click on the point and then click on the processing wheel symbol and then enter the exact coordinates in the dialog box that pops up. 4. Click OK. 5. Use the line tool provided to plot a regression line for this data with ending coordinates of (550, 6180). To use the line tool, first click on the appropriate y-intercept point, then click the second appropriate point on the graph to create the line. Scattergraph-Cost of Cavitles Filled 7000 1001 Feb Required: Instructions: 1. Create a scattergraph using Mountain's activity and cost information and draw a line on the graph that you believe has the best fit. 1. Click on a point to the right of the graph. 2. Click within the graph to place the point. 3. To enter exact coordinates, click on the point and then click on the processing wheel symbol and then enter the exact coordinates in the dialog box that pops up. 4. Click OK. 5. Use the line tool provided to plot a regression line for this data with ending coordinates of (550, 6180). To use the line tool, first click on the appropriate y-intercept point, then click the second appropriate point on the graph to create the line. Scattergraph-Cost of Cavities Filled Jan 7000 Feb 6000 ces 5000 Mar 4000 Total Cost April 3000 2000 Mey 1000 0 200 400 Juv Number of Cavities Filled