BUS - 352 Chapter 2 Homework Assignment

1. Consider the following frequency distribution.

Class Frequency
10 - 19 10
20 - 29 13
30 - 39 17
40 - 49 6
50 - 59 4
Construct a cumulative frequency distribution and a cumulative relative frequency distribution. Round your
answers to two decimal places, if necessary.

Class Cumulative Frequency Cumulative Relative Frequency

Less than or equal to 19 10 0.20
Less than or equal to 29 23 0.46
Less than or equal to 39 40 0.80
Less than or equal to 49 46 0.92
Less than or equal to 59 50 1.00

2. A researcher is gathering data from four geographical areas designated: South = 1; North = 2; East =
3; West = 4.

The designated geographical regions represent _____.

a. categorical data
b. quantitative data
c. directional data
d. continuous data

3. Each year Forbes ranks the world's most valuable brands. A portion of the data for of the brands in
the Forbes list is shown in the table below (Forbes website). The data set includes the following
variables:

Brand: The name of the brand.

Industry: The type of industry associated with the brand, labeled Automotive &
Luxury, Consumer Packaged Goods, Financial Services, Other,
Technology.

Brand Value ($ billions): A measure of the brand's value in billions of dollars developed by Forbes
based on a variety of financial information about the brand.

1-Yr Value Change (): The percentage change in the value of the brand over the previous year.

Brand Revenue ($ billions): The total revenue in billions of dollars for the brand.
 Brand Value 1-Yr Value Brand Revenue
Brand Industry ($ billions) Change (%) ($ billions)
Accenture Other 9.7 10 30.4
Adidas Other 8.4 23 14.5
Allianz Financial Services 6.9 5 130.8
[Link] Technology 14.7 44 60.6
American Express Financial Services 18 5 33.8
Audi Automotive & Luxury 10.9 1 55.2
AXA Financial Services 5.6 10 149.3
Bank of America Financial Services 7.7 -9 83.3
Boeing Other 6.4 12 81.7
Burberry Automotive & Luxury 5.5 13 3
Canon Technology 8.7 -11 41.8
Caterpillar Other 8.5 21 65.9
Chanel Automotive & Luxury 7 13 4.4
Chase Financial Services 6.3 -9 56.8
Coach Automotive & Luxury 10.5 1 5.1
Colgate Consumer Packaged Goods 7.9 7 3.9
Credit Suisse Financial Services 5.7 -9 42
Danone Consumer Packaged Goods 11.1 13 13.3
Dell Technology 6.4 -23 56.9
Ebay Technology 8.5 14 6.3
Ericsson Technology 5.9 -35 34.6
ESPN Other 12.9 12 10.4
Estee Lauder Consumer Packaged Goods 5.4 15 4.4
Facebook Technology 13.7 4 5.1
FedEx Other 5.8 10 44.3
Ford Automotive & Luxury 10.6 34 130
Fox Other 10.2 20 11.7
Frito-Lay Consumer Packaged Goods 11.6 6 11.1
General Electric Other 34.2 2 132.1
Gillette Consumer Packaged Goods 18.3 9 8
Goldman Sachs Financial Services 6.8 -15 41.7
Google Technology 47.3 26 43.5
Gucci Automotive & Luxury 12.1 1 4.7
H&M Other 16.1 12 18.3
Heineken Other 7 7 6
Heinz Consumer Packaged Goods 5.6 2 4.4
Hermès Automotive & Luxury 9.3 20 4.5
Hewlett-Packard Technology 15.3 -16 119.9
Home Depot Other 10.1 12 74.8
HSBC Financial Services 15.2 0 104.9
Hyundai Automotive & Luxury 6.5 21 49.7
IBM Technology 50.7 5 104.5
IKEA Other 11.5 5 35.5
ING Financial Services 5.7 8 118.7
Intel Technology 30.9 -4 53.3
J.P. Morgan Financial Services 9.1 -30 43.1
John Deere Other 6.4 14 36.2
Kellogg's Consumer Packaged Goods 8.7 -6 7.1
Kraft Consumer Packaged Goods 9.1 -10 7.1
Lancome Consumer Packaged Goods 6.2 13 4
Lexus Automotive & Luxury 7 1 18.7
L'Oréal Consumer Packaged Goods 16.9 16 10.6
Louis Vuitton Automotive & Luxury 28.4 16 9.4
Marlboro Other 16.6 9 23.6
Mastercard Financial Services 7.4 8 7.4
McDonald's Other 39.4 5 88.3
Microsoft Technology 56.7 4 77.8
MTV Other 5.6 -7 3.1
Nestle Consumer Packaged Goods 11.8 18 11.3
NIKE Other 18.2 14 23.7
Nintendo Technology 8 -39 7.6
Nissan Automotive & Luxury 6.9 17 108.5
Nokia Technology 7 -55 38.8
Pampers Consumer Packaged Goods 9.6 12 10.4
Philips Other 7.1 14 31.9
Porsche Automotive & Luxury 5.7 16 17.8
Prada Automotive & Luxury 7.1 23 3.4
Ralph Lauren Other 6.4 28 6.4
Rolex Automotive & Luxury 7.4 14 4.5
Santander Financial Services 6 -2 57.3
SAP Technology 19.6 28 20.3
Siemens Other 13.7 1 100.6
Sony Technology 6.6 -20 69.5
Starbucks Other 6.9 9 13
Subway Other 5.7 17 18.1
Thomson Reuters Other 9.6 -10 7.2
UPS Other 10.2 13 54.1
Verizon Other 19.3 0 115.8
Visa Financial Services 14.2 12 10.4
Volkswagen Automotive & Luxury 8.1 16 145.7
Wells Fargo Financial Services 9 -14 91.2
Zara Other 9.4 11 13.5

