From the course: Excel for Engineering Professionals

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Regression analysis: Helpful functions

Regression analysis: Helpful functions - Microsoft Excel Tutorial

From the course: Excel for Engineering Professionals

Start my 1-month free trial Buy for my team

Regression analysis: Helpful functions

“

- [Instructor] I don't know what you are like, but I really don't enjoy doing the same job over and over again. Also, I want my engineering calculations to be correct and traceable. That's why I don't really like how the Analysis ToolPak add-in returns static results. It's also why I have taken the trouble of duplicating some of the output of the ATP using formulas. Remember how we use the Analysis ToolPak add-in and let it generate descriptive statistics of our defect percentage? Now, because these descriptives are all static, I decided it's to be a good idea to reproduce all of the numbers using the proper formulas that Excel has on offer. Well, I'm not going to waste your time by explaining each and every formula in turn. You are smart enough to figure them out and you can use the exercise file that accompanies this video to do that. Should you want to learn more about one of the functions, just click on the FX…

Contents