Nabídka tohoto termínu kurzu již není aktuální. Podobné kurzy naleznete zde.

Microsoft Excel – Data Analysis and Statistic Calculations

Základní info

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

V angličtině

Microsoft Excel – Data Analysis and Statistic Calculations

Vybraný termín:

24.1.2022  Praha

Cena

Kontaktovat dodavatele


Kontrola proti spamu. Kolik je šest a čtyři ? Součet zapište číslicemi.