Use the data in the file named Stock.xlsx to construct histograms for monthly returns for GE and
Question:
Use the data in the file named Stock.xlsx to construct histograms for monthly returns for GE and Intel.
Transcribed Image Text:
A 49 50 51 Date B Microsoft GE min max Intel D E F -0.240320429 -0.202509 0.276619107 0.338983 CSCO 0.037267081 0.047404062 -0.003891051 -0.053892214 0.083515622 0.221518993 0.005444646 0.034296028 -0.13438046 -0.113387093 -0.04587156 0.052884616 GM 52 30-Mar-90 0.121518984 0.040485829 53 30-Apr-90 54 31-May-90 0.115819208 0.042105 0.258620679 55 29-Jun-90 0.04109589 56 31-Jul-90 -0.125 -0.025906736 -0.020565553 0.070707 -0.25 -0.05319149 -0.020997375 -0.037736 -0.131367296 -0.029412 -0.003745318 -0.088050313 -0.090909 0.007518797 0.013793103 0.311111 0.119402982 0.013605442 0.338983 57 31-Aug-90 -0.075187966 58 28-Sep-90 0.024390243 59 31-Oct-90 0.011904762 60 30-Nov-90 0.13333334 61 31-Dec-90 0.041522492 62 31-Jan-91 0.303986698 63 28-Feb-91 0.057324842 64 28-Mar-91 0.022891566 0.026666667 -0.05821918 0.136076 0.057260275 0.115468413 0.188311681 0.054545455 0.303621 0.070468754 0.043715846 0.100689657 -0.042735 0.023897059 -0.020942409 -0.044303797 -0.129464 0.016157989 0.053475935 -0.052980132 0.220513 0.131979689 0.217482507 0.084034 67 28-Jun-91 -0.068906605 -0.042071197 -0.165919289 -0.055072464 -0.054264 65 30-Apr-91 -0.067137808 66 31-May-91 0.108585857 0.09908127 68 31-Jul-91 69 30-Aug-91 0.078899086 -0.010135135 0.010752688 -0.024539877 0.286885 0.159863949 0.022184301 0.053191491 -0.033962265 0.156051 0.043988269 -0.066644408 -0.146464646 -0.016447369 -0.096419 -0.005405406 -0.03846154 -0.060200669 0.189024 70 30-Sep-91 71 31-Oct-91 0.054775283 0.022284122 0.010753 -0.035422344 0.010638
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 50% (6 reviews)
Answered By
Keziah Thiga
I am a self motivated financial professional knowledgeable in; preparation of financial reports, reconciling and managing accounts, maintaining cash flows, budgets, among other financial reports. I possess strong analytical skills with high attention to detail and accuracy. I am able to act quickly and effectively when dealing with challenging situations. I have the ability to form positive relationships with colleagues and I believe that team work is great key to performance. I always deliver quality, detailed, original (0% plagirism), well-researched and critically analyzed papers.
4.90+
1504+ Reviews
2897+ 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 beta of a stock is found by running a regression with the monthly return on a market index as the explanatory variable and the monthly return on the stock as the dependent variable. The beta of...
-
In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. (If you use a computer to complete these exercises, use a copy of the...
-
Use the data in the data file named Student GPA, which is described in the Chapter 11 appendix, to develop a model to predict a student's grade point average in economics. Begin with the variables...
-
The Depression Anxiety Stress Scales (DASS) is a tool to measure the depression, anxiety and stress levels of individuals. For measuring the stress level, the DASS score ranges from 0 to 42 and a...
-
TRUE-FALSE QUESTIONS 1. There is one set of control activities that all organizations should implement. 2. Control activities include both preventive and detective controls. 3. An organizations...
-
Target Corporation prepares its financial statements according to U.S. GAAP. Target's financial statements and disclosure notes for the year ended January 30, 2016, are available in Connect. This...
-
Consider the IRR and ERR measures of worth. If we define a root to mean a value for the measure that results in \(\mathrm{PW}=0\), then which of the following statements is true? a. Both IRR and ERR...
-
Assigning Accounts Receivable On April 1, 2010, Prince Company assigns $500,000 of its accounts receivable to the Third National Bank as collateral for a $300,000 loan due July 1, 2010. The...
-
What is immediate, up-to-date information? What is Real-time systems Information governance?
-
Which method of representing quantities involves discrete steps?
-
The file named Problem12data.xlsx contains in a single cell a states name and population. Use Excel formulas to extract the population to a new column. If a new row is added, then your formulas...
-
Set up conditional formatting that colors the cell range A1:H8 like a checkerboard, with alternating white and black coloring. The =ROW() function gives the row number of a cell, and the =COLUMN()...
-
The accompanying SAS computer output relates to the 1990 Census data from Problem 14 in Chapter 8. Use this output and, if necessary, the output from Problem 13 in Chapter 9 to answer the following...
-
Several individuals form Lang Corporation on May 1, 2019. The corporation begins acquiring assets on June 1, 2019, and begins business on August 1, 2019. What is the latest date that Lang can file...
-
Alpha Corporation began business at the beginning of the year. On February 15, George sold his stock to Danny. Alpha files for S corporation status on March 10, but George refuses to consent to the...
-
Damion Corporation begins its first tax year on June 23, 2019. What is the latest date that Damion may apply for S corporation status to qualify as of the beginning of operations?
-
Acme Corporation, a calendar year S corporation, has $100,000 of Accumulated Earnings and Profits. Larry, the sole shareholder, has adjusted basis of $80,000 in stock basis with a $20,000 in...
-
John owns stock in an S corporation. Johns share of the corporations loss for the year is $5,000. His adjusted basis in the corporation stock is $1,000. In addition, John has a loan outstanding to...
-
The current liabilities of WestJet Airlines include the advance ticket sales account. The companys recent annual reports show the following trend in the balance of this account over a three- year...
-
1A. If the researcher is concerned about the number of variables, the nature of the analysis, and completion rates, then, he/she is at which stage of the sampling design process (Figure 11.1 in the...
-
Do you agree with the following statement? Explain your answer. Total estimated overhead costs will vary depending on whether we use the plantwide method, department method, or activity- based...
-
A colleague states, We produce one product, and our operations are relatively simple. Activity-based costing and activity-based management would be a waste of time for our company! Do you agree with...
-
The company president makes the following statement: Product costs are straightforward. Whatever costs are incurred to produce a product are assigned to that product. Do you agree with this...
-
What is the Project Deliverables/Outcomes of food festival? Give an explanation of the outcomes of your festival - What to expect from the festival? Describe and outline the main food festival...
-
Identify and analyze the social and cultural factors prevailing in the business environment affecting Swatch Group in the home country of Switzerland. (National culture). Include: o The GLOBE...
-
What is a research-supported overview of innovative technology to support clinical documentation of preexisting conditions and the impact on post-surgical care quality issues? (i.e. artificial...
Study smarter with the SolutionInn App