0% found this document useful (0 votes)
19 views13 pages

Statistics Programs

The document presents a statistical analysis of class marks, detailing frequency distributions, cumulative frequencies, and various statistical measures such as mean, median, mode, and standard deviation. It includes calculations for percentiles, quartiles, and correlation coefficients, providing insights into the data's distribution and relationships. Additionally, it features regression analysis and graphical representations of the data.

Uploaded by

tanjim09826
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
19 views13 pages

Statistics Programs

The document presents a statistical analysis of class marks, detailing frequency distributions, cumulative frequencies, and various statistical measures such as mean, median, mode, and standard deviation. It includes calculations for percentiles, quartiles, and correlation coefficients, providing insights into the data's distribution and relationships. Additionally, it features regression analysis and graphical representations of the data.

Uploaded by

tanjim09826
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Class Marks

Frequency (f)
(x)

55.5 6
59.5 9
63.5 11
67.5 16
71.5 8

18 60
16
16
50
14

Cumulative frequency
12 11 40

10
Frequency

9
8 30
8
6
6 20

4
10
2

0 0
55.5 59.5 63.5 67.5 71.5
Class mark

Original Class Frequency (f)


53.5-57.5 6
57.5-61.5 9
61.5-65.5 11 N = 50
65.5-69.5 16
69.5-73.5 8

16
16

14

12 11

10 9
Frequency

8
8
6
6

4
65.5-6
2 32%
12 11

10 9

Frequency
8
8
6
6

4
65.5-6
2 32%

0
Class boundary

53.5-57.5 57.5-61.5 61.5-65.5 65.5-69.5 69.5-73.5


Class Upper
CF (F)
Boundary

57.5 6
61.5 15
65.5 26
69.5 42
73.5 50

60

50
50
42
Cumulative frequency

40

30 26

20
15

10 6

0
57.5 61.5 65.5 69.5 73.5
Class upper boundary

Original Frequency
Angle (θ)
Class (f) Percentage
53.5-57.5 6 12.00% 43.2
57.5-61.5 9 18.00% 64.8
61.5-65.5 11 22.00% 79.2
65.5-69.5 16 32.00% 115.2
69.5-73.5 8 16.00% 57.6

53.5-57.5
12%
69.5-73.5
16%
57.5-61.5
18%

65.5-69.5
32%
16%
57.5-61.5
18%

65.5-69.5
32%
61.5-65.5
22%
Cumulative
Class Interval Class Boundary Class Mark Frequency
Frequency
(Class) (Original Class) (Mid Value) (x) (f)
(F)
54-57 53.5-57.5 55.5 6 6
58-61 57.5-61.5 59.5 9 15
62-65 61.5-65.5 63.5 11 26
66-69 65.5-69.5 67.5 16 42
70-73 69.5-73.5 71.5 8 50

SUM 50

AM (Direct) = 64.38
a = 63.5, h = 4 AM (Code) = 64.38

L = 65.5
del1 = 5 Mode (Mo) = 67.0384615
del2 = 8
C=4

3*50/4 = 37.5
L = 65.5 Quartile (Q3) = 68.375
F_(q - 1) = 26
f_q = 16
C=4
f*x u = (x - 63.5)/4 f*u log(x) f*log(x) f/x

333 -2 -12 1.744293 10.465757899 0.10810810810811


535.5 -1 -9 1.774517 15.970652692 0.15126050420168
698.5 0 0 1.802774 19.830510978 0.17322834645669
1080 1 16 1.829304 29.268860365 0.23703703703704
572 2 16 1.854306 14.834448334 0.11188811188811

3219 11 90.370230268 0.78152210769163

GM = 64.1807230328
HM = 63.9777166991

50/2 = 25
L = 61.5
F_(m - 1) = 15 Median(Me) = 65.13636
f_m = 11
C=4

2*50/10 = 10 95*50/100 = 47.5


L = 57.5 L = 69.5
F_(d - 1) = 6 Decile (D2) = 59.27778 F_(p - 1) = 42 Percentile (P95) = 72.25
f_d = 9 f_p = 8
C=4 C=4
Original Class Class Marks (x) Frequency (f) f*ABS(x - AM) f*ABS(x - Mode)
53.5-57.5 55.5 6 53.28 69.24
57.5-61.5 59.5 9 43.92 67.8600000000001
61.5-65.5 63.5 11 9.68 38.9400000000001
65.5-69.5 67.5 16 49.92 7.3599999999999
69.5-73.5 71.5 8 56.96 35.68

Sum 50 213.76 219.08

Arithmatic mean = 64.38


