Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Here are the answers to A & B. Just need help figuring out C, the Slope and Intercept functions. COST FUNCTION? The city of Brownswood
Here are the answers to A & B. Just need help figuring out C, the Slope and Intercept functions.
COST FUNCTION?
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. Click here to view the Excel dataset. (b) Your answer is correct Identify the high and low points. Low point 1 potholes. $ 245 repair cost High point 157 potholes, 5 14519 repair cost Am Using the high-low method to estimate the road repair cost function (Round answers to 2 decimal places, eg. 52.43.) Cost estimate = $ 153.50 +($ 91.50 * number of potholes repaired) eTextbook and Media Assistance Used Attempts: 2 of 3 used (c) Use the SLOPE and INTERCEPT functions in Excel to estimate the road repair cost function using regression (Round answers to 4 decimal places, eg. 52.4321.) Cost function = ($ x number of pothole repaired) + $ 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. Click here to view the Excel dataset. (b) Your answer is correct Identify the high and low points. Low point 1 potholes. $ 245 repair cost High point 157 potholes, 5 14519 repair cost Am Using the high-low method to estimate the road repair cost function (Round answers to 2 decimal places, eg. 52.43.) Cost estimate = $ 153.50 +($ 91.50 * number of potholes repaired) eTextbook and Media Assistance Used Attempts: 2 of 3 used (c) Use the SLOPE and INTERCEPT functions in Excel to estimate the road repair cost function using regression (Round answers to 4 decimal places, eg. 52.4321.) Cost function = ($ x number of pothole repaired) + $ Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started