Britannia Share Values
Autor: Adnan • February 13, 2018 • 520 Words (3 Pages) • 650 Views
...
MEASURES OF CENTRAL TENDENCY:
CENTRAL TENDENCY
OPEN
HIGH
LOW
CLOSE
VOLUME
MEAN:
2937.353
2977.471
2906.923
2944.84
207437
MEDIAN:
2846
2871.075
2811.575
2845.65
149994
MODE:
2850
3370
3340
#N/A
#N/A
COMMENTS:
For the above data set of stock values of Britannia we can see that:
- The average value of the stock (opening, high, low and close) is 2941.16 INR.
- The median value of the stock (opening, high, low and close) is around 2800 INR.
- The mode value gives the most frequent share price of the stock. From observation, it is clear that the closing price of Britannia does not have a frequent price unlike the opening, high and low prices of the stock.
Relationship between mean, median and mode:
MODE= 3 MEDIAN – 2 MEAN
On using this formula Mode obtained is as follows:
OPEN
HIGH
LOW
CLOSE
VOLUME
2663.293
2658.283
2620.88
2647.27
35108.03
COMMENTS:
We can see that the relationship between mean, median and mode for opening, high, low, closing and volume values of Britannia Ltd does not hold true for the above data set.
90th PERCENTILE FOR CLOSING VALUES: 3406.65
=PERCENTILE(F2:F61,0.6), using this function in excel the value is obtained.
6th DECILE FOR CLOSING VALUES: 2866.22
=PERCENTILE(F2:F61,0.6), using this function in excel the value is obtained.
DESCRIPTIVE STATISTICS FOR CLOSING VALUES OF BRITANNIA INDUSTRIES LTD.
DESCRIPTIVE STATISTICS FOR CLOSING VALUES
Mean
2944.84
Standard Error
35.36124518
Median
2845.65
Mode
#N/A
Standard Deviation
273.9070274
Sample Variance
75025.05964
Kurtosis
-0.850800913
Skewness
0.770464953
Range
899.45
Minimum
2564.85
Maximum
3464.3
Sum
176690.4
Count
60
Q1: 2746.413
=QUARTILE(A2:A61,1) using this function in excel the value is obtained.
Q3: 3094.85
=QUARTILE(A2:A61,3) using this function in excel the value is obtained.
Inter quartile range: 348.4375
=Q3-Q1
Quartile deviation: 1547.425
=(Q3-Q1)/2
Coefficient of quartile deviation: 0.059651
=(Q3-Q1)/(Q3-Q2)
Standard Deviation: 273.9070274
Descriptive Statistics Function in excel.
Frequency Distribution Table
CLASS
UPPER LIMITS
Frequency
Less than Cumulative Frequency
More than Cumulative Frequency
Relative Frequency
Frequency Percentage
2500-2600
2500
0
0
60
0
0
2600-2700
2600
4
4
56
0.0666667
...