Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Section B Lab-Type Questions (36 Marks) Answer all questions in this section. In this section, you will use excel to answer the following questions. Do
Section B Lab-Type Questions (36 Marks) Answer all questions in this section. In this section, you will use excel to answer the following questions. Do all the necessary computations in excel. You can copy the output from excel into Word document and do the discussion. Question 1 (9 marks) Part 1 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. [6 marks] 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started