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
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 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...
Indices DUR DUR (OLD) 1 6 11 2 13 14 3 11 14 4 7 10...
Indices DUR DUR (OLD)
1 6 11
2 13 14
3 11 14
4 7 10
5 9 9
6 7 10
7 8 11
8 5 8
9 7 6
10 7 10
11 7 13
12 3 5
13 10 13
14 3 15
15 4 12
16 9 7
17 9 8
18 10 13
19 6 10
20 8 14
21 10 14
22 8 18
23 2 10
24 4 11
25 7 16
26 ...
I am making a game like Rock Paper Scissors called fire water stick where the rules...
I am making a game like Rock Paper Scissors called fire water
stick where the rules are
Stick beats Water by floating on top of it
Water beats Fire by putting it out
Fire beats Stick by burning it
The TODOS are as follows:
TODO 1: Declare the instance variables of the class. Instance
variables are private variables that keep the state of the game.
The recommended instance variables are:
1.
2. 3. 4. 5. 6.
A variable, “rand” that...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 6 minutes ago
asked 10 minutes ago
asked 15 minutes ago
asked 23 minutes ago
asked 24 minutes ago
asked 29 minutes ago
asked 35 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 2 hours ago
asked 2 hours ago
asked 2 hours ago