Question: A B C D E F G H J K L From the data on Pfizer, P&G and GE (worksheet titled data) compute in Excel

A B C D E F G H J K L From the data on Pfizer, P&G and GE (worksheet titled data) compute in Excel the following statistics: 2 3 1. Average returns of the three firms 4 2. Standard deviations of returns ..... 5 3. Covariance between the three returns 6 4. Correlation between the three returns 7 8 Note 1: Use the "sample" statistics (not the "population' . .m.. 9 Note 2: Use "simple" returns (not the "log" returns File PreviewThe data below is hypothetical data and is for assignment purposes. It may be different from the actual stock price data. Month PFE PG GE 1 13.7441 25.8483 23.3923 2 15.2573 27.1296 24.0336 3 154995 26.2177 23.5039 4 13.562 24.3938 22.4581 5 13.7482 26.0828 21.3913 6 14.0312 25.8535 22.3458 7 13.4651 244777 21.1025 8 13.732 25.7313 22.7998 9 13.3674 28.0968 22.5169 10 12,5573 27.5198 21.9434 File Preview 11 12.8253 29.1826 22.2854 12 141241 29.0086 20.9745 13 14.9358 28.7765 23.4447 14 16.5456 30.3982 23.6745 15 17.3587 31.04 25.1686 16 17.3993 30.9233 25.0111 17 18.039 32.7841 25.9374 18 18.0797 33.7225 26.8638 19 18.0797 33.7225 26.3037 20 19.129 32.502 27.5285 21 18.3541 32,7379 27.4702 22 187211 36.3362 29.9358 23 18.8331 38.4158 29.701 24 19.6501 41.0243 31.5206 25 19.2708 39.3644 34.0269 26 21.0301 40.019 36.2717 27 214393 39.0662 35.6809 28 20.9074 40.3763 37.0249 29 20.3288 40.4467 36.7277 30 19.9189 42.0622 39.3427 31 20.6157 43.3785 41.2444 32 18.2735 42,9491 39.3134 33 18.7252 42.7686 39.7316 34 20.7784 46.9191 43.7155 35 21.6782 47.8624 46.4777 33 18.7252 42.7686 39.7316 34 20.7784 46.9191 43.7155 35 21.6782 47.8624 46.4777 36 24.3109 52.5762 49.9605 37 22.9534 52.0323 47.739 38 24.0202 56.1255 49.972 39 24.4734 58.3098 49.6702 40 24.0202 55.7007 48.1623 41 26.9937 61.2664 53.8641 42 27.0349 67.1738 58.5954 43 26.4984 68.8182 63.0841 44 26.7293 74.3627 68.3252 45 25.4063 65.075 60.9568 File Preview 46 26.6673 67.5191 66.5744 47 27.2878 66.7107 63.2121 48 31.4493 74.7429 72.2599 49 32.795 78.2992 72.0761 50 35.4513 77.1297 76.1281 37.1305 83.5264 76.373 52 35.4098 83.0343 84.996 53 41.3787 81.1268 84.0098 54 37.6207 82.7925 82.2224 55 34.9009 89.8872 89.6187 56 34.3669 78.6044 88.493 57 27.3813 75.7573 79.1552 58 25.323 70.4345 79.0076 59 26.9375 88.1321 86.8898 60 32.1875 87.0763 89.7447

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

question 1 Fit a parabola to the data, using model 4 = Bo + Bix + B2 x + E Xo X Y = 9 X s - 2 4 O 1 - 1 - 1 O O N 4 Question 2 : can you help me calculate s and SSE by hand ? and I hope the answers...

need help with this question, i have attached the data below I Question 27 (4 points) An important application of regression in manufacturing is the estimation of cost of production. Based on DATA...

I need to balance a sheet but I'm not able to do so , and tommorow is my submission could you help me with the same ? Q Search the web... fa D Rocket Investment services exercise - template...

I have to calculate free cash flow and had incorrect on prior assignment. The guidance I received from the professor was: FCF = Net cash flow from operations - capital expenditures - cash paid for...

1) General Journal 2) General Ledger 3) Trial Balance, Accounts Payable Schedule, Accounts Receivable Schedule 4)Subsidiary Ledger 5) Worksheet Thank you! Accounting Cycle.xlsx - Excel X File Home...

Function Sumif, Sumifs, Averageif, Averageifs Functions 1. For each product, determine the total number of units and dollar volume sold. 2. Determine the total revenue earned before December 10,...

I need: 1) General Journal 2) General Ledger 3)Trial Balance, Accounts Receivable Schedule, Accounts Payable Schedule 4) Subsidiary Ledger 5) Worksheet Thank you very much for your time! Accounting...

This is an accounting project. Could you please verify and tell me if I'm missing any data entry for the Journal entry and the ledgers? Everything else looks acceptable to me. _._, ______________...

I have created an excel work book for Lockheed Martin. I have completed all sections of this project except for the the projected income statements; Projected Income Statement, Projected Balance...

Imagine that you were assigned the opposite gender at birth, but that your race, ethnicity, religion, and social class background remain the same. Drawing on the understanding of social inequality...

If 200 is added to a positive integer I, the result is a square number. If 276 is added to to the same integer I, another square number is obtained. Find I.

2. (LO 9-1) Which of the following activities results in work-in-process moving to finished goods inventory? a. Authorize production b. Inspect work c. Complete production d. Issue raw material e....

Depreciation by Three Methods; Partial Years Perdue Company purchased equipment on April 1 for $56,550. The equipment was expected to have a useful life of three years, or 7,800 operating hours, and...