a. Prepare a crosstabulation of the data on Industry (rows) and Brand Value ($ billions). Use classes of 0
– 9.9, 10 – 19.9, 20 – 29.9, 30 – 39.9, 40 – 49.9, and 50 – 59.9 for Brand Value ($ billions). If an
amount box does not require an entry, leave it blank or enter "0".
 Industry 0 – 9.9 10 – 19.9 20 – 29.9 30 – 39.9 40 – 49.9 50 – 59.9 Total
Automotive & Luxury 10 4 1 0 0 0 15
Consumer Packaged Goods 7 5 0 0 0 0 12
Financial Services 11 3 0 0 0 0 14
Other 14 10 0 2 0 0 26
Technology 7 4 0 1 0 2 15
Total 49 26 1 3 1 2 82

b. Prepare a frequency distribution for the data on Industry.

Industry Frequency
Automotive & Luxury 15
Consumer Packaged Goods 12
Financial Services 14
Other 26
Technology 15
Total 82

c. Prepare a frequency distribution for the data on Brand Value ($ billions).

Brand Value ($ Frequency

billions)
0 – 9.9 49
10 – 19.9 26
20 – 29.9 1
30 – 39.9 3
40 – 49.9 1
50 – 59.9 2
Total 82

d. How has crosstabulation helped in preparing the frequency distributions in parts (b) and (c)?

The right margin shows the frequency distribution for the fund type variable and the bottom margin shows
the frequency distribution for the brand value.

e. What conclusions can you draw about the type of industry and the brand value?

Higher brand values are associated with the technology brands.

4. The sum of the relative frequencies for all classes will always equal _____.
a. the number of classes
b. 100
c. 1
d. the sample size

5. The following observations are for two quantitative variables, x and y.

Observation x y
1 22 69
2 10 88
3 53 45
 4 71 21
5 41 63
6 90 29
7 44 41
8 26 99
9 57 40
10 61 49
11 23 89
12 73 21
13 61 35
14 29 86
15 73 26
16 34 49
17 37 61
18 69 69
19 41 28
20 45 20

x: 10 – 29: 5 = (22, 10, 26, 23, 29)

30 – 49: 6 = (41, 44, 34, 37,41,45)
50 – 69: 5 = (53, 57, 61, 61, 69)
70 – 90: 4 = (70, 90, 73, 73)
y: 20 – 39: 7 = (21, 29, 21, 35, 26, 28,20)
40 – 59: 5 = (45, 41, 40, 49, 49)
60 – 79: 4 = (69, 63, 61, 69)
80 – 100: 4 = (88, 99, 89, 86)
If your answer is "zero", enter "0".
a. Develop a crosstabulation for the data, with x as the row variable and y as the column variable.
For x use classes of 10 – 29, 30 – 49, 50 – 69, and 70 – 90; for y use classes of 20 – 39, 40 – 59, 60 –
79, and 80 – 100.

y
20 – 39 40 – 59 60 – 79 80 – 100 Grand Total
10 – 29 0 0 1 4 5
x 30 – 49 2 2 2 0 6
50 – 69 1 3 1 0 5
70 – 90 4 0 0 0 4
Grand Total 7 5 4 4 20

b. Compute the row percentages (to 1 decimal).

y
20 – 39 40 – 59 60 – 79 80 – 100 Grand Total
10 – 29 0.0% 0% 20.0% 80.0% 100.0%
x 30 – 49 33.3% 33.3% 33.3% 0% 100.0%
 50 – 69 20.0% 60.0% 20.0% 0% 100.0%
