Use the data in the file named Stock.xlsx to generate descriptive statistics for Intel and GE stock.
Question:
Use the data in the file named Stock.xlsx to generate descriptive statistics for Intel and GE stock.
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)
The image provided displays an Excel spreadsheet containing stock data for several companies including Intel column D and GE column C However I am una...View the full answer
Answered By
Michael Mulupi
I am honest,hardworking, and determined writer
4.70+
72+ Reviews
157+ 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
-
Use your answer to Problem 1 to compare the monthly returns on Intel and GE stock. Data from in Problem 1 Use the data in the file named Stock.xlsx to generate descriptive statistics for Intel and GE...
-
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 owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure...
-
In the late 1980s, various states and the US Congress debated placing limits on sulfur emissions to reduce the impact of acid rain. Utilities that generated electricity using coal-powered plants felt...
-
Refer to Exhibit. For each control activities principle, provide an example of how that principle might be applied in an organization.
-
Eastern Manufacturing is involved with several situations that possibly involve contingencies. Each is described below. Eastern's fiscal year ends December 31, and the 2018 financial statements are...
-
Consider the following cash flow profile and assume MARR is 10 percent/year and the finance rate is 4 percent/year. a. Determine the MIRR for this project. b. Is this project economically attractive?...
-
Paul Sabin organized Sabin Electronics 10 years ago to produce and sell several electronic devices on which he had secured patents. Although the company has been fairly profitable, it is now...
-
Shelby Woods owns and operates an ice cream factory, the finest of its kind in all the world. Given that pints of ice cream are meant to be identical (for the same flavor), her company uses process...
-
Mordica Company identifies three activities in its manufacturing process: machine setups, machining, and inspections. Estimated annual overhead cost for each activity is $150,000, $325,000, and...
-
The website https://en.wikipedia.org/wiki/List_of_largest_companies_in_the_United_States_by_revenue contains data on the 500 largest US companies. Create a web query that includes the company name,...
-
The website https://www.loc.gov/rr/print/list/057_chron.html contains information about each US president. Create a web query that places each presidents start year and end year in a separate column...
-
A block of mass m is suspended from two springs having a stiffness of k 1 and k 2 , arranged a) Parallel to each other, and b) As a series. Determine the equivalent stiffness of a single spring with...
-
Does your company have opportunities to use incentive compensation techniques? If so, explain your companys approach to incentive compensation. Is there any hard evidence you can cite that indicates...
-
Prepare a trend-adjusted exponential smoothing forecast.
-
Freedom Electronics is a start-up with about 20 sales representatives. The company has a solid product line but knows that to remain competitive it must continue recognizing opportunities for new...
-
Compute and use regression and correlation coefficients.
-
Compute and use seasonal relatives.
-
Capaz Company completed its statement of earnings and statement of financial position for 2015 and provided the following information: In addition, Capaz bought a small service machine for $ 5,000....
-
Cable Corporation is 60% owned by Anna and 40% owned by Jim, who are unrelated. It has noncash assets, which it sells to an unrelated purchaser for $100,000 in cash and $900,000 in installment...
-
Congressman Patrick indicates that he is opposed to tax proposals that call for a flat tax rate because the structure would not tax those individuals who have the ability to pay the tax. Discuss the...
-
The governor of your state stated in a recent political speech that he has never supported any income tax increases as the tax rates have remained at the same level during his entire term of office....
-
Carmen has computed that her average tax rate is 16% and her marginal tax rate is 25% for the current year. She is considering whether to make a charitable contribution to her church before the end...
-
In the "Eating to Win" podcast, Louise Burke talks about the rise of Gatorade and Muscle Milk. Explain what her instance is on the utility of each of these products for the average individual. What...
-
Asking questions such as are there waste materials associated with the manufacturing of this product and how will this product be disposed of when it is no longer useful helps yo determine whether or...
-
(a) [10 marks] Qualitative Asset Transformation means: I. II. Having total assets of greater value than total liabilities Having non risky assets III. Having liquid liabilities IV. Having assets with...
Study smarter with the SolutionInn App