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:
( 4 reviews ) London, United Kingdom

Project ID: #13231840

Awarded to:


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)

29 freelancers are bidding on average £118 for this job


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
(338 Reviews)

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
(18 Reviews)
£150 GBP in 3 days
(57 Reviews)

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
(120 Reviews)
£142 GBP in 3 days
(128 Reviews)
£36 GBP in 2 days
(338 Reviews)

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

£28 GBP in 3 days
(39 Reviews)

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
(30 Reviews)

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)

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
(39 Reviews)

We have expertise in Excel [login to view URL] 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
(10 Reviews)
£166 GBP in 3 days
(4 Reviews)
£100 GBP in 3 days
(12 Reviews)

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)

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. [login to view URL] ; [login to view URL] More

£60 GBP in 3 days
(5 Reviews)

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)

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)

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)

A proposal has not yet been provided

£70 GBP in 2 days
(5 Reviews)
£133 GBP in 3 days
(3 Reviews)