|
|
|
MSEXST1 - Microsoft Excel 2007 – Data Analysis and Statistic Calculations
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.
Who the course is forThe course is for experienced users who work with
data and want to analyze them. Participants meet advanced MS Excel 2007 tools.
What we teach youAt 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.
Required skillsExcellent knowledge of MS Excel. Participants should be
able to work with functions, formulas and they should have an idea about data
analysis principles.
Teaching methodsProfessional instruction with practical examples and
practices on computers.
Teaching materialsPowerPoint handouts
Course syllabus
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
Recommended prior courses
MSEX3 - Microsoft Excel 2003 – Advanced Methods and Functions
MSEX307 - Microsoft Excel 2007 – Advanced Methods and Functions
Recommended subsequent courses
MSMAK1 - Using Microsoft Office 2003 Macros
MSMAK107 - Using Microsoft Office 2007 Macros
Catalog price of course and handbook
| Praha |
7000 Kč
|
--
|
0 items
|
| Brno |
6200 Kč
|
--
|
0 items
|
Course dates
|
