Flash Sale!🎉|70% discount on courses
13hours 12minutes left!

Statistical & Research Analysis with Microsoft Excel | AQskill
3D Designs Accounting Accounting Software Affiliate Marketing Animation App Development Backend Web Development Business Analysis Cartoon Animation Computer programming Content Creation Customer Relation Data Analysis Data Analytics and Visualization Digital Marketing Digital Skill E-commerce Electronics Elementor Financial Analysis Forex Trading Graphics Design Importation Logo design Microsoft Word Mobile Skill Acquisition course Motion Design MySQL photoshop Presentation Software design SQL Statistics and Research UI/UX design Video Editing Website Design Website development Youtube Marketing
Preview this course

Statistical & Research Analysis with Microsoft Excel

A complete guide into statistical & research analysis. Highlights: Statistical calculations, Demographic analysis, Statistical charts, Research, Survey, Questionnaires, Inferences, Statistical tests, Hypothesis.
New Course
103 students enrolled
Statistics and Research
Awesome Emmanuel

What you'll learn

  • How to perform various statistical tests with the ability to understand when to reject or accept the Null and Alternative hypotheses
  • Perform descriptive statistics for surveys and questionnaires
  • Source and analyze web data and ability to administer online surveys
  • Transform demographic information into interactive dashboards.
  • Transform statistical data into meaningful charts and visualizations.
  • Ability to perform basic statistical calculations to draw meaningful inference
  • Understand the basic of Microsoft Excel for Statistical & Research Analysis
×
Rate our course

Course content

  • Expand all
Statistical Analysis with MS Excel(Part 1 Introduction to Basic Statistical Calculations)
14 lectures
1.1 Introduction 1
10 minutes
1.2 Introduction 2
10 minutes
1.3 Arithmetic Calculation
8 minutes
1.4 Percentages
9 minutes
1.5 Statistical Averages
5 minutes
1.6 Measures of Dispersion
7 minutes
1.7 Weighted Mean
8 minutes
1.8 Weighted Mean 2
5 minutes
1.9 Weighted Sum Method
17 minutes
1.10 Mean (Group Data)
6 minutes
1.11 Median (Group Data)
8 minutes
1.12 Mode (Group Data)
6 minutes
1.13 Data Collection (Questionnaire)
17 minutes
1.14 Age Bracket
10 minutes
Statistical Analysis with MS Excel (Part 2 Charts)
11 lectures
2.15 Bar Chart
10 minutes
2.16 Pie Chart
6 minutes
2.17 Donought Chart
5 minutes
2.18 Bar Chart 2
5 minutes
2.19 Pie Chart 2
5 minutes
2.20 Histogram
8 minutes
2.21 Line & Funnel Chart
6 minutes
2.22 Scatter Plot
5 minutes
2.23 Ogive
8 minutes
2. 24 Normal Curve 1
15 minutes
2.25 Normal Curve 2
9 minutes
Statistical Analysis with MS Excel (Part 3 Population Analysis)
4 lectures
3.26 Web Data
6 minutes
3.27 Map Chart (Nigeria Map)
10 minutes
3.28 Population Dashboard 1
16 minutes
3.29 Population Dashboard 2
15 minutes
Statistical Analysis with MS Excel (Part 4 Descriptive Statistics)
1 lecture
4. 30 Descriptive Statistics
13 minutes
Statistical Analysis with MS Excel (Part 5 Research Analysis & Questionnaire Output)
3 lectures
5. 31 Research Analysis(Frequency Counts & Percentages)
10 minutes
5.32 Research Analysis(Frequency Counts & Percentages) 2
12 minutes
5.33 Gender - Dependence
11 minutes
Statistical Analysis with MS Excel(Part 6 Statistical Tests)
14 lectures
6.34 Simple Regression Test 1
13 minutes
6.35 Multiple Regression Test
6 minutes
6.36 Chi Square Test (Goodness of Fit)
9 minutes
6.37 Chi Square Test (Goodness of Fit) 2
5 minutes
6.38 ChiSquare Test of Independence I
11 minutes
6.39 ChiSquare Test of Independence II
7 minutes
6.40 Questionnaire Test Result
5 minutes
6.41 F Test
7 minutes
6.42 T Test ( 1 Sample)
7 minutes
6.43 T Test (2 Sample, Paired & Unpaired)
9 minutes
6.44 Z Test
7 minutes
6.45 One Way ANOVA
9 minutes
6.46 Post Hoc Test
8 minutes
6.47 Two Way ANOVA
16 minutes

13hours 12minutes left

₦3,300

70%

₦11,000

Course Features

47 Lessons(6 Hours)

103 students

Lifetime access to course

Certificate of completion

Skill Level: All Levels

Rated: New Course

YOU MAY LIKE

See all

13hours 12minutes left

₦11,000 ₦3,300
Select your currency
NGN Nigerian naira
GHS Ghana cedi
KES Kenyan shilling
ZMW Zambian kwacha
USD United States (US) dollar
ZAR South African rand
UGX Ugandan shilling
SOS Somali shilling