software

i have excel 2003 and am trying to create graphs for an electronics lab write
up. I have entered information into a table and created scatter diagrams etc
but i want to put on a line of best fit. The trendline function does not work
well enough for what i want, and i remember there being an option for a line
of best fit on an older version of the program. is there a way to do it? The
reason i am asking is because i want to read off values from my graph, i.e.
on a voltage vs frequency graph i want to know what the frequency would
theoretically be at 0.707 volts. if i can not create a best fit line, is
there a way to do this??

You did not tell if the fit is linear or not
You can use LINEST to fit to linear, polynomial, log etc
See www.stfx.ca/people/bliengme/ExcelTips and
www.tushar-mehta.com

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Becky Hutchinsonquot; lt;Becky gt; wrote in
message ...
gt;i have excel 2003 and am trying to create graphs for an electronics lab
gt;write
gt; up. I have entered information into a table and created scatter diagrams
gt; etc
gt; but i want to put on a line of best fit. The trendline function does not
gt; work
gt; well enough for what i want, and i remember there being an option for a
gt; line
gt; of best fit on an older version of the program. is there a way to do it?
gt; The
gt; reason i am asking is because i want to read off values from my graph,
gt; i.e.
gt; on a voltage vs frequency graph i want to know what the frequency would
gt; theoretically be at 0.707 volts. if i can not create a best fit line, is
gt; there a way to do this??
they're not linear or polynomial. some are like exponential but upside down
(yet not logarithmic, dunno what they're called). some are like the shape of
a black body curve if you ever did physics alevel. they're weird shapes that
can't be mapped onto a 'normal' function. what i really need to know is how
to get excel to read x values for a given y value

quot;Bernard Liengmequot; wrote:

gt; You did not tell if the fit is linear or not
gt; You can use LINEST to fit to linear, polynomial, log etc
gt; See www.stfx.ca/people/bliengme/ExcelTips and
gt; www.tushar-mehta.com
gt;
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;Becky Hutchinsonquot; lt;Becky gt; wrote in
gt; message ...
gt; gt;i have excel 2003 and am trying to create graphs for an electronics lab
gt; gt;write
gt; gt; up. I have entered information into a table and created scatter diagrams
gt; gt; etc
gt; gt; but i want to put on a line of best fit. The trendline function does not
gt; gt; work
gt; gt; well enough for what i want, and i remember there being an option for a
gt; gt; line
gt; gt; of best fit on an older version of the program. is there a way to do it?
gt; gt; The
gt; gt; reason i am asking is because i want to read off values from my graph,
gt; gt; i.e.
gt; gt; on a voltage vs frequency graph i want to know what the frequency would
gt; gt; theoretically be at 0.707 volts. if i can not create a best fit line, is
gt; gt; there a way to do this??
gt;
gt;
gt;


A couple of ideas:

1) Are your data spaced closely enough to use interpolation instead of
curve fitting to get reasonable results? Excel doesn't have a built in
interpolation function (some other spreadsheets have built in linear
interpolation functions if you're not tied to Excell), but it can be
done in Excel. Either write a UDF for it, or work out the lookup
portion using INDEX(MATCH()) then interpolate on the located interval.

2) If you insist on using a curve fitting approach, you've got to come
up with some kind of function that will represent your data. Trendlines
and LINEST really only work on linear parameter (or equation where the
parameters can be linearized), but there are other functions that don't
use linear parameters for which the parameters can be found using a
numerical approach like Solver. For example, you mention that some of
your data look like a blackbody radiation curve. Been a long time
since I dealt with that stuff, but a quick Google search found that a
blackbody curve is an equation of the form y=(Ax^-5)/(B^1/x-1) where A
and B are constants (B is a function of temperature). In your case, I
would just treat A and B as parameters. Can you come up with a few
equations that will fit your data?--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: www.excelforum.com/member.php...oamp;userid=22181
View this thread: www.excelforum.com/showthread...hreadid=496153A curve fit with Solver would be possible if you have an idea what function
you wish to fit the data to.
Contact me privately if you wish to explore this idea.
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Becky Hutchinsonquot; gt; wrote in
message ...
gt; they're not linear or polynomial. some are like exponential but upside
gt; down
gt; (yet not logarithmic, dunno what they're called). some are like the shape
gt; of
gt; a black body curve if you ever did physics alevel. they're weird shapes
gt; that
gt; can't be mapped onto a 'normal' function. what i really need to know is
gt; how
gt; to get excel to read x values for a given y value
gt;
gt; quot;Bernard Liengmequot; wrote:
gt;
gt;gt; You did not tell if the fit is linear or not
gt;gt; You can use LINEST to fit to linear, polynomial, log etc
gt;gt; See www.stfx.ca/people/bliengme/ExcelTips and
gt;gt; www.tushar-mehta.com
gt;gt;
gt;gt; --
gt;gt; Bernard V Liengme
gt;gt; www.stfx.ca/people/bliengme
gt;gt; remove caps from email
gt;gt;
gt;gt; quot;Becky Hutchinsonquot; lt;Becky gt; wrote in
gt;gt; message ...
gt;gt; gt;i have excel 2003 and am trying to create graphs for an electronics lab
gt;gt; gt;write
gt;gt; gt; up. I have entered information into a table and created scatter
gt;gt; gt; diagrams
gt;gt; gt; etc
gt;gt; gt; but i want to put on a line of best fit. The trendline function does
gt;gt; gt; not
gt;gt; gt; work
gt;gt; gt; well enough for what i want, and i remember there being an option for a
gt;gt; gt; line
gt;gt; gt; of best fit on an older version of the program. is there a way to do
gt;gt; gt; it?
gt;gt; gt; The
gt;gt; gt; reason i am asking is because i want to read off values from my graph,
gt;gt; gt; i.e.
gt;gt; gt; on a voltage vs frequency graph i want to know what the frequency would
gt;gt; gt; theoretically be at 0.707 volts. if i can not create a best fit line,
gt;gt; gt; is
gt;gt; gt; there a way to do this??
gt;gt;
gt;gt;
gt;gt;