We've noticed this is not your region.
Redirect me to my region
What do you want to learn today?

Details

SkillsFuture Course - Statistical Data Analysis Training with Excel 

Microsoft Excel is an important tool to perform statistical data analysis. This course provides an overview of the fundamentals, from performing common calculations to conducting Bayesian analysis with Excel. The trainer will start with the foundational concepts, including an introduction to the central limit theorem, and then shows how to visualize data, relationships, and future results with Excel's histograms, graphs, and charts. He also covers testing hypotheses, modeling different data distributions, and calculating the covariance and correlation between data sets. The course closes with a look at calculating Bayesian probabilities in Excel.

Topics include:

  • Excel Data Analysis Tool
  • Basic Statistical Concepts
  • Hypothesis Testing
  • Correlation Analysis
  • Analysis of Variance
  • Regression
  • Bayesian Probability Analysis
  • Simulation

Outline

Module 1: Get Started ....

  • Excel Statistics Essentials
  • Excel Functions
  • Excel Statistical Functions
  • Excel Graphics
  • Excel Analysis ToolPak

Module 2 Basic Statistics Using Excel

  • Mean, Median, Mode
  • Variance and Standard Deviation
  • Probability Distributions
  • Normal Distribution
  • Central Limit Theorem
  • Estimation and Confidence Level
  • Hypothesis Testing

Module 3: Hypothesis Testing Using Excel

  • Z-Test Hypothesis Testing
    • z-score
    • One-tailed test
    • Two-tailed test
  • T-Test Hypothesis Testing
    • t-score
  • F-test Hypothesis Testing
  • Chi-Square Hypothesis Testing

Module 4 Analysis of Variance (ANOVA)

  • Single-Factor (multi-levels) ANOVA
  • Two Factors ANOVA
  • Post-ANOVA Testing

Module 5 Regression

  • Linear Regression
  • Multiple Regression
  • Non-Linear Regression

Module 6 Correlation

  • Two Factors Covariance
  • Multiple Factors Covariance Matrix
  • Two Factors Correlation
  • Multiple Factors Correlation Matrix

Module 7 Time Series & Forecasting

  • Time Series
  • Forecasting

Module 8 Simulation

  • Monte Carlo Simulation
  • Business Simulation

SkillsFuture Credit Applicable for Individual

WDA Training Grant Applicable for Company

Course Code: CRS-N-0032379

For more details, please visit our website at 

https://www.tertiarycourses.com.sg/statistical-data-analysis-training-with-excel-in-singapore.html or contact us at [email protected]

Speaker/s

Dr. Shailey Chawla is an experienced academician and researcher with over 10 years of experience in teaching and research. Her PhD research topic was on Web Requirements Engineering. She has published various research papers and book chapters in reputed international journals and conferences. Her recent research has been in Big Data Analytics at Hong Kong Polytechnic University where she worked on Urban Data Analytics and Educational Data Mining. She is proficient in R, Python, Java, Advanced Excel, Data Mining, C, Linux programming among various other core computing subjects.
Reviews
Be the first to write a review about this course.
Write a Review

Tertiary Courses Singapore offer many SkillsFuture courses in Singapore. We offers wide range of classroom instructor-led technical training courses for working professionals and executives in Singapore. Many of our courses and trainings are SkillsFuture Approved and eligible for WDA Absentee Payroll Grant.

Our courses include Infocomm, Digital Media, Robotics, Semiconductor,Telecommunication, Life Science, Horticulture Industries , and Business Administration . Below are some of our popular courses

  1. Python Programming
  2. R Programming
  3. Tableau
  4. Machine Learning
  5. Raspberry Pi
  6. Arduino
  7. 3D Printing
  8. iOS Apps Development
  9. Android Apps Development
  10. Magento eCommerce
  11. Wordpress
  12. Joomla
  13. Search Engine Optimization
  14. Web Design
  15. Google Analytics
  16. Facebook Marketing
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.