ANOVA Two Factor With Replication | Two Way ANOVA | Example In Excel
Вставка
- Опубліковано 19 лип 2024
- To learn Lean Six Sigma most effectively and practically, please visit: www.successfulcareerhub.com/p...
Excel Data Analysis Tutorial, Two Way ANOVA, (ANOVA Two Factor With Replication):
Hello Friends,
Two-Way ANOVA is used to compare the means of more than 2 samples for 2 Factors. This is one of the most used types of Hypothesis Testing.
This video consists of the following topics:
✅ Introduction to Excel Data Analysis (Data Analysis In Excel)
✅ What is Two-Way ANOVA? (ANOVA Two Factor with Replication)
✅ ANOVA Two Factor With Replication Example (Two Way ANOVA Example)
✅ Null Hypothesis & Alternative Hypothesis In Two Factor ANOVA
✅ Two-Way ANOVA Example In Excel
✅ Data Arrangement In Excel to perform Two-Way ANOVA
✅ Procedure to perform Two-Way ANOVA in Excel (ANOVA Two Factor With Replication)
✅ Interpretation of Two-Way ANOVA results in Excel (ANOVA Two Factor With Replication)
✅ Explanation of ANOVA Table in detail
✅ Use of Boxplot to explain Two-Way ANOVA results
✅ Draw Boxplot in Excel Example
✅ Boxplot Results and Two-Way ANOVA results in comparison
✅ Learn Lean Six Sigma and Minitab Most Effectively and Practically
I am sure you will like it.
The Important links about LEARN & APPLY:
👨🏫 About Me: vijaysabale.com
🏫 Know about LEARN & APPLY: learnandapply.org
📚 My Learning Management System (LMS): www.successfulcareerhub.com/p...
📺 Join this channel to get access to perks: / @learnandapply
0:00 Introduction to Excel Data Analysis (Data Analysis In Excel)
0:56 What is Two-Way ANOVA? (ANOVA Two Factor with Replication)
2:51 ANOVA Two Factor With Replication Example (Two Way ANOVA Example)
3:56 Null Hypothesis & Alternative Hypothesis In Two Factor ANOVA
5:08 Two-Way ANOVA Example In Excel
6:04 Data Arrangement In Excel to perform Two-Way ANOVA
7:15 Procedure to perform Two-Way ANOVA in Excel (ANOVA Two Factor With Replication)
9:22 Interpretation of Two-Way ANOVA results in Excel (ANOVA Two Factor With Replication)
11:54 Explanation of ANOVA Table in detail
15:55 Use of Boxplot to explain Two-Way ANOVA results
16:19 Draw Boxplot in Excel Example
17:24 Boxplot Results and Two-Way ANOVA results in comparison
18:23 Learn Lean Six Sigma and Minitab Most Effectively and Practically
Thank you for watching...🙏😊
#anova #twowayanova #twofactoranova #analysisofvariance #exceldataanalysis #dataanalysisexcel #sixsigmaexcel #analysistools #leansixsigma #sixsigma #successfulcareerhub #learnandapply #statistics #excel
Very well explained Vijay. Thanks a lot
Thank you so much for your valuable comments and appreciation ☺🙏🙏
Two way annova can be used for comparing three different suppliers Raw material with change in properties like YS,r bar and Ra values.
This tool is useful in my current project.
Thanks vijay san for this vedio
That's amazing practical application. You are a deep learner Prakash!
Thank you so much for your valuable comments and appreciation 🙏🙏😊
Do more video on DA
Yes, I am working on it. Thank you so much for your valuable comments 🙏😊
Amit Keskar:
#Learnandapply #Successfulcareerhub #deeplearner #
Data analysis in Excel
ANOVA Two Factor With Replication
1. This analysis tool is useful when data can be classified along two different dimensions.
2. This is also called as Analysis of Means, as More than one factor is considered in this analysis.
3. For Example, a study compared experienced and inexperienced drivers on three types of roads, first class, second class a d dirt.
4. A tester recorded the number of steering corrections each driver made on each type of road. The response variable is Corrects.
5. As our data consists of two different factors, we need to use Two Way ANOVA ( ANOVA Two Factor)
6. We also have data for Multiple observations for the combination of these two factors, therefore we need to select an option for ANOVA Two Factor With Replication
7. A study compared experienced and inexperienced drivers types of roads,
The two factors are
1. Driving Experience- Eight inexperienced drivers and eight experienced drivers took part in this study The two levels were coded as Experience =1 and inexperienced =0
2. Road type- Each driver on one of three road types. The three levels were coded as first class road=1 Second class road =2, dirt road =3
3. A tester recorded the number of steering corrections each driver made on each type of road. The response variable is Corrects.
Null and Alternate Hypothesis is
Ho: mean of 1 = mean of 2 = mean of 3 or Ho: u1=u2=u3
Ho: Mean of inexperience = mean of experience of Ho:u1=ue
H1 : Any of the mean is different
Box Plot
This is transcript Amit. Can you please write here only about your learnings?
Thank you so much for your valuable comments 🙏🙏😊