Copyrigth © 2000, 2004, Nederlandse Taalunie and
R.J.J.H. van Son
All materials presented here are licensed under the
GNU General Public License (GPL) unless explicitely stated
otherwise. Please note that these materials are presented WITHOUT ANY WARRANTY.
For information or further details
see the License,
GNU.org, or contact me
at Rob.van.Son@hum.uva.nl.
| Use this button to change the query | Use this button to select the speech fragments that were used |
#
# MEAN
#
# Group (rows X columns):
# PHONEMESPHONEME_value X PHONEMESPHONEME_speaker
#
# Nrows: 15256
#
#
# F0 (semitones) of selected Spontaneous sonorants: Speaker x Phoneme
# (valid durations only)
#
# Manners Speakers
# F: Fricatives F: Female
# G: Glides M: Male
# N: Nasals 20: Years of Age
# S: Stops [A-Z]: ID code
# V: Vowels
# O: Others (pauses)
#
#
# Case2
F20N F28G F40L F60E M15R M40K M56H M66O Total
2 23.337 19.636 21.843 22.756 13.022 12.337 12.834 17.435 18.126
9+ 21.580 19.137 18.629 18.475 12.260 12.986 12.359 17.945 16.953
@ 22.726 20.850 20.070 20.333 13.305 12.519 12.602 18.033 18.046
A 21.879 19.726 19.585 19.590 14.228 12.245 11.980 18.410 17.597
E 21.031 20.528 20.078 20.108 13.370 12.875 12.885 18.416 18.004
E+ 22.342 21.022 20.239 18.462 12.680 11.961 12.637 18.061 17.866
E~ 0 10.308 0 0 0 0 0 0 10.308
I 22.268 20.953 20.145 19.941 13.719 12.900 13.693 19.163 18.170
J 0 21.707 0 0 0 0 0 0 21.707
N 23.741 22.562 21.162 21.121 12.961 12.939 13.228 19.050 18.634
O 22.853 20.247 19.734 19.313 13.487 12.466 12.448 18.765 17.922
O+ 24.468 18.762 17.990 17.544 13.467 10.821 11.772 18.321 17.263
O~ 0 0 21.142 0 0 0 0 18.136 19.138
Y 24.999 21.522 19.902 19.710 13.695 12.060 12.489 18.500 18.661
a 22.493 20.899 18.599 19.361 13.838 10.961 11.907 17.415 17.533
e 23.241 20.786 19.880 20.328 13.519 12.174 12.894 18.768 18.104
i 23.493 21.959 22.423 21.582 14.334 12.880 12.455 18.452 18.969
j 22.478 21.943 22.151 21.531 14.324 12.340 11.675 17.931 17.757
l 23.251 21.592 20.650 21.068 13.487 11.635 12.550 18.053 18.287
m 23.068 21.594 21.133 20.056 13.730 11.731 11.753 17.717 17.911
n 22.872 21.216 20.453 20.158 13.295 11.824 12.139 17.546 17.931
o 23.312 20.739 19.023 18.727 14.150 12.152 12.794 18.621 17.824
r 23.184 21.941 21.786 21.526 15.008 12.520 11.744 17.950 18.596
u 24.703 21.949 21.548 22.478 13.735 12.623 12.869 19.788 19.088
w 22.079 21.130 20.312 20.398 13.068 12.735 13.179 17.741 18.206
y 23.774 21.053 20.287 21.354 12.620 12.826 11.214 20.982 18.909
Total 22.747 20.988 20.293 20.270 13.672 12.256 12.436 18.132 18.070
#
# SD
F20N F28G F40L F60E M15R M40K M56H M66O Total
2 1.219 5.682 2.949 3.008 1.730 3.200 2.530 1.890 5.203
9+ 5.001 5.355 5.803 5.277 2.055 3.282 2.981 2.501 5.205
@ 5.261 5.441 4.772 4.507 2.513 4.213 4.767 3.328 5.743
A 4.506 5.547 4.836 4.910 4.868 3.691 4.516 3.166 5.743
E 6.170 5.612 4.427 4.475 2.528 4.651 4.090 2.417 5.663
E+ 4.552 4.641 3.622 5.519 1.249 4.431 4.288 2.449 5.532
E~ 0 0 0 0 0 0 0 0 0
I 5.228 4.986 4.523 5.018 1.788 2.921 4.729 2.265 5.462
J 0 0 0 0 0 0 0 0 0
N 4.356 2.105 1.881 3.764 1.775 3.015 3.439 2.512 5.144
O 5.467 7.051 5.059 5.627 2.467 3.342 3.023 2.450 5.761
O+ 1.816 4.697 6.069 3.925 1.113 2.643 2.671 2.432 5.171
O~ 0 0 0 0 0 0 0 1.122 1.908
Y 2.335 4.878 4.574 5.152 2.215 2.562 2.873 2.306 5.513
a 4.650 4.193 5.276 4.188 5.289 3.659 2.483 2.101 5.495
e 3.358 4.846 4.237 5.015 1.498 2.823 2.464 3.678 5.452
i 3.838 4.224 2.248 3.586 1.954 4.227 2.690 2.847 5.448
j 4.781 5.110 2.444 6.689 2.186 4.032 2.611 3.210 5.922
l 3.217 5.055 3.444 3.670 1.727 3.338 4.543 3.193 5.547
m 3.273 3.076 2.946 4.007 2.017 2.363 3.582 2.091 5.233
n 4.327 4.354 3.366 4.068 1.698 2.991 3.870 3.148 5.402
o 2.701 5.024 4.756 4.418 3.443 3.794 2.540 2.675 5.247
r 4.302 5.229 5.075 4.131 6.463 5.719 3.406 4.102 6.239
u 1.714 5.276 4.284 3.678 1.915 2.219 4.125 2.969 5.631
w 4.603 4.452 3.736 4.194 1.575 3.194 4.614 2.181 5.114
y 1.363 4.566 7.190 2.358 0.743 3.494 2.625 1.247 5.732
Total 4.527 5.015 4.414 4.497 3.267 3.814 3.971 3.063 5.602
#
# Degrees of Freedom
F20N F28G F40L F60E M15R M40K M56H M66O Total
2 10 5 3 3 5 2 8 5 48
9+ 13 6 17 12 4 14 14 21 108
@ 347 333 301 401 158 301 305 557 2710
A 145 173 124 177 58 142 135 158 1119
E 115 148 127 116 41 119 93 126 892
E+ 65 52 29 68 23 46 35 76 401
E~ 0 0 0 0 0 0 0 0 0
I 111 69 54 85 35 73 107 119 660
J 0 0 0 0 0 0 0 0 0
N 29 22 19 25 20 21 23 36 202
O 55 72 67 78 27 62 55 112 535
O+ 11 30 4 7 5 7 15 21 107
O~ 0 0 0 0 0 0 0 1 2
Y 21 39 32 12 6 21 19 30 187
a 84 123 85 109 34 80 80 120 722
e 74 86 67 75 27 98 47 85 566
i 60 81 44 101 22 65 61 58 499
j 38 18 12 18 12 31 29 45 210
l 113 111 93 158 40 132 83 158 895
m 103 100 59 87 41 90 85 117 689
n 260 246 220 260 92 240 206 357 1888
o 87 68 59 53 43 77 57 113 564
r 152 159 156 190 79 151 134 250 1278
u 33 26 28 20 19 24 26 36 219
w 79 110 93 90 32 100 50 114 675
y 13 8 3 6 1 5 8 3 54
Total 2040 2109 1719 2173 846 1923 1697 2741 15255
#
# counts
F20N F28G F40L F60E M15R M40K M56H M66O Total
2 11 6 4 4 6 3 9 6 49
9+ 14 7 18 13 5 15 15 22 109
@ 348 334 302 402 159 302 306 558 2711
A 146 174 125 178 59 143 136 159 1120
E 116 149 128 117 42 120 94 127 893
E+ 66 53 30 69 24 47 36 77 402
E~ 0 1 0 0 0 0 0 0 1
I 112 70 55 86 36 74 108 120 661
J 0 1 0 0 0 0 0 0 1
N 30 23 20 26 21 22 24 37 203
O 56 73 68 79 28 63 56 113 536
O+ 12 31 5 8 6 8 16 22 108
O~ 0 0 1 0 0 0 0 2 3
Y 22 40 33 13 7 22 20 31 188
a 85 124 86 110 35 81 81 121 723
e 75 87 68 76 28 99 48 86 567
i 61 82 45 102 23 66 62 59 500
j 39 19 13 19 13 32 30 46 211
l 114 112 94 159 41 133 84 159 896
m 104 101 60 88 42 91 86 118 690
n 261 247 221 261 93 241 207 358 1889
o 88 69 60 54 44 78 58 114 565
r 153 160 157 191 80 152 135 251 1279
u 34 27 29 21 20 25 27 37 220
w 80 111 94 91 33 101 51 115 676
y 14 9 4 7 2 6 9 4 55
Total 2041 2110 1720 2174 847 1924 1698 2742 15256
#
# two-factor ANOVA (extremely simplistic, using the above numbers)
#
# F DoF partial W^2 ( = [dof * (F-1)] / [dof*(F-1) + n] )
# Rows : 10.19 25 / 15048 0.015
# Cols : 183.02 7 / 15048 0.077
# Interaction: 13.64 175 / 15048 0.127
# Harmonic Sample Size: 6.67504587263136
#
#
# Nrows: 15256
# Table: PHONEMESPHONEME
# Function: MEAN
#
# Date: Sat Feb 28 18:47:03 2004
# QUERY:
# SELECT DISTINCT
# PHONEMESPHONEME.value as PHONEMESPHONEME_value,
# PHONEMESPHONEME.speaker as PHONEMESPHONEME_speaker,
# PHONEMESPHONEME.id,
# CASE
# WHEN PHONEMESPHONEME.duration >= 0 THEN (1000*PHONEMESPHONEME.duration)
# END AS Case1 ,
# CASE
# WHEN PITCHSEMITONES_FM.time2 >= 0 THEN (PITCHSEMITONES_FM.time2-12*ln(50)/ln(2))
# END AS Case2
# FROM
# PHONEMESPHONEME,
# WORDSPHONEME,
# TRANSLITPHONEME,
# POSPOS,
# INTAS915,
# PITCHSEMITONES_FM
# WHERE
# (WORDSPHONEME.id = PHONEMESPHONEME.wordsid AND
# PHONEMESPHONEME.wordsid = WORDSPHONEME.id AND
# TRANSLITPHONEME.id = PHONEMESPHONEME.sentenceid AND
# PHONEMESPHONEME.sentenceid = TRANSLITPHONEME.id AND
# TRANSLITPHONEME.id = WORDSPHONEME.sentenceid AND
# WORDSPHONEME.sentenceid = TRANSLITPHONEME.id AND
# POSPOS.id = WORDSPHONEME.id AND
# WORDSPHONEME.id = POSPOS.id AND
# PITCHSEMITONES_FM.id = PHONEMESPHONEME.id AND
# PHONEMESPHONEME.id = PITCHSEMITONES_FM.id AND
# INTAS915.id = TRANSLITPHONEME.id AND
# TRANSLITPHONEME.id = INTAS915.id) AND
# ( PHONEMESPHONEME.manner IN ('F', 'G', 'N', 'O', 'S', 'V') AND
# PHONEMESPHONEME.durationvalid = 'V' AND
# POSPOS.value != 'TSW' AND
# INTAS915.style IN ('I', 'R') AND
# PHONEMESPHONEME.manner IN ('V', 'N', 'G')
# )
#