LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.charting
Jerry W. Lewis
 
Posts: n/a
Default calibration curve

I did not suggest that your data was not curved. I suggested that over an
appropriate range log(OD) might straighten it into a line. Barring that, you
would probably get a better fit from a model that flattens out toward max and
min values (as OD must) instead of increasing or decreasing without bound (as
a polynomial must).

Jerry

"PAUL GRAZIDE" wrote:

Polynomial in this case is correct, because the curve is not linear. If
curve was linear, then i would use y=mx+b.

Thanks


"Jerry W. Lewis" wrote in message
...
Are you sure that a polynomial is an appropriate calibration curve here?
You
don't give enough points to assess the fit, but I am much more familiar
with
OD calibration curves that are either log-linear or a 4- or 5-parameter
logistic equation.

Jerry

"PAUL GRAZIDE" wrote:

I am setting up a chemistry calibration curve using data below

OD reading Concentration
..020 0
..045 10
..245 40 etc

Plotting in XY scatter chart and get trendline using polynomial function.
How can I determine the concentration of an unkown solution ? I want to
use
trendline data to do this.






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
nonlinear regression/ curve fits geocalc Excel Discussion (Misc queries) 4 December 30th 05 08:18 PM
Fitting a curve similar to capacitor charging current. mcgradys New Users to Excel 3 November 22nd 05 06:27 PM
curve fitting a charging capacitor type curve mcgradys Excel Discussion (Misc queries) 4 November 15th 05 12:46 PM
watch a curve change over time like a movie RandyBarrett Charts and Charting in Excel 6 February 19th 05 05:00 AM
Vertical ND Curve on Combination Chart Phil Hageman Charts and Charting in Excel 4 December 30th 04 06:07 PM


All times are GMT +1. The time now is 08:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"