90.2K

Verified Solution

Link Copied!

Table Annual Revenue and Rating for Americas 30 Large Corporations shows are the Americas 30 large corporations, with annual revenue expressed in billions of dollars (source: CNN Money website, January 15, 2010) and ABCD rating index category (source: mock data). The table Annual Revenue and Rating for Americas 30 Large Corporations can be found in the table below.

Table. Annual Revenue and Rating for America's 30 Large Corporations
Corporation	Revenue	ABCD Rating Index
Amerisource Bergen	71	A
Archer Daniels Midland	70	B
AT&T	124	B
Bank of America	113	C
Berkshire Hathaway	108	A
Boeing	61	A
Cardinal Health	91	B
Chevron	263	D
Citigroup	112	C
ConocoPhillips	231	D
Costco Wholesale	72	A
CVS Caremark	87	A
Exxon Mobil	443	D
Ford Motors	146	A
General Electric	149	A
Hewlett-Packard	118	B
Home Depot	71	A
IBM	104	B
Johnson & Johnson	64	B
JPMorgan Chase	101	B
Kroger	76	C
Marathon Oil	74	A
McKesson	102	A
Morgan Stanley	62	A
Procter & Gamble	84	A
Target	65	A
UnitedHealth Group	81	B
Valero Energy	118	B
Verizon	97	B
Walmart	406	D

a. In a table, summarize the Revenue by constructing the following:

(i) a frequency distribution;

(ii) a relative frequency distribution;

(iii) a percent frequency;

(iv) a cumulative frequency distribution;

(v) a cumulative relative frequency distribution.

b. What do these distributions tell you about the annual revenue of the 30 large corporations in America?

c. Make a histogram with frequency on the y-axis and comment on the shape of the distribution.

d. Make a histogram with percent frequency on the y-axis and comment how it differs from histogram in question c.

e. In a table, show the relationship between corporation revenue and ABCD rating index using cross tabulation method.

f. Comment on the relationship between corporation revenue and ABCD rating index based on the table created in question c.

Answer & Explanation Solved by verified expert

See Answer