70 – 90 100.0 0% 0.0% 0% 100.0%
%

c. Compute the column percentages (to 1 decimal).

y
20 – 39 40 – 59 60 – 79 80 – 100
10 – 29 0.0% 0.0% 25% 100%
x 30 – 49 28.6% 40% 50% 0.0%
50 – 69 14.3% 60% 25% 0.0%
70 – 90 57.1% 0.0% 0% 0.0%
Grand Total 100.0% 100.0% 100.0% 100.0%

d. What is the relationship, if any, between x and y?

Higher values of x are associated with lower values of y.
Higher values of y are associated with lower values of x.

6. A doctor's office staff studied the waiting times for patients who arrive at the office with a request for
emergency service. The following data with waiting times in minutes were collected over a one-month
period.
5, 8, 10, 14, 2, 3, 4, 16, 12, 7, 9, 7, 17, 24, 6, 8, 6, 14, 17, 3
a. Fill in the frequency values below.

Waiting Time Frequency

0–4 4
5–9 8
10 – 14 4
15 – 19 3
20 – 24 1
Total 20

b. Fill in the relative frequency values below (2 decimals).

Waiting Time Relative Frequency
0–4 0.20
5–9 0.40
10 – 14 0.20
15 – 19 0.15
20 – 24 0.05
Total 1.00
 c. Fill in the cumulative frequency values below.
Waiting Time Cumulative Frequency
Less than or equal to 4 4
Less than or equal to 9 12
Less than or equal to 14 16
Less than or equal to 19 19
Less than or equal to 24 20

d. Fill in the cumulative relative frequency values below (2 decimals).

Waiting Time Cumulative Relative Frequency
Less than or equal to 4 0.20
Less than or equal to 9 0.60
Less than or equal to 14 0.80
Less than or equal to 19 0.95
Less than or equal to 24 1.00

e. What proportion of patients needing emergency service wait 9 minutes or less? 0.60

7. The following crosstabulation summarizes the data for two categorical variables, x and y. The
variable x can take on values Low, Medium, or High and the variable y can take on values Yes or No.

y
Yes No Total
Low 32 7 39
x Medium 7 33 40
High 15 34 49
Total 54 74 128

a. Compute the row percentages (to 2 decimals).

y
Yes No Total
Low 82.05% 17.95% 100%
x Medium 17.50% 82.50% 100%
High 30.61% 69.39% 100%

b. Choose a correct stacked percent frequency bar chart with x on the horizontal axis.
Table B
8. In a recent report, the top five most-visited English-language websites were [Link] (GOOG),
[Link] (FB), [Link] (YT), [Link] (YAH), and [Link] (WIKI). The most-
visited websites for a sample of 50 Internet users are shown in the following table:
Most Visited Websites
YAH WIKI YT WIKI GOOG
YT YAH GOOG GOOG GOOG
WIKI GOOG YAH YAH YAH
YAH YT GOOG YT YAH
GOOG FB FB WIKI GOOG
GOOG GOOG FB FB WIKI
FB YAH YT YAH YAH
YT GOOG YAH FB FB
WIKI GOOG YAH WIKI WIKI
YAH YT GOOG GOOG WIKI

a. Are these data categorical or quantitative?

categorical
b. Provide frequency and percent frequency distributions. Round your percent frequency answers to the
nearest percent.

Website Frequency Percent Frequency

FB 7 14%
GOOG 14 28%
WIKI 9 18%
YAH 13 26%
YT 7 14%
Total 50 100%

c. On the basis of the sample, which website is the most frequently visited website for Internet users?
GOOG
Which is second?
YAH
9. A partial relative frequency distribution is given.
a. What is the relative frequency of class D (to 2 decimals)?

Class Relative Frequency

A 0.20
B 0.66
C 0.05
D 0.09

b. The total sample size is 100. What is the frequency of class D (to whole number)? 9
 c. Show the frequency distribution (to whole number).

Class Frequency
A 20
B 66
C 5
D 9
Total 100

d. Show the percent frequency distribution (to whole number).

Class Percent Frequency

A 20%
B 66%
C 5%
D 9%
Total 100%

10. The response to a question has three alternatives: A, B, and C. A sample of 120 responses provides 66 A, 33
B, and 24 C. Show the frequency and relative frequency distributions (use 2 decimals for the relative
frequency column).

Class Frequency Relative Frequency

A 66 0.55
B 30 0.25
C 24 0.20
Total 120 1.00