Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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. image text in transcribed
image text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Canadian Income Taxation Planning And Decision Making

Authors: Joan Kitunen, William Buckwold

17th Edition 2014-2015 Version

1259094332, 978-1259094330

Students also viewed these Accounting questions