I have to do a lab report for school and my teacher told me to go on excel
and insert the data that it will automatically give you a line graph with a
best-fit line. Please help me!!!!!!!!!!! Thank you

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"westhighgirl" wrote in message
...
I have to do a lab report for school and my teacher told me to go on excel
and insert the data that it will automatically give you a line graph with
a
best-fit line. Please help me!!!!!!!!!!! Thank you

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
_______


"westhighgirl" wrote in message
...
I have to do a lab report for school and my teacher told me to go on excel
and insert the data that it will automatically give you a line graph with
a
best-fit line. Please help me!!!!!!!!!!! Thank you