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% (8 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.
-
Using terminology introduced in chapter 7, describe ruminant microbes according to their nutritional, temperature, pH, and oxygen adaptations.
-
Describe the conceptual differences between the bonus and goodwill methods. AppendixLO1
-
Spearman Domestic Equity Fund sells two types of share, A+ and B+. A+ shares are sold with frontend load fee of 6% whilst Type B+ shares are not subject front-end load fee but are charged to...
-
Subject : Auditing Topic : MIA BY LAWS /LEGAL LIABILITY/GOVERNANCE QUESTION 3 Pakatan Maju Sdn. Bhd is a retail company planning to list on a stock exchange within the next six months, and management...
-
9. Write the static method hidePicture that takes two pictures (source and secret) and hides the secret in source using the algorithm previously discussed, returning the new picture. Add code to main...
-
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...
-
Cyclopentamine is an amphetamine-like central nervous system stimulant. Propose a synthesis of Cyclopentamine from materials of five carbons orless. CH3 -CH2CHNHCH3 Cyclopentamine
-
Listed below are the lead concentrations (in ug/g) measured in different Ayurveda medicines. Ayurveda is a traditional medical system commonly used in India. The lead concentrations listed here are...
-
The assignment states to use a movie and talk about 2 scenes where physics ideas are used. The rubric is shown and 6 big ideas that can be talked about are also attached. Background Information...
-
A series of computer and backup system failures caused the loss of most of the company records at Stotter, Incorporated. Information technology consultants for the company could recover only a few...
-
Future value of an annuity Using the values below, answer the questions that follow. (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Deposit period...
-
Mercury, Incorporated, produces cell phones at its plant in Texas. In recent years, the company's market share has been eroded by stiff competition from overseas. Price and product quality are the...
-
Green, Howitt, and Russo (2005) estimate the supply and demand curves for California processing tomatoes. The supply function is ln Q = 0.2 + 0.55 ln p, where Q is the quantity of processing tomatoes...
-
Wholesalers Ltd. deals in the sale of foodstuffs to retailers. Owing to economic depression, the firm intends to relax its credit policy to boost productivity and sales. The firms current credit...
-
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...
-
explain in excel please For a particular product the price per unit is $6. Calculate Revenue if sales in current period is 200 units. Conduct a data analysis, on revenue by changing the number of...
-
Hall Company sells merchandise with a one-year warranty. In the current year, sales consist of 35,000 units. It is estimated that warranty repairs will average $10 per unit sold and 30% of the...
-
Q 4- Crane Corporation, an amusement park, is considering a capital investment in a new exhibit. The exhibit would cost $ 167,270 and have an estimated useful life of 7 years. It can be sold for $...
Study smarter with the SolutionInn App