Using the Dow.xlsx data, determine the three stocks with the highest skew. 1 2 3 4 5
Question:
Using the Dow.xlsx data, determine the three stocks with the highest skew.
Transcribed Image Text:
1 2 3 4 5 69 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 A Date AA B AIG C AXP D BA E C F G 0 CAT DD H DIS | GE J GM K 7/1/86 8/1/86 0.096296 0.050093 0.098028 0.029596 0.096273 0.117634 0.083816 -0.05684 0.076986 0.056958 9/2/86 0 -0.12898 -0.1409 -0.12319 -0.07513 -0.24058 -0.02732 -0.13434 -0.08586 -0.05903 10/1/86 -0.01676 -0.00811 0.04238 -0.00937 0.073511 0.052798 0.07339 0.110886 0.060943 0.049742 11/3/86 -0.0481 -0.5092 -0.01921 -0.03555 -0.03139 -0.00627 0.039186 -0.01709 0.088525 0.024606 12/1/86 -0.02166 0.018833 -0.00937 0.002549 -0.00884 0.012617 -0.06009 0 0.036145 -0.09428 1/2/87 0.173259 0.112383 0.200917 -0.01721 0.129339 0.083977 0.165119 0.309993 0.165698 0.140152 2/2/87 0.031447 0.106618 0.088305 0.079602 0.084211 0.054713 0.021764 0.050973 0.031122 -0.00837 3/2/87 0.039756 -0.03654 0.010088 -0.04369 -0.53029 0.051656 0.1187 0.050522 0.014511 0.046904 4/1/87 0.117288 -0.08621 -0.08402 -0.14225 -0.10852 -0.00249 -0.00107 0.029978 -0.01306 0.152074 5/1/87 0.002519 -0.02838 -0.50462 0.016854 -0.07257 0.077914 0.008949 -0.00389 -0.49758 -0.05278 6/1/87 0.117906 0.100979 0.020096 0.036022 0.04075 0.031226 0.064302 0.128906 0.045769 -0.03085 7/1/87 0.192019 -0.01228 0.076923 0.130546 0.098967 0.212523 0.040583 -0.0018 0.089555 0.075648 8/3/87 -0.14349 0.158857 0.006533 -0.00472 0.016393 -0.04609 -0.00601 0.109262 0.054852 0.03522 9/1/87 0.130826 -0.01541 -0.0238 -0.03545 -0.03226 0.187783 -0.04028 -0.03125 -0.016 -0.09783 10/1/87 -0.30229 -0.14549 -0.32402 -0.24076 -0.35844 -0.32313 -0.24236 -0.2871 -0.22959 -0.29518 11/2/87 0.023256 -0.17582 -0.07279 -0.11002 -0.11673 0.140704 -0.1344 -0.05195 -0.10553 -0.03624 0.0625 0.066667 0.031117 0.076207 -0.05412 0.092511 0.118408 0.131157 0.041293 0.088684 1/4/88 -0.12299 0.05 0.157064 0.236486 0.160862 -0.06048 -0.05288 -0.0189 0.02266 0.071196 2/1/88 0.140244 -0.08127 -0.00948 0.038251 0.111429 0.11588 0.045317 0.055909 0.008199 0.098859 3/1/88 -0.06952 -0.07343 -0.06284 -0.02105 -0.04402 -0.04031 -0.06509 -0.03666 -0.11253 -0.01218 4/4/88 0.008736 -0.02797 -0.00766 0.032258 -0.16807 0.005931 0.060344 -0.02757 5/2/88 0.048314 0.088625 0.052124 0.145833 -0.01535 -0.01195 -0.03067 0.008696 0.040119 0.0016 6/1/88 0.157609 0.026432 0.089297 0.068182 0.118178 0.092742 0.1173 0.086207 0.044762 0.06656 7/1/88 -0.00695 0.04721 0.029759 0.029787 -0.09651 -0.08118 -0.06461 0.002063 -0.02575 8/1/88 -0.04028 0.008197 0.017993 -0.02479 0.177904 -0.10635 -0.08196 -0.00792 -0.05544 9/1/88 0.039409 0.075122 -0.02196 0.08678 0.033615 0.025078 0.035766 0.074294 12/1/87 0 0.050862 0 -0.09049 0.02923
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 33% (3 reviews)
Answered By
Vineet Kumar Yadav
I am a biotech engineer and cleared jee exam 2 times and also i am a math tutor. topper comunity , chegg India, vedantu doubt expert( solving doubt for iit jee student on the online doubt solving app in live chat with student)
5.00+
2+ Reviews
10+ Question Solved
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted:
Students also viewed these Business questions
-
The file S03_64.xlsx lists monthly data since 1950 on the well-known Dow Jones Industrial Average (DJIA), as well as the less well-known Dow Jones Transportation Average (DJTA) and Dow Jones...
-
The Dow Jones Industrial Average (DJIA) underwent one of its infrequent reshufflings of companies when General Motors and Citigroup were replaced by Cisco Systems and Travelers (The Wall Street...
-
Using only the sunspot numbers, identify the highest number and convert it to a z score. In the context of these sample data, is that highest value "significantly high"? Why or why not? Listed below...
-
Here are the supply and demand equations for throstles, where p is the price in dollars: D (p) = 40 p S (p) = 10+p. On the axes below, draw the demand and supply curves for throstles, using blue...
-
In February 2012, the Wall Street Journal reported that Diamond Foods Inc. fired its CEO and CFO, and would restate financial results for two years. The restatement was required after the company...
-
Position vectors along the robotic arm from O to B and B to A arc r 0B = (100i +300j + 400k} mm and n BA = {350i + 225j - 640k) mm, respectively. Determine the distance from O to the grip at A. N...
-
What information should you attempt to obtain from the client during an initial interview? Why is this information important?
-
Read the case XYZ Company: An Integrated Capital Budgeting Instructional Case and answer the following question: Should the replacement asset be purchased? That is, does it make economic (financial)...
-
The liabilities of the Smith Company are $120,000 and its owner's equity is $232,000. What is the amount of the company's total assets? The total assets of the Jones Company are $190,000 and its...
-
Which series has the highest beta. BraveNewCoin Liquid Index for Bitcoin 1D BNC Trading Brave Ne Yellow Green Blue Orange
-
Use the data in the file named Makeupdb.xlsx to create a data table that shows the average per-unit revenue generated by each person for sales in which the average per-unit price exceeded $3.30. G H...
-
Using the Dow.xlsx data, determine the three stocks with the most risk or variability.
-
Assume that when you are 25 years old you plan to aggressively save for your retirement by contributing $5,000 a year to a tax-sheltered account. A relative of yours tells you to forget about earning...
-
What is the difference between P-time and M-time cultures?
-
Fixed assets purchased from general fund revenue were received. What account, if any, should have been debited in the general fund? a. None b. Fixed Assets c. Expenditures d. Fund BalanceUnassigned
-
What are the six main cultural dimensions analyzed in the Hofstede framework?
-
Clarice became very ill in February of 2017 and was unable to work the rest of the year. She had only $12,000 of income from her sole proprietorship for the time she worked and was forced to sell the...
-
A Budgetary Fund BalanceAssigned for Encumbrances in excess of a balance of Encumbrances Control indicates a. An excess of vouchers payable over encumbrances. b. An excess of purchase orders over...
-
A town wants to build a new bridge. Construction firms will submit sealed bids. The town will award the contract to the firm that submits the lowest bid and will pay the firm the amount of the second...
-
The Dow Jones Industrial Average reached a high of $ 7801.63 on December 29, 1997. Recall from Example 18.4 that it reached a high of $ 1003 on November 14, 1972. The Consumer Price Index for...
-
Match each of the following accounts with the appropriate description that follows. _____ Raw materials inventory _____ Work-in-process inventory _____ Finished goods inventory _____ Cost of goods...
-
Match each of the following terms used in a manufacturing companys income statement with the equivalent term used in a merchandising companys income statement. _____ Cost of goods manufactured _____...
-
The following list of personnel within organizations comes from Figure 1.1. 1. Board of directors 2. Chief financial officer 3. Controller 4. Managerial accountant 5. Financial accountant 6. Tax...
-
Describe how one of the competencies listed below and describe how learning in this course helped you to meet the competency. Provide at least two specific examples.
-
Section Three Quality Control: Drawing upon industry best quality control practices provide answer for the following questions: How would you ensure that the project's deliverables and outcomes were...
-
What would be a great housekeeping training plan to implement when it comes to combating long turnover times in the operating room? (Short and long-term) How can the housekeeping team work together...
Study smarter with the SolutionInn App