Purchase Solution

ANOVA and Economic Policy

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

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.

Purchase this Solution


Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.