Q#4: In an experiment, a group of college students was told that they wereparticipating in a manual skill study. Half of the students were given a stackof money to count, and the other half got a stack of blank pieces of paper.After the counting task, the participants were asked to dip their hands intobowls of very hot water (122°F) and rate how uncomfortable it was. Thefollowing data show ratings of pain like the results obtained in the study.Counting Money7, 6, 6, 9, 8,7Counting paper9, 4, 8, 2, 7, 5Is there a significant difference in reported pain between the twoconditions? Use a two-tailed test with a = 0.01.

The random variable is reporting pain. There are two independent samples which are counting money and counting paper. We have to test whether there is a difference in reported pain between the two conditions or not. This is two-sample t-test with two-tailed.Null hypothesis: There is no difference in reported pain between the two conditions. Alternative hypothesis: There is a difference in reported pain between the two conditions.EXCEL (Data Analysis) Procedure: Step 1: In EXCEL sheet, enter Counting money in one column and enter Counting paper in one column. Step 2: In Data, select Data Analysis and choose t test: Two-Sample Assuming Unequal Variances. Step 3: In Input Variable 1 Range: select Counting money. Step 4: In Input Variable 2 Range: select Counting paper. Step 5: Select Lables. Click Ok. EXCEL (Data Analysis) output:The value of the test statistic is t = 1.13. p-value = 0.2952. Conclusion: Since p-value (=0.2952) > α(=0.01), then fail to reject the null hypothesis. There is insufficient evidence to conclude that there is a significant difference in reported pain between the two conditions.