Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Solve the below: The data shows employee's documented achievements in the financial office. The management team is interested in determining whether or not the achievements
Solve the below:
The data shows employee's documented achievements in the financial office. The management team is interested in determining whether or not the achievements of Female staff members are equivalent to those of Male staff members.
Use Excel to run the hypothesis statement and make a decision and explain a meaningful conclusion.
What insight have you gained from this analysis? Explain.
Order | ACHIEVEMENT | Gender |
1 | 59 | Female |
2 | 66 | male |
3 | 60 | Female |
4 | 66 | Female |
5 | 62 | Female |
7 | 72 | Male |
8 | 61 | Male |
9 | 61 | Male |
10 | 65 | Female |
11 | 42 | Female |
12 | 24 | Female |
13 | 72 | Male |
14 | 76 | Male |
15 | 66 | Male |
16 | 45 | Female |
17 | 53 | Female |
18 | 95 | Female |
19 | 50 | Male |
20 | 53 | Male |
21 | 76 | Male |
22 | 75 | Male |
23 | 43 | Male |
24 | 86 | Female |
25 | 67 | Female |
26 | 50 | Female |
27 | 58 | Female |
28 | 77 | Female |
29 | 76 | Female |
30 | 28 | Female |
31 | 86 | Female |
32 | 53 | Female |
33 | 67 | Female |
34 | 59 | Female |
6 | 55 | Male |
35 | 39 | Male |
36 | 73 | Male |
37 | 53 | Male |
38 | 46 | Male |
39 | 30 | Male |
40 | 71 | Male |
41 | 54 | Male |
42 | 48 | Male |
43 | 47 | Female |
44 | 29 | Female |
45 | 53 | Female |
46 | 31 | Female |
47 | 34 | Female |
48 | 66 | Female |
49 | 71 | Female |
50 | 52 | Male |
51 | 66 | Male |
52 | 85 | Male |
53 | 61 | Male |
54 | 71 | Male |
55 | 40 | Male |
56 | 44 | Male |
57 | 45 | Male |
58 | 57 | Male |
59 | 64 | Male |
60 | 41 | Male |
61 | 86 | Male |
62 | 49 | Female |
63 | 41 | Female |
64 | 66 | Female |
65 | 64 | Female |
66 | 45 | Male |
67 | 76 | Male |
68 | 57 | Male |
69 | 52 | Male |
70 | 82 | Male |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started