Question
The following table contains recorded values on a level transmitter of a tank that’s holding water....
The following table contains recorded values on a level transmitter of a tank that’s holding water.
The samples are taken every hour for 24 hours.
| Hours | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
| Litres | 100 | 101 | 104 | 106 | 99 | 50 | 103 | 91 | 110 | 91 | 93 | 92 |
| Hours | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |
| Litres | 95 | 96 | 91 | 92 | 101 | 104 | 106 | 125 | 106 | 101 | 104 | 100 |
Calculate the following using a computer program such as excel:
Median:
Mode:
Outlier:
Homework Answers
Answer #1
Solution-
| Measures | Values | Excel Functions |
|---|---|---|
| Median | 100.5 | =MEDIAN() |
| Mode | 91 | =MODE() |
| Q1 | 92.75 | =QUARTILE.INC(data,1) |
| Q3 | 104 | =QUARTILE.INC(data,3) |
| IQR | 11.25 | =Q3-Q1 |
| Lower Limit | 75.875 | =Q1 -(1.5*IQR) |
| Upper Limit | 120.875 | =Q3 +(1.5*IQR) |
Data is arranged in ascending order we have calculated limits for outliers -
( 75.875 , 120.875 ) the points outside this interval are Outliers.
there are two points outside of this interval 50 and 125
therefore outliers are 50 and 125
- Excel Output-
Not the answer you're looking for?
Similar Questions
Construct a dot plot from the set of 50 IQ scores from randomly selected 10th graders....
Construct a dot plot from the set of 50 IQ scores from randomly
selected 10th graders. The scores are
60 73 76 77 80 81 83 84 85 87 88 89 90 91 92 93 94 94 95 96 96
97 98 99 100 100 101 102 103 103 104 105 106 107 109 110 111 112
113 114 116 117 119 120 123 124 130 133 134 141
The IQ scores of 50 students are given below. 117 85 108 86 104 110 90...
The IQ scores of 50 students are given below.
117
85
108
86
104
110
90
116
101
113
116
111
108
112
97
115
86
110
119
87
95
99
116
98
110
115
99
114
100
88
92
106
96
103
108
85
94
96
113
98
108
88
95
96
115
106
93
92
115
101
(a) Construct a grouped frequency distribution for the data. Use
85-89 for the first class and use the same width for...
A fast-food franchiser is considering building a restaurant at a certain location. Based on financial analyses,...
A fast-food franchiser is considering building a restaurant at a
certain location. Based on financial analyses, a site is acceptable
only if the number of pedestrians passing the location averages
more than 100 per hour. The number of pedestrians observed for each
of 40 hours was recorded. Assuming that the population standard
deviation is known to be 16, Estimate with 95% confidence the mean
number of pedestrians passing the location. Can we conclude at the
5% significance level that the...
The following data represent trunk circumferences (in mm) for a random sample of 60 four-year-old apple...
The following data represent trunk circumferences (in mm) for a
random sample of 60 four-year-old apple trees at East Malling
Agriculture Research Station in England.†
108
99
106
102
115
120
120
117
122
142
106
111
119
109
125
108
116
105
117
123
103
114
101
99
112
120
108
91
115
109
114
105
99
122
106
113
114
75
96
124
91
102
108
110
83
90
69
117
84
142
122
113
105
112
117...
Open the Body Data file under “Elementary Statistics, 13th edition” in Statdisk. This file contains information...
Open the Body Data file under “Elementary Statistics, 13th
edition” in Statdisk. This file contains information on the
measurements of a sample of 300 individuals. The population mean
systolic blood pressure is 124.7 with a variance of 211.10. The
population standard deviation is said to be roughly 14.5. For this
exercise, refer to pages 7, 11, and 12 of the Statdisk User Manual
document. Be sure to enter the population standard deviation in the
appropriate box. Given that the systolic...
Open Three Hospitals data. SETUP: It is believed that the number of injuries recorded in hospital...
Open Three Hospitals data. SETUP: It is
believed that the number of injuries recorded in hospital 1 is
different from the number of injuries recorded in hospital 2. Given
the data your job is to confirm or disprove this assertion.
10. What test/procedure did you perform? (4
points)
a. Regression
b. Two sided t-test
c. One sided t-test
d. Confidence Interval
11. What is the statistical interpretation? (4
points)
a. Average of data is inconsistent with the claim
b. P-value...
Sandra is the manager of human resources at ABC Inc. As part of his yearly report...
Sandra is the manager of human resources at ABC Inc. As part of
his yearly report to the CEO she is required to present an analysis
of the salaried employees. Because there are over 1,000 employees,
she does not have the staff to gather information on each salaried
employee, so she selects a random sample of 40. For each employee
she records monthly salary, service at ABC (in months), gender
(1=male, 0=female), and whether the employee has a technical or...
Many standard statistical methods that you will study in Part II of this book are intended...
Many standard statistical methods that you will study in Part II
of this book are intended for use with distributions that are
symmetric and have no outliers. These methods start with the mean
and standard deviation, x and s. For example,
standard methods would typically be used for the IQ and GPA data
here data215.dat.
(a) Find x and s for the IQ data. (Round your
answers to two decimal places.)
s=
Here are the numbers
obs gpa iq gender...
Pat.# Before After 1 195 125 To the left is 2 datasets measured for a sample...
Pat.#
Before
After
1
195
125
To the left is 2 datasets measured for
a sample of 107 patients with the high cholesterol level before and
after taking medication. Obtain the following for both sets:
2
208
164
3
254
152
1- the mean, mode and median
4
226
144
5
290
212
2- the variance and standard
deviation
6
239
171
7
216
164
3- First, second and third
quartiles
8
286
200
9
243
190
10
217
130...
A loan made on March 14 is due September 13 of the following year. Find the...
A loan made on March 14 is due September 13 of the following
year. Find the exact time for the loan in a non-leap year and a
leap year.
days.
The exact time in a non-leap year is ? days
The exact time in a leap year is ? days.
Data Table
Sequential Numbers for Dates of the Year
Day of Month
Jan.
Feb.
Mar.
Apr.
May
June
July
Aug.
Sept.
Oct.
Nov.
Dec.
1
1
32
60
91
121...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 17 minutes ago
asked 46 minutes ago
asked 49 minutes ago
asked 55 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago