Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jeff C
 
Posts: n/a
Default Complete unknown values in series

I have a series of lab values vs age. I can plot them on a graph and a line
forms between the values forming a curve though not symetrical. Since age is
a constant across the graph from 0 to 120 hours, is there a way to get Excel
to predict lab values for specific ages based on the curve generated on the
graph by the known values? If so, can someone help me through this? Thank
you.
  #2   Report Post  
bj
 
Posts: n/a
Default

you can use <chart<add trendline to have Excel try to fit your data.
If you have a theoretical expected fit (Log, Power, exponential, etc) you
can tell excel to fit many of those curves. In options have Excle print the
equation for th trendline, and you can use the equation to calculate specific
values. note many times the Trendline equaiotn signifcance needs to have
more significant figures so be sure to format the equaitn to have enough for
the accuracy you need.

"Jeff C" wrote:

I have a series of lab values vs age. I can plot them on a graph and a line
forms between the values forming a curve though not symetrical. Since age is
a constant across the graph from 0 to 120 hours, is there a way to get Excel
to predict lab values for specific ages based on the curve generated on the
graph by the known values? If so, can someone help me through this? Thank
you.

Reply
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
Excel should not automatically extend series or fill values whisperlm Excel Discussion (Misc queries) 0 July 13th 05 07:06 PM
VBA error: Unable to set the Values property of the Series class Marco Shaw Charts and Charting in Excel 1 July 12th 05 02:34 PM
Chart -- How to chart 65536 values in 1 series? kilmaley11 About this forum 0 June 8th 05 11:19 AM
Create new series (on the same chart) for every change of values in a combobox uriel78 Charts and Charting in Excel 5 April 15th 05 12:08 AM
retrieving values between 2 defined limits in experimetal data series uriel78 Excel Discussion (Misc queries) 5 February 13th 05 11:36 AM


All times are GMT +1. The time now is 12:30 PM.

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

About Us

"It's about Microsoft Excel"