2-31.Cost estimation

The city of Brownswood is trying to understand its road repair costs. As a starting point, Mark Winston, the city's finance manager, asked public works manager Rachel Morris to gather relevant data. Rachel provided Mark with a data set containing a list of completed pothole repair work orders and the related costs for a recent week. Mark has asked you to analyze this data set and provide some initial insights about the city's road repair costs.

How to do a visualization of the data set using the CHART function in Excel to create an XY scattergraph chart. (See the video below for some information on making a scattergraph.) Comment on what the visualization reveals. And, the answer can be answer by using the MIN, MAX, and VLOOKUP functions in Excel to estimate the road repair cost function using the high-low method.

February 25 110 $ 9,761.00 February 25 110 $ 8,479.00 February 25 117 $ 10,302.00 February 25 121 $ 12,565.00 February 25 157 $ 14,519.00 February 26 2 541.00 February 26 3 384.00 February 26 517.00 February 26 397.00 February 26 3 396.00 February 26 6 601.00 February 26 815.00 February 26 947.00 February 26 9 840.00 February 26 10 992.00 February 26 10 943.00 February 26 10 $ 955.00 February 26 11 $ 1,389.00 February 26 12 $ 1,240.00 February 26 12 $ 1,353.00 February 26 12 $ 1,151.00 February 26 14 $ 1,540.00 February 26 1,626.00 February 26 15 $ 1,771.00 February 26 15 $ 1,700.00 February 26 16 $ 1,580.00 February 26 16 $ 1,723.00 February 26 17 $ 1,709.00 February 26 17 $ 1,806.00 February 26 20 $ 1,912.00 February 26 20 1,984.00 February 26 21 $ 2,062.00 February 26 21 $ 1,980.00 February 26 21 $ 2,146.00 February 26 2,044.00 February 26 22 $ 2,038.00 February 26 22 $ 2,202.00 February 26 24 $ 2,250.00 February 26 25 $ 2,385.00 February 26 26 $ 2,348.00 February 26 27 $ 2,685.00 February 26 28 $ 2,863.00 February 26 29 $ 2,720.00 February 26 30 $ 2,798.00 February 26 31 $ 3,025.00 February 26 31 $ 2,863.00 February 26 33 $ 3,286.00February 26 34 $ 3,058.00 February 26 35 $ 3,157.00 February 26 36 $ 3,453.00 February 26 38 $ 3,449.00 February 26 39 $ 3,745.00 February 26 42 $ 3,961.00 February 26 43 $ 5,047.00 February 26 52 $ 4,545.00 February 26 56 $ 6,136.00 February 26 56 $ 5,030.00 February 26 80 $ 8,166.00 February 26 119 $ 9,612.00 February 27 3 $ 379.00 February 27 13 $ 1,531,00 February 27 14 $ 1,453.00 February 27 15 $ 1,517.00 February 27 30 $ 2,951.00 February 27 31 $ 3,133.00 February 27 36 $ 3,246.00 February 28 2 $ 339.00 February 28 8 $ 865.00 February 28 15 1,650.00 February 28 32 $ 3,123.00 February 28 39 4,471.00 February 29 1 245,00 February 29 254.00 February 29 333.00 February 29 320.00 February 29 201.00 February 29 510.00 February 29 394.00 February 29 380.00 February 29 $36.00 February 29 358.00 February 29 1,354.00 February 29 439.00 N NOOOGUAAWWWWWNNNNNNN February 29 328.00 February 29 370.00 February 29 706.00 February 29 640.00 February 29 465.00 February 29 655.00 February 29 841.00 February 29 429.00 February 29 418.00 February 29 752.00 February 29 798.00February 29 822.00 February 29 919.00 February 29 798.00 February 29 546.00 February 29 678.00 February 29 965.00 February 29 655.00 February 29 10 1,093.00 February 29 10 1,040.00 February 29 10 $ 1,011.00 February 29 10 945.00 February 29 10 $ 899.00 February 29 10 $ 968.00 February 29 11 $ 1,053.00 February 29 11 1,429.00 February 29 12 $ 1,171.00 February 29 12 $ 1,268.00 February 29 12 $ 1,511.00 February 29 12 $ 1,368.00 February 29 12 $ 1,171.00 February 29 13 $ 1,424.00 February 29 13 $ 1,421.00 February 29 1,637.00 February 29 14 1,406.00 February 29 15 $ 1,770.00 February 29 15 $ 1,654.00 February 29 15 $ 1,401.00 February 29 16 $ 1,557.00 February 29 16 $ 1,505.00 February 29 17 $ 1,919.00 February 29 17 $ 1,847.00 February 29 17 $ 1,923.00 February 29 18 $ 1,814.00 February 29 18 $ 1,789.00 February 29 18 $ 1,744.00 February 29 18 $ 1,802.00 February 29 19 $ 2,045.00 February 29 20 $ 2,188.00 February 29 21 $ 1,954.00 February 29 22 $ 2,354.00 February 29 24 $ 2,227.00 February 29 24 $ 2,492.00 February 29 25 $ 2,426.00 February 29 29 $ 2,606.00 February 29 36 $ 4,217.00 February 29 38 $ 3,573.00 February 29 39 $ 5,553.00February 29 41 3,831.00 run February 29 46 4,059.00 February 29 4,329.00 February 29 47 $ 4,189.00 February 29 49 $ 4,370.00 February 29 50 $ 4,474.00 February 29 51 $ 5,814.00 February 29 55 $ 5,009.00 February 29 67 $ 5,889.00 February 29 69 $ 6,196.00 February 29 5,437.00 February 29 84 $ 9,558.00 February 29 91 $ 7,874.00 February 29 95 $ 9,332.00 March 01 2 424.00 March 01 802.00 March 01 604.00 March 01 200.00 March 01 193.00 March 01 387.00 March 01 451.00 March 01 279.00 March 01 332.00 March 01 407.00 March 01 561.00 March 01 502.00 March 01 591.00 (D (0 00 CO 00 00 CO COCONUTMIMUAAAA WNNNN March 01 478.00 March 01 571.00 March 01 643.00 March 01 436.00 March 01 821.00 March 01 375.00 March 01 846.00 March 01 675.00 March 01 842.00 March 01 709.00 March 01 802.00 March 01 842.00 March 01 10 1,002.00 March 01 10 $ 1,019.00 March 01 10 808.00 March 01 10 $ 803.00 March 01 10 $ 1,034.00 March 01 10 $ 1,010.00 March 01 11 $ 1,136.00 March 01 11 $ 1,106.00March 01 12 5 1,152.00 March 01 12 5 1,334.00 March 0-1 13 $ 1,537.00 March 01 15 5 1,007.00 March 01 15 S 1,595.00 March 01 15 5 1,518.00 March 01 15 5 1,449.00 March 01 16 S 1,485.00 March 01 17 $ 1355.00 March 01 18 $ 1,755.00 March 01 25 5 2,308.00 March 01 25 S 2,559.00 March 01 29 5 2,955.00 March 01 30 5 2,948.00 March 01 39 S 3,574.00 March 01 45 .5 4,240.00 March 01 49 $ 4,651.00 March 01 61 $ 5,373.00 March 01 65 5 4,851.00 March 01 135 S 13,822.00