1. Calculate the covariance between profits and market capitalization and what does the covariance indicate about...

70.2K

Verified Solution

Question

Basic Math

1. Calculate the covariance between profits and marketcapitalization and what does the covariance indicate about therelationship between profits and market capitalization? (positiveor negative).

2. Calculate the correlation coefficient between profits andmarket capitalization and what does this indicate about therelationship between profits and market capitalization?(strong/weak/non-linear relationship) .

CompanyProfits ($ millions)Market Capitalization ($ millions)
Alliant Techsystems313.201891.90
Amazon.com631.0081458.60
AmerisourceBergen706.6010087.60
Avis Budget Group-29.001175.80
Boeing4018.0055188.80
Cardinal Health959.0014115.20
Cisco Systems6490.0097376.20
Coca-Cola8572.00157130.50
ConocoPhillips12436.0095251.90
Costco Wholesale1462.0036461.20
CVS Caremark3461.0053575.70
Delta Air Lines854.007082.10
Fidelity National Financial369.503461.40
FMC Technologies399.8012520.30
Foot Locker278.003547.60
General Motors9190.0032382.40
Harley-Davidson599.108925.30
HCA Holdings2465.009550.20
Kraft Foods3527.0065917.40
Kroger602.0013819.50
Lockheed Martin2655.0026651.10
Medco Health Solutions1455.7021865.90
Owens Corning276.003417.80
Pitney Bowes617.503681.20
Procter & Gamble11797.00182109.90
Ralph Lauren567.6012522.80
Rockwell Automation697.8010514.80
Rockwell Collins634.008560.50
United Stationers109.001381.60
United Technologies4979.0066606.50
UnitedHealth Group5142.0053469.40

Answer & Explanation Solved by verified expert
3.7 Ratings (666 Votes)
COVARIANCE1 BRING DATA IN TO EXCEL SHEET2 WRITE A FORMULA COVARARRAY1ARRAY2 AND GET THE COVRIANCEBETWEEN TWO    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students