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
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...
An Illinois state program evaluator is tasked with studying the intelligence of soon graduating high school...
An Illinois state program evaluator is tasked with studying the
intelligence of soon graduating high school students in a number of
Chicago-area high schools.
One of the specific questions that needs to be answered is, “How
do the students of Collins High School, one of Chicago’s
lowest-rated high schools in terms of academic achievement, fare
compared to students of Lincoln Park High School, one of Chicago’s
highest-rated high schools in terms of academic achievement?”.
To conduct this study, the program...
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 ...
please write the code in java so it can run on jGRASP import java.util.Scanner; 2 import...
please write the code in java so it can run on jGRASP import java.util.Scanner;
2 import java.io.*; //This imports input and output (io)
classes that we use
3 //to read and write to files. The * is the
wildcard that will
4 //make all of the io classes available if
I need them
5 //It saves me from having to import each
io class separately.
6 /**
7 This program reads numbers from a file, calculates the
8 mean (average)...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 26 minutes ago
asked 26 minutes ago
asked 36 minutes ago
asked 37 minutes ago
asked 41 minutes ago
asked 42 minutes ago
asked 43 minutes ago
asked 43 minutes ago
asked 45 minutes ago
asked 52 minutes ago
asked 57 minutes ago
asked 1 hour ago