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.
29 freelancers are bidding on average £118 for this job
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.