1,155 total views, 2 views today
MS Office Excel Training - MS Excel Analysis Toolpack Add-in in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.
ID : 929
Goal : Discover trough examples of real case studies in detail all options available in the MS Excel analysis tool add-in for business or statistics analysis.
Audience : Engineers, financial analysts, accountants, executives and analysts/forecasters that whish to make more advanced analysis than it is possible using the spreadsheet-basic tools.
Prerequisites : Have at least a university degree or equivalent level in a scientific field (economics, physics, mathematics, chemistry, etc.) and be comfortable with statistics. One must also have the ability to mentally represent simple or complex mechanisms and processes.
- Descriptive statistics
- Rank and Percentile
- Moving Average
- Correlation Analysis
- Covariance Analysis
- Linear regression
- Exponential Smoothing
- Random Number Generation
- Z-Test two sample for Means,t-Test Paired tow sample for means
- t-Test Two-Sample assuming equal variances
- t-Test two Sample assuming unequal variances
- F-test two-Sample for Variances
- ANOVA single Factor
- ANOVA double Factor without replication
- Fourier Analysis
- Random and periodic Sampling
- Training Conclusion
Pedagogical method : A certificate will be awarded to each participant who has attended at least 80% of the training.
Suggested duration (days) : 2
Daily price : 425 CHF
Price per day per trainee without course material, without certificate, without evaluation, without training room or computer
Tags : ms excel busienss training, ms excel statistics training, ms excel business cours, analysis tool, anova , fourier transform, statistical test , business.