Question

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 | 5.6 | 3.8 | 27.3 |

DAL | 34.6 | 0.2 | 37.4 | 5.1 |

DCA | 6.5 | 0.8 | 14.4 | 16.2 |

DEN | 11.8 | 0.3 | 8.1 | 12.7 |

DFW | 10.3 | 0.6 | 10.0 | 14.8 |

DTW | 13.1 | 0.5 | 22.4 | 4.4 |

EWR | 4.5 | 9.6 | 9.3 | 13.4 |

FLL | 15.5 | 10.6 | 4.8 | 4.3 |

HNL | 15.0 | 0.5 | 5.1 | 10.9 |

HOU | 11.1 | 2.1 | 2.7 | 3.6 |

IAD | 13.5 | 2.7 | 14.7 | 4.2 |

IAH | 10.9 | 0.4 | 10.2 | 23.8 |

IND | 24.5 | 2.1 | 30.6 | 3.2 |

JFK | 4.6 | 1.2 | 21.0 | 9.8 |

LAS | 21.5 | 1.6 | 17.0 | 6.9 |

LAX | 18.2 | 15.1 | 3.0 | 0.7 |

LGA | 21.1 | 3.8 | 13.8 | 4.7 |

MCI | 10.2 | 1.1 | 9.5 | 13.5 |

MCO | 14.2 | 1.2 | 9.5 | 22.2 |

MDW | 71.3 | 2.5 | 5.5 | 13.3 |

MEM | 14.1 | 2.4 | 14.4 | 16.7 |

MIA | 22.2 | 4.0 | 4.0 | 5.0 |

MKE | 23.1 | 2.7 | 13.4 | 5.6 |

MSP | 1.4 | 0.3 | 10.0 | 16.7 |

MSY | 7.7 | 0.3 | 6.3 | 1.4 |

OAK | 16.0 | 0.4 | 6.0 | 22.5 |

ORD | 55.6 | 30.4 | 8.2 | 7.0 |

PDX | 4.5 | 5.0 | 6.5 | 15.0 |

PHL | 0.8 | 0.5 | 7.5 | 5.9 |

PHX | 1.8 | 0.6 | 7.6 | 13.3 |

PIT | 14.7 | 4.0 | 12.4 | 10.1 |

RDU | 20.2 | 2.7 | 11.0 | 5.4 |

RSW | 38.5 | 13.0 | 9.7 | 8.6 |

SAN | 3.2 | 0.3 | 2.7 | 2.6 |

SAT | 11.6 | 0.3 | 4.5 | 11.7 |

SEA | 11.1 | 1.6 | 8.0 | 15.0 |

SFO | 12.0 | 0.7 | 2.8 | 2.5 |

SJC | 17.5 | 3.6 | 2.7 | 7.4 |

SLC | 15.8 | 3.2 | 4.0 | 2.8 |

SMF | 13.7 | 0.3 | 17.5 | 23.5 |

SNA | 22.4 | 15.2 | 7.1 | 18.5 |

STL | 3.6 | 8.2 | 2.2 | 17.3 |

TPA | 9.9 | 14.1 | 5.3 | 16.1 |

Answer #1

The steps for deriving the mean and standard deviation are as follows :

Step1 : Enter the data in the Excel.

Step 2 : Now for mean, enter " Average(A1:A51) " function in any
other cell and press ok, we get the following results :

Mean = Average(A1:A51) = 10.704

Step 3 : Now for standard deviation, enter "STDEV.P(A1:A51)" for
deriving the population standard deviation and enter
"STDEV.S(A1:A51)" for deriving the sample standard deviation.

Standard deviation = STDEV.P(A1:A51) = 8.0399.

Standard deviation = STDEV.S(A1:A51) = 8.1215.

Hope this answers your query!

Use the following cell phone airport data speeds (Mbps) from a
particular network. Find the percentile corresponding to the data
speed 4.3 Mbps. 0.1 0.2 0.3 0.4 0.4 0.4 0.5 0.6 0.7 0.7 0.7 0.7 0.8
0.9 0.9 0.9 1.5 1.5 1.7 1.8 1.9 2.1 2.6 2.6 2.6 2.7 2.7 3.1 3.3 4.3
5.1 5.9 6.2 7.1 7.2 7.3 8.7 8.8 9.5 9.6 10.9 11.1 11.2 11.4 12.7
13.4 14.4 14.7 15.5 27.2 Percentile of 4.3=

USE EXCEL ONLY PLEASE
Using the data on the weight of a particular small animal find a
simple random sample of size 10, and a systematic sample of size
10. If you use the Data Analysis Tool Pack, include screenshots of
your settings in your submitted work. Find the mean and standard
deviations of your sample
Weight
16.5
12.2
12.0
10.6
9.8
9.3
12.4
14.2
13.1
10.9
12.8
16.1
13.5
14.1
12.5
10.7
13.1
15.3
12.7
12.1
15.9
14.7
15.3...

The cost of electricity (in $) was recorded for a random sample
of 50 cities in a country. These data are as follows:
9.0
9.0
9.5
9.6
10.2
10.8
10.9
11.1
11.4
11.6
11.9
12.3
12.7
12.8
12.9
13.0
13.0
13.5
13.7
13.9
14.1
14.3
14.4
14.7
14.8
14.8
14.9
14.9
15.0
15.1
15.3
15.4
15.7
16.3
16.5
16.6
16.7
16.8
17.1
17.2
17.5
17.8
18.3
18.5
18.7
19.1
19.7
20.2
20.6
21.3
A “less than” frequency distribution is constructed...

Use the data in Bank Dataset to answer this question.
Construct a 95% confidence interval for the mean increase in
deposits. Note that the population standard deviation σ is not
known in this case. Instead the sample standard deviation s should
be calculated from the sample and the t distribution should be
used.
2. What is the margin of error at the 95% confidence level?
Bank Dataset of Increase in deposits. Mean is 4. Sample size is
152 customers.
4.3...

We want to compare the
soil water content (% water by volume) of two fields growing bell
peppers.
The claim is that the two fields have different soil water
content.
Use the data below to test the hypothesis that the fields have
different soil water content.
Field 1 is in list1 and Field 2 is in list2.
We do not know whether the water content values are normally
distributed or not, but their variances are equal.
Provide your answers below....

Will rate, please and thank you!
9. Telephone Interviews: Survey The National Study of the
Changing Work Force conducted an extensive survey of 2958 wage and
salaried workers on issues ranging from relationships with their
bosses to household chores. The data were gathered through
hour-long telephone interviews with a nationally representative
sample (The Wall Street Journal). In response to the question “What
does success mean to you?” 1538 responded, “Personal satisfaction
from doing a good job.” Let p be the...

We wish to determine the impact of Specification Buying, X11, on
Satisfaction Level, X10. To do so we will split the Hatco data file
into two separate data sets based on the Specification Buying, X11.
This variable has two categories:
1=employs total value analysis approach, evaluating each
purchase separately;
0 = use of specification buying.
Sort the entire Hatco data set based on Specification Buying.
This will create two separate groups of records. Those records with
X11 = 0 and...

BODYFAT
HEIGHT
12.9
67.75
6
72.25
25.5
66.25
10.6
72.25
28.1
71.25
20
74.75
19.2
69.75
11.9
72.5
4.3
74
12.9
73.5
7.6
74.5
8.3
76
20.4
69.5
19.8
71.25
22.2
69.5
20.9
66
28
71
23
71
15.6
67.75
16.9
73.5
18.5
68
15.5
69.75
14.7
68.25
18
70
13.6
67.75
4.3
71.5
8
67.5
22.4
67.5
4.4
64.75
8.9
69
13.2
73.75
6.3
71.25
12.6
71.25
21
71
31.9
73.5
39.1
65
23.2
70
26.6
68.25
34.3
72.25...

To measure profitability, La Quinta used operating
margin, which is the ratio of the sum profit, depreciation,
and interest expenses divided by total revenue. The ratio is
expressed in percent form, meaning that it could theoretically take
on any value between 0 and 100, with a higher value indicating
greater profitability. La Quinta defines profitable inns as those
with an operating margin in excess of 50 percent; unprofitable inns
are those with margins of less than 30 percent. After a...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 17 minutes ago

asked 20 minutes ago

asked 24 minutes ago

asked 47 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago

asked 2 hours ago