SOLUTION: The average daily cost of a room at a city hospital has risen by $59.82 per year for the years 1990- 2000. If the average cost of a room in 1996 was $1128.50, determine the slope

Question 676074: The average daily cost of a room at a city hospital has risen by $59.82 per year for the years 1990-
2000. If the average cost of a room in 1996 was $1128.50, determine the slope-intercept form of
the line, complete the chart, and graph it.
Whats formula could I use to make it work on excel for the years? Thank you
Answer by KMST(5328) (Show Source): You can put this solution on YOUR website!
THE SLOPE-INTERCEPT FORM OF THE EQUATION FOR THE LINE:
= cost of a room at a city hospital (in $)
= year
(NOTE: There are other, popular alternate options, such as making =years after 1990)
The slope-intercept form of the line would be
where is the slope, and is the y-intercept.
The slope of the line for the years 1990-2000 is 59.82,
the increase of the cost (in $) per year.
You are given one point in the line, (1996,1128.5),
the point with and .
For any other point within the years 1990-2000,
you would be years after 1996,
and the cost would have increased by .
Since the cost increased by $ per year,
.
That equation is in the point-slope form, using the given point and slope.
With a little algebra, we can transform it into the one and only slope-intercept form:
--> --> --> -->
IF you set = year, the slope-intercept form of the line is

NOTE:
IF you set = years after 1990, the point-slope form of the line
would be (using point (6,1128.5))
and the slope-intercept form of the line would be

USING EXCEL FOR THE GRAPH:
If you are familiar with Excel, you will understand what I mean.
If not, maybe another way of graphing will work better.
You could use one of the equations above to generate an Excel table and graph,
but if you know Excel, you can generate everything without knowing algebra.
To use Excel for the graph I would make two columns titled x and y (A1=x, B1=y),
I would fill the x values below the x title (in the A column).
(You could use 1990, 1991, 1992, ...., if using = year,
or 0, 1, 2, ...., if using = years after 1990)
I would enter the value 1128.5 (B8), for the cost for 1996, in the y column,
next to the corresponding year value for the x (A8=1996 or 6).
Next, I would enter formulas above and below that 1128.5,
refering to that cell containing that value (relative reference, as in B9=B8+59.82),
so that the y value (B9) for the year 1997 (A9=1997 or 7) would be 1128.5+59.82,
and the value for 1995 would be 1128.5+59.82.
Then I would propagate the formula down for years 1997-2000 and up for years 1995-1900.
RELATED QUESTIONS
In 1990, the cost of tuition at a large Midwestern university was $104 per credit hour.... (answered by josgarithmetic)

Help solve: average tuition in 1990 was $2035.00. By 2000 it had risen approx 85%.... (answered by consc198)

for the 1996-97 academic year, the average cost of tuition, fees, and room and board at a (answered by fcabanski)

Solve. (We are working on rational expressions including factoring) A company that... (answered by lekelly)

In 1990, the cost of tuition at a large Midwestern university was $102 per credit hour.... (answered by ikleyn,Theo)

In 1960, the average price per gallon of gasoline was 31 cents per gallon. From 1960 to... (answered by josgarithmetic)

In 1950 the average global temperature was 57.2 degrees F. Since that year the... (answered by ankor@dixie-net.com)

In 1990, the resident energy use in the US was responsible for 962 million metric tons of (answered by jsmallt9)