Polynomial Curve Fit in Excel using Data Curve Fit Creator Add-in

This video demonstrates how to do curve fitting in Excel with Data Curve Fit Creator Add-in. It shows how to do a polynomial fit and how to get polynomial coefficients for a set of data.

Download free trial and learn more at:
http://www.srs1software.com/DataCurve...

---

Closed Caption:

this is a demonstration have did occur
fit creator Aaron
did occur for creator had in his in at
in from Microsoft Excel
which and he will add curve fitting in
data smoothing functions to excel
i can download it for free creator and
in from WWW dot s response offered a
condom and agent right now for free for
30 days
a 30-day trial so are what I'm gonna do
right now means I just wanted to I'll
give you a quick demo show you how it
works
I N to occur fit on some sample data
with the real simple polynomial said
just to show you how
how this works don't have gotten did
occur fit creator and installed here
and you know us when you get when you
install
did occur for creator Alan it as this
menu
must did occur fit creator menu to
to excel but to an changeover using the
N
what you really will be using most the
time his just the
extra functions it adds to excel so in
this case
up if Elena make a bunch of polynomial
estimate of my data right here I what I
would do is just much like the first
shell
all shady cools and use the function was
your day insert function measured from
Excel
and you if I go to the user-defined
category halted incur fit creator at in
functions are in net user-defined
category
and you can see them must hear cubic
spline fleck spline
go since moved acceptor and I'm gonna
take the polynomial fit the polly fit
function
I say okay and first thing it asks for
first argument is this your state the
source expel used
I'm sold gone highlight those values
now and I'm hit have four partial
because
amor I want to turn that into an
absolute referenced I always wanna point
to the same set of input values
up nuanced for my Fit
arm next call going arms like the y
values
my source data again I enough for to
make an absolute reference
next year I need to input the
expel you for which I'm doing an
estimate and now
that tax values listed right here the
as Shah before I head 0923 chatter out
27
me get some estimates for all those
values to see what my turf it looks like
and last you can input the fitzwater
and have already reserve the cell where
I have the fed water listed here
some click their had therefore make an
absolute
referenced and netted
and pretty much set prison optional
waiting values
argument is well and all are but I'll
leave that offering our shiny that'll be
later
so basically marcia had okay and I have
my
estimates my first input point an well
do now is all copies down
and hammacher fit and
nice then you know these
since I haven't have the order listed as
one
it's a linear fit obviously for the
status at Lanier
said maybe isn't a raid set maybe it's
maybe you can do better
so are making a trashcan perfect &
söhne
even better I let me Tresor Dorner said
ok-ish that seems like it's looking a
lot better
Arnold says pretty much it that's how it
works %uh
let me adjust tryout adding some waiting
values just show you how that works
your sisters one value that seems like
it's sort of a liar
we want a reduce the waiting have that
point how would we do that
you know a me set up up my set up a new
column
next my data listed as Wade and I'm just
going to
initially populated always ones
are equal value switches with the
default her
values know that staunch news
and I'm not going here and a
call my function now was it again and
now I'm gonna go in
highlight is winning values and her dad
is a an argument make an absolute
reference
copy down the values and now I'm gonna
go in for example set the waiting if
this.value
to 0 so that it doesn't meet at use that
value their point of
he sees it mid use that mean value any
create the
improves the occur fit I said I wanted
to force this value to be an exact fit
I want to be exactly 2.0 well what if I
said the waiting for that
200 you know you can do things like that
so this is just a quick demo are that
showed how you should
have polynomial fit function you can go
to our website for more demos
and up and downloads of rent right of
yourself
thank you very much