Mode = 67.04
Median = 65.14
MD (AM) = 4.2752
MD (Mode) = 4.3816
MD (Median) = 4.3056
Co-efficient of MD (AM) = 6.64%
Co-efficient of MD (Mode) = 6.54%
Co-efficient of MD (Median) = 6.61%

SD (Direct) = 5.0145388621488
SD (Code) = 5.0145388621487

a = 63.5, h = 4

Co-efficient of SD = 7.79%
f*ABS(x - Median) f*x f*x^2 u = (x - 63.5)/4 f*u f*u^2 z = (x - AM)/SD
57.84 333 18481.5 -2 -12 24 -1.77086449297
50.76 535.5 31862.25 -1 -9 9 -0.973177784425
18.04 698.5 44354.75 0 0 0 -0.17549107588
37.76 1080 72900 1 16 16 0.6221956326653
50.88 572 40898 2 16 32 1.4198823412105

215.28 3219 208496.5 11 81


Class Mark (x) Frequency (f) u = (x - 65.5)/4 f*u f*u^2 f*u^3
55.5 6 -2.5 -15 37.5 -93.75
59.5 9 -1.5 -13.5 20.25 -30.375
A = 65.5 63.5 11 -0.5 -5.5 2.75 -1.375
h=4 67.5 16 0.5 8 4 2
71.5 8 1.5 12 18 27

SUM 50 -14 82.5 -96.5

m1 = -1.12
m2 = 26.4
m3 = -123.52
m4 = 1649.28

M1 = 0
M2 = 25.1456
M3 = -37.625856
M4 = 1289.88680192

negatively
gamma_3 = -0.29839626641 <0
skewed
gamma_4 = 2.0399879096 <3 platykurtic

corrected M2 = 23.81226666667
corrected M4 = 1096.188668587
f*u^4
234.375
45.5625
0.6875
1
40.5

322.125
Weight Height
X Y X^2 Y^2 X*Y U = (X - 70)/10 V = (Y - 65)/5
75 69 5625 4761 5175 0.5 0.8
70 67 4900 4489 4690 0 0.4
80 63 6400 3969 5040 1 -0.4
74 68 5476 4624 5032 0.4 0.6
60 65 3600 4225 3900 -1 0
N = 12 60 63 3600 3969 3780 -1 -0.4
49 63 2401 3969 3087 -2.1 -0.4
64 65 4096 4225 4160 -0.6 0
75 65 5625 4225 4875 0.5 0
80 70 6400 4900 5600 1 1
69 65 4761 4225 4485 -0.1 0
60 65 3600 4225 3900 -1 0
a = 70, h = 10 b = 65, k = 5
SUM 816 788 56484 51806 53724 -2.4 1.6

𝑟= 0.569539
𝑏_(𝑦⁄𝑥)=0.140562
Positively Correlated (Strong)

𝑏_(𝑥⁄𝑦)=2.307692
Direct Y is less depending on X
X is more depending on Y

𝑟= 0.569539
𝑏_(𝑦⁄𝑥)=0.140562 Regression line of Y on X
𝑏_(𝑥⁄𝑦)=2.307692
Code
67.5
67

𝑥 ̅=
66.5
𝑦 ̅=
68
66
65.66667
65.5
65
Regression line of y on x 68 70 72 74 76 78 80 82

y = 0.14(X - 68) + 65.67


Regression line of X on Y
y = 0.14 X + 56.15
66
64
Regression line of x on y
62
60
x = 2.31(Y - 65.67) + 68
58
x = 2.31 Y - 83.70 56
54 56 58 60 62 64 66 68
U^2 V^2 U*V Serial X-rank Y-rank
0.25 0.64 0.4 1 1 4
0 0.16 0 2 5 3
1 0.16 -0.4 3 2 9
0.16 0.36 0.24 4 8 6
1 0 0 5 7 5
1 0.16 0.4 6 3 1
4.41 0.16 0.84 7 9 10
0.36 0 0 8 4 2
0.25 0 0 9 10 7
1 1 1 10 6 8
0.01 0 0
1 0 0 SUM N = 10

10.44 2.64 2.48


Rank Correlation Coefficient =

Comment: Positively Correlated (Mod

X y = 0.14 X + 56.15
Y on X
70 65.95
80 67.35

76 66.79

6 78 80 82

x = 2.31 Y - 83.70 Y
on Y
54.9 60
66.45 65

59.52 62

64 66 68
d=X-Y d^2
-3 9
2 4
-7 49
2 4
2 4
2 4
-1 1
2 4
3 9
-2 4

92

relation Coefficient = 0.442424

: Positively Correlated (Moderate)

You might also like