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

Excel - Essay ExampleBut if the modal(a) is considered, then S & P 500 is a better company to invest in.Mean and median value are two types of averages and are the most common. Mean is the average which is realized when you add up exclusively the numbers and then divide by the count of the numbers, in this case after calculating the dream up 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 grow 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 string 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 guess 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 chemical group 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