In cell C3, find the average difference (d bar) between the sales amounts (after-before).
On the Data sheet, in cells C2:C24, find the difference (after-before).
In cell C5, find the standard deviation for the differences in sales amounts.
In cell C6, find the degrees of freedom for the data.
The human resources department would like to test the claim that the average in sales amounts increased after the training workshop. Is this a one-sided or two-sided test? Choose your answer from the dropdown menu in cell C7.
The null hypothesis is that the average difference in sales amounts (d) is less than or equal to zero. What is the alternative hypothesis? Choose your answer from the dropdown menu in cell C8.
In cell C9, find the value of the test statistic.
In cell C10, find a one-sided critical value for the test of the hypothesis at alpha=0.05.
Sales After the Training Workshop ($)	Sales Before the Training Workshop ($)	Difference (After-Before)
15,400	14,280
14,000	13,000
15,520	16,440
14,680	12,000
15,240	13,560
15,520	16,300
14,960	13,500
15,240	12,800
15,520	12,520
15,240	13,640
14,680	13,500
15,300	14,800
15,400	13,360
14,800	13,360
14,500	13,080
14,700	13,240
11,100	13,900
15,100	16,880
16,000	15,200
16,200	16,880
14,300	15,200
13,600	13,900
14,300	15,000