Statistics for Managers Assignment
Complete the problems below and submit your work in an Excel document. Be sure to show all of your work and clearly label all calculations. All statistical calculations will use the Employee Salary Data Set.
Problems
 Is either that male or female salary equal to the overall mean salary? (Two hypotheses, onesample tests needed.)
 Are male and female average salaries statistically equal to each other?
 Are the male and female compa average measures equal to each other?
 If the salary and compa mean tests in questions 2 and 3 provide different equality results, which would be more appropriate to use in answering the question about salary equity? Why?
 What other information would you like to know to answer the question about salary equity between the genders? Why?
Answer rating (rated one time)
Week 2  testing
body preview (0 words)
file1.xlsx preview (188 words)
xxxxxxxx x
xxxxxxxxxxxxxxxxxx either xxx male or xxxxxx salary xxxxx xx xxx xxxxxxx xxxx salary?  
xxxxxxxxxxx  xxxx  xxxxxx 
Sample mean (*) (1)  xx  38 
xxxxxx xxxxxxxx deviation xxx (2)  17.78  xxxxx 
Population mean xxx xxx  45  45 
Number xx items xx sample (4)  25  xx 
xxxxxxxx error of xxx mean (5) x (2)/sq.root(4)  xxxx  xxxx 
t xxxxxxxxx x {(1)  (3)}/(5)  1.969  1.913 
xx xxx the xxxxxxxx xxxxxx xxx the xxx tailed test,  
t(0.05,24)  2.064  2.064 
xxxxxxxxxx  
xxxxx the xxxxxxxxxx xxxxx xx x xx xxxxxx xxxx the table xxxxxx the salaries xx xxxxx and xxxxxxx are xxx xxxxxxxxxxxxx different from xxx xxxxx overall mean salary  
(*) derived xxxx xxxx xxx xxxxxxxx results 
xxxxxxxx x
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxx male and xxxxxx xxxxxxxx statistically xxxxx xx each xxxxxx  
xxxx Sal  xxxxxx xxx  tTest: xxxxxxxxxx xxxxxxxx Equal Variances  
58  34  
27  41  xxxxxxxxxxx  Variable x  Variable 2 
66  xx  Mean  xxxxx  xxxxx 
47  xx  xxxxxxxx  316.00  xxxxxx 
xx  23  xxxxxxxxxxxx  xxxxx  25.00 
77  xx  xxxxxx Variance  xxxxxx  
xx  xx  xxxxxxxxxxxx xxxx Difference  xxxx  
47  xx  xx  48.00  
xx  xx  t Stat  xxxx  
xx  xx  xxx<xxx xxxxxxxx  0.00  
xx  34  t xxxxxxxx xxxxxxxx  xxxx  
xx  xx  xxx<xxx twotail  xxxx  
72  23  x xxxxxxxx twotail  xxxx  
xx  50  
xx  xx  
64  xx  
xx  xx  
xx  xx  
25  xx  
xx  22  
60  xx  
65  xx  
62  xx  
xx  55  
66  65 
xxxxxxxx x
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx the xxxx xxx xxxxxx compas equal to each xxxxxx  
xxxx xxxxx  Female Compa  tTest: xxxxxxxxxx Assuming xxxxx xxxxxxxxx  
1.017  1.096  
0.870  1.025  xxxxxxxxxxx  xxxxxxxx 1  xxxxxxxx x 
xxxxx  1.000  xxxx  1.06  1.07 
xxxxx  xxxxx  xxxxxxxx  xxxx  0.00 
xxxxx  xxxxx  xxxxxxxxxxxx  xxxxx  xxxxx 
xxxxx  1.050  xxxxxx xxxxxxxx  0.01  
xxxxx  1.043  xxxxxxxxxxxx xxxx Difference  0.00  
xxxxx  xxxxx  df  48.00  
xxxxx  xxxxx  x Stat  xxxxx  
xxxxx  1.161  P(T<=t) xxxxxxxx  0.29  
1.043  xxxxx  x Critical xxxxxxxx  1.68  
1.000  xxxxx  P(T<xxx twotail  xxxx  
1.074  1.000  t Critical xxxxxxxx  2.01  
1.020  xxxxx  
0.903  1.043  
xxxxx  xxxxx  
0.903  xxxxx  
0.982  1.043  
1.086  xxxxx  
xxxxx  xxxxx  
xxxxx  1.129  
xxxxx  1.043  
xxxxx  1.149  
1.052  1.145  
xxxxx  1.140 
file2.docx preview (622 words)
Is xxxxxx the male or female salary xxxxx to xxx overall mean salary?
To xxxxxx this xxxxxxxxx xx calculate xxx tvalue xxx female to xxxxxxxxxx and xxxx to population. xxxxxxx is as xxxxxxxx
Where
x x xxx xxxxxxxxxx xxxxx xx t
x = xxx sample mean
μM x xxx xxxxxxxxxx xxxx
xxx = xxx estimated standard xxxxx of the xxxxx which xx based xx xxx xxxxxx xxxxxxxx xxxxxxxxxx s
The xxxxxxxxx xxx the xxx xxxxxxxxxxx
Null xxxxxxxxxx xx : xx1 x xxx
Alternate hypothesis xx : μ1 ≠ μx
xx1 x xxxx of sample
xx2 = mean of xxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxParticulars  Male  xxxxxx 
Sample xxxx xxx (1)  xx  38 
Sample xxxxxxxx xxxxxxxxx (*) xxx  xxxxx  xxxxx 
Population mean xxx xxx  45  45 
xxxxxx of items in xxxxxx (4)  xx  25 
Standard error xx the mean xxx = (2)/sq.root(4)  3.56  3.66 



x statistic = {(1)  xxxxxxxx  1.969  xxxxxx 



xx xxx xxx xxxxxxxx xxxxxx for xxx two xxxxxx test, 


t(0.05,24)  xxxxx  xxxxx 
(*) xxxxxxx xxxx xxxx 1's xxxxxxxx xxxxxxx
xxxxxxxxxxx
Since the
   more text follows   
Try it before you buy it 
UPDATED 100% correct answer A+++++++++++++++++++TUTORIAL GUARANTEED PERFECT PLAGIARISM FREE WORK PERFECT CALCULATIONS
body preview (0 words)
file1.xlsx preview (306 words)
xxxxxx
xxxxxxxx  Sal  Compa  xxx  Age  xxx  SR  x  Raise  Deg  xxxx  Gr  xxxx xxxxxx salary  Mean xxxx xxxxxx  Avg. Salay  Male compa  female 
   more text follows   
Try it before you buy it 