Use of VBA in Excel for Least Square Method

Asked By Conley Pamela 0 points N/A Posted on - 02/11/2013

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.

• Status: Open
• Question Views: 1025
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Noell Pearson 0 points N/A #160338

Use of VBA in Excel for Least Square Method

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.

About Noell Pearson

Questions
3

Answers
101

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 03/04/2013
• Question Category: MS Excel