Please help me to understand how an ANOVA is conducted using the information from the hypothesis below and how this is calculated in Excel:
The Economic Policy Institute has the statistics on the number of vacation days for employees in the United States which are about 16 vacation days a year, with France at 30 and Japan with 25 vacation days per year. This becomes an even larger gap when you consider that 30% of workers in the United States choose not to take their vacation time.
n = 300 ( population)
100 people surveyed from the US
100 people surveyed from Japan
100 people surveyed from France
The null hypothesis (H0) is that statement or claim that is assumed true until proven otherwise. The alternative hypothesis (H1) or known as the research hypothesis is believed to be true if the null hypothesis is found false. Simply stated it means an equal hypothesis versus not equal hypothesis (two- tailed test)
Set one, vacation days per year earned in the United States
Null Hypothesis; Н0: μ1 = 16 μ2 = 25 μ3 = 30
Alternative Hypothesis; Н1: μ1 ≠ 16 μ2 ≠ 25 μ3 ≠ 30
Use this hypothesis test it using ANOVA.
Please example in detail how you arrived at the ANOVA and provide the formula and the steps to complete in EXCEL.
This solution contains step-by-step instructions on how to conduct an ANOVA with the data provided, and also decides to accept or reject the null hypothesis.