Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions

Question

3. List ways to manage relationship dynamics

Answered: 1 week ago