I am getting stupid. Excel 2007 doesn't seem to let me do the charting I was once able to do. In Column A I have data values for mile values recorded from the satellite. In column B I have values recorded from the odometer. I want to chart the curve that represents satellite miles VS Odometer miles.
Sat Truck
116.30 111.10
168.70 161.10
195.80 187.00
206.30 197.00
210.00 200.60
As you can see it's not linear and I wanted to have excel develop the curve calculation for me. It's been 15 years since my calculus class. What I keep getting is two lines with the Y axis being satellite miles and the X axis going being the row numbers 1 through 5. Do you see what I want? I hope someone can help.
Here's what I want to do. I need to figure out what the equation is to give me actual miles (Satellite) for any given odometer reading. My tires are bigger than factory and I want actual miles for gas calculations. I know it's a curve just by looking at the data. But since it has been 15 years since my last calculus class I am getting lost here. If I drive 15 miles odometer reading what is the actual miles driven? If I have the data charted can't excel apply a trend line and give me an equation?
Thanks for your help.
Bookmarks