One Way ANOVA using Microsoft Excel

ANOVA :- ANALYSIS OF VARIANCE
THIS VIDEO IS BASED ON COCEPT OF ONE WAY CLASSIFICATION OF ANOVA BY USING THE MICROSOFT EXCEL...(Test of the significance between the means of several Samples)
*REMEMBER*
If Calculated value of F statistics is greater than Critical value of F or if the P-Value is less than Significant level then we will Reject the Null Hypothesis.
F statistics value is calculated by dividing the Mean sum of squares of deviation Between the Samples By the Mean sum of Squares of deviation Within the Samples.

USE OF ANOVA
1- Test of the significance between the means of several Samples
2- Test of the significance between the Variance of two Samples
3- Study of homogenity in case of two-way classification
4- Test of Correlation and Regression
link for Part-2

Thanks For Watching :)