Completed

Write VBA function to do weighted parabolic regression

I currently use excel LINEST function to fit parabolas (Y = AX^2 + BX + C) to hundreds of (X,Y) data points, and can crudely do weighted fitting by multiplying the instances of each point by integer weights. I need someone to write VBA code (that doesn't use excel LINEST) that can be used to do this for decimal weights. I currently have the VBA code to do this for Y=MX+C but need the code to now do weighted parabolic regression to find A, B and C in Y=AX^2 +BX+C.

Attached is a PDF of the code I am currently using. I need this adapted to solve for parabolic fitting.

Skills: Mathematics, Programming, Visual Basic

See more: vba read write xml sql server, vba read write xml, vba appointment write add event, vba access write xml, excel vba read write, vba access write filescarriage return, write xml data file using excel vba, vba spreadsheet write xml file, vba script write sql, vba bulk write, vba macro write text simplified chinese, vba script write outlook alert, excel vba read write xml file, vba macro write text file hyphens, write code transfer data sql server excel

About the Employer:
( 3 reviews ) London, United Kingdom

Project ID: #13231840

Awarded to:

pgbhughes

To be fair, I do believe this problem is not a difficult one. I have various ways of achieving this using built in solver, or if needed I can code the math directly. I am an engineer so I solve these kind of problems o More

£28 GBP in 3 days
(7 Reviews)
3.0

29 freelancers are bidding on average £118 for this job

jaylancer43

Hello Sir, My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If More

£200 GBP in 3 days
(319 Reviews)
7.7
£150 GBP in 3 days
(54 Reviews)
6.7
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex More

£150 GBP in 2 days
(106 Reviews)
6.9
£142 GBP in 3 days
(118 Reviews)
6.6
£36 GBP in 2 days
(330 Reviews)
6.3
MohsanEijaz

I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for y More

£66 GBP in 3 days
(29 Reviews)
5.4
The24CarrotsInc

Greetings for the day!!! We understand your requirement. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc

£28 GBP in 3 days
(34 Reviews)
5.1
dobreiiita

Hello I am VB and Algorithm expert and interested in this project. I have reviewed the attached document and confident to handle it perfectly. I will keep codes well documented and simple. Please commu More

£200 GBP in 5 days
(74 Reviews)
5.3
vsprybhanu

Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data from Multiple Sheets, Advanced Formulas, Critical Programming, D More

£250 GBP in 3 days
(38 Reviews)
5.0
£166 GBP in 3 days
(4 Reviews)
4.3
£100 GBP in 3 days
(12 Reviews)
4.1
axiomswb

We have expertise in Excel [url removed, login to view] have an expertise team to complete the job within the time span.. Client's satisfaction is my first priority and believe in long-term relationship with clients.

£80 GBP in 1 day
(9 Reviews)
3.8
vovo4ka

HI, Just wonder if you would be interested to learn more powerful tool than excell - R. R is an open software for data science, statistic and visualization. [url removed, login to view] ; [url removed, login to view] More

£60 GBP in 3 days
(5 Reviews)
3.5
rakeshwadhwani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and More

£250 GBP in 3 days
(2 Reviews)
3.2
ksinghrajeev

I got your requirement. Please provide you file. Ping me if you have any question for me. Thanks, Rajeev

£100 GBP in 5 days
(4 Reviews)
3.4
asin1987

Dear Employer, I will automate the process for you using VBAs and MAcros. Please find attached my previous work samples. Please let me know if we can discuss further on this. You can add me on s*k*y*p*e as well More

£166 GBP in 3 days
(2 Reviews)
3.4
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format More

£23 GBP in 1 day
(14 Reviews)
3.6
Weebside

Hello, Sir I am Afzaal Abid. A professional who will provide freelancer service to worthy clients like you. I can prove to be best writer and will provide you High-Quality Product with 100% Delivery Rate, 100% Satisf More

£150 GBP in 3 days
(10 Reviews)
3.7
fb57e1f6608abfb

Hi, I have ~4+ years of experience of creating and operating low to very high complexity of Excel/VBA/SQL,SAS, SPSS, R, Powerpoint based tools/processes, reports. I can assure you of high quality and on-time del More

£100 GBP in 1 day
(4 Reviews)
3.2
vivirain

A proposal has not yet been provided

£70 GBP in 2 days
(5 Reviews)
3.0