Find Jobs
Hire Freelancers

Curve fitting with Excel and using resulting equation for subsequent calculation

$15-25 USD / hour

In Progress
Posted over 7 years ago

$15-25 USD / hour

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
Project ID: 11213120

About the project

9 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 ([login to view URL] maths) with sufficient experience (4 years) hence I assure you quality work.
$22 USD in 1 day
4.8 (44 reviews)
4.8
4.8
9 freelancers are bidding on average $20 USD/hour for this job
User Avatar
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 in 10 days
4.5 (5 reviews)
4.3
4.3
User Avatar
A proposal has not yet been provided
$15 USD in 5 days
5.0 (11 reviews)
3.5
3.5
User Avatar
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 in 1 day
5.0 (2 reviews)
2.3
2.3
User Avatar
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 free work coupled the best time delivery.
$22 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i have an experience working with numerical data in excel . i have an experience working with numerical data in excel
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$22 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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 & experience that are required to complete this project. I can show you some examples of my work. Please contact me to discuss your project.
$22 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Ossining, United States
5.0
12
Payment method verified
Member since Mar 19, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.