Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    Automatic Statistical Computation

    Uploaded by

    Ryan San Luis
    1. The document contains statistical data including scores, frequencies, cumulative frequencies, class midpoints, and computations to determine the mean, median, mode, variance, and standard deviation. 2. Key values calculated include a mean of 32.33, variance of 122.3446, and standard deviation of 11.06095. 3. The data is used to analyze a distribution with scores ranging from 10 to 59 in increments of 10, with a total of 60 data points.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Automatic Statistical Computation

    Uploaded by

    Ryan San Luis
    14 views14 pages
    1. The document contains statistical data including scores, frequencies, cumulative frequencies, class midpoints, and computations to determine the mean, median, mode, variance, and standard deviation. 2. Key values calculated include a mean of 32.33, variance of 122.3446, and standard deviation of 11.06095. 3. The data is used to analyze a distribution with scores ranging from 10 to 59 in increments of 10, with a total of 60 data points.

    Original Title

    automatic statistical computation.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. The document contains statistical data including scores, frequencies, cumulative frequencies, class midpoints, and computations to determine the mean, median, mode, variance, and standard deviation. 2. Key values calculated include a mean of 32.33, variance of 122.3446, and standard deviation of 11.06095. 3. The data is used to analyze a distribution with scores ranging from 10 to 59 in increments of 10, with a total of 60 data points.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    14 views14 pages

    Automatic Statistical Computation

    Uploaded by

    Ryan San Luis
    1. The document contains statistical data including scores, frequencies, cumulative frequencies, class midpoints, and computations to determine the mean, median, mode, variance, and standard deviation. 2. Key values calculated include a mean of 32.33, variance of 122.3446, and standard deviation of 11.06095. 3. The data is used to analyze a distribution with scores ranging from 10 to 59 in increments of 10, with a total of 60 data points.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 14

    Scores F CF

    1 5 8 8
    6 10 0 8
    11 15 2 10
    16 20 3 13
    21 25 1 14
    26 30 0 14
    31 35 1 15
    N= 15

    Mean ( X)= 10.67

    F-1= 14
    CM Fm CM - X (m-X)2 F( m-x)2
    3 24 -7.67 58.78 470.22
    8 0 -2.67 7.11 0
    13 26 2.33 5.44 10.89
    18 54 7.33 53.78 161.33
    23 23 12.33 152.11 152.11
    28 0 17.33 300.44 0
    33 33 22.33 498.78 498.78
    160 1293.33

    Variance= 92.38095 Standard Dev. 9.611501


    Scores F
    15 19 1
    20 24 5
    25 29 16
    30 34 28
    35 39 17
    40 44 3

    N= 70

    Mean ( X)=

    F-1= 69
    CF CM Fm CM - X (m-X)2 F( m-x)2
    1 17 17 -14.57 212.33 212.33
    6 22 110 -9.57 91.61 458.0612
    22 27 432 -4.57 20.90 334.37
    50 32 896 0.43 0.18 5.14
    67 37 629 5.43 29.47 500.98
    70 42 126 10.43 108.76 326.2653

    2210 1837.14

    31.57

    Variance= 26.62526 Standard Dev. 5.159967


    COMPUTATION FOR MEAN, MEDIAN, MODE, VARIANCE AND

    Scores F CF CM
    11 20 0 0 15.5
    21 30 4 4 25.5
    31 40 6 10 35.5
    41 50 8 18 45.5
    51 60 10 28 55.5
    61 70 5 33 65.5
    71 80 6 39 75.5
    Lmed= 50.5 81 90 1 40 85.5
    fmed= 10 91 100 0 40 95.5
    fbef= 8 N= 40
    fafter= 5
    class= 10 Mean ( X)= 52.50
    n/2= 20
    cfbef= 18
    F-1= 39

    N= 20

    Median 52.5
    MEDIAN, MODE, VARIANCE AND STANDARD DEVIATION

    Fm CM - X (m-X)2 F( m-x)2
    0 -37.00 1369.00 0.00
    102 -27.00 729.00 2916
    213 -17.00 289.00 1734.00
    364 -7.00 49.00 392.00
    555 3.00 9.00 90.00
    327.5 13.00 169.00 845
    453 23.00 529.00 3174.00
    85.5 33.00 1089.00 1089.00
    0 43.00 1849.00 0.00
    2100 10240.00

    Variance= 262.5641 Standard Dev. 16.20383

    Mode= 53.35714
    COMPUTATION FOR MEAN, MEDIAN, MODE, VARIANCE AND STANDA

    Scores F CF CM Fm
    5 10 2 2 7.5 15
    11 15 3 5 13 39
    16 20 4 9 18 72
    21 25 10 19 23 230
    26 30 5 24 28 140
    31 35 2 26 33 66
    36 40 3 29 38 114
    xlb= 20.5 41 45 0 29 43 0
    fmed= 10 46 50 1 30 48 48
    fbef= 4 N= 30 724
    fafter= 5
    class= 5 Mean ( X)= 24.13
    n/2= 15
    cfbef= 9
    F-1= 29

    N= 15

    Median 23.5
    ODE, VARIANCE AND STANDARD DEVIATION

    CM - X (m-X)2 F( m-x)2
    -16.63 276.67 553.34
    -11.13 123.95 371.8533
    -6.13 37.62 150.47
    -1.13 1.28 12.84
    3.87 14.95 74.76
    8.87 78.62 157.2356
    13.87 192.28 576.85
    18.87 355.95 0.00
    23.87 569.62 569.62
    2466.97

    Variance= 85.06782 Standard Dev. 9.22

    Mode= 23.23
    SCORE F SCORES
    1.) 11 20 0 2.) 5
    21 30 4 11
    31 40 6 16
    41 50 8 21
    51 60 10 26
    61 70 5 31
    71 80 6 36
    81 90 1 41
    91 100 0 46
    SCORES F
    10 2
    15 3
    20 4
    25 10
    30 5
    35 2
    40 3
    45 0
    50 1
    5 to 10

    Scores F
    10 19 8 8
    20 29 16 24
    30 39 21 45
    40 49 11 56
    50 59 4 60

    N= 60

    Mean ( X)= 32.33

    59
    CM Fm CM - X (m-X)2 F( m-x)2
    14.5 116 -17.83333 318.0278 2544.222
    24.5 392 -7.833333 61.36111 981.7778
    34.5 724.5 2.166667 4.694444 98.58333
    44.5 489.5 12.16667 148.0278 1628.306
    54.5 218 22.16667 491.3611 1965.444

    1940 7218.333

    Variance= 122.3446 Standard Dev. 11.06095


    Scores F CF
    0 9 24 24
    10 19 14 38
    20 29 39 77
    30 39 18 95
    40 49 5 100
    N= 100

    Mean ( X)= 21

    F-1= 99
    CM Fm CM - X (m-X)2 F( m-x)2
    4.5 108 -16.5 272.25 6534
    14.5 203 -6.5 42.25 591.5
    24.5 955.5 3.5 12.25 477.75
    34.5 621 13.5 182.25 3280.5
    44.5 222.5 23.5 552.25 2761.25
    2110 13645

    Variance= 137.8283 Standard Dev. 11.74003

    You might also like