7. Using Excel, find the mean and the standard deviation of the
AT&T speeds from the...
7. Using Excel, find the mean and the standard deviation of the
AT&T speeds from the data set #32 Airport Data Speeds. Round
your answers to 3 decimal places. (Show your work!)
mean, x :
standard deviation:
AIRPORT
CODE
VERIZON
SPRINT
AT&T
T-MOBILE
ATL
77.8
0.4
33.9
27.3
AUS
28.5
0.5
29.0
5.1
BNA
1.9
2.3
4.6
9.5
BOS
6.2
1.0
11.7
9.6
BWI
43.0
3.4
12.7
3.2
CLE
15.1
0.5
7.6
24.7
CLT
7.9
1.1
9.1
4.4
CMH
25.7...
An important statistical measurement in service facilities (such
as restaurants and banks) is the variability in...
An important statistical measurement in service facilities (such
as restaurants and banks) is the variability in service times. As
an experiment, two bank tellers were observed, and the service
times for each of 100 customers were recorded. Do these data allow
us to infer at the 5% significance level that the variance in
service times differs between the two tellers? Estimate with 95%
confidence the ratio of variances of the two bank tellers. Teller 1
Teller 2 7.2 10.9 5.4...
Find the first quartile, the third quartile, and the
interquartile range for each data set.
(a)...
Find the first quartile, the third quartile, and the
interquartile range for each data set.
(a) {21, 18, 38, 34, 30, 51, 21, 34}
first quartile _________________
third quartile _________________
interquartile range ______________
(b) {13.1, 7.8, 12.6, 2.3, 6.7, 2.3, 7.4, 2.7, 8.4,
6.6, 6.8, 5.1, 2.2, 5.6, 5.5, 2.1, 7.7, 13.9, 1.6, 1.7}
first quartile _________________
third quartile _________________
interquartile range _____________
(C) {−13, −13, −7, −15, −21, −10, −21, −20, −25, −15}
first quartile _________________
third quartile _________________...
Med Student Sleep Average (Raw Data, Software
Required):
Here we consider a small study on the...
Med Student Sleep Average (Raw Data, Software
Required):
Here we consider a small study on the sleep habits of med students
and non-med students. The study consists of the hours of sleep per
night obtained from 30non-med students and 25 med students. The
sample data is given in the table below. Test the claim that, on
average, the mean hours of sleep for all med students is different
from that for non-med students. Test this claim at the 0.01
significance...
Data showing the population by state in millions of people
follow (The World Almanac, 2012). The...
Data showing the population by state in millions of people
follow (The World Almanac, 2012). The dataset in Excel file
2012Population.xlsx.
a. Develop a frequency distribution, a percent frequency
distribution, and a histogram. Use a class width of 2.5
million.
b. Does there appear to be any skewness in the distribution?
Explain.
c. What observations can you make about the population of the 50
states?
State
Population
Alabama
4.8
Alaska
0.7
Arizona
6.4
Arkansas
2.9
California
37.3
Colorado
5
Connecticut...