Group Assignment No.

Descriptive Statistics- Using Statistics

Max. Marks: 60

Use Excel wherever necessary to solve the following questions. All the questions are

compulsory. The weightage of each question has been mentioned next to it. 

Submit Excel and Word files both.

Note: 

1. Solve all questions in a single Excel file. Please avoid using multiple spreadsheets within

the same excel file, unless necessary.

2. Please do not repeat the text of questions in your response sheets.

3. There must be only a single submission per group.

4. Use the following format to name your files (both Word and Excel) before submitting:

Group<No.>. Example, members of group no. 5 will name their files as: Group5.

Q1. The 2010 U.S. Census also asked for each person’s age. Suppose that a sample of 40

households taken from the census data showed the age of the first person recorded on the census

form to be as follows.

4 29 31 38 55 27 28
2
3
3 49 70 25 21 38 47
6
3 22 38 52 50 41 19
2
2 29 81 52 26 35 38
2
9 31 48 26 33 42 58
 4
0 32 24 34 25

Compute percentiles: P10, P80, quartiles: Q1, Q3, the interquartile range, and the range for these

data. 

(2+2+2+2+2+2)=12

Q2. The time needed to assemble a particular piece of furniture with experience is normally

distributed with a mean time of 43 minutes. If 68% of the assembly times are between 40 and 46

minutes, what is the value of the standard deviation? Suppose 99.7% of the assembly times are

between 35 and 51 minutes and the mean is still 43 minutes. What would the value of the

standard deviation be now? Suppose the time needed to assemble another piece of furniture is

not normally distributed and that the mean assembly time is 28 minutes. What is the value of the

standard deviation if at least 77% of the assembly times are between 24 and 32 minutes?

(2+2+3)=7

Q3. Environmentalists are concerned about emissions of sulfur dioxide into the air. The average

number of days per year in which sulfur dioxide levels exceed 150 milligrams per cubic meter in

Milan, Italy, is 29. The number of days per year in which emission limits are exceeded is

normally distributed with a standard deviation of 4.0 days. 

a. What percentage of the years would average between 25 and 33 days of excess emissions

of sulfur dioxide? 

b. What percentage of the years would exceed 33 days? 

c. What percentage of the years would exceed 37 days? 

d. In what percentage of the years would there be fewer than 21 days with excess sulfur

dioxide emissions?
 (2+2+2+2)=8

Q4. According to a Human Resources report, a worker in the industrial countries spend on

average 419 minutes a day on the job. Suppose the standard deviation of time spent on the job is

27 minutes.

a. If the distribution of time spent on the job is approximately bell shaped, between what

two times would 68% of the figures be? 95%? 99.7%?

b. If the shape of the distribution of times is unknown, approximately what percentage of

the times would be between 359 and 479 minutes?

c. Suppose a worker spent 400 minutes on the job. What would that worker’s z score be,

and what would it tell the researcher?

(2+2+2)=6

Q5. The Air Transport Association of America publishes figures on the busiest airports in the

United States. The following frequency distribution has been constructed from these figures for a

recent year. Assume these are population data.

Number of Passengers Arriving and Number of (millions) Airports

20–under 30 8

30–under 40  7

40–under 50  1

50–under 60  0
 60–under 70  3

70–under 80  1

a. Calculate the mean of these data.

b. Calculate the mode.

c. Calculate the median.

d. Calculate the variance.

e. Calculate the standard deviation.

(2+2+2+2+2)=10

Q6. Shown here are the U.S. oil refineries with the largest capacity in terms of barrels per day

according to the U.S. Energy Information Administration. Use these as population data and

answer the questions.

Refinery Location  Company  Capacity

Texas City, Texas  BP  4,37,080

Whiting, Indiana  BP  4,05,000

Pascagoula, Mississippi  Chevron  3,30,000

a. What are the values of the mean and the median? Compare the answers and state which

you prefer as a measure of location for these data and why.

b. What are the values of the range and interquartile range? How do they differ?
 c. What are the values of variance and standard deviation for these data?

d. What is the z score for Pascagoula, Mississippi? What is the z score for Texas City,

Texas? Interpret these z scores.

(3+3+2+3)=11

Q7. During the 1990s, businesses were expected to show a lot of interest in Central and Eastern

European countries. As new markets began to open, American businesspeople needed a better

understanding of the market potential there. The following are the per capita GDP figures for

eight of these European countries published by the World Almanac. Note: The per capita GDP

for the U.S. is $46,900.

Country Per Capita GDP (U.S. $)

Albania 6,000
Bulgaria 12900
Croatia 18300
Czech Republic 25900

Hungary 19800
Poland 17300
Romania 12200
Bosnia/Herzegovin 6500
a

a. Compute the mean and standard deviation for Albania, Bulgaria, Croatia, and Czech

Republic.

b. Compute the mean and standard deviation for Hungary, Poland, Romania, and

Bosnia/Herzegovina.

c. Use a coefficient of variation to compare the two standard deviations. Treat the data as

population data.

(2+2+2)=6