Statistical Computing Master Class in Excel
Offered by
Benaadir Research, Consultancy & Evaluation Center (BRCE)

-
LevelAll Levels
-
Total Enrolled141
-
Duration6 hours
-
Last Updated30/06/2025
-
CertificateCertificate of completion
Course description
The “Statistical Computing Master Class in Excel” is an advanced course designed to provide in-depth knowledge and practical skills in statistical analysis using Microsoft Excel. The course is structured to guide you through the essential aspects of statistical computing, from data collection and cleaning to performing complex inferential statistics. Each section is meticulously crafted to build your proficiency in leveraging Excel for statistical tasks, making it an invaluable tool for data analysis in various professional fields.
Why should you take this course?
This course is perfect for anyone looking to harness the power of Excel for statistical analysis. Excel is one of the most widely used tools in business and academia for data analysis due to its accessibility and versatility. By taking this course, you will:
- Gain a comprehensive understanding of Excel’s statistical functions.
- Learn practical skills for real-world data analysis.
- Improve your ability to make data-driven decisions.
- Enhance your resume with advanced Excel and statistical computing skills.
Who is this course for?
- Business professionals who need to analyze data as part of their job.
- Students and academics conducting research requiring statistical analysis.
- Data analysts looking to enhance their skills with Excel.
- Anyone interested in learning how to perform statistical analysis without specialized software.
Material Includes
- 3 Downloadable Excel Datasets
- 1 Downloadable course note
Course Curriculum
Section 1. Course Overview
-
36:53
-
Basic Aggregations
20:55
Section 2. Data Basics
-
Developing questionnaire
06:16 -
Data collection (online)
19:20 -
Downloading and importing data into Excel.
01:35 -
Data Cleaning
05:03
Section 3. Descriptive statistics
-
Statistical Analysis Using Pivot table
28:32 -
Statistical Analysis Using Charts
09:31 -
Measures of Central Tendency
19:34 -
Measures of Dispersion
18:52 -
Descriptive statistics
25:52
Section 4. Inferential statistics
-
Fundamentals of hypothesis testing
47:42 -
One Sample t test Example 1
16:18 -
One Sample t test Example 2
07:36 -
Independent T-test Example 1
08:04 -
Independent T-test Example 2
09:13 -
Dependent T-test (paired) Example 1
05:11 -
Dependent T-test (paired) Example 2
03:00 -
One-way (between Subjects) Annova Example 1
12:45 -
One-way (between Subjects) Annova Example 2
05:34 -
Repeated Measured (Within Subject) Annova Example 1
11:04 -
Repeated Measured (Within Subject) Annova Example 2
02:00 -
Correlation Example 1
04:39 -
Correlation Example 2
02:59 -
Regression Example 1
05:19 -
Regression Example 2
04:24 -
Chi Square Example 1
10:18 -
Chi Square Example 1
17:19
Final Assessment
-
Statistical Computing masterclass in Excel Final assessment
Student Ratings & Reviews
This subject provides a comprehensive and practical foundation in applying statistical methods to real-world educational data. Through key concepts such as descriptive statistics, t-tests, ANOVA, correlation, regression, and chi-square analysis, students gain valuable skills in interpreting and analyzing data related to academic performance, study habits, and demographic factors. The use of visual tools like bar charts and pie charts enhances understanding and communication of findings. By integrating theory with hands-on analysis, the subject not only strengthens statistical reasoning but also equips students with the ability to make evidence-based decisions in educational settings. Overall, it is an essential and engaging course for anyone interested in data-driven insights in education.
About the instructors

Offered by

BRCE waa xarun ka shaqaysa horu marinta iyo barashada arimaha la xariira xirfadaha Casriga ah oo ku salaysan Technology-ga.