x values and plotting points

[annette christian]

I need to plot points and draw a straight line to
calculate the slope. I will use this same method to
present a trend for data points over time ( three years
per compound)!

Help! I have Excel 97.

Thanks!

 

[dvt]

I need to plot points and draw a straight line to
calculate the slope. I will use this same method to
present a trend for data points over time ( three years
per compound)!

Help! I have Excel 97.

Thanks!

You should be able to chart your data points using the Chart Wizard. See
http://www.geocities.com/jonpeltier/Excel/Charts/index.html for a good intro
to charting.

Next, you can show a trendline on the chart and have the formula displayed.
Search for "trendline" in Excel help. That will give you the slope of your
line. If you wish to use spreadsheet functions instead, have a look at the
LINEST and FORECAST functions. Look up "Project values" in Excel help as a
starting point.

Dave
dvt at psu dot edu