Microsoft Office Excel - analiza statystyczna Certificate for Anna...
Certificate ID:
659215
Authentication Code:
9e64c
Certified Person Name:
Anna Jarnicka
Trainer Name:
Rafał Kwaśnik
Duration Days:
2
Duration Hours:
14
Course Name:
Microsoft Office Excel - analiza statystyczna
Course Date:
15 November 2021 09:00 to 16 November 2021 16:00
Venue:
Warszawa
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
Course Name Eng:
Excel For Statistical Data Analysis