Microsoft Excel – Data Analysis and Statistic Calculations

Popis kurzu

At the course participants meet advanced data analysis methods. All standard statistical - analytic functions are discussed especially the Analysis ToolPack Add-Inn which is used for demanding statistical analyses. Listeners learn how to work with tools such as a descriptive statistics, a properties correlation, a values prediction and a work with time series. The course also focuses on clear interpretation of found results.

At the course participants meet advanced data analysis methods. All standard statistical - analytic functions are discussed especially the Analysis ToolPack Add-Inn which is used for demanding statistical analyses. Listeners learn how to work with tools such as a descriptive statistics, a properties correlation, a values prediction and a work with time series. The course also focuses on clear interpretation of found results.

Obsah kurzu

Analysis of extensive data volumes by helping PivotTable (PT) and PivotTable Chart Report.

• PT creation principles


• Total functions in PT


• Build-in functions for different data views in PT


• Calculated fields and items


• Data analysis and data understanding in PT

Basic data analysis

• Frequency analysis


• Histogram - frequency chart


• Level characteristics (Mean, Median, Mode, Quantity)


• Variable characteristics (Variance, Deviation)


• Shape allocation characteristics (Kurtosis, Skewness)

Dependence analysis

• Correlation


• Regression analysis (appropriate regression model, comparison of two different alternatives, judgment of regression model quality, estimates based on chosen regression model


• Graphic dependence analysis


• Multi regression (more independent variables)

Time series analysis

• Time series characteristics


• Basic time series description (differences, growth speed - chain, indexes)


• Time series modeling


• Time series decomposition (trend, seasonal, cyclic, random item of time series)


• Time series purge of seasonal component (moving average)


• Estimates based on time series model

Studijní materiály