Find Jobs
Hire Freelancers

Curve fitting with Excel and using resulting equation for subsequent calculation

$15-25 USD / hour

En curso
Publicado hace más de 7 años

$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
ID del proyecto: 11213120

Información sobre el proyecto

9 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
4,8 (44 comentarios)
4,8
4,8
9 freelancers están ofertando un promedio de $20 USD /hora por este trabajo
Avatar del usuario
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 en 10 días
4,5 (5 comentarios)
4,3
4,3
Avatar del usuario
A proposal has not yet been provided
$15 USD en 5 días
5,0 (11 comentarios)
3,5
3,5
Avatar del usuario
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 en 1 día
5,0 (2 comentarios)
2,3
2,3
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
i have an experience working with numerical data in excel . i have an experience working with numerical data in excel
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$22 USD en 40 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Ossining, United States
5,0
12
Forma de pago verificada
Miembro desde mar 19, 2006

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.