Question

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 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
Math   Statistics-And-Probability   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

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!

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use the following cell phone airport data speeds​ (Mbps) from a particular network. Find the percentile...
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...
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...
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...
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...
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...
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...
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...
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,...
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
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT