Start by putting the first x-value in cell A1 (the cell under column A, next
to row 1). Put the other x-values below this.
Put the y-values in column B
Select any one of the cells with data; click the chart wizard on the tool
bar
I expect you want an XY chart
Now you can experiment; make the chart large/smaller; change the scale; etc.
See if there is an Excel book in the school library
Or visit Jon's excellent site
Peltier Technical Services, Inc. - http://PeltierTech.com
best wishes

It's not a completely automatic process, but it's still pretty easy.

Enter the data, with X values in one column and Y values in the next.
Select the data, run the Chart Wizard (Insert menu > Chart, or the little
chart icon on the toolbar). In step 1 choose an XY (scatter) type, NOT a
line type.
Right click on the series of points in the chart, and select Trendline. The
default trendline is a linear fit. On the trendline dialog, click on the
Options tab and check the Show Equation and Show R-squared boxes. When the
line and equation appear, you should click on the equation, then use the
toolbar icon to increase the displayed decimals in the formula.

To get the slope, intercept, and correlation coefficient in the worksheet,
use

=Slope(<y values>,<x values>)
=Intercept(<y values>,<x values>)
=Correl(<y values>,<x values>)

where <y values> and <x values> are the ranges used to plot the Y and X
values in the chart.

My daughter is doing statistics in her algebra class, and I showed her this
capability, and also how to enter formulas into Excel. After a week or more
on the statistics unit, she finally understands what the best fit means, and
what residuals are. I guess the book didn't have good diagrams, but nothing
beats an interactive process like this, especially when you are not bogged
down doing all the calculations on a pocket calculator.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______