Statistics Solutions

[Steps Shown] Jerry’s Bargain Department Store spent $50,000 on a training program to improve sales effectiveness of its employees. Below is a table of

Question: Jerry’s Bargain Department Store spent $50,000 on a training program to improve sales effectiveness of its employees. Below is a table of the before and after sales amounts for a random sample of employees who took the training program. Assume that data is recorded for an equal period of "before"-"after" time. Use the 1% level for risk. Process the data by Excel.

Person Before Training After Training Person Before Training After Training
CJ $38,747 $40,838 JZ $49,090 $53,700
TM $42,505 $48,555 HB $45,650 $49,799
JJ $35,464 $36702 TA $53,250 $55,404
DN $51,010 $52,910 ZK $60,990 $61,858
EW $48,575 $60,999 PL $58,344 $59,995
CH $32,377 $38,358 LD $44,012 $54,038
  1. Paste your Excel Printout here, or attach it to this assignment.
    t-Test: Paired Two Sample for Means
    After Training Before Training
    Mean 51096.33 46667.83
    Variance 73925202 75550259
    Observations 12 12
    Pearson Correlation 0.910035
    Hypothesized Mean Difference 0
    df 11
    t Stat 4.182105
    P(T<=t) one-tail 0.000766
    t Critical one-tail 2.718079
    P(T<=t) two-tail 0.001531
    t Critical two-tail 2.200986
  2. Given the processed data, describe what Jerry should do.

Price: $2.99
Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document


∴ Other downloads you may be interested in ∴

log in to your account

Forgot password?
Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in