all 12%1:19 Y ☺Lab Assignment #8_-150...ANOVAAn experiment was conducted to determine if motivational techniques in management significantly impactedemployee stress levels compared to no intervention. An employee survey was given to three groups: onegroup under a manager who started using a transformational motivation technique, one group under amanager who began using a transformational motivation technique, and then a control group with no newtechnique used. Stress levels were self-reported by the employees as shown below. Use alpha = 0.05TransformationalTransactionalControl26.331. What is your null hypothesis?2. What is your alternative hypothesis?After running the single factor analysis of variance on the data, what is the p-value for between3.groups?Using the 95% significance level, is there a significance difference in stress levels between the three4.groups?5. Do you reject or accept the null hypothesis?YesNoRejectAcceptII

Question
Asked Dec 8, 2019
4 views
all 12%
1:19 Y ☺
Lab Assignment #8_-150...
ANOVA
An experiment was conducted to determine if motivational techniques in management significantly impacted
employee stress levels compared to no intervention. An employee survey was given to three groups: one
group under a manager who started using a transformational motivation technique, one group under a
manager who began using a transformational motivation technique, and then a control group with no new
technique used. Stress levels were self-reported by the employees as shown below. Use alpha = 0.05
Transformational
Transactional
Control
2
6.
3
3
1. What is your null hypothesis?
2. What is your alternative hypothesis?
After running the single factor analysis of variance on the data, what is the p-value for between
3.
groups?
Using the 95% significance level, is there a significance difference in stress levels between the three
4.
groups?
5. Do you reject or accept the null hypothesis?
Yes
No
Reject
Accept
II
help_outline

Image Transcriptionclose

all 12% 1:19 Y ☺ Lab Assignment #8_-150... ANOVA An experiment was conducted to determine if motivational techniques in management significantly impacted employee stress levels compared to no intervention. An employee survey was given to three groups: one group under a manager who started using a transformational motivation technique, one group under a manager who began using a transformational motivation technique, and then a control group with no new technique used. Stress levels were self-reported by the employees as shown below. Use alpha = 0.05 Transformational Transactional Control 2 6. 3 3 1. What is your null hypothesis? 2. What is your alternative hypothesis? After running the single factor analysis of variance on the data, what is the p-value for between 3. groups? Using the 95% significance level, is there a significance difference in stress levels between the three 4. groups? 5. Do you reject or accept the null hypothesis? Yes No Reject Accept II

fullscreen
check_circle

Expert Answer

Step 1

Formulation of hypothesis

1)

Null Hypothesis is :- There is no difference between the mean of stress level among the three groups

 H0: µTransformational = µTransactional = µcontrol  

2)

Alternative Hypothesis is :- At least one of the group has difference between the mean of stress level.

Hα: µTransformational ≠ µTransactional ≠µcontrol

3)

Steps to perform ANOVA in Excel is given below

  • Enter the data in Excel as shown below
help_outline

Image Transcriptionclose

A 1 Transformational Transactional Control 2 2 3 4 3 3 9. 6. 2

fullscreen
Step 2
  • GO to data->data analysis->select Anova: Single Factor
  • Enter the following data in this table
help_outline

Image Transcriptionclose

Anova: Single Factor Input OK Input Range: SAS1:SCS6 Cancel Grouped By: Columns O Rows Help M Labels in first row Alpha: 0.05 Output options SFS8:SLS18 Output Range: New Worksheet Ply: New Workbook

fullscreen
Step 3

Result From ANOVA is...

help_outline

Image Transcriptionclose

Anova: Single Factor SUMMARY Variance Groups Count Sum Average Transformational 17 3.4 7.3 Transactional 11 2.2 3.7 Control 3.3 33 6.6 ANOVA F crit Source of Variation df P-value SS MS Between Groups 51.7333 2 25.8667 5.42657 0.02096 3.88529 Within Groups 57.2 12 4.76667 Total 108.933 14

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in
MathStatistics

Hypothesis Testing

Related Statistics Q&A

Find answers to questions asked by student like you
Show more Q&A
add