Question

A new over-the-counter medicine to treat a sore throat is to be tested for effectiveness. The makers of the medicine take two random samples of 25 individuals showing symptoms of a sore throat. Group 1 receives the new medicine and Group 2 receives a placebo. After a few days on the medicine, each group is interviewed and asked how they would rate their comfort level 1-10 (1 being the most uncomfortable and 10 being no discomfort at all). The results are below. Find the 90% confidence interval in the difference of the mean comfort level. Is there sufficient evidence to conclude that the new medicine is effective? Assume the data is normally distributed with unequal variances. (Round answers to 4 decimal places)  Make sure to put the 0 in front of the decimal.

Average Group 1 = 5.84, SD Group 1 = 2.211334, n1 = 25

Average Group 2 = 3.96, SD Group 2 = 2.35372, n2 = 25

__________ < μ₁ - μ₂ < ______________

Please help with how to figure this out in excel or show formula.

Answer 1