Scribd
Upload
72 views2 pages

Module 3 Post Task

The document provides data on the time taken to solve 3 computer problems for an IT company. It asks the learner to analyze the data in Excel to calculate measures like the mean, median, mode, range, standard deviation and quartiles for each problem. The analysis shows Problem 1 has the longest mean and median time to resolve, Problem 3 has the highest mode and range and standard deviation, indicating it has the most variable resolution times. The document tests if the learner can interpret these results.

Uploaded by

THEA BEATRICE GARCIA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
72 views2 pages

Module 3 Post Task

The document provides data on the time taken to solve 3 computer problems for an IT company. It asks the learner to analyze the data in Excel to calculate measures like the mean, median, mode, range, standard deviation and quartiles for each problem. The analysis shows Problem 1 has the longest mean and median time to resolve, Problem 3 has the highest mode and range and standard deviation, indicating it has the most variable resolution times. The document tests if the learner can interpret these results.

Uploaded by

THEA BEATRICE GARCIA
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Rocero, Angela Louise S.

BSA – 2A

Let us now check whether you have remembered and understood the lessons in this module. Please
answer the problems in the attached. Use MS Excel to solve the problems. Interpret the results.

Given:

A certain IT company would like to identify the average time to solve 3 different computer-related
problems. The data (in terms of minutes) are indicated below.

Problem 1: 35 42 20 52 68 46 57 39 70 37

Problem 2: 40 32 25 22 45 50 39 28 64 75

Problem 3: 20 18 38 49 63 76 39 29 46 42

Questions:

1. What problem has the longest time to be resolved in terms of:

a. Mean = Problem 1

b. Median = Problem 1

c. Mode = Problem 3

2. Which problem has the most dispersed time in resolving in terms of:
a. Range = Problem 3

b. Standard Deviation = Problem 3

3. What time for each problem corresponds to the following:

a. Q1
 Problem 1 = 20
 Problem 2 = 22
 Problem 3 = 18

b. Q3

 Problem 1 = 20
 Problem 2 = 22
 Problem 3 = 18

b. D4
 Problem 1 = 40.8
 Problem 2 = 36.2
 Problem 3 = 38.6

c. D8
 Problem 1 = 59.2
 Problem 2 = 52.8
 Problem 3 = 51.8

You might also like