sd by shuifanglj

VIEWS: 29 PAGES: 12

									                                    The Meaning of Standard Deviation
                                A                    B
                                 38                       20
                                 34                       20
                                 26                       20
                                 24                       20
                                 20                       20
                                 20                       20
                                 16                       20
                                 14                       20
                                   6                      20
                                   2                      20
                                200 total
                       total of X value of X value       200
                         Ma      20       Mb              20
                Mean

                   5
            4
                            6
        3
                                                 8
                                                           9
                                                 8

1
            4
                   5
1
    2
                   5


                                                               average
                                                               sqrt
eaning of Standard Deviation
                                  C
                                       25                    sq
                                       24                5                                 5.071429
                                       23                4
                                       22                6
                                       21                3
                                       19                8
                                       18                9
                                       17                8
                                       16               10
                                       15                1
               total of X value       200                4
                      Mc               20                5
                                                         1
                                  x         xsq          2
                                        0           0    5                           69
                                        1           1   62                       4.9286               5.071429
                                        1           1
                                        2           4                 Column1
                                        3           9
                                        4          16        Mean            5.071428571
                                        3           9        Standard Error 0.766498287
                             10         5          25        Median                    5
                                        4          16        Mode                      5
                                        1           1                        2.867973976
                                                             Standard Deviation
                                        0           0        Sample Variance8.225274725
                                        4          16        Kurtosis        -0.88217706
                                        3           9        Skewness        0.213352859
                                        0           0        Range                     9
               total                   31         107        Minimum                   1
                                                             Maximum                  10
               average                       7.642857        Sum                      71
               sqrt                          2.764572        Count                    14
                                                             Largest(1)               10
                                                             Smallest(1)               1
                                                                              1.65591887
                                                             Confidence Level(95.0%)
 5                                                                       5
 4
 6
 3
 8
 9
 8                                                                       5
10
 1                                         0
 4
 5
 1
 2
 5

                  Column1
                                               X= raw score
     Mean                    5.071428571       x= deviation (distance)
     Standard Error          0.766498287
     Median                            5
     Mode                              5
     Standard Deviation      2.867973976
     Sample Variance         8.225274725
     Kurtosis               -0.882177058
     Skewness                0.213352859
     Range                             9
     Minimum                           1
     Maximum                          10
     Sum                              71
     Count                            14
     Largest(1)                       10
     Smallest(1)                       1
     Confidence Level(95.0%) 1.65591887
                                   X deviation (distance to mean) xsq
                               5                              -7.5     56.25
10                           10                               -2.5      6.25
     15                      15                                2.5      6.25
          20                 20                                7.5     56.25
     15                      15                                2.5      6.25
               25            25                               12.5    156.25
                               5                              -7.5     56.25
10                           10                               -2.5      6.25
                               0                             -12.5    156.25
     15                      15                                2.5      6.25
10                           10                               -2.5      6.25
          20                 20                                7.5     56.25
                    total   150                                  0      575
                    mean    12.5



                                                    47.91666667
                raw score          deviation to mean Sq of Deviation
                             15                    2.5          6.25
                             20                    7.5         56.25
                             10                   -2.5          6.25
                             10                   -2.5          6.25
                             15                    2.5          6.25
                             20                    7.5         56.25
                             20                    7.5         56.25
                             10                   -2.5          6.25
                               0                 -12.5       156.25
                             15                    2.5          6.25
                               5                  -7.5         56.25
sqrt                         10                   -2.5          6.25
 6.922187                   150                      0           425
                            12.5                                       sum/12 testees
                                                                         35.41666667

                            Column1

            Mean                                12.5
            Standard Error              1.794351406
            Median                              12.5
            Mode                                 10
            Standard Deviation          6.215815605
            Sample Variance             38.63636364
            Kurtosis                   -0.091349481
            Skewness                   -0.511030376
            Range                                20
            Minimum                                0
            Maximum                              20
            Sum                                 150
            Count                                12
            Largest(1)                           20
            Smallest(1)                            0
            Confidence Level(95.0%)     3.949340815
sqrt
   5.95119
sd
                             Jack's score
      item     reading    writing grammar verb speechtranslation
English             140         140       150 150   100     60
weighted score    0.175       0.175 0.1875 0.1875 0.125 0.075
science
weighted score
P.E.
weighted score
Math
weighted score
         Total Point 800
logical Total points/scorepoint Total score
      60                    800
  0.075                       1         100
             Reliability Check
                                            High Reliability: 0.7 - 0.9
Test     Re-Test                       Pearson r
    21         22                                0.764
    20         26
    23         30                                    Column1
    20         22
    20         28                Mean
    21         28                Standard Error
    22         32                Median
    19         26                Mode
    16         20                Standard Deviation
    20         22                Sample Variance
    18         24                Kurtosis
    23         30                Skewness
    21         32                Range
    21         30                Minimum
    22         30                Maximum
    19         24                Sum
    16         22                Count
    18         20                Largest(1)
   360        468                Smallest(1)
                                 Confidence Level(95.0%)
High Reliability: 0.7 - 0.9
                 Cronbach's Alpha
                        0.759
                                                Column 1 Column 2
       Column1                       Column 1           1
                                     Column 2       0.764       1
                       26.35294118
                       0.958480632
                                26
                                22
                       3.951916884
                       15.61764706
                      -1.460693196
                      -0.056612733
                                12
                                20
                                32
                               448
                                17
                                32
                                20
                       2.031888157
                                          Percentile formula
                 Pr = # of Students below the score/Total Students * 100


        Name        Score
 1   student25          100
 2   student23            99
 3   student24            99
 4   student22            97
 5   student21            94
 6   student20            90
 7   student19            89
 8   student17            87
 8   student18            87
 9   student15            77
10   student16            77
11   student14            72
12   student13            67
13   student12            66
14   student10            65
15   student11            65
16   student9             59
17   student8             58
18   student7             56
19   student6             48
20   student5             44
21   student4             42
22   student3             36
23   student2             32
24   student 1            21
Pr = 16/25 * 100 = 0.640 * 100 = 64.0%




                                         16   25   0.640

								
To top