Please help by providing detailed answers to the questions and explanations to the questions. Thank you.
...
...
...
...
...
...
Assuming that the dean of the School of Business would like to understand how the COVID-19 pandemic has affected undergraduate business students. In particular, he would like to know: 1. Has it changed the demographic profile of the student body? 2. With the loss of employment during the lockdown, how has it affected summer and fall employment among students and their ability to pay for their education? 3. With the stress of the pandemic, employment and the shift to online classes, how has this affected student mental health? (a) Comparing Graph 1 and Graph 2, Count of Response ID 90 80 Count of Response ID Column Labels Row Labels 2019 2020 Grand Total Female 61 37 98 Male 78 75 153 Other 2 2 (blank) 9 2 11 Grand Total 148 116 264 70 60 50 Class 40 2019 30 2020 20 10 0 Female Male Other ( (blank) Gender Count of Response ID Column Labels Row Labels 2019 2020 Grand Total Female 43.88% 33.04% 39.04% Male 56.12% 66.96% 60.96% Grand Total 100.00% 100.00% 100.00% Count of Response ID 80.00% 70.00% 60.00% 50.00% 40.00% Class 2019 30.00% 2020 20.00% 10.00% 0.00% Female Male Gender Has the gender mix changed significantly? Comment. [A comparison can be made on how formatting has helped in making comparison, but you are not expected to comment on this] (b) After making some mild changes and reformatting, these were the graphs obtained: Count of Response ID 60.00% Count of Response ID Column Labels Row Labels 2019 2020 Grand Total Africa 5.41% 5.17% 5.30% Canada outside Nova Scotia 9.46% 8.62% 9.09% Caribbean 8.11% 5.17% 6.82% China 13.51% 11.21% 12.50% Nova Scotia 41.89% 55.17% 47.73% Other 8.78% 8.62% 8.71% South Asia 8.11% 4.31% 6.44% #N/A 4.73% 1.72% 3.41% Grand Total 100.00% 100.00% 100.00% 50.00% 40.00% 30.00% Class . 2019 2020 20.00% 10.00% 0.00% Africa Caribbean China Nova Scotia Other South Asia Canada outside Nova Scotia AN/A Home Count of Response ID 60.00% 50.00% Count of Response ID Row Labels International Africa Caribbean China Other South Asia Canada outside Nova Scotia Canada outside Nova Scotia - Nova Scotia Nova Scotia Grand Total Column Labels 2019 2020 Grand Total 46.10% 35.09% 41.18% 5.67% 5.26% 5.49% 8.51% 5.26% 7.06% 14.18% 11.40% 12.94% 9.22% 8.77% 9.02% % 8.51% 4.39% 6.67% 9.93% 8.77% 9.41% 9.93% 8.77% 9.41% 43.97% 56.14% 49.41% % 43.97% 56.14% 49.41% 100.00% 100.00% 100.00% 40.00% 30.00% Class 2019 2020 20.00% 10.00% 0.00 Africa Caribbean China Other South Asia Canada outside Nova Scotia Nova Scotia International Canads outside Nova Scotia Nova Scotia Home Home .Y It is observed that Nova Scotian students are in majority and that there are few from any one location outside of the province. Is there any evidence that COVID has affected the proportion of students who are from outside of Canada? Note that most international students in this course were already in Canada when COVID hit. (c) Comparing the average summer earnings for NS, Canada, outside NS and International students, with respect to how they were affected by COVID, Micrage of Summers $20,000 Average of Summers Column Labels Row Labels . 2019 2020 Grand Total International $2,720 $1,225 $2,199 Canada outside Nova Scotia $7,643 $6,056 $7,022 Nova Scotia $19,600 $5,356 $12,145 Grand Total $10,521 $4,113 $7,803 $18,000 $16.000 $14,000 $12,000 $10,000 . Class 2019 - 2020 $9.000 $6.000 $4,000 $2,000 $ International Canada de Nova Scotia Nova Scotia Home Home Y (i) Comment on the pattern(s). In 2019, there were no constraints on what values students could enter for summer earnings, whereas in 2020, there were some limits. The graph below shows the reported earnings following an exclusion of earnings under $500 and beyond $20,000. Summers (Multiple Items) - Summer Average of Summer $9,000 Average of Summer$ Column Labels Row Labels Y 2019 2020 Grand Total +International $4,501 $2,891 $4,065 Canada outside Nova Scotia $8,231 $4,500 $6,925 Nova Scotia $6,937 $6,221 $6,611 Grand Total $6,266 $5,370 $5,917 $8,000 $7,000 $6,000 $5,000 Class 2019 $4,000 2020 LI $3,000 1 $2,000 $1,000 $0 International Canada outside Nova Scotia Nova Scotia Home2 Home Referring to the graph above, comment on the pattern(s)
