Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
Course Outline
Aggregating Data in Excel
- Statistical Functions
- Outlines
- Subtotals
- Pivot Tables
Data Relation Analysis
- Normal Distribution
- Descriptive Statistics
- Linear Correlation
- Regression Analysis
- Covariance
Analysing Data in Time
- Trends/Regression line
- Linear, Logarithmic, Polynomial, Power, Exponential, Moving Average Smoothing
- Seasonal fluctuations analysis
Comparing Populations
- Confidence Interval for the Mean
- Test of Hypothesis Concerning the Population Mean
- Difference Between Mean of Two Populations
- ANOVA: Analysis of Variances
- Goodness-of-Fit Test for Discrete Random Variables
- Test of Independence: Contingency Tables
- Test Hypothesis Concerning the Variance of Two Populations
Forecasting
- Extrapolation
Requirements
Participants should be familiar with the basics of Excel and Statistics.
Testimonials
Presentation of new tools that I didn't know before.
- Knauf Bełchatów Sp. z o.o.
The fact he had dif excel and data sheets with exercises for us to do.
Deepakie Singh Sodhi - Queens College, CUNY
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
The reminder of the world of statistics :)
Export Credit insurance corporation
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
Related Courses
Automated Monitoring with Zabbix
14 hours
Databricks
14 hours
Data Cleaning
7 hours
Datadog Monitoring
7 hours
Netdata
7 hours
Zenoss Monitoring for Administrators
21 hours
Fluentd for Log Data Unification
14 hours
KNIME Analytics Platform for BI
21 hours
Nagios
35 hours
Nagios Core
21 hours
Nagios XI Administration
21 hours
Sensu: Beginner to Advanced
14 hours
SPSS Modeler
14 hours