Fortune provides a list of America's largest corporations based on annual revenue. Shown below are the 50 largest corporations, with annual revenue expressed in billions of dollars (CNN Money website, January 15, 2010). The data set is available in file named LargeCorp.xlsx in chapter 2.   Use Excel to summarize the data by constructing the following: a. A frequency distribution (classes 0 - 49, 50 - 99, 100 - 149, and so on). b. A percent frequency distribution. c. A cumulative percent frequency distribution. d. A histogram. Upload the excel worksheet that contains the tables and graph.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Fortune provides a list of America's largest corporations based on annual revenue. Shown below are the 50 largest corporations, with annual revenue expressed in billions of dollars (CNN Money website, January 15, 2010). The data set is available in file named LargeCorp.xlsx in chapter 2.

 

Use Excel to summarize the data by constructing the following:

a. A frequency distribution (classes 0 - 49, 50 - 99, 100 - 149, and so on).

b. A percent frequency distribution.

c. A cumulative percent frequency distribution.

d. A histogram.

Upload the excel worksheet that contains the tables and graph.

 
 
 
 

 

LargeCorp.xlsx in chapter 2.
Corporation
Amerisource Bergen
Archer Daniels Midland
AT&T
Bank of America
Berkshire Hathaway
Boeing
Cardinal Health
Caterpillar
Chevron
Citigroup
ConocoPhillips
Costco Wholesale
CVS Caremark
Dell
Dow Chemical
Exxon Mobil
Ford Motors
General Electric
Goldman Sachs
Revenue
71
70
124
113
108
61
91
51
263
112
231
72
87
61
58
443
146
149
54
118
71
104
101
64
76
Corporation
Lowe's
Marathon Oil
McKesson
Medco Health
MetLife
Microsoft
Morgan Stanley
Pepsico
Pfizer
Procter & Gamble
Safeway
Sears Holdings
State Farm Insurance
Sunoco
Target
Time Warner
United Parcel Service
United Technologies
UnitedHealth Group
Hewlett-Packard
Home Depot
IBM
J.P. Morgan Chase
Johnson & Johnson
Kroger
Answer the next two questions.
Valero Energy
Verizon
Walgreen
Wal-Mart Stores
WellPoint
Wells Fargo
Revenue
48
74
102
51
55
60
62
43
48
844447
61
52
65
47
51
59
81
118
97
59
406
61
52
Transcribed Image Text:LargeCorp.xlsx in chapter 2. Corporation Amerisource Bergen Archer Daniels Midland AT&T Bank of America Berkshire Hathaway Boeing Cardinal Health Caterpillar Chevron Citigroup ConocoPhillips Costco Wholesale CVS Caremark Dell Dow Chemical Exxon Mobil Ford Motors General Electric Goldman Sachs Revenue 71 70 124 113 108 61 91 51 263 112 231 72 87 61 58 443 146 149 54 118 71 104 101 64 76 Corporation Lowe's Marathon Oil McKesson Medco Health MetLife Microsoft Morgan Stanley Pepsico Pfizer Procter & Gamble Safeway Sears Holdings State Farm Insurance Sunoco Target Time Warner United Parcel Service United Technologies UnitedHealth Group Hewlett-Packard Home Depot IBM J.P. Morgan Chase Johnson & Johnson Kroger Answer the next two questions. Valero Energy Verizon Walgreen Wal-Mart Stores WellPoint Wells Fargo Revenue 48 74 102 51 55 60 62 43 48 844447 61 52 65 47 51 59 81 118 97 59 406 61 52
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman