My chemistry teacher wants us to write out an equation that represents the general relationship between two sets of data. I made a scatterplot graph on microsoft excel, and want to calculate the equation for the best fit line, which appears to be exponential. I'm not too familiar with spreadsheet, but my professor made it seem like I could do this on Excel.
2006-09-07 05:27:33 · 4 answers · asked by Liz B 1 in Computers & Internet ➔ Software
Follow the instructions found here:
http://chemed.chem.purdue.edu/genchem/lab/datareports/excel/bestfit.html
2006-09-07 05:34:11 · answer #1 · answered by CaptainObvious 3 · 2⤊ 0⤋
Yes, you can calculate a best fit line using Microsoft Excel.
2006-09-07 12:50:13 · answer #2 · answered by Louise Smith 7 · 0⤊ 1⤋
Yes, your prof is right, It is in Excel
- In your chart, right click on the curve that is represented by your date.
- Select Add trendline
- In this window, you can select the type of your trendline.
- Check on the checkbox that says "Show Equation"
- Click Ok
Now you got the Trndline and the equation of it
good luck
Read my profile, I am XLMan
2006-09-08 06:48:22 · answer #3 · answered by Anonymous · 2⤊ 0⤋
u can do it in excel... u shudv asked how and i wudv told u.
2006-09-07 12:33:30 · answer #4 · answered by Carefree? Noway! I wish! 4 · 0⤊ 2⤋