Statistical & Research Analysis with Microsoft Excel

What you'll learn

Understand the basic of Microsoft Excel for Statistical & Research Analysis
Ability to perform basic statistical calculations to draw meaningful inference
Transform statistical data into meaningful charts and visualizations.
Transform demographic information into interactive dashboards.

Perform descriptive statistics for surveys and questionnaires
Perform descriptive statistics for surveys and questionnaires
How to perform various statistical tests with the ability to understand when to reject or accept the Null and Alternative hypotheses

Description

Course Content

Reviews

Statistical & Research analysis is the science of investigating trends, patterns, and relationships using quantitative data.
Also, It is an important and demanding skill used by scientists, governments, businesses, academic institutes, and other organizations.

In addition, this course provides the most complete, detailed, interactive, and practical training on Statistical & Research Analysis with Microsoft Excel.

The course is divided into six (6) practical sections; Basic Statistical Calculations, Statistical Charts, and maps, Demographic/Population Analysis/Dashboard, Descriptive statistics, Research analysis & Questionnaires, and finally Statistical tests. Serving as a Guardian for you to know how to make witted summation aiding your statistical efficiency.

KEY QUESTIONS:

What are the course requirements?

Access to a laptop or computer.

Will certificate be issued?

Yes, certificate of completion will be issued at the end of the course.

Expand all

Statistical Analysis with MS Excel(Part 1 Introduction to Basic Statistical Calculations)

15 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

30 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

10 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

OLAIYA TEMITAYO

Rating |

I found the statistical and research analysis with MS Excel course on this platform to be extremely helpful in improving my data analysis skills. The course covered a wide range of topics, including data visualization, hypothesis testing, and regression analysis. The instructors were knowledgeable and presented the material in a clear and concise manner. Overall, I would highly recommend this course to anyone looking to improve their data analysis skills using MS Excel.

Daud, Abdulhakeem korede

Rating |

Abdulbaki Alfa-Ibrahim

Rating |

It's been an awesome and inspiring learning experience with Mr. Awesome. Thank you for much for putting together these insightful and value-filled lessons at affordable fee. This course has indeed shapen my learning and ignited my interest in data analysis and data science. I look forward to more insightful and valuable lessons like this on AQskills.

Abdikarim Hassan Atteyeh

Rating |

i am so excited I learned very important lessons in my life and also in my career and thank you for being a teacher

OKORONKWO NNENNA ESTHER

Rating |

this course is mind blowing , kudos to MR EMMANUEL He made it so simple to understand , GOD BLESS HIM

Chukwuneke Cynthia

Rating |

am impressed with your teaching, i learnt so much and practiced all you taught here. kudos

Ifiok Francis Bassey

Rating |

I'm getting more insights on research data analysis. Thank you so much Mr. Awesome.

Chinecherem Okeke

Rating |

This course is well-detailed and explained. I'm glad to be here

Richard Amakwoe D'Almeida

Rating |

Awesome presentation.Well explained lessons, point by point

Paul Ndunda Makau

Rating |

The course is perfect and it is really me prepare my thesis

Are the videos downloadable ?

The videos are efficiently compressed for quick downloads at any time.

How do I access the course videos and materials?

Once your payment is complete, you will have full access to the course lessons and materials. You can download and watch them at your convenience, and our team will provide full support and assistance throughout your learning journey.