Polynomial Regression - EXCEL/VBA

preview_player
Показать описание
In this lesson you’ll learn about:
• How to find the best fit line to a set of curved data points
• How to develop a polynomial regression program
• Compare Results to Excel’s inbuilt linear regression function
  1. Shams ElFouly
Рекомендации по теме
Polynomial Regression - 0:22:20

Polynomial Regression - EXCEL/VBA

[Tutorial] How to 0:02:53

[Tutorial] How to prepare and Calculate Regression of Polynomial Equation using VBA

Linearization Curve Fitting 0:15:46

Linearization Curve Fitting - EXCEL/VBA

REGRESSION ANALYSIS WITH 0:00:52

REGRESSION ANALYSIS WITH VBA EXCEL

Excel Tutorial: Creating 0:29:36

Excel Tutorial: Creating a mathematical model; Simulating data; Fitting a Polynomial Regression

MAT 382 Lesson 0:03:08

MAT 382 Lesson 6 video 2 Using Excel for Polynomial Regression

Nonlinear Regression in 0:09:14

Nonlinear Regression in Microsoft Excel

Polynomial Regressions 0:04:03

Polynomial Regressions

How to fit 0:06:24

How to fit non-linear equations in excel using solver

How to do 0:05:18

How to do a linear regression on excel

Applied Statistics for 1:04:03

Applied Statistics for Business and Management using Microsoft Excel Improving Regression Models VBA

Regression and SUM 0:01:52

Regression and SUM Formula in VBA

Linear Regression - 0:15:49

Linear Regression - EXCEL/VBA

How to Solve 0:11:33

How to Solve Quadratic Equation using VBA in Excel

How to Use 0:24:16

How to Use Polynomial Regression | Excel and Minitab Examples | StraightLinePerform

Lagrange Interpolating Polynomial 0:13:21

Lagrange Interpolating Polynomial EXCEL + VBA

Polynomial regression 0:03:13

Polynomial regression

Curve Fitting Made 0:04:28

Curve Fitting Made easy in Excel: Fit line, polynomial, log, power law and moving average in Excel

Quadratic Regression Model 0:04:49

Quadratic Regression Model

Overfitting in Polynomial 0:00:09

Overfitting in Polynomial Regression

Microsoft Excel: A 0:08:14

Microsoft Excel: A Polynomial Fit | Dr. Samer Ali

LINEST Polynomial Regression 0:05:26

LINEST Polynomial Regression of Standard Logistic Function and TANH in Google Sheets Excel

Excel tip custom 0:00:29

Excel tip custom user defined functions VBA

Cubic Spline - 0:23:14

Cubic Spline - EXCEL/VBA

Комментарии
Автор

Cheers my friend! I just bought your course on Udemy. Great stuff! Very well done!

gergelylaszlo
Автор

This was very helpful. Thank you very much. Keep up the good work. :)

ezcomezgo
Автор

Really great video. Do you have any video or links/suggestions to a solution that can handle variying x values (like the XY-scatter can)?

egdchr
Автор

Is there a way to make this sub into a function? I'd like to apply it to multiple sets of y values.

elisabethandersson
Автор

Hi my friend, I have a "6" error with the line "factor = a (i, k) / a (k, k)" do you have any idea how to fix it? I used clng before the values ​​but it didn't work

I also tried with "Dim factor As Integer" but work either


Thanks for the help

yodiethmachado
Автор

Do you have any experience with Power BI? I would like to use your VBA in PowerBI to create a polynomial fit line of data.

wesayers
Автор

Absolutly great video!
somehow, when I run my sub (which I copied exaclty from you, did check it multiple times) s1, s2, & s3 are still blank cells, whereas r2 works perfectly fine. Also tried to change numbers for x & f(x) and the cell output...

Any ideas where my mistake could be or what happend there?
Thanks!


edit: found my mistake. wrongly put a 1 instead of i.

nicvolk
Автор

can you share a link or some how post the VBA Code you are using to make it easier to follow along?

ericwicklund
Автор

I copy exaclty the code but the lines of a0 and a1 empty appear, you could send me them please

jonathansologaistoa