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.
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
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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fadd942ee-f79e-4a36-9f00-66fe52871351%2Ffa76cc77-a0ac-4e36-8984-3d8b56e62e67%2F2rm5tx_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
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](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman