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 (268 words)
xxxxxxxx x
xxxxxxxxxxxxxxxxxx either xxx xxxx xx xxxxxx xxxxxx equal to xxx xxxxxxx xxxx xxxxxxx  
xxxxxxxxxxx  xxxx  xxxxxx 
xxxxxx xxxx xxx (1)  52  xx 
Sample xxxxxxxx xxxxxxxxx xxx xxx  xxxxx  18.29 
Population mean xxx xxx  xx  xx 
xxxxxx of xxxxx in sample xxx  xx  25 
Standard xxxxx of the mean xxx x (2)/sq.root(4)  3.56  3.66 
t statistic x xxxx x (3)}/(5)  xxxxx  1.913 
xx per the critical values for xxx xxx tailed test,  
t(0.05,24)  2.064  2.064 
xxxxxxxxxx  
Since the xxxxxxxxxx xxxxx of x xx lesser than the xxxxx value, the salaries of xxxxx and xxxxxxx xxx not xxxxxxxxxxxxx xxxxxxxxx from the xxxxx xxxxxxx xxxx salary  
xxx xxxxxxx from xxxx 1's xxxxxxxx xxxxxxx 
xxxxxxxx x
xxxxxxxxxxAre the male and female salaries xxxxxxxxxxxxx xxxxx xx each other?  
Male Sal  xxxxxx Sal  xxxxxxx TwoSample xxxxxxxx Equal xxxxxxxxx  
58  xx  
xx  xx  Particulars  Variable x  xxxxxxxx x 
66  23  Mean  52.00  xxxxx 
47  22  xxxxxxxx  316.00  xxxxxx 
xx  23  xxxxxxxxxxxx  xxxxx  xxxxx 
77  42  Pooled xxxxxxxx  325.33  
xx  xx  Hypothesized xxxx 
   more text follows   
file2.docx preview (700 words)
Is either xxx male or female xxxxxx equal xx the xxxxxxx mean xxxxxxx
xx xxxxxx xxxx xxxxxxxxx we xxxxxxxxx the xxxxxxx for female xx population and male xx xxxxxxxxxxx xxxxxxx xx as xxxxxxxx
xxxxx
t x the calculated value xx t
x x the sample xxxx
μM = the xxxxxxxxxx mean
xxx = xxx xxxxxxxxx standard error xx xxx xxxxx xxxxx xx xxxxx on xxx sample standard xxxxxxxxxx s
The xxxxxxxxx xxx xxx two xxxxxxxxxxx
Null hypothesis xx x xxx x μx
xxxxxxxxx hypothesis HA x xx1 ≠ μ2
xx1 x xxxx of xxxxxx
μx x xxxx of xxxxxxxxxx
xxxxxxxxxxxxParticulars  xxxx  xxxxxx 
xxxxxx xxxx xxx xxx  xx  38 
Sample xxxxxxxx deviation xxx xxx  xxxxx  18.29 
xxxxxxxxxx mean (*) xxx  45  45 
Number xx items in xxxxxx (4)  25  xx 
Standard error xx the xxxx xxx = xxxxxxxxxxxxxx  xxxx  3.66 



t statistic = {(1)  (3)}/(5)  1.969  xxxxxx 



As xxx the critical xxxxxx for xxx two xxxxxx xxxxx 


t(0.05,24)  xxxxx  2.064 
(*) derived from Week 1's xxxxxxxx xxxxxxx
Conclusion:
xxxxx 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 (528 words)
xxxxxx
xxxxxxxID  xxx  xxxxx  Mid  xxx  EES  SR  G  xxxxx  Deg  Gen1  xx  Mean xxxxxx salary  xxxx xxxx salary  xxxx Salay  Male xxxxx  female 
   more text follows   
Try it before you buy it 