Course Outline
Aggregating Data in Excel
- Statistical Functions
- Outlines
- Subtotals
- Pivot Tables
Data Relation Analysis
- Normal Distribution
- Descriptive Statistics
- Linear Correlation
- Regression Analysis
- Covariance
Time-Based Data Analysis
- Trends/Regression Line
- Linear, Logarithmic, Polynomial, Power, Exponential, and Moving Average Smoothing
- Seasonal Fluctuations Analysis
Comparing Populations
- Confidence Interval for the Mean
- Hypothesis Testing for Population Means
- Differences Between Means of Two Populations
- ANOVA: Analysis of Variances
- Goodness-of-Fit Test for Discrete Random Variables
- Test of Independence: Contingency Tables
- Hypothesis Testing for Variances of Two Populations
Forecasting
- Extrapolation
Requirements
Participants should possess a foundational understanding of Excel and Statistics.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
1. Clear theoretical explanation of concepts and alternatives to problem solving. 2. Practical examples where concepts are, and can be applied. 3. I learnt skills that I can use in my job, which will make some of my work easier 4. It will definitely bring some innovation into some of the reports I prepare for different Committees.
Sindiso Ndlovu - Export Credit insurance corporation
Course - Excel For Statistical Data Analysis
Steve was willing to answer every questions and worked diligently to address any individual concerns or technical issues as they arose in the class. He also did a great job of presenting the technical details in a way that made it less intimidating to even the least tech savvy people in the room. Personally, learning about some useful shortcuts in Excel that I didn't know about will certainly improve my overall workflow when using Excel in the future! I am so appreciative of those little details that I was exposed to during the two-day training.
Alan Gonzalez - Queens College, CUNY
Course - Excel For Statistical Data Analysis
The fact he had dif excel and data sheets with exercises for us to do.
