– Business – Economics – Engineering – Management – Mathematics – Science – Statistics How it works?

– Business – Economics – Engineering – Management – Mathematics – Science – Statistics How it works?

   – Business   – Economics   – Engineering   – Management   – Mathematics   – Science   – StatisticsHow it works?Q&AData AnalyticsContact UsHomework Help
·         Description
·         Reviews (0)
1.     Refer to data file Marketcap. Use MS Excel for data analysis. This file gives you the data for profits and market capitalizations from a sample of firms
a.      Prepare a scatter chart to display the relationship between the variables Profit (X-axis) and Market Capitalization (on Y-axis). Comment on the relationship between the variables.
b.     Add a trendline on the above chart. What does the trendline indicate? 
Company
Profits ($ millions)
Market Capitalization ($ millions)
Alliant Techsystems
313.2
1891.9
Amazon.com
631
81458.6
AmerisourceBergen
706.6
10087.6
Avis Budget Group
-29
1175.8
Boeing
4,018.00
55188.8
Cardinal Health
959
14115.2
Cisco Systems
6,490.00
97376.2
Coca-Cola
8,572.00
157131
ConocoPhillips
12,436.00
95251.9
Costco Wholesale
1,462.00
36461.2
CVS Caremark
3,461.00
53575.7
Delta Air Lines
854
7082.1
Fidelity National Financial
369.5
3461.4
FMC Technologies
399.8
12520.3
Foot Locker
278
3547.6
General Motors
9,190.00
32382.4
Harley-Davidson
599.1
8925.3
HCA Holdings
2,465.00
9550.2
Kraft Foods
3,527.00
65917.4
Kroger
602
13819.5
Lockheed Martin
2,655.00
26651.1
Medco Health Solutions
1,455.70
21865.9
Owens Corning
276
3417.8
Pitney Bowes
617.5
3681.2
Procter & Gamble
11,797.00
182110
Ralph Lauren
567.6
12522.8
Rockwell Automation
697.8
10514.8
Rockwell Collins
634
8560.5
United Stationers
109
1381.6
United Technologies
4,979.00
66606.5
UnitedHealth Group
5,142.00
53469.4