Assignment:
Statistics & Research
-Management
01
Submitted by:Ashutosh Singh (Division-B)
Roll No. 331204
CONTENT
1. Collect the data (at least 50 observations) on closing
daily stock market prices of any company.
2. Present the data values you have collected in an
appropriate manner.
3. Based on these data, obtain the values of -i) Arithmetic Mean,
ii) Median,
iii) Mode,
Verify and comment on whether the relationship among
the above three measures of central tendency holds good
for your data set.
iv) 6 th decile,
v) 90th percentile,
vi) Range,
vii) Inter quartile range,
viii) Quartile deviation,
ix) Coefficient of quartile deviation,
x) Standard Deviation.
4. Prepare a frequency distribution table with appropriate
class intervals.
5. Draw a Histogram, a frequency polygon, and ogive
curves using the frequency distribution table. Verify some
of the values obtained in Item 2 above, with what you
have obtained from the histogram and the ogives.
Comment on the basis of each graph.
6. Find less than and more than cumulative frequencies.
7. Find the relative frequencies and construct a relative
frequency polygon
8. Which concepts of Statistics you have used to solve
this assignment.
1)
The data of stock market price (50 days, from
20 July to 25 September) of Asian Paint
Company:Date
25 Sep,
2015
24 Sep,
2015
23 Sep,
2015
22 Sep,
2015
21 Sep,
2015
18 Sep,
2015
17 Sep,
2015
16 Sep,
2015
15 Sep,
2015
14 Sep,
2015
11 Sep,
2015
10 Sep,
2015
Ope
High
n
Clos
e
806.0 806.0 806.0 806.0
5
5
5
5
806.0
795
814
786
5
786.2 794.0
798
804
5
5
830 839.5
830.5 834.6
800
803
Volu
Adj
me Close*
0
116,80
0
223,50
0
108,30
0
806.05
806.05
794.05
803
825 829.6
62,100
829.6
837.0
5
94,900
837.05
824.7 824.7 824.7 824.7
824.7
77,600
824.7
86,900
829.45
101,80
0
838.95
91,100
814.5
825 847.9
825
820.2
824.7
5
848.2 824.1 829.4
843
5
5
5
819.0 838.9
820.8
841
5
5
824.6
814.9
810.8 814.5
5
801.2 807.7
818
818
5
5
836
9 Sep, 2015
800
8 Sep, 2015
791
7 Sep, 2015
Low
840
822 796.6
818
778.7 791.1
5
5
819.9 784.2
816
789.5
5
5
800
105,60
0
116,20
0
124,70
0
129,40
0
807.75
818
791.15
789.5
4 Sep, 2015 826.6
3 Sep, 2015
2 Sep, 2015
1 Sep, 2015
827 792.4 812.5
832.2
826.1
806.9
5
5
799.3 806.2
825 830.9
5
5
817.2
847
847
803
5
862.7 845.1
856.5
848.6
5
5
850.3
856.1 874.2
856.3
5
851.2 854.8
870
871
5
5
852.1
868 848.1 848.1
5
812.7 851.8
840 864.4
5
5
812
31 Aug,
2015
28 Aug,
2015
27 Aug,
2015
26 Aug,
2015
25 Aug,
2015
24 Aug,
869
877 826.1 838.8
2015
21 Aug, 879.4
886.5
891
865
2015
5
5
20 Aug,
883.4
905
914
880
2015
5
19 Aug,
902.2 882.2 899.2
900
2015
5
5
5
18 Aug,
892.6 901.2
903
915
2015
5
5
17 Aug,
900.0
896 907.9
895
2015
5
14 Aug,
895.4
880 899.5
880
2015
5
13 Aug,
886.9
875
862.5 874.1
2015
5
12 Aug,
893.4 867.1
885
871
2015
5
5
11 Aug, 902.1
904.9 881.7 885.3
2015
5
135,10
0
105,60
0
134,40
0
301,10
0
812.5
826.15
806.25
817.25
55,500
848.6
109,90
0
856.3
73,900
854.85
112,70
0
176,40
0
153,40
0
851.85
88,600
886.55
113,90
0
883.45
80,000
899.25
74,000
901.25
61,800
900.05
74,600
895.45
141,60
0
874.1
73,900
871
66,600
885.3
848.1
838.8
10 Aug,
916.7
900.9
907.9
896.4
2015
5
5
924.4 896.3 899.6
7 Aug, 2015
916
5
5
5
914.4
6 Aug, 2015
920
924
910
5
924.6 886.0
5 Aug, 2015
905
921.4
5
5
904.7
4 Aug, 2015 882.2 907.8 879.1
5
887.4 875.1 877.0
3 Aug, 2015
884
5
5
5
857.5
881.4
31 Jul, 2015
884.8 855.2
5
5
847.5 857.2
30 Jul, 2015 851.7 865.5
5
5
826.6 846.5
29 Jul, 2015 836.5
851
5
5
858.2
835.0
28 Jul, 2015
853
826
5
5
836.4 851.2
27 Jul, 2015 849.5 858.9
5
5
847.2
24 Jul, 2015 846.5
855 844.1
5
851.4 836.3 846.0
23 Jul, 2015
846
5
5
5
816.6 843.1
22 Jul, 2015
817
845
5
5
816.6
21 Jul, 2015
852
869
812
5
20 Jul, 2015 827.1
856 827.1 851.9
72,900
900.95
100,60
0
899.65
87,700
914.45
174,20
0
235,50
0
78,000
903,40
0
127,90
0
98,000
104,10
0
110,40
0
112,30
0
109,60
0
217,20
0
682,70
0
185,30
0
921.4
904.75
877.05
881.45
857.25
846.55
835.05
851.25
847.25
846.05
843.15
816.65
851.9
2) The data of daily closing stock of 50 days (25
September to 20 July) of Asian paint from above
data.
806. 837. 814. 812. 856. 886. 895. 899. 881.
1
1
5
5
3
6
5
7
5
806. 824. 807. 826. 854. 883. 874. 914. 857.
1
7
8
2
9
5
1
5
3
794. 824.
806. 848. 899.
921. 846.
1
7
818
3
1
3 871
4
6
829. 791. 817. 851. 901. 885. 904. 835.
803
5
2
3
9
3
3
8
1
829.
789. 848. 838. 900.
877. 851.
6 839
5
6
8
1 901
1
3
3. Based on these data, obtain the values of -Arithmetic Mean:-
847.
3
846.
1
843.
2
816.
7
851.
9
=849.327
On excel: - =average(number1,number2)
Median:=846.9
On excel: - =median(number1,number2.)
Mode:=806.05
On excel: - =mode(number1,number2..)
Comment:There is slight difference the average and median which shows there is no
more fluctuation in share price of company and can take easily decision for
investment.
Decile:-
Formula=(matrix *6th decline/10)
=50*6/10 =30
Percentile:Pth percentile of a group of observation is that observation below
which lie p% observations.
90th percentile of the 50 days closing stock price
=900.14
On excel: - =percentile(array,k)
percentile in decimal
K = value of
Range:= maximum value minimum value
=131.5
On excel:For maximum value: - =max(number1,number2)
For minimum value: - =min(number1,number2)
Quartile:Certain percentile have greater importance than others because
they break down the distribution of data into four parts. These the
quartiles. The first Quartile Q1 is 25th percentile. It is the point
where lie 1/4th of the data. Second Quartile Q2 is 50th percentile.
This is the same as the median and on this point lie below half the
data. The third Quartile Q3 is 75th percentile and on this point lie
below the 75 per cent of the data.
Q1 (25th percentile) =819.675
Q2 (50th percentile) =846.5
Q3 (75th percentile) =880.35
Inter Quartile data:This is the difference between the first and the third quartile. It is
the measure of spread of the data.
=Q3 Q1
=60.675
Quartile deviation:-
This is the average of the difference between the third Quartile
and first Quartile.
= Q3-Q1/2
=30.3375
Coefficient of quartile deviation:Relative measure of quartile deviation is called the coefficient of
Quartile deviation.
=Q3-Q1/Q3+Q1
=.035691
Standard deviation:=35.43805188
On excel= =STDV.P(NUMBER1,NIMBER2)
4) Data frequency
distribution:For data frequency distribution firstly we have to find class interval.
For appropriate class interval
Formula = Range/square root of N
Range= maxium value minimum value (max
=921.4 ,min = 789.5
=131.9
N=matrix = column * rows
=10*5
=50
Square root of N = 7.071
On Excel = =SQRT(number)
So we will take the value of N = 8
Class internal = Range / square root of N
=131.9/8
=16.4875
So we take the class interval = 17
After the class interval then find the bin array which
means upper limit of the class interval and the find the
frequency distribution.
Class interval
Bin array (upper lim.)
Frequency
789.5-806.5
806.5
806.5-823.5
23.5
823.5-840.5
840.5
840.5-857.5
857.5
12
857.5-874.5
874.5
874.5-891.5
891.5
891.5-908.5
908.5
908.5-925.5
925.5
Total
50
On Excel= =FREQUENCY(data array, bin array)
Justification:The calculation of frequency is correct because the
total of frequency is equal to matrix. (Total of
frequency = matrix)
5) Graphs
Histogram:Histogram
12
9
7
5
2
Frequency Polygon:-
Frequency polygon
4
7
3
12
9
7
5
2
6) Less than and more than cumulative frequencies
cumulativ
e
Frequenc
y
Class
interval
Bin
array
(upper
lim.)
Frequen
cy
Less More
than than
Relative
Frequenc
y
P%
Relative
F(x)
789.5806.5
806.5
50
0.14
14
806.5823.5
823.5
13
43
0.12
12
823.5840.5
840.5
22
37
0.18
18
840.5857.5
857.5
12
34
28
0.24
24
857.5874.5
874.5
36
16
0.04
874.5891.5
891.5
41
14
0.1
10
891.5908.5
908.5
48
0.14
14
908.5925.5
925.5
50
0.04
100
Total
50
Justification:The calculation of relative frequency is correct because the
addition is one (1).
7) Relative Frequency polygon:Relative Frequency polygon
8
7
6
5
4
3
2
1
0.14
0.12
0.18
0.24
0.04
0.1
0.14
0.04
Less than and more than ogives:-
Less and more than ogives
50
48
43
37
50
41
34
36
28
22
16
13
7
1
4
Less than
14
6
9
7
More than
Justification:From the histogram we get mode and from the ogive curve we
find out the median of the data the value is find out above is
same. And from the graph we can easily understand.
