Britannia Share Values

...

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

...