HBL Bank Pvt  LtD. is studying  its ATM use in the Gulshan-e-Iqbal area of Karachi. A sample of 30 ATMs showed they were used in the given number of times (in seconds) on a particular day, as shown in Table 1. Identify the presence of outliers in this dataset After removing the outliers (if present) from the given dataset, what is the expected or average number of times (in seconds) the ATM is used in the new dataset (if outliers were detected and removed). Show your results with errors in the statistical expected or average value.   83.24 64.01 84.23 76.20 84.21 54.29 5.11 59.21 70.23 61.01 63.10 80.23 84.21 73.20 68.11 52.19 65.22 90.16 52.16 177.21 95.23 36.15 48.12 16.18 59.32 84.22 195.13 47.18 87.13 26.11

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
icon
Concept explainers
Topic Video
Question

HBL Bank Pvt  LtD. is studying  its ATM use in the Gulshan-e-Iqbal area of Karachi. A sample of 30 ATMs showed they were used in the given number of times (in seconds) on a particular day, as shown in Table 1.

  1. Identify the presence of outliers in this dataset
  2. After removing the outliers (if present) from the given dataset, what is the expected or average number of times (in seconds) the ATM is used in the new dataset (if outliers were detected and removed). Show your results with errors in the statistical expected or average value.

 

83.24

64.01

84.23

76.20

84.21

54.29

5.11

59.21

70.23

61.01

63.10

80.23

84.21

73.20

68.11

52.19

65.22

90.16

52.16

177.21

95.23

36.15

48.12

16.18

59.32

84.22

195.13

47.18

87.13

26.11

 

Expert Solution
Step 1

(a)

 

Identify the outliers from the given data set.

 

The outliers from the given data set are determined below as follows:

 

Arrange the given data in the ascending order. The total number of values in the given data set are n=30.

 

Use EXCEL Procedure to obtain the value of first quartile.

 

Follow the instruction to obtain the value of first quartile.

 

  1. Open EXCEL
  2. Go to Formula bar.
  3. In formula bar enter the function as“=QUARTILE”
  4. Enter the range as $A$1:$A$31.
  5. Enter the quartile as 1.
  6. Click enter.

 

EXCEL output:

 

From the EXCEL output, the value of the first quartile is 52.715

 

Thus, the value of the first quartile is 52.715.

 

 

 

Use EXCEL Procedure to obtain the value of second quartile.

 

Follow the instruction to obtain the value of second quartile.

 

  1. Open EXCEL
  2. Go to Formula bar.
  3. In formula bar enter the function as“=QUARTILE”
  4. Enter the range as $A$1:$A$31.
  5. Enter the quartile as 2.
  6. Click enter.

 

EXCEL output:

 

From the EXCEL output, the value of the second quartile is 66.665.

 

Thus, the value of the second quartile is 66.665.

 

 

 

Use EXCEL Procedure to obtain the value of third quartile.

 

Follow the instruction to obtain the value of third quartile.

 

  1. Open EXCEL
  2. Go to Formula bar.
  3. In formula bar enter the function as“=QUARTILE”
  4. Enter the range as $A$1:$A$31.
  5. Enter the quartile as 3.
  6. Click enter.

 

EXCEL output:

 

From the EXCEL output, the value of the third quartile is 84.21

 

Thus, the value of the third quartile is 84.21.

 

 

Obtain the value of the Inter quartile range.

 

The value of Inter quartile range is obtained below:

 

The formula to obtain IQR is,

Probability homework question answer, step 1, image 1

Where Q3 denotes the third quartile.

Q1 denotes the First quartile.

 

The required value is,

Probability homework question answer, step 1, image 2

Thus, the value of Inter quartile range is 31.495.

 

Identify the outliers.

 

Rule for outliers:

Probability homework question answer, step 1, image 3

It is clear that if any data point falls outside the interval (5.47,131.45) are considered as outliers.

 

There are three data points considered as outliers that falls outside the interval are 5.11, 177.21 and 195.13.

steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Centre, Spread, and Shape of a Distribution
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, probability and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON