A researcher is conducting a study on the palliative care of patients at a specific facility to determine how their chronic pain symptoms change after entering the palliative care environment. This...

A researcher is conducting a study on the palliative care of patients at a specific facility to determine how their chronic pain symptoms change after entering the palliative care environment. This study is aimed at determining the effectiveness of a standardized treatment protocol for the patients entering into the palliative care environment. To do this, the researcher is comparing the pain scores of individuals before treatment and after treatment. Set up a Wilcoxon signed-ranks test and interpret it at the alpha equals .05 level.

1. A) We fail to reject H_0,
   which states the median difference in the pain scores before and after treatment are equal because 40 is less than the critical value 6 for a Wilcoxon signed-ranks test with a population of only 9 individuals.


2. B) We fail to reject H_0,
   which states the median difference in the pain scores before and after treatment are equal because 40 is greater than the critical value 6 for a Wilcoxon signed-ranks test with a population of only 9 individuals.


3. C) We reject H₀
   in favor of H_1,
   which states the median difference in pain scores before and after treatment are not equal because 1 is less than the critical value 6 for a Wilcoxon signed-ranks test with a population of only 9 individuals.

D) We reject H₀
in favor of H_1,
which states the median difference in pain scores before and after treatment are not equal because 1 is greater than the critical value 6 for a Wilcoxon signed-ranks test with a population of only 9 individuals

Please let me know if this can also be done on excel