Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show me how to do in excel! thank you! i will like its not missing infotmstion. the data is right next to it. Company

please show me how to do in excel! thank you! i will like
image text in transcribed
its not missing infotmstion. the data is right next to it.
Company Profits (s millions) Profit/MktCap Ratios Use the Fortune 500 data. Create a heat map of Profit/(Market Capitalization) Ratios. Profit/Market Capitalization) Ratios Alliant Techsystems Amazon.com AmerisourceBergen Avis Budget Group Boeing Cardinal Health Cisco Systems Coca-Cola ConocoPhillips Costco Wholesale CVS Caremark Delta Air Lines Fidelity National Financial FMC Technologies Foot Locker General Motors Harley Davidson HCA Holdings Kraft Foods Kroger Lockheed Martin Medce Health Solutions Owens Coming Pitney Bowes Procter & Gamble Ralph Lauren Rockwell Automation Rockwell Collins United Stationers United Technologies United Health Group 313.20 631.00 706.60 -29.00 4018.00 959.00 6490,00 8572.00 12436.00 1462.00 3461.00 854.00 369.50 399.80 278.00 9190.00 599.10 2465.00 3527.00 602.00 2655.00 1455,70 276,00 617.50 11797.00 567.60 697.80 634.0) 109.00 4979.00 5142.00 Market Capitalization (s millions) 1891.90 81458.60 10087.60 1175.80 55188.80 14115.20 97376.20 157130.50 95251.90 36461.20 53575,70 7082.10 3461.40 12520.30 3547.60 32382.40 8925.30 9550.20 65917,40 13819,50 26651.10 21865.90 3417.80 3681.20 182109.90 12522.80 10514.80 8560.50 1381.60 66606,50 53469.40

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

IT And European Bank Performance

Authors: E. Beccalli

1st Edition

0230006949, 9780230006942

More Books

Students also viewed these Accounting questions

Question

=+d. Purchaser: buys the item.

Answered: 1 week ago