You have asked 100 course mates to give an estimate of their average sedentary time in a day. Thereafter, you asked them to wear an activity monitoring device and calculated their average daily sedentary time objectively. The recordings were found in the dataset provided

(a) Describe the central tendency of average daily sedentary time for both measurements using relevant Excel reports. Determine the standard deviation and interquartile range of average daily sedentary time for both measurements and explain how you decide on the appropriate use of the two measures of dispersion.

(b) Using appropriate charts and numerical measures, develop a summary report to address the issue of human tends to underestimate their sedentary time.

Average Daily Average Daily Sedentary Time Sedentary Time Student (Self-Report) (by Device) 3 5.3 2.8 5.8 4.2 6.3 6.3 6.9 6.9 7.4 7.4 7.4 7.4 7.9 0.1 10.1 10.1 10.1 0.1 0.1 10.1 10.1 10.1 0.6 0.6 10.6 0.6 0.6 10.6 0.6 0.6 10.6 0.6 11.2 11.2 11.7 11.7 11 .7 11.7 11.7 11.7 11.7 11.7 12.2 12.2 12.2 12.2 12.2 12.2 15.2 12.2 11.3 2.8 2 .8 12.8 www 12.8 13.2 12.8 12.8 13.3 13.3 13 3 13.3 2.8 13.8 2.8 13.8 2.8 14.4 13.5 14.4 14.9 100 15.4