(LO 2) 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. Required:

(a) Prepare 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. (b) Use the MIN, MAX, and VLOOKUP functions in Excel to estimate the road repair cost function using the high-low method. (c) Use the REGRESSION data analysis tool or the SLOPE and INTERCEPT functions in Excel to estimate the road repair cost function using regression. (d) Based on your work so far, do you have any concerns about the data used to calculate the cost function estimates? In other words, do you believe this data is appropriate for preparing a cost estimate? Why? (e) Think about factors that might affect pothole repairs and the associated costs. What additional data would you like to have available to help you prepare a better cost estimate? NOTE: The repair costs in the data include ALL costs associated with completing the work, so information about additional costs is not needed.