Reference no: EM132858298
The COVID-19 pandemic had redefined the meaning of normal life. Medically, hospitals were crowded with patients suffering from the disease. Suddenly, life became fragile. Economically, many companies were in difficulty and many people lost their jobs. Socially, people could not meet each other face-to-face. The normal handshake became a dangerous move.
Amid this troubled times, the elderly was the most affected. First, the disease was more deadly to this age group. Second, some of these elderlies were still working for a living prior to the pandemic and suddenly they lost their jobs. Third, many elderlies may not be familiar with social media technology and were distant with their love ones both physically and socially.
Mary was a student of the renowned Singapore University of Social Sciences. During this period, she happened to be an intern of the Society of Elderly Living. The Director of the society, Mr Jonny Tan, was concerned that the anxiety level of the elderlies may have increased substantially. As such, he had approached Mary to assist in the analysis.
Mary chanced upon a social science report on anxiety level of old folks in Malaysia. In the report, twenty-seven (27) old folks were given an anxiety test and their scores were published in 2010. The scores ranged from 0 to 200, higher score means more anxious. Mary decided to use the same test on a random sample of 27 elderlies. She intends to compare these two results and provide a preliminary analysis to Mr Tan.
(a) Using relevant Excel reports, describe the values for the mean, median, standard deviation and interquartile range of anxiety scores before and after the pandemic. Explain how you decide on the appropriate use of measures of dispersion - standard deviation or interquartile range.
Anxiety Score Categories 129 After 108 After 138 After 141 After 159 After 183 After 147 After 186 After 159 After 135 After 171 After 153 After 141 After 162 After 174 After 141 After 159 After 153 After 159 After 168 After 141 After 123 After 135 After 159 After 188 After 192 After 132 After 84 Before 132 Before 123 Before 102 Before 126 Before 123 Before 117 Before 129 Before 93 Before 105 Before 93 Before 141 Before 135 Before 84 Before 117 Before 126 Before 108 Before 111 Before 117 Before 108 Before 96 Before 102 Before 111 Before 108 Before 114 Before 144 Before 120 Before