parabolic best fit?

[mwmorph]

hey guys, hoew do i find a parabolic line of best fit? I need to know fast.

my data right now is:K is fro kelvin(temperature), not thousands.
X column value.........Y values
323K.......................8.85......9
313K.......................8.9........9.05
303K.......................8.95......9.1
293K.......................8.95......9.15
283K.......................9...........9.2
281K.......................9...........9.25
279K.......................9...........9.25
277K.......................9.05......9.25
276K.......................9.05......9.3
275K.......................9.05......9.3
274K.......................9.05......9.3
273K.......................9.05......9.3

 

[mwmorph]

really guys i need help. due tommorow.

 

[mundane]

Your graphing calculator should be able to do it; or, lacking that, MATLAB.

 

[BlueWeasel]

In Excel? By Hand?

 

[Indolent]

excel seems like the easiest choice


*edit* just graphing this in excel, your data is horrible if it is supposed to be parabolic. Looks quite linear to me. And, whatever measured your y values wasn't precise enough, too big of jumps for the little range the data covers.

 

[mwmorph]

Originally posted by: Indolent
excel seems like the easiest choice


*edit* just graphing this in excel, your data is horrible if it is supposed to be parabolic. Looks quite linear to me. And, whatever measured your y values wasn't precise enough, too big of jumps for the little range the data covers.

yeah i know, nut ehh, it;s not all that important i just need to know how to d oit in excel for work. I didnt measure this, im just making the presentation for the upper level guys.

 

[Indolent]

Originally posted by: mwmorph

Originally posted by: Indolent
excel seems like the easiest choice


*edit* just graphing this in excel, your data is horrible if it is supposed to be parabolic. Looks quite linear to me. And, whatever measured your y values wasn't precise enough, too big of jumps for the little range the data covers.

yeah i know, nut ehh, it;s not all that important i just need to know how to d oit in excel for work. I didnt measure this, im just making the presentation for the upper level guys.

just put the data in excel, and graph it with an xy scatter

right click on a data point>add trendline

a parabola is a polynomial with x^2 as it's highest value so go to type>polynomial>2

 

[Indolent]

Originally posted by: Indolent

Originally posted by: mwmorph

Originally posted by: Indolent
excel seems like the easiest choice


*edit* just graphing this in excel, your data is horrible if it is supposed to be parabolic. Looks quite linear to me. And, whatever measured your y values wasn't precise enough, too big of jumps for the little range the data covers.

yeah i know, nut ehh, it;s not all that important i just need to know how to d oit in excel for work. I didnt measure this, im just making the presentation for the upper level guys.

just put the data in excel, and graph it with an xy scatter

right click on a data point>add trendline

a parabola is a polynomial with x^2 as it's highest value so go to type>polynomial>2

btw* what kind of work? it looks a lot like a screwed up chemistry lab experiment

 

[mwmorph]

Originally posted by: Indolent

Originally posted by: Indolent

Originally posted by: mwmorph

Originally posted by: Indolent
excel seems like the easiest choice


*edit* just graphing this in excel, your data is horrible if it is supposed to be parabolic. Looks quite linear to me. And, whatever measured your y values wasn't precise enough, too big of jumps for the little range the data covers.

yeah i know, nut ehh, it;s not all that important i just need to know how to d oit in excel for work. I didnt measure this, im just making the presentation for the upper level guys.

just put the data in excel, and graph it with an xy scatter

right click on a data point>add trendline

a parabola is a polynomial with x^2 as it's highest value so go to type>polynomial>2

btw* what kind of work? it looks a lot like a screwed up chemistry lab experiment

ge medical. we're putting together very a very simplified graph of mri motion insensitive temperature mapping and intensity correlation for some less than competent new middle management guys.