Answer to Question #214160 in Macroeconomics for Anisha Radhika Kum

Question

Use excel

Assume a survey by Moodle Team collected data on average hours spent studying on moodle for 10 EC203 students before the Final Exam. Day James Peter Chris Susan Jessica Chathy Ryan Melina Eric Monday 5.48 4.82 5.19 6.22 4.70 5.07 7.42 6.84 6.91 Tuesday 6.21 5.63 5.70 3.85 5.21 5.61 9.06 6.42 6.82 Wednesday 7.15 6.57 6.64 3.79 6.15 6.55 7.66 7.08 7.15 Thursday 5.22 4.56 4.93 5.96 4.44 4.81 10.73 8.09 8.49 Friday 6.83 6.17 6.54 7.57 6.05 6.42 8.99 8.41 8.48 Saturday 8.04 7.46 7.53 9.68 7.04 7.44 10.29 9.71 9.78 Sunday 16.76 6.1 10.47 7.5 8.98 9.35 12.61 9.97 10.37 a) Based on the information above, construct an index of the average hours spent on studying by EC203 students for Tuesday onwards. Use Monday as the base period. b) Using a relevant descriptive tool, show and briefly discuss whether the 10 students are indeed spending more time studying on Moodle before the Final Exam

Answer 1

Given that:-