Hypothesis Testing using MS Excel

A Step by Step Method
0.0 (0 ratings) â€¢ 6 students enrolled
Instructed by Dr. Ash Narayan Sah
\$15
\$95
84% off
• Lectures 18
• Length 1.5 hours
• Skill Level All Levels
• Languages English
30 day money back guarantee!
Available on iOS and Android
Certificate of Completion
Wishlisted Wishlist

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

Published 1/2016 English

Course Description

Hypothesis testing using MS Excel course will help you to understand the concept of hypothesis testing. The course includes:

• What is the concept of hypothesis testing?
• Concept of two-tail and one-tail test
• the procedure of hypothesis testing
• Hypothesis test of population mean in case of large sample
• Hypothesis test of population mean in case of small sample
• Hypothesis test of Population variance
• Hypothesis test of two population mean using T test
• Paired t test
• F test
• Hypothesis tests using MS Excel

You will 17 lectures which includes 1hour 18 minutes of video lectures. You will also get review excercises for further practice. You will also find excel data files useful for hypothesis testing using MS excel.

What are the requirements?

• Knowledge of MS excel is desirable
• Knowledge of basic statistics

What am I going to get from this course?

• Understand the concept of Hypothesis Testing
• Learn the concept of two tail test
• Learn the concept of one tail test
• Learn the procedure of hypothesis testing
• Learn various tests like Z test, T test, F test, Paired t test
• Learn how to conduct paired t test, F test and other tests using MS Excel

Who is the target audience?

• Students who have some exposure in foundations of statistics
• Researchers of various disciplines can also benefit from this course
• Students of BBA and MBA

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Hypothesis Testing
Introduction Preview
03:18
The Concept of Hypothessis Testing
13:13
Two-Tail Test
01:34
One-Tail Test
01:02
Procedure of Hypothesis Testing
03:44
Hypothesis testing of Population Mean: Large Sample
05:54
Hypothesis Testing of Population: Small Sample
06:16
Hypothesis Testing of Population: Proportion
05:13
Hypothesis of Two Independent Population Assuming Equal Variance
07:43
Hypothesis Test Excel Application
05:10
Hypothesis Test of Two Population Assuming Unequal Variance
04:27
Hypothesis Testing Excel Application
03:47
Hypothesis Test of Two Population: Paired t test
05:12
Paired t Test Excel Application
03:23
Hypothesis Test of Population Variance:Chi-Square Test
06:51
Hypothesis Test of Two Population Variance
04:15
F Test Excel Application
03:42
Review Excercises
2 pages