Regression analysis using Excel
-
Speaker : ISAAC GOTTLIEB
-
When : Monday, August 26, 2024
-
Time : 01 : 00 PM EST
-
Add To Calendar
Refer a Friend
For more than 25 years Dr. Isaac Gottlieb has been teaching Excel workshops for MBA students in a number of universities, including, Columbia, NYU and others in the US and other countries. In addition, he taught courses of Management Science and Statistics for Managers (always) using Excel. Over 100,000 students have attended his workshops and courses over the past 25 years.
He received the Microsoft MVP – Most Valuable Professional – award for the years 2014-6. “A Microsoft Most Valuable Professional (MVP) is an award for individuals who have exhibited exceptional technical expertise and a talent for sharing knowledge within their technical community.” (From Microsoft’s site.)
Isaac Gottlieb has taught how to use Excel—and how to apply it effectively to various business disciplines—to thousands corporate professionals from leading multinational companies as well as small private business corporations.
He mails Excel-Tip-Of-The-Month to over 35,000 recipients.
Dr. Gottlieb has earned his PhD and two Masters Degrees from Columbia University Department of Industrial Engineering and Operations Research.
His two recent books are:
- Excel 2022 Pro 100 + PivotTables, Charts & Reports: Explore Excel 2022 with Graphs, Animations, Sparklines, Goal Seek, Histograms, Correlations, Dashboards. Nov 2022.
- Management Science using Excel: Harnessing Excel's advanced features for business optimization. Aug 2023.
This workshop is an introduction to performing and interpreting regression analysis, even if Excel isn’t your primary statistical software package.
This workshop provides step-by-step instructions for using Excel to perform single and multiple regression analysis. It also shows you how to specify the model case studies. This workshop is an introduction to performing and interpreting regression analysis, even if Excel isn’t your primary statistical software package.
This workshop provides step-by-step instructions for using Excel to perform single and multiple regression analysis. It also shows you how to specify the model case studies
You will receive all the Excel files before the workshop – so that you can practice all these techniques during the workshop and on your own.
Areas Covered
- Using Regressions
- Charts and regressions
- Using the Analysis Tool Pak for single regression
- Using the Analysis Tool Pak for multi - regressions
- Real-life case studies
Course Level - All Excel users that have small and large databases and they have to find relationships that will help them forecast using the data.
Who Should Attend
Any person using Excel that needs wants to improve their day-to-day skills and deal with small and large databases.
Why Should You Attend
Professionals or students who are using Excel:
- Have extensive databases of data and need to find the relationship you wish to use for forecasting
- You do know all the forecasting functions in Excel and you do need to perform the regression without using sophisticated tool
Topic Background
You are a whole lot of different data and are asked to forecast next year's sales numbers for your business. You have discovered dozens, or even hundreds, of factors that can possibly affect the numbers. How do you know which ones are important? Run regression analysis in Excel. This will give you an answer to this and many more questions: Which factors matter and which can be ignored? How closely are these factors related to each other? And how certain can you be about the predictions?
-
$160.00
-
