Excel Essay Example | Topics and Well Written Essays - 2750 words

Excel - Essay Example 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