Find Jobs
Hire Freelancers

Curve fitting with Excel and using resulting equation for subsequent calculation

$15-25 USD / hour

Em Andamento
Publicado há mais de 7 anos

$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 do Projeto: 11213120

Sobre o projeto

9 propostas
Projeto remoto
Ativo há 8 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
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 em 1 dia
4,8 (44 avaliações)
4,8
4,8
9 freelancers estão ofertando em média $20 USD/hora for esse trabalho
Avatar do Usuário
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 em 10 dias
4,5 (5 avaliações)
4,3
4,3
Avatar do Usuário
A proposal has not yet been provided
$15 USD em 5 dias
5,0 (11 avaliações)
3,5
3,5
Avatar do Usuário
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 em 1 dia
5,0 (2 avaliações)
2,3
2,3
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
i have an experience working with numerical data in excel . i have an experience working with numerical data in excel
$15 USD em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A proposal has not yet been provided
$22 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Ossining, United States
5,0
12
Método de pagamento verificado
Membro desde mar. 19, 2006

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.