Statistical Computing Master Class in Excel
Offered by
Benaadir Research, Consultancy & Evaluation Center (BRCE)
-
LevelAll Levels
-
Total Enrolled77
-
Duration6 hours
-
Last Updated03/12/2024
-
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
Mahadsanidiin
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.