Devam Ediyor

Curve fitting with Excel and using resulting equation for subsequent calculation

I have a small data set consisting of less than 100 x,y pairs. x is a distance measurement horizontally from a wall along a laser level line. y is a distance measurement vertically from the horizontal down onto an imperfect brick lined concave shaped water ditch. That's the setup.

So, the cross section is a shallow parabolic shape.

What I need to do is determine the area inside the parabola as a function of height from the bottom of the bowl.

The measurements are scattered, so after graphing the data in Excel I did a curve fit and had the equation show on the graph.

Using that equation, I then generated a larger number of new x,y data points. This is so I could create a table of height vs. area to a finer resolution than the original data. BUT, the generated data set, when graphed, DID NOT line up with the curve fit (trendline). But it should, right?!

Just to test that expectation, I made a trendline through the new generated data set graph and the equation from that turned out to be exactly the same as the fit equation from the original data. As it should, but again, the graph of it doesn't overlap the original. What the heck is going on? It's not even close but way off.

For this job, I'll send my original data set. Please help figure out why this is coming out wrong and help get a fit equation that works.

I imagine this would take a half hour for someone who is proficient with curve fitting and error analysis in Excel.

Thank you,

Gareth

Beceriler: Veri İşleme, Excel, Matematik

Daha fazlasını gör: why graph data, why graph, what is graphing, proficient in using, i need help with excel, graph using c, graphing of data, graphing data, graphing and data, graph and data, data graphing, data for graphing, data for graph, data and graphing, data and graph, data analysis with excel, create line graph, create a line graph, copy paste using macro excel, reading using data excel, construct spss analysis using microsoft excel, printdisplay using vba excel, using unicode excel macro, pbl using word excel, using odbc excel iseries

İşveren Hakkında:
( 12 değerlendirme ) Ossining, United States

Proje NO: #11213120

Seçilen:

fredysisenye

I will use curve fitting to fit quadratic curve then use calculus to get the relationship btn area and height. I am an expert in maths ([url removed, login to view] maths) with sufficient experience (4 years) hence I assure you quality wo Daha Fazla

$22 USD / saat
(44 Değerlendirme)
4.8

Bu iş için 9 freelancer ortalamada $20/saat teklif veriyor

$25 USD / saat
(39 Değerlendirme)
5.6
chyconsl

Hi, I have read and understood the project description and possess the skills required to meet your needs. Please give me a chance and reply. Thanks.

$16 USD / saat
(5 Değerlendirme)
4.3
The24CarrotsInc

A proposal has not yet been provided

$15 USD / saat
(11 Değerlendirme)
3.5
chiranjibpatra

hello! I am PhD in sensor networks I have done this kind of data crunching job in my research work. I can confidently do this kind of job at a definite time frame . kind regards

$22 USD / saat
(2 Değerlendirme)
2.3
segunyemi

it is highly essential for you to award this project to a professional. in this view i will like to help you out on this issue and i promise i will give you the best curve in excel and i will make the work an error fre Daha Fazla

$22 USD / saat
(0 Değerlendirme)
0.0
fargalialakarie

i have an experience working with numerical data in excel . i have an experience working with numerical data in excel

$15 USD / saat
(0 Değerlendirme)
0.0
sumanghosh

A proposal has not yet been provided

$22 USD / saat
(0 Değerlendirme)
0.0
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & Daha Fazla

$22 USD / saat
(0 Değerlendirme)
0.0