Hypothesis Testing using MS Excel
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Hypothesis Testing using MS Excel to your Wishlist.

Add to Wishlist

Hypothesis Testing using MS Excel

A Step by Step Method
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
6 students enrolled
Last updated 1/2016
English
Current price: $10 Original price: $95 Discount: 89% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Knowledge of MS excel is desirable
  • Knowledge of basic statistics
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.

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
18 Lectures
01:26:44
+
Hypothesis Testing
18 Lectures 01:24:44


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
About the Instructor
Dr. Ash Narayan Sah
3.7 Average rating
3 Reviews
2,073 Students
6 Courses
Data Scientist

I am Ash Narayan Sah working as assistant professor in the area of Economics and Econometrics in Thapar University, Patiala. I am a doctorate in Economics. I started doing my specilization in the economics area after my 12th. I completed my graduation in economics with honours from Utkal University in 1997. I did my master in economics from Hyderabad Central University, Andhra Pradesh in 2000. I also did my M.Phil in Economics and after M.Phil, I enrolled for my PhD in Financial Economics in Hyderabad Central University. After completion of my PhD, I joined as an assistant professor in University of Petroleum and Energy Studies, Dehradun in January 2007. I worked for 5 years in University of Petroleum and Energy Studies and taught basic econometrics course and mangerial economics to MBA students. During my stay at University of petroleum and Energy Studies, I realized the need of data analysis book using MS Excel for students of business studies. And then I decided to author my first book titled 'data Analysis using MS Excel', which published in 2009. after that I published another book titled ' Statistics for Management using MS Excel', which got published in 2013. I am having eight years teaching experience. In addition, I have also published few research papers. My expertise also extends in doing econometric and statistical analysis using several softwares like SPSS, Eviews, and MS Excel.