I need help completing this assignment in excel. I have the excel file but I am not sure how to attach the file. I need to know how to perform a Wilcoxon test in excel and aswer the following questions.

Chapter 13 Activity

Mission: One symptom of the virus is mouth ulcers. As a result, you're now interested in investigating the oral condition of infected individuals. The data set contains data for a study of oral condition of virus patients. The oral conditions of the patients were measured and recorded at the initial stage, at the end of the second week, at the end of the fourth week, and at the end of the sixth week.The variables age, initial weight and initial virus stage of the patients were recorded.Patients were divided into two groups at random:one group received a placebo and the other group received an aloe juice treatment. (See the Excel File "Chapter 13 Activity" to complete the questions below.)

Variable Names:

ID- Patient ID

TRT- treatment group:0 = placebo; 1 = aloe juice

AGE- patient's age in years

WEIGHTIN- patient's weight at the initial stage

STAGE- initial virus stage, coded 1 through 4

TOTALCIN- oral condition at the initial stage

TOTALCW2- oral condition at the end of week 2

TOTALCW4- oral condition at the end of week 4

TOTALCW6- oral condition at the end of week 6

Research Question: Is there a difference in oral condition at the end of week 6 between the two treatment groups? (Assume the samples are not normally distributed.)

1. What type of test will we perform?

Wilcoxon

2. What is the parametric version of this type of test?

dependent

3. Use Excel to calculate the medians for each group.

Trt = 0

Trt = 1

4. Calculate the sum of the ranks for the two treatment groups.

Trt = 0

Trt = 1

5. Identify the appropriate test statistic (z score) and p-value for testing the claim that there is a difference in oral condition at the end of week 6 between the two treatments. [Use the Excel file and enter the value you calculated for the test statistic to get the p-value.]

Test statistic:

p-value:

6. Using the Excel file, calculate the effect size. (Round your value to two decimal places.)

r =

7. write up your results of this analysis.