Statistics for the Non-Statistician
-
Speaker : ISAAC GOTTLIEB
-
When : Wednesday, May 01, 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.
The Excel Data Analysis ToolPak Add-in allows Excel users to solve statistical analysis problems without the need for a statistical background or being familiar with conventional Excel statistical functions. This tool can solve your problems applicable to finance, statistics, engineering, and more.
The “Descriptive Statistics” feature of the Data Analysis ToolPak, allows you to analyze data and get all the statistical summaries of that data (Sum, Average, High, Low, Median, Standard Deviations, and a few more) with just a few clicks.
The “Histogram” part of this tool, creates a frequency distribution of occurrences and a frequency-distribution-chart without the effort and know-how that other statistical functions require.
The “Correlation” feature of the ToolPak is a tool that will, almost instantly, generate all the multiple correlation coefficients between a number of variables simultaneously.
This workshop will cover the recently introduced “Forecast Sheet” an easy-to-use tool to help you forecast future values based on historical data.
This tool will work for you again, without a statistical background.
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
- Learn how to download the Excel Data Analysis ToolPak
- Review most of the 19 statistics applications the tool can solve
- Focus on three applications; descriptive statistics, histograms, and correlations
- Create mathematical formulas on data, using simple charts
- Use Excel tool for effortless forecasting
Course Level - This workshop uses Fundamental concepts. The tools presented need beginners' Excel skills
Who Should Attend
Excel users who would like to acquire statistical tools for daily use and decision-making. This workshop was taught by a presenter in the executive MBA programs, where the attendees did not have a statistical background.
Why Should You Attend
The vast majority of college students feel overwhelmed by statistical concepts. This anxiety often persists into their professional lives.
Statistics enables you to:
- Effectively conduct research
- Make decisions based on the data collected
- Understand what statistics they want to use before they collect their data
- Employ the correct analyses, and effectively present the results
Topic Background
- The objective of this workshop is to give you the tools to solve the day-to-day statistical problems you may have, without using the conventional Excel statistical functions.
- Attendees have to have only very basic Excel skills.
-
$160.00
-
