Use of VBA in Excel for Least Square Method

Asked By 0 points N/A Posted on -
qa-featured

Hi,

I am an engineer and I have to do a lot of experiments. Usually, I need a way to fit my measurement results with a curve.

I need a way to fit the data to an equation by using least square method.

I know there is an option in Excel called "VBA" to do it in a very smart way. But I really don't know how doing it exactly.

Can anyone help me?

Thanks.

SHARE
Answered By 0 points N/A #160338

Use of VBA in Excel for Least Square Method

qa-featured

Hello there Conley,

The Regression tool in the Analysis Tool Pack Add-in in Excel is the right tool you are searching for. Just activate the Analysis Tool Pack by going to the Microsoft Button > options > Add-in's tab.

Select the Analysis Tool Pack and click on OK.

As an example you could select an empty cell in Excel and press "Shift+F3" to open the functions tab. Type in Recursion in the search box and you will get the options which Excel can do for you. Highlight an option and click on help below to know more about it.

I hope this should help you add data into a curve in Excel and perform regression.

Cheers.

Login/Register to Answer

Related Questions