ANOVA using MS Excel

A Step by Step Method
4.0 (1 rating) 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.
23 students enrolled
80% off
Take This Course
  • Lectures 7
  • Length 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

About This Course

Published 1/2016 English

Course Description

Analysis of Variance (ANOVA) course offers a complete package on ANOVA using MS Excel. The course includes:

  • What is the concept of ANOVA
  • How to do one-way ANOVA using Excel
  • What is two-way or N-way ANOVA
  • How to conduct test of Two-way or N-way ANOVA without interactions(replications) using excel
  • How to conduct test of two-way or n-way ANOVA with replications using excel with examples.

You will get more than 40 minutes video lectures and review excercise for further practice. Excel data files you can download for one-way and two anova for practice in MS Excel.

What are the requirements?

  • Knowledge of MS excel is desirable
  • Basic knowledge of inferential statistics

What am I going to get from this course?

  • Learn concepts of Analysis of Variance
  • Learn One-way ANOVA
  • Learn how to do one-way ANOVA using MS Excel
  • Learn how to do Two-Way and N-way ANOVA using Excel

What is the target audience?

  • Students who are already having knowledge of basic training in statistical analysis
  • Students doing BBA and MBA courses
  • Researchers

What you get with this course?

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

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: Analysis of Variance
Introduction to Analysis of Variance (ANOVA)
The Concept of One-Way ANOVA
Estimation of One-Way ANOVA using Excel
The Concept of Two-Way Anova without Replication
Estimation of Two-Way ANOVA without replication using Excel
Two-Way ANOVA with Replication using Excel
Review Excercises
2 pages

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Dr. Ash Narayan Sah, 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.

Ready to start learning?
Take This Course