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...
-
Almaden Hardware Store sells two product categories, tools and paint products. Information pertaining to its 2018 year-end inventory is as follows: Required: 1. Determine the carrying value of...
-
In 2010, in an attempt to increase the number of Americans covered by health insurance and reduce the cost of health care, Congress passed the Patient Protection and Affordable Care Act. A key...
-
On November 1,2017, the following were the account balances of Soho Equipment Repair. During November, the following summary transactions were completed. Nov. 8 Paid $1,220 for salaries due...
-
Treating the porphyrin as a two dimensional square box with length L in each direction, write the expression for the energies of an electron in the box. B) (10 pts) Comment on the degeneracy of...
-
Marcella, who is from Toledo, Ohio, drives to Troy, Michigan, and shops at a popular mall. When leaving the parking lot, Marcella causes a car accident when she runs a stop sign. 1. What is the name...
-
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.
-
Factor the given expressions by grouping as illustrated in Example 10. 2y y 2 6y 4 + 12y 3 Data from Example 10 Factor: 2x 2y + ax ay. We see that there is no common factor to all four terms, but...
-
Based on the facts in this case, is Acuxen most likely a food, drug, or dietary supplement, or all three and why? To answer this question, you must consider both the composition of Acuxen and the...
-
A patient presents a pharmacist with a prescription for a drug product that can be used to induce abortion. The pharmacist is opposed to abortion and refuses to fill the prescription. What is the...
-
A manufacturer learns postmarket that its drug is increasingly being linked to an adverse effect not apparent during the IND process. Explain the process required if the manufacturer decides it wants...
-
Some economists think the high rates of growth of productivity achieved by many Asian economies cannot be sustained. Why might they be right? What would have to happen for them to be wrong?
-
A pharmacist received a prescription from a dentist for an antibiotic written to take tid for a urinary infection. Explain if it would violate the law to dispense this prescription and the procedure...
-
Matching Players in the Accounting Communication Process with Their Definitions Match each player with the related definition by entering the appropriate letter in the space provided. Players _____...
-
What are the main distinctions between the different schools of legal interpretation?
-
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...
-
A. Firms often pay managers a percent of profits to encourage them to work longer hours for the company. Managers are often conflicted by the desire for extra income and the reduction of leisure time...
-
What does "ethical" conversation mean for the school district including the virtual community (i.e. Facebook, Twitter, Instagram, Texting, etc...). Try to base some of your ideas on at least one...
-
Acme and Tartine are identical bakeries and are the only suppliers of baguettes in San Francisco. They have agreed to form a cartel: they jointly sell Q=16 baguettes and charge P=9 . Each bakery...
Study smarter with the SolutionInn App