The scatter chart in the following figure was created using sample data for profits and market capitalizations from a sample of firms in the Fortune 500. Click on the datafile logo to reference the data. DATA file 200000 160000 Market Cap ($ millions) 120000 80000 40000 0 0 4000 8000 12000 16000 Profits ($millions) (a) Discuss what does this scatter chart indicates about the relationship between profits and market capitalization? The scatter chart indicates that there may be a - Select your answer linear relationship between profits and market capitalization. (b) The data used to produce this are contained in the file Fortune 500. Calculate the covariance between profits and market capitalization. If required, round your answer to an integer. If your answer is negative use "minus sign". Discuss what does the covariance indicates about the relationship between profits and market capitalization? This indicates that there is a - Select your answer relationship between profits and market capitalization. (c) Calculate the correlation coefficient between profits and market capitalization. If required, round your answer to four decimal places. If your answer is negative use "minus sign". What does the correlation coefficient indicate about the relationship between profits and market capitalization? This indicates that there is a -Select your answer - between profits and market capitalization. Hint(s) Check A1 PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected Vie Xfx Company A Company B D E F 1 2 Alliant Techsystems Profits ($ millions) Market Capitalization ($ millions) 313.20 1891.90 3 Amazon.com 631.00 81458.60 4 AmerisourceBergen 706.60 10087.60 5 Avis Budget Group -29.00 1175.80 6 Boeing 4018.00 55188.80 7 Cardinal Health 959.00 14115.20 8 Cisco Systems 9 Coca-Cola 10 ConocoPhillips 11 Costco Wholesale 6490.00 97376.20 8572.00 157130.50 12436.00 95251.90 1462.00 36461.20 12 CVS Caremark 3461.00 53575.70 13 Delta Air Lines 854.00 7082.10 14 Fidelity National Financial 369.50 3461.40 15 FMC Technologies 399.80 12520.30 16 Foot Locker 278.00 3547.60 17 General Motors 18 Harley-Davidson 19 HCA Holdings 9190.00 32382.40 599.10 8925.30 2465.00 9550.20 20 Kraft Foods 3527.00 65917.40 21 Kroger 602.00 13819.50 22 Lockheed Martin 2655.00 26651.10 23 Medco Health Solutions 1455.70 21865.90 24 Owens Corning 276.00 3417.80 25 Pitney Bowes 617.50 3681.20 26 Procter & Gamble 11797.00 182109.90 27 Ralph Lauren 567.60 12522.80 28 Rockwell Automation 697.80 10514.80 29 Rockwell Collins 634.00 8560.50 30 United Stationers 109.00 1381.60 31 United Technologies 4979.00 66606.50 32 UnitedHealth Group 5142.00 53469.40 33 34