I kindly ask if you could help me with this question in Excel. The question is u

Question

I kindly ask if you could help me with this question in Excel.
The question is use this data for a gym where BMI 16 individuals where written down in the beginning and end of the year. Use Sign Test to see if BMI for individuals have decreased during the year.
The only question I need answered is how do I calculate the p value for this hypothesis? I have the correct answer from the teacher and that is suppose to be: 0,8491.
But I need help how he calculated this.

The data for this example is the following:

26,47

BMI beginning of year BMI end of year 26,5 26,06 26,07 26,4 25,37 25,53 27,41 26,28 25,39 25,39 25,4 25,69 25,79 26,12 26,34 26,24 26,52 26,53 26,08 26,37 26,45 26,22 25,9 26,42 25,51 25,57 25,67 24,94 25,44 25,95 27,04

26,47

Explanation / Answer

Solution:

Sample Value Rank 26.06 24.94 1 26.5 25.37 2 26.5 25.39 3.5 26.06 25.39 3.5 26.5 25.4 5 26.5 25.44 6 26.5 25.51 7 26.06 25.53 8 26.06 25.57 9 26.5 25.67 10 26.06 25.69 11 26.5 25.79 12 26.5 25.9 13 26.06 25.95 14 26.5 26.07 15 26.5 26.08 16 26.06 26.12 17 26.06 26.22 18 26.06 26.24 19 26.06 26.28 20 26.5 26.34 21 26.06 26.37 22 26.06 26.4 23 26.06 26.42 24 26.5 26.45 25 26.06 26.47 26 26.5 26.52 27 26.06 26.53 28 26.5 27.04 29 26.5 27.41 30

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---