Excel - Essay Example

Comments (0) Cite this document
Descriptive statistics involves the analysis of data that helps describe, show and summarize data in a meaningful way that patterns may emerge from the data. With reference to the descriptive statistics, the location and dispersion were taken into considerations in analyzing the…
Download full paperFile format: .doc, available for editing
GRAB THE BEST PAPER94.3% of users find it useful
Read TextPreview

Extract of sample "Excel"

Download file to see previous pages But if the average is considered, then S & P 500 is a better company to invest in.
Mean and median are two types of averages and are the most common. Mean is the average which is realized when you add up all the numbers and then divide by the count of the numbers, in this case after calculating the mean value for each of the firms, we realized the following data outputs, Abbots Laboratories 34.51503, Unilever realized a mean of 37.05433 while S & P500 realized a mean of 1654.891. The median is the middle value in the list of various numbers, to obtain median the numbers are listed in numerical order, after calculations we realized the following data, Abbotts Laboratory a median of 34.75, Unilever realized a median of 38.11 and S&P 500 realized 1649.6. The range on the other hand is the difference between the largest and the smallest values in a group of data, the range of the firms were as follows, Abbotts Laboratory realized a range of 21.14, the Unilever realized a range of 16.57 and finally S&P 500 realized a range of 810.96.
Median =where L is the lower limit of the interval containing the median, N the total number of scores, FW is the frequency or the number of scores within the interval containing the median, and I is the range of the interval.
In finance and accounting, variance is a term used to measure the degree of risk in an investment. It is obtained by calculating the average of the squared deviations from the mean rate of return. The standard deviation is the representation of the risk associated with a given security (stocks, bonds) or the risk of a portfolio of securities and it is obtained by taking the square root of the variance. Table below shows the report on the mean, median, range, variance and Standard deviation based on the weekly returns of each of the three assets.
Statistically these value returns helps investors understand he financial market ...Download file to see next pagesRead More
Cite this document
  • APA
  • MLA
(“Excel Essay Example | Topics and Well Written Essays - 2750 words”, n.d.)
Excel Essay Example | Topics and Well Written Essays - 2750 words. Retrieved from https://studentshare.org/finance-accounting/1686359-excel
(Excel Essay Example | Topics and Well Written Essays - 2750 Words)
Excel Essay Example | Topics and Well Written Essays - 2750 Words. https://studentshare.org/finance-accounting/1686359-excel.
“Excel Essay Example | Topics and Well Written Essays - 2750 Words”, n.d. https://studentshare.org/finance-accounting/1686359-excel.
  • Cited: 0 times
Comments (0)
Click to create a comment or rate a document


Excel Project

...from that, the rest of the companies reported the positive returns in the given time frame. Results One basis of the results computed on the Microsoft Excel sheet along with the graphs, the analysis of 120 trading days’ activity clearly reflects that SAP performed remarkably well earning a gain of around $90,000, whereas Microsoft turned out to be the worst among all five participants reporting a net loss of around $55,000. The other three software designing firms produced mediocre results, presenting net gains $15,000, $9,000 and ?12,000 by oracle, Intuit and Sage respectively. Source Yahoo! Finance was used as the data source from the stock price data was retrieved. The reason for choosing this financial database is...
6 Pages(1500 words)Essay

Positional argument: Green technologies

3 Pages(750 words)Essay

MS Excel

...1. Describe ways in which the use of MS Excel as a tool for interpreting data can be used by a manager of an organization. Microsoft Excel is a toolthat the various members of an organization utilize for various purposes and reasons. Among the most prominent users of Excel are the managers who happen to serve as the decision-makers in the firm. These people gain the most from the numerous tools that the software offers its users. Managers can utilize Excel in several ways and for several scenarios as well. Primarily though, the spreadsheet is most valuable when managers ponder on and engage in the decision making process. Its value lies in the fact that it is a highly...
2 Pages(500 words)Essay

Excel Project

...grains & cereals showed an increase in 2005, its sales performance decreased in 2006. Graphic Recommendation It is recommended that the company shall focus on the top 5 performing product categories. A more focused and less diverse product portfolio would make the company more efficient and effective. The top 5 performing categories are the sales generating and revenue drivers of the company. The other products that do not perform are becoming more of a liability than an asset to the company. SELF ASSESSMENT From completing the Excel project, I learned the advantage of organizing the data before doing any analysis. Organizing the data makes it easier to read. Applying formats would make it even more appealing to the...
3 Pages(750 words)Essay

Exercise for windows excel

...Assignment Project management can be defined as the process of knowledge, skills and techniques necessary in order to finish projects effectively and efficiently. It is considered a strategic competency for any organization, by connecting project results with business goals and enabling it to better compete in the market in which it functions. The most important part of this process is the planning, which includes the steps necessary to fulfill the task. This process has as primary step the initiation phase, in which the scope of the project and the resources necessary are clearly defined. Next, the planning phase must include the sources of funding the project and how these will be distributed. The third phase is the execution... Project...
3 Pages(750 words)Essay

In excel:

...My Business and Number of Answer Report For any business to realize an increase in profits at the end of a given duration, quite a number of factors can be varied. Two parameters were chosen for this business model and that is: sales and cost of sales while maintaining all the other factors constant, e.g. those relating to customers. To do this, a spreadsheet named “Profit Analyzer” was created that projects the expected profits depending on how these two chosen parameters are expected to vary quarterly i.e. their percentage rate of increase or decrease (Ken Kaufaman, 2010). When a percentage rate of change is entered under the “Variations” column for either of the two parameters, say 105% if sales are projected to increase... Business and...
2 Pages(500 words)Essay

The Piazza of San Marco

6 Pages(1500 words)Essay

Excel Assignment

...ASSIGNMENT, BUSINESS EXCEL ASSIGNMENT By OWNERS OF SIMPLY AIRLINE, 4TH DECEMBER 2014 Dear Owner of Simply Airline, RE: THE PROGRESS I HAVE MADE IN IMPROVING THIS AIRLINE OVER THE PAST 8 QUARTERS I hereby wish to reiterate the progress that i have been able to make in the efforts ad input that I have done to make the operations of the Simply Airline improve. While in the process of ensuring the operations are effective, I managed to raise the salespersons from 1 to 2 in the first and second quarters and even raise the wage to $18000 for each employee. This was a good move as it motivated them to work harder, loyally and even be determined on operations of the business. In this context therefore...
2 Pages(500 words)Assignment


...INFS 3100 EXCEL ASSIGNMENT DUE: Wednesday, February 11 (beginning After 12:50 pm the assignment is considered a day late. See syllabus for late policy. Helpful Hint: Don’t forget to “Lock Cells” (Use absolute cell references) as needed when doing calculations for this assignment. Instructions: (use formulas or functions unless otherwise noted) 1. Download and open the template found on D2L. (Filename: 3100 Excel Assignment 1 Outline Spring 2015) 2. Set the value of the January “Beg. Of Month Inventory” equal to the “Initial Inventory” Cell. 3. Set the value of January “Production” equal to the “Initial Production” Cell. 4. Set the value of January “Units Sold” equal to the “Initial Units Sold” Cell. 5. Management predicts... “Not...
1 Pages(250 words)Assignment

Finance excel

...Retirement Plan Grade May 12th My Retirement Plan I believe I will retire when I am no longer in a healthy condition to serve society to the fullest. I believe that retirement should occur when I reach around sixty-years old. After considering the information in the Actuarial life cycle, I believe may live up to eighty years old (Cassidy, 2006). As such, as I plan for my living expenses during retirement, I will need to save enough money for twenty years, without work while maintaining the standard of living I had grew accustomed. Since I started work early, I will start to save when I am twenty years. The real rate of return is 7%, the years of retirement are twenty, and living expenses need are $36,000. The savings needed... Plan Grade May ...
1 Pages(250 words)Assignment
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.

Let us find you another Essay on topic Excel for FREE!

Contact Us