ieXbeta Board > help with excel homework

generalnewbie

Sep 14 2004, 14:03

i need to graph these equations
in excel and have no idea what to do.... any help
y=4200+0.0315x
y=4800+.0230x

so i find where they intersect

thnks a million

DangerousDave86

Sep 14 2004, 15:22

Create some simple sets of data to plot the equations.
For the first equation:

CODE

When x = 0, y = 4200+(0.0315x0)
" x = 1, y = 4200+(0.0315x1)
... etc
" x = 20, y = 4200+(0.0315x20)

Then for the second equation

CODE

When x = 0, y = 4800+(0.0230x0)
" x = 1, y = 4800+(0.0230x1)
... etc
" x = 20, y= 4800+(0.0230x20)

Personally I'd find out where they intersect first (mathamatically) and the choose a suitable range of x values for each equation to show it on a graph nicely.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.