data analysis using sql and excel chapter 3
DESCRIPTION
Data Analysis Using SQL and Excel Chapter 3TRANSCRIPT
mean confidence std error50% 2.50% 1.28%
Percent Normal Value Shaded Part42.0% 0.0000 #N/A -8.0%42.1% 0.0000 #N/A -7.9%42.2% 0.0000 #N/A -7.8%42.3% 0.0000 #N/A -7.7%42.4% 0.0000 #N/A -7.6%42.5% 0.0000 #N/A -7.5%42.6% 0.0000 #N/A -7.4%42.7% 0.0000 #N/A -7.3%42.8% 0.0000 #N/A -7.2%42.9% 0.0000 #N/A -7.1%43.0% 0.0000 #N/A -7.0%43.1% 0.0000 #N/A -6.9%43.2% 0.0000 #N/A -6.8%43.3% 0.0000 #N/A -6.7%43.4% 0.0000 #N/A -6.6%43.5% 0.0001 #N/A -6.5%43.6% 0.0001 #N/A -6.4%43.7% 0.0002 #N/A -6.3%43.8% 0.0002 #N/A -6.2%43.9% 0.0003 #N/A -6.1%44.0% 0.0005 #N/A -6.0%44.1% 0.0007 #N/A -5.9%44.2% 0.0010 #N/A -5.8%44.3% 0.0014 #N/A -5.7%44.4% 0.0020 #N/A -5.6%44.5% 0.0029 #N/A -5.5%44.6% 0.0040 #N/A -5.4%44.7% 0.0056 #N/A -5.3%44.8% 0.0077 #N/A -5.2%44.9% 0.0106 #N/A -5.1%45.0% 0.0144 #N/A -5.0%45.1% 0.0195 #N/A -4.9%45.2% 0.0263 #N/A -4.8%45.3% 0.0352 #N/A -4.7%45.4% 0.0469 #N/A -4.6%45.5% 0.0620 #N/A -4.5%45.6% 0.0815 #N/A -4.4%45.7% 0.1065 #N/A -4.3%45.8% 0.1383 #N/A -4.2%45.9% 0.1785 #N/A -4.1%46.0% 0.2289 #N/A -4.0%46.1% 0.2918 #N/A -3.9%46.2% 0.3697 #N/A -3.8%46.3% 0.4656 #N/A -3.7%46.4% 0.5827 #N/A -3.6%46.5% 0.7248 #N/A -3.5%46.6% 0.8960 #N/A -3.4%46.7% 1.1009 #N/A -3.3%
56 106
46.8% 1.3443 #N/A -3.2%46.9% 1.6314 #N/A -3.1%47.0% 1.9678 #N/A -3.0%47.1% 2.3590 #N/A -2.9%47.2% 2.8107 #N/A -2.8%47.3% 3.3283 #N/A -2.7%47.4% 3.9171 #N/A -2.6%47.5% 4.5818 4.5818 -2.5%47.6% 5.3264 5.3264 -2.4%47.7% 6.1541 6.1541 -2.3%47.8% 7.0669 7.0669 -2.2%47.9% 8.0653 8.0653 -2.1%48.0% 9.1483 9.1483 -2.0%48.1% 10.3133 10.3133 -1.9%48.2% 11.5553 11.5553 -1.8%48.3% 12.8675 12.8675 -1.7%48.4% 14.2410 14.2410 -1.6%48.5% 15.6645 15.6645 -1.5%48.6% 17.1247 17.1247 -1.4%48.7% 18.6063 18.6063 -1.3%48.8% 20.0922 20.0922 -1.2%48.9% 21.5639 21.5639 -1.1%49.0% 23.0015 23.0015 -1.0%49.1% 24.3845 24.3845 -0.9%49.2% 25.6924 25.6924 -0.8%49.3% 26.9045 26.9045 -0.7%49.4% 28.0012 28.0012 -0.6%49.5% 28.9640 28.9640 -0.5%49.6% 29.7763 29.7763 -0.4%49.7% 30.4238 30.4238 -0.3%49.8% 30.8949 30.8949 -0.2%49.9% 31.1811 31.1811 -0.1%50.0% 31.2771 31.2771 0.0%50.1% 31.1811 31.1811 0.1%50.2% 30.8949 30.8949 0.2%50.3% 30.4238 30.4238 0.3%50.4% 29.7763 29.7763 0.4%50.5% 28.9640 28.9640 0.5%50.6% 28.0012 28.0012 0.6%50.7% 26.9045 26.9045 0.7%50.8% 25.6924 25.6924 0.8%50.9% 24.3845 24.3845 0.9%51.0% 23.0015 23.0015 1.0%51.1% 21.5639 21.5639 1.1%51.2% 20.0922 20.0922 1.2%51.3% 18.6063 18.6063 1.3%51.4% 17.1247 17.1247 1.4%51.5% 15.6645 15.6645 1.5%51.6% 14.2410 14.2410 1.6%51.7% 12.8675 12.8675 1.7%51.8% 11.5553 11.5553 1.8%51.9% 10.3133 10.3133 1.9%52.0% 9.1483 9.1483 2.0%52.1% 8.0653 8.0653 2.1%
52.2% 7.0669 7.0669 2.2%52.3% 6.1541 6.1541 2.3%52.4% 5.3264 5.3264 2.4%52.5% 4.5818 4.5818 2.5%52.6% 3.9171 #N/A 2.6%52.7% 3.3283 #N/A 2.7%52.8% 2.8107 #N/A 2.8%52.9% 2.3590 #N/A 2.9%53.0% 1.9678 #N/A 3.0%53.1% 1.6314 #N/A 3.1%53.2% 1.3443 #N/A 3.2%53.3% 1.1009 #N/A 3.3%53.4% 0.8960 #N/A 3.4%53.5% 0.7248 #N/A 3.5%53.6% 0.5827 #N/A 3.6%53.7% 0.4656 #N/A 3.7%53.8% 0.3697 #N/A 3.8%53.9% 0.2918 #N/A 3.9%54.0% 0.2289 #N/A 4.0%54.1% 0.1785 #N/A 4.1%54.2% 0.1383 #N/A 4.2%54.3% 0.1065 #N/A 4.3%54.4% 0.0815 #N/A 4.4%54.5% 0.0620 #N/A 4.5%54.6% 0.0469 #N/A 4.6%54.7% 0.0352 #N/A 4.7%54.8% 0.0263 #N/A 4.8%54.9% 0.0195 #N/A 4.9%55.0% 0.0144 #N/A 5.0%55.1% 0.0106 #N/A 5.1%55.2% 0.0077 #N/A 5.2%55.3% 0.0056 #N/A 5.3%55.4% 0.0040 #N/A 5.4%55.5% 0.0029 #N/A 5.5%55.6% 0.0020 #N/A 5.6%55.7% 0.0014 #N/A 5.7%55.8% 0.0010 #N/A 5.8%55.9% 0.0007 #N/A 5.9%56.0% 0.0005 #N/A 6.0%56.1% 0.0003 #N/A 6.1%56.2% 0.0002 #N/A 6.2%56.3% 0.0002 #N/A 6.3%56.4% 0.0001 #N/A 6.4%56.5% 0.0001 #N/A 6.5%56.6% 0.0000 #N/A 6.6%56.7% 0.0000 #N/A 6.7%56.8% 0.0000 #N/A 6.8%56.9% 0.0000 #N/A 6.9%57.0% 0.0000 #N/A 7.0%
56 106
z-Score Confidence Confidencez-Score1.00 68.269% 90.000% 1.641.64 89.899% 95.000% 1.961.96 95.000% 99.000% 2.582.00 95.450% 99.500% 2.812.50 98.758% 99.900% 3.293.00 99.730% 99.990% 3.893.29 99.900% 0.99999 4.423.89 99.990%4.00 99.994%4.42 99.999%5.00 100.000%
x x avg y y
minus infinity plus infinity
normsdist(y)
normsdist(y) - normsdist(x)
normsdist(x)
x x avg y y
minus infinity plus infinity
normsdist(y)
normsdist(y) - normsdist(x)
avg $73.98stdev $197.23
5 10 50 100 250Sample SizSample SizSample SizSample Size 100 Sample Siz
$50.00 0.0084 0.0097 0.0000 0.0000 0.0000$50.25 0.0084 0.0098 0.0000 0.0000 0.0000$50.50 $0.01 $0.01 0.0000 0.0000 0.0000$50.75 $0.01 $0.01 0.0000 0.0000 0.0000$51.00 $0.01 $0.01 0.0000 0.0000 0.0000$51.25 0.0086 0.0104 0.0000 0.0000 0.0000$51.50 0.0086 0.0106 0.0000 0.0000 0.0000$51.75 0.0086 0.0107 0.0000 0.0000 0.0000$52.00 0.0087 0.0109 0.0000 0.0000 0.0000$52.25 0.0087 0.0110 0.0000 0.0000 0.0000$52.50 0.0087 0.0112 0.0000 0.0000 0.0000$52.75 0.0087 0.0113 0.0000 0.0000 0.0000$53.00 0.0088 0.0115 0.0000 0.0000 0.0000$53.25 0.0088 0.0116 0.0000 0.0000 0.0000$53.50 0.0088 0.0118 0.0000 0.0000 0.0000$53.75 0.0089 0.0120 0.0000 0.0000 0.0000$54.00 0.0089 0.0121 0.0000 0.0000 0.0000$54.25 0.0089 0.0123 0.0000 0.0000 0.0000$54.50 0.0090 0.0124 0.0000 0.0000 0.0000$54.75 0.0090 0.0126 0.0000 0.0000 0.0000$55.00 0.0090 0.0127 0.0000 0.0000 0.0000$55.25 0.0090 0.0129 0.0000 0.0000 0.0000$55.50 0.0091 0.0130 0.0000 0.0000 0.0000$55.75 0.0091 0.0132 0.0000 0.0000 0.0000$56.00 0.0091 0.0133 0.0000 0.0000 0.0000$56.25 0.0091 0.0135 0.0000 0.0000 0.0000$56.50 0.0092 0.0137 0.0000 0.0000 0.0000$56.75 0.0092 0.0138 0.0000 0.0000 0.0000$57.00 0.0092 0.0140 0.0000 0.0000 0.0000$57.25 0.0092 0.0141 0.0000 0.0000 0.0000$57.50 0.0093 0.0143 0.0000 0.0000 0.0000$57.75 0.0093 0.0144 0.0000 0.0000 0.0000$58.00 0.0093 0.0146 0.0000 0.0000 0.0000$58.25 0.0093 0.0147 0.0000 0.0000 0.0000$58.50 0.0094 0.0149 0.0000 0.0000 0.0000$58.75 0.0094 0.0150 0.0001 0.0000 0.0000$59.00 0.0094 0.0152 0.0001 0.0000 0.0000$59.25 0.0094 0.0153 0.0001 0.0000 0.0000$59.50 0.0095 0.0154 0.0001 0.0000 0.0000$59.75 0.0095 0.0156 0.0002 0.0000 0.0000$60.00 0.0095 0.0157 0.0002 0.0000 0.0000$60.25 0.0095 0.0159 0.0002 0.0000 0.0000$60.50 0.0095 0.0160 0.0003 0.0000 0.0000$60.75 0.0096 0.0162 0.0004 0.0000 0.0000$61.00 0.0096 0.0163 0.0005 0.0000 0.0000$61.25 0.0096 0.0164 0.0006 0.0000 0.0000$61.50 0.0096 0.0166 0.0007 0.0000 0.0000$61.75 0.0096 0.0167 0.0008 0.0000 0.0000
$62.00 0.0097 0.0168 0.0010 0.0000 0.0000$62.25 0.0097 0.0169 0.0012 0.0000 0.0000$62.50 0.0097 0.0171 0.0015 0.0000 0.0000$62.75 0.0097 0.0172 0.0018 0.0000 0.0000$63.00 0.0097 0.0173 0.0021 0.0000 0.0000$63.25 0.0097 0.0174 0.0025 0.0000 0.0000$63.50 0.0098 0.0176 0.0030 0.0000 0.0000$63.75 0.0098 0.0177 0.0035 0.0000 0.0000$64.00 0.0098 0.0178 0.0041 0.0000 0.0000$64.25 0.0098 0.0179 0.0048 0.0000 0.0000$64.50 0.0098 0.0180 0.0056 0.0000 0.0000$64.75 0.0098 0.0181 0.0065 0.0000 0.0000$65.00 0.0099 0.0182 0.0076 0.0000 0.0000$65.25 0.0099 0.0183 0.0087 0.0000 0.0000$65.50 0.0099 0.0184 0.0100 0.0000 0.0000$65.75 0.0099 0.0185 0.0115 0.0000 0.0000$66.00 0.0099 0.0186 0.0131 0.0001 0.0000$66.25 0.0099 0.0187 0.0148 0.0001 0.0000$66.50 0.0099 0.0188 0.0168 0.0002 0.0000$66.75 0.0099 0.0189 0.0189 0.0002 0.0000$67.00 0.0100 0.0190 0.0211 0.0004 0.0000$67.25 0.0100 0.0191 0.0236 0.0006 0.0000$67.50 0.0100 0.0192 0.0262 0.0009 0.0000$67.75 0.0100 0.0192 0.0291 0.0014 0.0000$68.00 0.0100 0.0193 0.0321 0.0020 0.0000$68.25 0.0100 0.0194 0.0352 0.0030 0.0000$68.50 0.0100 0.0195 0.0385 0.0043 0.0000$68.75 0.0100 0.0195 0.0420 0.0060 0.0000$69.00 0.0100 0.0196 0.0456 0.0083 0.0000$69.25 0.0100 0.0197 0.0493 0.0114 0.0000$69.50 0.0100 0.0197 0.0531 0.0153 0.0000$69.75 0.0101 0.0198 0.0569 0.0203 0.0000$70.00 0.0101 0.0198 0.0608 0.0264 0.0000$70.25 0.0101 0.0199 0.0647 0.0338 0.0000$70.50 0.0101 0.0199 0.0685 0.0426 0.0000$70.75 0.0101 0.0200 0.0723 0.0529 0.0001$71.00 0.0101 0.0200 0.0760 0.0646 0.0004$71.25 0.0101 0.0200 0.0796 0.0776 0.0013$71.50 0.0101 0.0201 0.0830 0.0918 0.0036$71.75 0.0101 0.0201 0.0862 0.1067 0.0093$72.00 0.0101 0.0201 0.0892 0.1222 0.0217$72.25 0.0101 0.0201 0.0919 0.1377 0.0457$72.50 0.0101 0.0202 0.0943 0.1526 0.0870$72.75 0.0101 0.0202 0.0963 0.1665 0.1500$73.00 0.0101 0.0202 0.0981 0.1788 0.2338$73.25 0.0101 0.0202 0.0994 0.1889 0.3296$73.50 0.0101 0.0202 0.1004 0.1964 0.4202$73.75 0.0101 0.0202 0.1010 0.2009 0.4846$74.00 0.0101 0.0202 0.1011 0.2023 0.5055$74.25 0.0101 0.0202 0.1009 0.2004 0.4769$74.50 0.0101 0.0202 0.1003 0.1954 0.4069$74.75 0.0101 0.0202 0.0992 0.1874 0.3141$75.00 0.0101 0.0202 0.0978 0.1770 0.2192$75.25 0.0101 0.0202 0.0960 0.1644 0.1384
$75.50 0.0101 0.0202 0.0939 0.1503 0.0790$75.75 0.0101 0.0201 0.0915 0.1352 0.0408$76.00 0.0101 0.0201 0.0887 0.1197 0.0191$76.25 0.0101 0.0201 0.0857 0.1043 0.0081$76.50 0.0101 0.0201 0.0825 0.0894 0.0031$76.75 0.0101 0.0200 0.0790 0.0754 0.0011$77.00 0.0101 0.0200 0.0754 0.0626 0.0003$77.25 0.0101 0.0200 0.0717 0.0512 0.0001$77.50 0.0101 0.0199 0.0679 0.0411 0.0000$77.75 0.0101 0.0199 0.0641 0.0325 0.0000$78.00 0.0101 0.0198 0.0602 0.0253 0.0000$78.25 0.0101 0.0198 0.0563 0.0194 0.0000$78.50 0.0100 0.0197 0.0525 0.0146 0.0000$78.75 0.0100 0.0196 0.0487 0.0109 0.0000$79.00 0.0100 0.0196 0.0450 0.0079 0.0000$79.25 0.0100 0.0195 0.0414 0.0057 0.0000$79.50 0.0100 0.0195 0.0380 0.0040 0.0000$79.75 0.0100 0.0194 0.0347 0.0028 0.0000$80.00 0.0100 0.0193 0.0316 0.0019 0.0000$80.25 0.0100 0.0192 0.0286 0.0013 0.0000$80.50 0.0100 0.0192 0.0258 0.0009 0.0000$80.75 0.0100 0.0191 0.0232 0.0006 0.0000$81.00 0.0100 0.0190 0.0208 0.0004 0.0000$81.25 0.0099 0.0189 0.0185 0.0002 0.0000$81.50 0.0099 0.0188 0.0164 0.0001 0.0000$81.75 0.0099 0.0187 0.0145 0.0001 0.0000$82.00 0.0099 0.0186 0.0128 0.0001 0.0000$82.25 0.0099 0.0185 0.0112 0.0000 0.0000$82.50 0.0099 0.0184 0.0098 0.0000 0.0000$82.75 0.0099 0.0183 0.0085 0.0000 0.0000$83.00 0.0099 0.0182 0.0074 0.0000 0.0000$83.25 0.0098 0.0181 0.0064 0.0000 0.0000$83.50 0.0098 0.0180 0.0055 0.0000 0.0000$83.75 0.0098 0.0179 0.0047 0.0000 0.0000$84.00 0.0098 0.0178 0.0040 0.0000 0.0000$84.25 0.0098 0.0177 0.0034 0.0000 0.0000$84.50 0.0098 0.0175 0.0029 0.0000 0.0000$84.75 0.0097 0.0174 0.0024 0.0000 0.0000$85.00 0.0097 0.0173 0.0020 0.0000 0.0000$85.25 0.0097 0.0172 0.0017 0.0000 0.0000$85.50 0.0097 0.0171 0.0014 0.0000 0.0000$85.75 0.0097 0.0169 0.0012 0.0000 0.0000$86.00 0.0097 0.0168 0.0010 0.0000 0.0000$86.25 0.0096 0.0167 0.0008 0.0000 0.0000$86.50 0.0096 0.0165 0.0007 0.0000 0.0000$86.75 0.0096 0.0164 0.0005 0.0000 0.0000$87.00 0.0096 0.0163 0.0004 0.0000 0.0000$87.25 0.0096 0.0161 0.0004 0.0000 0.0000$87.50 0.0095 0.0160 0.0003 0.0000 0.0000$87.75 0.0095 0.0159 0.0002 0.0000 0.0000$88.00 0.0095 0.0157 0.0002 0.0000 0.0000$88.25 0.0095 0.0156 0.0001 0.0000 0.0000$88.50 0.0095 0.0154 0.0001 0.0000 0.0000$88.75 0.0094 0.0153 0.0001 0.0000 0.0000
$89.00 0.0094 0.0151 0.0001 0.0000 0.0000$89.25 0.0094 0.0150 0.0001 0.0000 0.0000$89.50 0.0094 0.0148 0.0000 0.0000 0.0000$89.75 0.0093 0.0147 0.0000 0.0000 0.0000$90.00 0.0093 0.0145 0.0000 0.0000 0.0000$90.25 0.0093 0.0144 0.0000 0.0000 0.0000$90.50 0.0093 0.0142 0.0000 0.0000 0.0000$90.75 0.0092 0.0141 0.0000 0.0000 0.0000$91.00 0.0092 0.0139 0.0000 0.0000 0.0000$91.25 0.0092 0.0138 0.0000 0.0000 0.0000$91.50 0.0092 0.0136 0.0000 0.0000 0.0000$91.75 0.0091 0.0135 0.0000 0.0000 0.0000$92.00 0.0091 0.0133 0.0000 0.0000 0.0000$92.25 0.0091 0.0132 0.0000 0.0000 0.0000$92.50 0.0091 0.0130 0.0000 0.0000 0.0000$92.75 0.0090 0.0129 0.0000 0.0000 0.0000$93.00 0.0090 0.0127 0.0000 0.0000 0.0000$93.25 0.0090 0.0126 0.0000 0.0000 0.0000$93.50 0.0089 0.0124 0.0000 0.0000 0.0000$93.75 0.0089 0.0122 0.0000 0.0000 0.0000$94.00 0.0089 0.0121 0.0000 0.0000 0.0000$94.25 0.0089 0.0119 0.0000 0.0000 0.0000$94.50 0.0088 0.0118 0.0000 0.0000 0.0000$94.75 0.0088 0.0116 0.0000 0.0000 0.0000$95.00 0.0088 0.0115 0.0000 0.0000 0.0000$95.25 0.0087 0.0113 0.0000 0.0000 0.0000$95.50 0.0087 0.0112 0.0000 0.0000 0.0000$95.75 0.0087 0.0110 0.0000 0.0000 0.0000$96.00 0.0087 0.0108 0.0000 0.0000 0.0000$96.25 0.0086 0.0107 0.0000 0.0000 0.0000$96.50 0.0086 0.0105 0.0000 0.0000 0.0000$96.75 0.0086 0.0104 0.0000 0.0000 0.0000$97.00 0.0085 0.0102 0.0000 0.0000 0.0000$97.25 0.0085 0.0101 0.0000 0.0000 0.0000$97.50 0.0085 0.0099 0.0000 0.0000 0.0000$97.75 0.0084 0.0098 0.0000 0.0000 0.0000$98.00 0.0084 0.0096 0.0000 0.0000 0.0000$98.25 0.0084 0.0095 0.0000 0.0000 0.0000$98.50 0.0083 0.0093 0.0000 0.0000 0.0000$98.75 0.0083 0.0092 0.0000 0.0000 0.0000$99.00 0.0083 0.0090 0.0000 0.0000 0.0000$99.25 0.0082 0.0089 0.0000 0.0000 0.0000$99.50 0.0082 0.0088 0.0000 0.0000 0.0000$99.75 0.0082 0.0086 0.0000 0.0000 0.0000
$100.00 0.0081 0.0085 0.0000 0.0000 0.0000
500 17,839 53,537Sample Size 500 Sample SizSample Size 53537
0.0000 $70.00 0.0000 0.00000.0000 $70.05 0.0000 0.00000.0000 $70.10 0.0000 0.00000.0000 $70.15 0.0000 0.00000.0000 $70.20 0.0000 0.00000.0000 $70.25 0.0000 0.00000.0000 $70.30 0.0000 0.00000.0000 $70.35 0.0000 0.00000.0000 $70.40 0.0000 0.00000.0000 $70.45 0.0000 0.00000.0000 $70.50 0.0000 0.00000.0000 $70.55 0.0000 0.00000.0000 $70.60 0.0000 0.00000.0000 $70.65 0.0000 0.00000.0000 $70.70 0.0000 0.00000.0000 $70.75 0.0000 0.00000.0000 $70.80 0.0000 0.00000.0000 $70.85 0.0000 0.00000.0000 $70.90 0.0000 0.00000.0000 $70.95 0.0000 0.00000.0000 $71.00 0.0000 0.00000.0000 $71.05 0.0000 0.00000.0000 $71.10 0.0000 0.00000.0000 $71.15 0.0000 0.00000.0000 $71.20 0.0000 0.00000.0000 $71.25 0.0000 0.00000.0000 $71.30 0.0000 0.00000.0000 $71.35 0.0000 0.00000.0000 $71.40 0.0000 0.00000.0000 $71.45 0.0000 0.00000.0000 $71.50 0.0000 0.00000.0000 $71.55 0.0000 0.00000.0000 $71.60 0.0000 0.00000.0000 $71.65 0.0000 0.00000.0000 $71.70 0.0000 0.00000.0000 $71.75 0.0000 0.00000.0000 $71.80 0.0000 0.00000.0000 $71.85 0.0000 0.00000.0000 $71.90 0.0000 0.00000.0000 $71.95 0.0000 0.00000.0000 $72.00 0.0000 0.00000.0000 $72.05 0.0000 0.00000.0000 $72.10 0.0000 0.00000.0000 $72.15 0.0000 0.00000.0000 $72.20 0.0000 0.00000.0000 $72.25 0.0000 0.00000.0000 $72.30 0.0000 0.00000.0000 $72.35 0.0000 0.0000
$60 $62 $64 $66 $68 $70 $72 $74 $76 $78 $80 $82 $84 $86 $88 $90
Sample Size 250
Sample Size 100
0.0000 $72.40 0.0000 0.00000.0000 $72.45 0.0000 0.00000.0000 $72.50 0.0000 0.00000.0000 $72.55 0.0000 0.00000.0000 $72.60 0.0000 0.00000.0000 $72.65 0.0000 0.00000.0000 $72.70 0.0000 0.00000.0000 $72.75 0.0000 0.00000.0000 $72.80 0.0000 0.00000.0000 $72.85 0.0000 0.00000.0000 $72.90 0.0000 0.00000.0000 $72.95 0.0000 0.00000.0000 $73.00 0.0000 0.00000.0000 $73.05 0.0000 0.00000.0000 $73.10 0.0000 0.00000.0000 $73.15 0.0000 0.00000.0000 $73.20 0.0000 0.00000.0000 $73.25 0.0000 0.00000.0000 $73.30 0.0000 0.00000.0000 $73.35 0.0000 0.00000.0000 $73.40 0.0000 0.00000.0000 $73.45 0.0000 0.00000.0000 $73.50 0.0000 0.00000.0000 $73.55 0.0000 0.00000.0000 $73.60 0.0000 0.00000.0000 $73.65 0.0000 0.00000.0000 $73.70 0.0000 0.00000.0000 $73.75 0.0000 0.00000.0000 $73.80 0.0000 0.00000.0000 $73.85 0.0000 0.00000.0000 $73.90 0.0000 0.00000.0000 $73.95 0.0033 0.00000.0000 $74.00 0.9648 1.00000.0000 $74.05 1.0000 1.00000.0000 $74.10 1.0000 1.00000.0000 $74.15 1.0000 1.00000.0000 $74.20 1.0000 1.00000.0000 $74.25 1.0000 1.00000.0000 $74.30 1.0000 1.00000.0000 $74.35 1.0000 1.00000.0000 $74.40 1.0000 1.00000.0001 $74.45 1.0000 1.00000.0009 $74.50 1.0000 1.00000.0078 $74.55 1.0000 1.00000.0462 $74.60 1.0000 1.00000.1825 $74.65 1.0000 1.00000.4824 $74.70 1.0000 1.00000.8533 $74.75 1.0000 1.00001.0101 $74.80 1.0000 1.00000.8001 $74.85 1.0000 1.00000.4242 $74.90 1.0000 1.00000.1505 $74.95 1.0000 1.00000.0357 $75.00 1.0000 1.00000.0057 $75.05 1.0000 1.0000
0.0006 $75.10 1.0000 1.00000.0000 $75.15 1.0000 1.00000.0000 $75.20 1.0000 1.00000.0000 $75.25 1.0000 1.00000.0000 $75.30 1.0000 1.00000.0000 $75.35 1.0000 1.00000.0000 $75.40 1.0000 1.00000.0000 $75.45 1.0000 1.00000.0000 $75.50 1.0000 1.00000.0000 $75.55 1.0000 1.00000.0000 $75.60 1.0000 1.00000.0000 $75.65 1.0000 1.00000.0000 $75.70 1.0000 1.00000.0000 $75.75 1.0000 1.00000.0000 $75.80 1.0000 1.00000.0000 $75.85 1.0000 1.00000.0000 $75.90 1.0000 1.00000.0000 $75.95 1.0000 1.00000.0000 $76.00 1.0000 1.00000.0000 $76.05 1.0000 1.00000.0000 $76.10 1.0000 1.00000.0000 $76.15 1.0000 1.00000.0000 $76.20 1.0000 1.00000.0000 $76.25 1.0000 1.00000.0000 $76.30 1.0000 1.00000.0000 $76.35 1.0000 1.00000.0000 $76.40 1.0000 1.00000.0000 $76.45 1.0000 1.00000.0000 $76.50 1.0000 1.00000.0000 $76.55 1.0000 1.00000.0000 $76.60 1.0000 1.00000.0000 $76.65 1.0000 1.00000.0000 $76.70 1.0000 1.00000.0000 $76.75 1.0000 1.00000.0000 $76.80 1.0000 1.00000.0000 $76.85 1.0000 1.00000.0000 $76.90 1.0000 1.00000.0000 $76.95 1.0000 1.00000.0000 $77.00 1.0000 1.00000.0000 $77.05 1.0000 1.00000.0000 $77.10 1.0000 1.00000.0000 $77.15 1.0000 1.00000.0000 $77.20 1.0000 1.00000.0000 $77.25 1.0000 1.00000.0000 $77.30 1.0000 1.00000.0000 $77.35 1.0000 1.00000.0000 $77.40 1.0000 1.00000.0000 $77.45 1.0000 1.00000.0000 $77.50 1.0000 1.00000.0000 $77.55 1.0000 1.00000.0000 $77.60 1.0000 1.00000.0000 $77.65 1.0000 1.00000.0000 $77.70 1.0000 1.00000.0000 $77.75 1.0000 1.0000
0.0000 $77.80 1.0000 1.00000.0000 $77.85 1.0000 1.00000.0000 $77.90 1.0000 1.00000.0000 $77.95 1.0000 1.00000.0000 $78.00 1.0000 1.00000.0000 $78.05 1.0000 1.00000.0000 $78.10 1.0000 1.00000.0000 $78.15 1.0000 1.00000.0000 $78.20 1.0000 1.00000.0000 $78.25 1.0000 1.00000.0000 $78.30 1.0000 1.00000.0000 $78.35 1.0000 1.00000.0000 $78.40 1.0000 1.00000.0000 $78.45 1.0000 1.00000.0000 $78.50 1.0000 1.00000.0000 $78.55 1.0000 1.00000.0000 $78.60 1.0000 1.00000.0000 $78.65 1.0000 1.00000.0000 $78.70 1.0000 1.00000.0000 $78.75 1.0000 1.00000.0000 $78.80 1.0000 1.00000.0000 $78.85 1.0000 1.00000.0000 $78.90 1.0000 1.00000.0000 $78.95 1.0000 1.00000.0000 $79.00 1.0000 1.00000.0000 $79.05 1.0000 1.00000.0000 $79.10 1.0000 1.00000.0000 $79.15 1.0000 1.00000.0000 $79.20 1.0000 1.00000.0000 $79.25 1.0000 1.00000.0000 $79.30 1.0000 1.00000.0000 $79.35 1.0000 1.00000.0000 $79.40 1.0000 1.00000.0000 $79.45 1.0000 1.00000.0000 $79.50 1.0000 1.00000.0000 $79.55 1.0000 1.00000.0000 $79.60 1.0000 1.00000.0000 $79.65 1.0000 1.00000.0000 $79.70 1.0000 1.00000.0000 $79.75 1.0000 1.00000.0000 $79.80 1.0000 1.00000.0000 $79.85 1.0000 1.00000.0000 $79.90 1.0000 1.00000.0000 $79.95 1.0000 1.00000.0000 $80.00 1.0000 1.0000
$60 $62 $64 $66 $68 $70 $72 $74 $76 $78 $80 $82 $84 $86 $88 $90
Sample Size 250
Sample Size 100
SELECT 5*FLOOR(TotalPrice/5) as price, SUM(CASE WHEN State = 'CA' THEN 1 ELSE 0 END) as CA, SUM(CASE WHEN State = 'NY' THEN 1 ELSE 0 END) as NYFROM Orders oWHERE o.State IN ('CA', 'NY')GROUP BY 5*FLOOR(TotalPrice/5)ORDER BY price
$17,839 $53,537 85.48 70.14price CA NY CA (avg is NY (avg is $70.14)
$0 $711 $3,858 4.0% 7.2%$5 668 1,639 3.7% 3.1%
$10 2,202 7,753 12.3% 14.5%$15 2,440 7,394 13.7% 13.8%$20 2,306 6,753 12.9% 12.6%$25 1,951 5,739 10.9% 10.7%$30 1,283 3,687 7.2% 6.9%$35 588 1,877 3.3% 3.5%$40 516 1,420 2.9% 2.7%$45 386 1,058 2.2% 2.0%$50 375 1,111 2.1% 2.1%$55 167 520 0.9% 1.0%$60 192 584 1.1% 1.1%$65 141 362 0.8% 0.7%$70 87 302 0.5% 0.6%$75 92 222 0.5% 0.4%$80 91 377 0.5% 0.7%$85 166 623 0.9% 1.2%$90 55 123 0.3% 0.2%$95 116 272 0.7% 0.5%
$100 91 222 0.5% 0.4%$105 72 309 0.4% 0.6%$110 48 93 0.3% 0.2%$115 123 280 0.7% 0.5%$120 22 55 0.1% 0.1%$125 39 109 0.2% 0.2%$130 40 75 0.2% 0.1%$135 12 33 0.1% 0.1%$140 13 35 0.1% 0.1%$145 21 54 0.1% 0.1%$150 12 24 0.1% 0.0%$155 26 69 0.1% 0.1%$160 9 55 0.1% 0.1%$165 10 32 0.1% 0.1%$170 173 274 1.0% 0.5%$175 662 1,594 3.7% 3.0%$180 11 28 0.1% 0.1%$185 21 54 0.1% 0.1%$190 14 42 0.1% 0.1%$195 414 981 2.3% 1.8%$200 7 32 0.0% 0.1%$205 7 46 0.0% 0.1%
$0 $10 $20 $30 $40 $50 $60 $70 $80 $90 $100 $110 $120 $130 $140 $150
0%
2%
4%
6%
8%
10%
12%
14%
16%
CA (avg is $85.48)
$210 10 21 0.1% 0.0%$215 6 34 0.0% 0.1%$220 2 23 0.0% 0.0%$225 8 18 0.0% 0.0%$230 2 10 0.0% 0.0%$235 7 23 0.0% 0.0%$240 5 11 0.0% 0.0%$245 2 12 0.0% 0.0%$250 5 8 0.0% 0.0%$255 7 28 0.0% 0.1%$260 3 4 0.0% 0.0%$265 13 27 0.1% 0.1%$270 10 45 0.1% 0.1%$275 0 7 0.0% 0.0%$280 0 5 0.0% 0.0%$285 6 13 0.0% 0.0%$290 3 5 0.0% 0.0%$295 3 12 0.0% 0.0%$300 3 11 0.0% 0.0%$305 177 462 1.0% 0.9%$310 4 17 0.0% 0.0%$315 5 21 0.0% 0.0%$320 14 34 0.1% 0.1%$325 2 6 0.0% 0.0%$330 20 29 0.1% 0.1%$335 65 134 0.4% 0.3%$340 153 325 0.9% 0.6%$345 26 60 0.1% 0.1%$350 92 209 0.5% 0.4%$355 36 70 0.2% 0.1%$360 6 9 0.0% 0.0%$365 3 10 0.0% 0.0%$370 6 5 0.0% 0.0%$375 47 99 0.3% 0.2%$380 0 2 0.0% 0.0%$385 1 3 0.0% 0.0%$390 46 95 0.3% 0.2%$395 19 33 0.1% 0.1%$400 0 5 0.0% 0.0%$405 2 14 0.0% 0.0%$410 3 10 0.0% 0.0%$415 0 4 0.0% 0.0%$420 1 5 0.0% 0.0%$425 0 5 0.0% 0.0%$430 4 7 0.0% 0.0%$435 1 3 0.0% 0.0%$440 1 2 0.0% 0.0%$445 34 65 0.2% 0.1%$450 3 13 0.0% 0.0%$455 0 1 0.0% 0.0%$460 3 9 0.0% 0.0%$465 2 4 0.0% 0.0%$470 1 4 0.0% 0.0%$475 2 5 0.0% 0.0%
$480 0 2 0.0% 0.0%$485 63 148 0.4% 0.3%$495 23 41 0.1% 0.1%$500 5 9 0.0% 0.0%$505 1 0 0.0% 0.0%$510 10 14 0.1% 0.0%$515 3 2 0.0% 0.0%$520 9 21 0.1% 0.0%$525 27 42 0.2% 0.1%$530 3 6 0.0% 0.0%$535 5 1 0.0% 0.0%$540 57 105 0.3% 0.2%$545 1 5 0.0% 0.0%$550 0 1 0.0% 0.0%$555 1 3 0.0% 0.0%$560 2 3 0.0% 0.0%$565 0 2 0.0% 0.0%$570 2 8 0.0% 0.0%$575 2 11 0.0% 0.0%$580 2 5 0.0% 0.0%$585 14 32 0.1% 0.1%$590 0 1 0.0% 0.0%$595 3 4 0.0% 0.0%$600 2 9 0.0% 0.0%$605 1 2 0.0% 0.0%$610 21 55 0.1% 0.1%$615 0 1 0.0% 0.0%$620 1 1 0.0% 0.0%$625 1 9 0.0% 0.0%$630 3 4 0.0% 0.0%$635 1 2 0.0% 0.0%$640 4 5 0.0% 0.0%$645 3 8 0.0% 0.0%$650 0 1 0.0% 0.0%$655 0 2 0.0% 0.0%$660 1 1 0.0% 0.0%$665 4 5 0.0% 0.0%$670 12 41 0.1% 0.1%$675 9 16 0.1% 0.0%$680 17 33 0.1% 0.1%$685 1 3 0.0% 0.0%$690 5 5 0.0% 0.0%$695 2 1 0.0% 0.0%$700 10 23 0.1% 0.0%$705 1 1 0.0% 0.0%$710 3 4 0.0% 0.0%$715 0 1 0.0% 0.0%$720 1 6 0.0% 0.0%$730 0 1 0.0% 0.0%$735 0 2 0.0% 0.0%$740 0 3 0.0% 0.0%$745 14 21 0.1% 0.0%$750 6 9 0.0% 0.0%$755 5 8 0.0% 0.0%
$760 1 0 0.0% 0.0%$765 2 5 0.0% 0.0%$770 0 2 0.0% 0.0%$780 6 16 0.0% 0.0%$790 0 4 0.0% 0.0%$795 1 2 0.0% 0.0%$800 19 27 0.1% 0.1%$805 0 2 0.0% 0.0%$810 3 6 0.0% 0.0%$815 0 3 0.0% 0.0%$820 0 5 0.0% 0.0%$825 0 2 0.0% 0.0%$835 0 2 0.0% 0.0%$840 5 6 0.0% 0.0%$845 0 1 0.0% 0.0%$855 0 1 0.0% 0.0%$860 1 2 0.0% 0.0%$865 1 5 0.0% 0.0%$870 1 1 0.0% 0.0%$875 6 10 0.0% 0.0%$880 1 3 0.0% 0.0%$885 2 2 0.0% 0.0%$890 9 17 0.1% 0.0%$900 17 53 0.1% 0.1%$910 1 4 0.0% 0.0%$915 3 10 0.0% 0.0%$925 1 0 0.0% 0.0%$930 1 1 0.0% 0.0%$935 0 1 0.0% 0.0%$940 3 3 0.0% 0.0%$945 0 1 0.0% 0.0%$950 1 1 0.0% 0.0%$955 0 1 0.0% 0.0%$960 0 4 0.0% 0.0%$965 1 2 0.0% 0.0%$970 6 18 0.0% 0.0%$975 5 9 0.0% 0.0%$980 1 1 0.0% 0.0%$985 0 1 0.0% 0.0%$990 4 12 0.0% 0.0%
$1,000 2 10 0.0% 0.0%$1,010 3 3 0.0% 0.0%$1,015 0 1 0.0% 0.0%$1,020 3 5 0.0% 0.0%$1,025 1 0 0.0% 0.0%$1,030 0 1 0.0% 0.0%$1,035 1 3 0.0% 0.0%$1,045 0 1 0.0% 0.0%$1,050 1 3 0.0% 0.0%$1,060 0 3 0.0% 0.0%$1,065 0 2 0.0% 0.0%$1,070 0 1 0.0% 0.0%$1,075 1 1 0.0% 0.0%$1,080 4 9 0.0% 0.0%
$1,085 2 1 0.0% 0.0%$1,095 0 5 0.0% 0.0%$1,100 1 1 0.0% 0.0%$1,110 0 1 0.0% 0.0%$1,125 2 2 0.0% 0.0%$1,135 1 1 0.0% 0.0%$1,145 0 1 0.0% 0.0%$1,150 1 3 0.0% 0.0%$1,165 2 0 0.0% 0.0%$1,170 1 3 0.0% 0.0%$1,175 1 1 0.0% 0.0%$1,185 2 0 0.0% 0.0%$1,200 0 2 0.0% 0.0%$1,210 0 1 0.0% 0.0%$1,215 0 1 0.0% 0.0%$1,220 4 10 0.0% 0.0%$1,230 0 1 0.0% 0.0%$1,235 0 1 0.0% 0.0%$1,240 0 1 0.0% 0.0%$1,250 1 1 0.0% 0.0%$1,270 0 1 0.0% 0.0%$1,275 1 1 0.0% 0.0%$1,280 1 1 0.0% 0.0%$1,285 0 7 0.0% 0.0%$1,290 0 2 0.0% 0.0%$1,295 0 1 0.0% 0.0%$1,320 0 1 0.0% 0.0%$1,330 0 1 0.0% 0.0%$1,335 1 4 0.0% 0.0%$1,340 2 2 0.0% 0.0%$1,350 3 2 0.0% 0.0%$1,360 3 7 0.0% 0.0%$1,365 0 1 0.0% 0.0%$1,370 1 0 0.0% 0.0%$1,375 1 2 0.0% 0.0%$1,385 0 4 0.0% 0.0%$1,390 1 3 0.0% 0.0%$1,395 0 1 0.0% 0.0%$1,400 2 1 0.0% 0.0%$1,410 1 0 0.0% 0.0%$1,415 0 1 0.0% 0.0%$1,420 1 1 0.0% 0.0%$1,435 0 1 0.0% 0.0%$1,440 1 2 0.0% 0.0%$1,455 1 6 0.0% 0.0%$1,460 0 1 0.0% 0.0%$1,475 1 0 0.0% 0.0%$1,480 1 1 0.0% 0.0%$1,485 1 1 0.0% 0.0%$1,490 3 2 0.0% 0.0%$1,500 0 5 0.0% 0.0%$1,505 1 0 0.0% 0.0%$1,510 0 1 0.0% 0.0%$1,520 1 0 0.0% 0.0%
$1,530 1 1 0.0% 0.0%$1,540 0 2 0.0% 0.0%$1,545 1 2 0.0% 0.0%$1,550 1 3 0.0% 0.0%$1,560 0 4 0.0% 0.0%$1,575 0 1 0.0% 0.0%$1,600 3 1 0.0% 0.0%$1,615 0 2 0.0% 0.0%$1,620 0 2 0.0% 0.0%$1,625 0 2 0.0% 0.0%$1,635 1 0 0.0% 0.0%$1,640 0 1 0.0% 0.0%$1,645 1 2 0.0% 0.0%$1,665 2 2 0.0% 0.0%$1,675 1 1 0.0% 0.0%$1,685 0 1 0.0% 0.0%$1,700 0 3 0.0% 0.0%$1,705 0 1 0.0% 0.0%$1,710 1 0 0.0% 0.0%$1,740 0 1 0.0% 0.0%$1,750 1 1 0.0% 0.0%$1,755 1 0 0.0% 0.0%$1,760 1 0 0.0% 0.0%$1,765 0 3 0.0% 0.0%$1,780 0 1 0.0% 0.0%$1,795 2 1 0.0% 0.0%$1,800 1 1 0.0% 0.0%$1,825 2 0 0.0% 0.0%$1,835 0 3 0.0% 0.0%$1,870 0 4 0.0% 0.0%$1,895 1 0 0.0% 0.0%$1,900 1 1 0.0% 0.0%$1,915 0 1 0.0% 0.0%$1,925 0 1 0.0% 0.0%$1,935 0 1 0.0% 0.0%$1,940 1 2 0.0% 0.0%$1,945 1 1 0.0% 0.0%$1,950 0 2 0.0% 0.0%$1,965 0 2 0.0% 0.0%$1,990 0 1 0.0% 0.0%$2,010 0 2 0.0% 0.0%$2,015 0 1 0.0% 0.0%$2,040 0 1 0.0% 0.0%$2,055 0 1 0.0% 0.0%$2,060 0 1 0.0% 0.0%$2,080 0 1 0.0% 0.0%$2,085 1 1 0.0% 0.0%$2,100 1 0 0.0% 0.0%$2,140 0 2 0.0% 0.0%$2,160 0 1 0.0% 0.0%$2,175 0 1 0.0% 0.0%$2,180 0 1 0.0% 0.0%$2,185 1 0 0.0% 0.0%$2,190 1 0 0.0% 0.0%
$2,195 0 1 0.0% 0.0%$2,245 1 0 0.0% 0.0%$2,250 1 1 0.0% 0.0%$2,275 1 0 0.0% 0.0%$2,300 1 0 0.0% 0.0%$2,315 1 0 0.0% 0.0%$2,340 0 1 0.0% 0.0%$2,350 0 1 0.0% 0.0%$2,355 1 1 0.0% 0.0%$2,365 0 1 0.0% 0.0%$2,380 0 1 0.0% 0.0%$2,395 0 2 0.0% 0.0%$2,430 0 2 0.0% 0.0%$2,435 0 1 0.0% 0.0%$2,445 1 1 0.0% 0.0%$2,455 1 0 0.0% 0.0%$2,485 0 1 0.0% 0.0%$2,495 0 1 0.0% 0.0%$2,500 0 1 0.0% 0.0%$2,515 1 0 0.0% 0.0%$2,565 1 0 0.0% 0.0%$2,570 0 1 0.0% 0.0%$2,610 0 1 0.0% 0.0%$2,645 0 1 0.0% 0.0%$2,665 0 2 0.0% 0.0%$2,700 1 3 0.0% 0.0%$2,720 0 2 0.0% 0.0%$2,750 1 0 0.0% 0.0%$2,760 0 1 0.0% 0.0%$2,835 0 1 0.0% 0.0%$2,855 1 0 0.0% 0.0%$2,910 1 0 0.0% 0.0%$2,970 0 1 0.0% 0.0%$2,995 1 0 0.0% 0.0%$3,005 1 0 0.0% 0.0%$3,035 1 0 0.0% 0.0%$3,060 1 1 0.0% 0.0%$3,105 0 1 0.0% 0.0%$3,135 0 2 0.0% 0.0%$3,165 1 0 0.0% 0.0%$3,185 0 1 0.0% 0.0%$3,240 0 1 0.0% 0.0%$3,260 0 1 0.0% 0.0%$3,295 0 1 0.0% 0.0%$3,300 0 1 0.0% 0.0%$3,330 0 1 0.0% 0.0%$3,350 0 1 0.0% 0.0%$3,360 0 1 0.0% 0.0%$3,385 0 1 0.0% 0.0%$3,400 1 0 0.0% 0.0%$3,425 1 0 0.0% 0.0%$3,465 1 0 0.0% 0.0%$3,535 0 1 0.0% 0.0%$3,750 1 0 0.0% 0.0%
$3,805 0 1 0.0% 0.0%$4,050 1 0 0.0% 0.0%$4,130 1 0 0.0% 0.0%$4,205 0 1 0.0% 0.0%$4,240 0 1 0.0% 0.0%$4,320 0 1 0.0% 0.0%$4,375 1 0 0.0% 0.0%$4,420 0 1 0.0% 0.0%$4,475 1 0 0.0% 0.0%$4,530 0 1 0.0% 0.0%$4,585 0 1 0.0% 0.0%$4,590 0 1 0.0% 0.0%$4,735 0 1 0.0% 0.0%$4,950 0 1 0.0% 0.0%$5,040 0 1 0.0% 0.0%$5,045 0 1 0.0% 0.0%$5,130 1 0 0.0% 0.0%$5,500 0 1 0.0% 0.0%$5,960 0 1 0.0% 0.0%$6,060 0 1 0.0% 0.0%$6,250 1 0 0.0% 0.0%$6,295 1 0 0.0% 0.0%$6,565 0 1 0.0% 0.0%$6,605 0 1 0.0% 0.0%$6,685 0 1 0.0% 0.0%$6,920 1 0 0.0% 0.0%$8,830 1 0 0.0% 0.0%
$0 $10 $20 $30 $40 $50 $60 $70 $80 $90 $100 $110 $120 $130 $140 $150
0%
2%
4%
6%
8%
10%
12%
14%
16%
CA (avg is $85.48)
SELECT AVG(1.0 * IsActive)FROM Subscribers s
(No column name)47.18%
WITH s as ( SELECT s.*, ROW_NUMBER() OVER (ORDER BY SubscriberId) as seqnum FROM Subscribers s )SELECT AVG(1.0 * IsActive)FROM sWHERE (seqnum * 17 + 59) % 101 < 1
(No column name)47.28%
WITH s as ( SELECT s.*, ROW_NUMBER() OVER (ORDER BY IsActive) as seqnum FROM Subscribers s )SELECT AVG(IsActive*1.0)FROM sWHERE seqnum % 100 = 1;
(No column name)47.18%
WITH s as ( SELECT s.*, ROW_NUMBER() OVER (ORDER BY Market, IsActive) as seqnum FROM Subscribers s )SELECT AVG(IsActive*1.0)FROM sWHERE seqnum % 100 = 1;
(No column name)47.18%
SELECT TOP 200 OrderDate, WITH o as ( (CASE WHEN PaymentType = 'AE' THEN TotalPrice END) as AE, SELECT o.*, (CASE WHEN PaymentType = 'AE' THEN NULL ROW_NUMBER() OVER (PARTITION BY isae ORDER BY NEWID()) as seqnum ELSE TotalPrice END) as NotAE FROM (SELECT o.*,FROM Orders (CASE WHEN PaymentType = 'AE' THEN 1 ELSE 0 END) as IsAEWHERE TotalPrice <= 200 FROM Orders oORDER BY NEWID() WHERE TotalPrice <= 200
) o )SELECT OrderDate, (CASE WHEN isae = 1 THEN TotalPrice END) as AE, (CASE WHEN isae = 0 THEN TotalPrice END) as NotAE
FROM oWHERE seqnum <= 100;
OrderDate AE NotAE AE NotAE2015-07-26 $42.41 NULL $42.41 #N/A2015-06-01 NULL $19.95 #N/A $19.952015-09-21 NULL $24.95 #N/A $24.952013-02-15 NULL $18.51 #N/A $18.512015-11-23 $195.00 NULL $195.00 #N/A2014-06-06 NULL $25.95 #N/A $25.952012-12-03 NULL $173.55 #N/A $173.552012-08-30 NULL $24.95 #N/A $24.952015-11-30 NULL $35.04 #N/A $35.042013-10-12 NULL $34.95 #N/A $34.952016-07-18 NULL $24.95 #N/A $24.952015-01-27 NULL $17.95 #N/A $17.952013-03-21 NULL $13.50 #N/A $13.502010-09-20 NULL $67.50 #N/A $67.502014-08-15 NULL $0.00 #N/A $0.002011-01-09 NULL $20.25 #N/A $20.252015-04-13 $18.00 NULL $18.00 #N/A2014-09-24 NULL $43.78 #N/A $43.782013-09-20 NULL $0.00 #N/A $0.002013-05-31 NULL $27.00 #N/A $27.002012-10-10 NULL $0.00 #N/A $0.002014-05-01 $14.40 NULL $14.40 #N/A2014-07-13 NULL $25.95 #N/A $25.952013-12-21 NULL $29.95 #N/A $29.952013-02-24 NULL $30.21 #N/A $30.212012-11-08 NULL $22.50 #N/A $22.502011-12-09 NULL $17.41 #N/A $17.412010-11-23 NULL $10.00 #N/A $10.002013-11-12 NULL $14.40 #N/A $14.402011-12-29 $15.25 NULL $15.25 #N/A2014-04-25 NULL $29.95 #N/A $29.952014-12-09 NULL $89.96 #N/A $89.962011-03-19 NULL $18.00 #N/A $18.002015-03-09 NULL $44.95 #N/A $44.952015-11-09 $89.95 NULL $89.95 #N/A2012-06-01 $32.40 NULL $32.40 #N/A2015-01-08 $29.95 NULL $29.95 #N/A2014-09-12 NULL $25.95 #N/A $25.952010-11-21 NULL $90.00 #N/A $90.002014-05-21 $14.00 NULL $14.00 #N/A2016-03-28 NULL $25.95 #N/A $25.952011-11-05 NULL $39.95 #N/A $39.952014-10-18 NULL $70.90 #N/A $70.902013-12-30 NULL $15.30 #N/A $15.302015-11-27 NULL $46.70 #N/A $46.702014-09-23 NULL $116.95 #N/A $116.952012-05-15 NULL $61.65 #N/A $61.652010-12-07 NULL $107.49 #N/A $107.492009-11-09 NULL $24.95 #N/A $24.952013-06-30 NULL $30.00 #N/A $30.002009-10-23 $40.00 NULL $40.00 #N/A2015-11-27 NULL $16.15 #N/A $16.152016-08-31 $59.90 NULL $59.90 #N/A
2013-08-21 NULL $0.00 #N/A $0.002014-06-25 NULL $53.90 #N/A $53.902015-05-25 NULL $17.90 #N/A $17.902011-03-11 NULL $15.95 #N/A $15.952013-01-23 NULL $195.00 #N/A $195.002009-10-26 NULL $20.00 #N/A $20.002013-09-28 NULL $34.95 #N/A $34.952011-01-11 NULL $10.00 #N/A $10.002016-04-28 NULL $0.00 #N/A $0.002014-12-28 NULL $38.95 #N/A $38.952014-12-08 NULL $41.90 #N/A $41.902013-01-09 $13.30 NULL $13.30 #N/A2012-10-16 $42.95 NULL $42.95 #N/A2013-12-05 NULL $19.88 #N/A $19.882013-09-20 NULL $58.95 #N/A $58.952012-03-04 NULL $15.97 #N/A $15.972015-02-02 NULL $25.95 #N/A $25.952011-08-28 NULL $0.00 #N/A $0.002013-12-18 $62.96 NULL $62.96 #N/A2012-03-14 NULL $175.00 #N/A $175.002014-07-30 $13.45 NULL $13.45 #N/A2011-01-02 $10.00 NULL $10.00 #N/A2015-05-28 NULL $23.35 #N/A $23.352014-11-24 $25.95 NULL $25.95 #N/A2010-11-24 NULL $20.00 #N/A $20.002014-07-26 $26.95 NULL $26.95 #N/A2012-05-14 NULL $35.25 #N/A $35.252015-10-17 NULL $13.50 #N/A $13.502016-01-24 NULL $13.50 #N/A $13.502009-11-18 NULL $20.00 #N/A $20.002011-05-20 NULL $19.57 #N/A $19.572014-11-12 NULL $25.95 #N/A $25.952015-06-15 $13.50 NULL $13.50 #N/A2013-02-18 NULL $15.25 #N/A $15.252015-04-23 NULL $6.50 #N/A $6.502014-08-16 NULL $0.00 #N/A $0.002014-11-24 $54.95 NULL $54.95 #N/A2013-05-20 NULL $12.95 #N/A $12.952014-01-12 NULL $16.15 #N/A $16.152014-12-30 NULL $125.00 #N/A $125.002013-12-09 NULL $59.90 #N/A $59.902014-06-23 NULL $23.35 #N/A $23.352013-08-06 NULL $81.42 #N/A $81.422012-12-03 NULL $14.40 #N/A $14.402012-02-07 NULL $175.00 #N/A $175.002014-01-08 NULL $19.12 #N/A $19.122013-12-26 $24.45 NULL $24.45 #N/A2011-02-02 NULL $0.00 #N/A $0.002013-12-21 NULL $0.00 #N/A $0.002011-01-25 $22.50 NULL $22.50 #N/A2014-12-06 $26.95 NULL $26.95 #N/A2016-06-13 $20.00 NULL $20.00 #N/A2014-10-07 NULL $195.00 #N/A $195.002010-08-04 NULL $19.68 #N/A $19.682014-06-08 NULL $25.95 #N/A $25.952013-12-03 $13.50 NULL $13.50 #N/A2014-07-10 NULL $23.35 #N/A $23.35
2013-11-17 NULL $18.95 #N/A $18.952014-12-12 NULL $25.95 #N/A $25.952016-02-10 $13.45 NULL $13.45 #N/A2011-01-07 NULL $20.00 #N/A $20.002012-12-04 $29.95 NULL $29.95 #N/A2014-09-22 NULL $87.25 #N/A $87.252014-08-27 NULL $25.90 #N/A $25.902011-08-14 $34.95 NULL $34.95 #N/A2015-04-09 NULL $0.00 #N/A $0.002013-11-25 NULL $26.95 #N/A $26.952010-12-22 $99.99 NULL $99.99 #N/A2015-03-06 NULL $16.14 #N/A $16.142011-02-14 NULL $0.00 #N/A $0.002011-10-10 NULL $20.25 #N/A $20.252011-06-11 NULL $17.61 #N/A $17.612011-12-21 NULL $16.15 #N/A $16.152011-12-10 NULL $16.15 #N/A $16.152014-01-06 $53.90 NULL $53.90 #N/A2009-12-10 NULL $10.00 #N/A $10.002014-11-25 NULL $54.95 #N/A $54.952011-10-16 NULL $175.00 #N/A $175.002012-08-23 NULL $20.25 #N/A $20.252014-08-14 NULL $0.00 #N/A $0.002014-05-27 NULL $26.95 #N/A $26.952016-06-06 NULL $17.95 #N/A $17.952014-08-12 NULL $62.95 #N/A $62.952013-11-17 $40.50 NULL $40.50 #N/A2015-10-29 $31.50 NULL $31.50 #N/A2015-06-05 $23.35 NULL $23.35 #N/A2012-03-22 NULL $11.50 #N/A $11.502012-10-20 NULL $20.25 #N/A $20.252012-11-13 NULL $18.51 #N/A $18.512012-01-27 NULL $18.00 #N/A $18.002014-09-22 $53.00 NULL $53.00 #N/A2014-11-25 $46.70 NULL $46.70 #N/A2013-07-19 NULL $33.90 #N/A $33.902014-01-07 NULL $16.95 #N/A $16.952014-08-22 NULL $0.00 #N/A $0.002014-02-11 NULL $18.00 #N/A $18.002015-11-06 $8.95 NULL $8.95 #N/A2011-02-17 NULL $60.00 #N/A $60.002009-11-12 $14.95 NULL $14.95 #N/A2014-02-03 NULL $16.00 #N/A $16.002014-12-12 $175.50 NULL $175.50 #N/A2014-12-23 NULL $0.00 #N/A $0.002011-08-28 NULL $34.95 #N/A $34.952012-11-25 NULL $38.40 #N/A $38.402014-08-11 NULL $44.95 #N/A $44.952014-07-10 $24.95 NULL $24.95 #N/A2012-06-21 NULL $37.82 #N/A $37.822013-01-25 NULL $8.00 #N/A $8.002011-12-13 NULL $13.45 #N/A $13.452015-02-16 NULL $15.00 #N/A $15.002013-11-25 NULL $35.95 #N/A $35.952015-11-30 NULL $42.25 #N/A $42.252013-04-23 NULL $193.42 #N/A $193.422015-09-16 NULL $6.99 #N/A $6.99
2011-06-24 NULL $20.25 #N/A $20.252013-07-18 NULL $10.95 #N/A $10.952014-12-11 NULL $18.00 #N/A $18.002014-12-08 NULL $35.00 #N/A $35.002014-05-23 NULL $23.35 #N/A $23.352014-11-30 NULL $75.58 #N/A $75.582013-08-05 $31.35 NULL $31.35 #N/A2015-01-04 NULL $23.35 #N/A $23.352012-01-03 NULL $16.15 #N/A $16.152011-02-01 NULL $0.00 #N/A $0.002012-11-06 $25.90 NULL $25.90 #N/A2016-06-15 NULL $195.00 #N/A $195.002012-01-04 NULL $19.57 #N/A $19.572014-07-28 $26.95 NULL $26.95 #N/A2013-12-07 NULL $64.72 #N/A $64.722014-09-20 $17.61 NULL $17.61 #N/A2011-11-13 NULL $18.00 #N/A $18.002012-11-02 $12.95 NULL $12.95 #N/A2009-11-14 NULL $10.00 #N/A $10.002014-12-09 $25.95 NULL $25.95 #N/A2016-06-23 NULL $22.95 #N/A $22.952013-08-21 NULL $48.50 #N/A $48.502014-12-02 NULL $31.45 #N/A $31.452014-11-11 NULL $12.95 #N/A $12.952011-07-01 NULL $195.00 #N/A $195.002015-01-13 NULL $25.95 #N/A $25.952013-12-10 NULL $25.94 #N/A $25.942011-01-07 $10.00 NULL $10.00 #N/A2012-06-28 NULL $31.45 #N/A $31.452012-10-11 NULL $44.51 #N/A $44.512012-06-06 NULL $20.02 #N/A $20.022012-07-31 NULL $18.00 #N/A $18.002014-09-19 NULL $34.95 #N/A $34.95
WITH o as ( SELECT o.*, ROW_NUMBER() OVER (PARTITION BY isae ORDER BY NEWID()) as seqnum FROM (SELECT o.*, (CASE WHEN PaymentType = 'AE' THEN 1 ELSE 0 END) as IsAE FROM Orders o WHERE TotalPrice <= 200
SELECT OrderDate, (CASE WHEN isae = 1 THEN TotalPrice END) as AE, (CASE WHEN isae = 0 THEN TotalPrice END) as NotAE
WHERE seqnum <= 100;
OrderDate AE NotAE AE NotAE2010-12-21 NULL $10.00 #N/A $10.002012-02-05 NULL $31.45 #N/A $31.452009-10-28 NULL $14.95 #N/A $14.952014-12-09 NULL $0.00 #N/A $0.002014-11-24 NULL $99.95 #N/A $99.952014-09-05 NULL $14.40 #N/A $14.402015-11-10 NULL $35.00 #N/A $35.002014-08-04 NULL $0.00 #N/A $0.002014-07-27 NULL $49.97 #N/A $49.972015-05-18 NULL $0.00 #N/A $0.002013-12-05 NULL $16.89 #N/A $16.892016-01-17 NULL $80.85 #N/A $80.852014-06-27 NULL $12.95 #N/A $12.952013-05-07 NULL $26.95 #N/A $26.952016-06-16 NULL $29.95 #N/A $29.952009-11-14 NULL $0.00 #N/A $0.002014-08-16 NULL $0.00 #N/A $0.002016-07-10 NULL $16.95 #N/A $16.952012-04-19 NULL $195.00 #N/A $195.002015-01-07 NULL $30.00 #N/A $30.002013-12-04 NULL $49.90 #N/A $49.902010-11-16 NULL $35.00 #N/A $35.002009-12-23 NULL $19.63 #N/A $19.632015-03-26 NULL $47.90 #N/A $47.902011-01-13 NULL $10.00 #N/A $10.002016-01-12 NULL $23.35 #N/A $23.352014-10-08 NULL $0.00 #N/A $0.002011-08-13 NULL $34.95 #N/A $34.952011-04-12 NULL $25.00 #N/A $25.002014-08-16 NULL $26.95 #N/A $26.952014-05-30 NULL $16.00 #N/A $16.002009-12-23 NULL $0.00 #N/A $0.002012-03-12 NULL $118.00 #N/A $118.002015-09-15 NULL $21.00 #N/A $21.002011-04-30 NULL $173.55 #N/A $173.552011-12-31 NULL $31.10 #N/A $31.102012-12-10 NULL $18.51 #N/A $18.512009-10-10 NULL $19.68 #N/A $19.682011-02-15 NULL $20.00 #N/A $20.002011-01-17 NULL $10.00 #N/A $10.002014-02-27 NULL $31.15 #N/A $31.152012-02-10 NULL $26.90 #N/A $26.902013-12-29 NULL $46.90 #N/A $46.902014-02-17 NULL $16.95 #N/A $16.952015-12-17 NULL $0.00 #N/A $0.002013-09-13 NULL $9.86 #N/A $9.862015-12-12 NULL $175.50 #N/A $175.502013-05-13 NULL $27.00 #N/A $27.002015-06-22 NULL $29.95 #N/A $29.952014-11-11 NULL $78.10 #N/A $78.102014-03-03 NULL $11.95 #N/A $11.952014-12-09 NULL $34.95 #N/A $34.952016-04-24 NULL $119.95 #N/A $119.95
$0
$20
$40
$60
$80
$100
$120
$140
$160
$180
$200
AE NotAE
$0
$20
$40
$60
$80
$100
$120
$140
$160
$180
$200
AE NotAE
2015-01-05 NULL $24.75 #N/A $24.752012-01-29 NULL $65.85 #N/A $65.852010-12-21 NULL $7.50 #N/A $7.502014-08-18 NULL $29.95 #N/A $29.952014-07-31 NULL $29.95 #N/A $29.952014-10-18 NULL $54.95 #N/A $54.952014-09-26 NULL $21.89 #N/A $21.892012-12-17 NULL $195.00 #N/A $195.002011-02-07 NULL $13.45 #N/A $13.452014-10-13 NULL $31.45 #N/A $31.452011-06-27 NULL $19.57 #N/A $19.572015-12-14 NULL $41.30 #N/A $41.302016-08-18 NULL $44.95 #N/A $44.952013-12-06 NULL $29.95 #N/A $29.952015-04-13 NULL $142.70 #N/A $142.702014-12-08 NULL $17.00 #N/A $17.002014-09-05 NULL $11.65 #N/A $11.652015-05-02 NULL $10.36 #N/A $10.362014-07-07 NULL $12.95 #N/A $12.952014-12-19 NULL $63.90 #N/A $63.902013-12-02 NULL $9.95 #N/A $9.952009-12-03 NULL $14.95 #N/A $14.952011-08-28 NULL $17.00 #N/A $17.002015-10-06 NULL $49.45 #N/A $49.452014-11-15 NULL $24.95 #N/A $24.952014-04-24 NULL $107.80 #N/A $107.802014-05-01 NULL $25.95 #N/A $25.952013-01-20 NULL $173.55 #N/A $173.552012-02-03 NULL $31.45 #N/A $31.452015-05-19 NULL $18.95 #N/A $18.952014-02-19 NULL $10.75 #N/A $10.752014-09-03 NULL $103.14 #N/A $103.142014-06-10 NULL $31.45 #N/A $31.452014-11-24 NULL $15.95 #N/A $15.952013-11-12 NULL $36.00 #N/A $36.002015-02-25 NULL $175.50 #N/A $175.502015-10-12 NULL $72.75 #N/A $72.752013-05-15 NULL $90.00 #N/A $90.002014-06-16 NULL $11.90 #N/A $11.902013-12-15 NULL $16.95 #N/A $16.952016-06-01 NULL $18.95 #N/A $18.952013-03-25 NULL $27.00 #N/A $27.002012-12-16 NULL $14.40 #N/A $14.402013-12-03 NULL $21.90 #N/A $21.902014-10-21 NULL $0.00 #N/A $0.002014-06-30 NULL $29.95 #N/A $29.952014-09-27 NULL $27.00 #N/A $27.002011-07-24 $22.50 NULL $22.50 #N/A2011-10-26 $57.56 NULL $57.56 #N/A2014-12-19 $89.96 NULL $89.96 #N/A2015-10-31 $31.50 NULL $31.50 #N/A2012-11-02 $66.00 NULL $66.00 #N/A2011-01-01 $10.00 NULL $10.00 #N/A2014-06-30 $23.35 NULL $23.35 #N/A2014-12-31 $51.90 NULL $51.90 #N/A2011-12-29 $6.75 NULL $6.75 #N/A2012-12-20 $29.75 NULL $29.75 #N/A
2016-04-19 $10.75 NULL $10.75 #N/A2015-05-11 $46.70 NULL $46.70 #N/A2013-10-11 $24.45 NULL $24.45 #N/A2016-05-13 $26.95 NULL $26.95 #N/A2011-01-17 $22.50 NULL $22.50 #N/A2015-01-12 $23.30 NULL $23.30 #N/A2015-12-27 $31.50 NULL $31.50 #N/A2009-10-26 $24.95 NULL $24.95 #N/A2010-11-27 $24.95 NULL $24.95 #N/A2016-08-24 $31.50 NULL $31.50 #N/A2010-11-24 $199.95 NULL $199.95 #N/A2009-12-28 $19.68 NULL $19.68 #N/A2011-03-17 $195.00 NULL $195.00 #N/A2012-11-27 $17.95 NULL $17.95 #N/A2012-12-27 $16.66 NULL $16.66 #N/A2014-09-09 $25.95 NULL $25.95 #N/A2010-11-29 $17.50 NULL $17.50 #N/A2016-04-07 $195.00 NULL $195.00 #N/A2014-04-25 $175.50 NULL $175.50 #N/A2011-09-23 $22.50 NULL $22.50 #N/A2016-05-21 $195.00 NULL $195.00 #N/A2014-12-10 $29.65 NULL $29.65 #N/A2014-12-06 $89.95 NULL $89.95 #N/A2014-09-05 $116.95 NULL $116.95 #N/A2016-03-20 $17.95 NULL $17.95 #N/A2013-01-27 $15.00 NULL $15.00 #N/A2010-11-04 $45.00 NULL $45.00 #N/A2014-06-11 $49.95 NULL $49.95 #N/A2010-03-09 $49.95 NULL $49.95 #N/A2014-05-19 $175.50 NULL $175.50 #N/A2011-12-13 $195.00 NULL $195.00 #N/A2010-09-13 $18.00 NULL $18.00 #N/A2015-12-08 $192.85 NULL $192.85 #N/A2014-05-29 $31.45 NULL $31.45 #N/A2010-12-31 $35.95 NULL $35.95 #N/A2015-10-21 $107.95 NULL $107.95 #N/A2015-01-28 $161.90 NULL $161.90 #N/A2013-01-22 $10.95 NULL $10.95 #N/A2013-01-28 $10.95 NULL $10.95 #N/A2010-05-24 $175.00 NULL $175.00 #N/A2014-12-03 $175.50 NULL $175.50 #N/A2014-03-05 $10.75 NULL $10.75 #N/A2014-07-11 $53.90 NULL $53.90 #N/A2010-07-20 $10.95 NULL $10.95 #N/A2011-07-19 $20.25 NULL $20.25 #N/A2015-09-10 $35.00 NULL $35.00 #N/A2012-02-26 $175.00 NULL $175.00 #N/A2014-11-30 $77.85 NULL $77.85 #N/A2010-12-13 $13.00 NULL $13.00 #N/A2011-05-20 $21.00 NULL $21.00 #N/A2015-06-17 $31.50 NULL $31.50 #N/A2011-08-14 $34.95 NULL $34.95 #N/A2011-12-12 $175.00 NULL $175.00 #N/A2009-10-04 $10.00 NULL $10.00 #N/A2013-07-10 $59.90 NULL $59.90 #N/A2015-01-20 $89.95 NULL $89.95 #N/A2009-11-29 $14.95 NULL $14.95 #N/A
2012-01-10 $62.90 NULL $62.90 #N/A2015-12-08 $63.00 NULL $63.00 #N/A2011-07-03 $20.25 NULL $20.25 #N/A2013-04-11 $13.30 NULL $13.30 #N/A2011-03-18 $16.15 NULL $16.15 #N/A2011-05-24 $17.00 NULL $17.00 #N/A2016-08-15 $22.95 NULL $22.95 #N/A2011-05-07 $62.00 NULL $62.00 #N/A2012-02-04 $7.75 NULL $7.75 #N/A2015-05-26 $39.95 NULL $39.95 #N/A2009-10-05 $10.00 NULL $10.00 #N/A2015-08-17 $13.50 NULL $13.50 #N/A2012-11-14 $20.25 NULL $20.25 #N/A2014-06-09 $31.50 NULL $31.50 #N/A2011-01-19 $175.00 NULL $175.00 #N/A2013-02-27 $30.00 NULL $30.00 #N/A2013-12-02 $195.00 NULL $195.00 #N/A2014-12-16 $14.00 NULL $14.00 #N/A2012-11-26 $46.50 NULL $46.50 #N/A2015-01-20 $183.95 NULL $183.95 #N/A2016-06-20 $133.50 NULL $133.50 #N/A2014-06-18 $51.90 NULL $51.90 #N/A2014-07-24 $26.95 NULL $26.95 #N/A2010-12-29 $40.00 NULL $40.00 #N/A2012-07-09 $26.95 NULL $26.95 #N/A2011-12-17 $65.95 NULL $65.95 #N/A2015-04-08 $25.95 NULL $25.95 #N/A2014-10-08 $31.45 NULL $31.45 #N/A2009-10-04 $10.00 NULL $10.00 #N/A2010-12-14 $29.95 NULL $29.95 #N/A2013-05-14 $17.00 NULL $17.00 #N/A2016-02-23 $10.75 NULL $10.75 #N/A2015-10-19 $98.90 NULL $98.90 #N/A
$0
$20
$40
$60
$80
$100
$120
$140
$160
$180
$200
AE NotAE
$0
$20
$40
$60
$80
$100
$120
$140
$160
$180
$200
AE NotAE
10 45 -0.628319X Y ALL A
1 A 0.00 1.00 A 0.00 1.00 1.00002 B 0.59 0.81 B 0.59 0.81 #N/A3 C 0.95 0.31 C 0.95 0.31 #N/A4 D 0.95 -0.31 D 0.95 -0.31 #N/A5 E 0.59 -0.81 E 0.59 -0.81 #N/A6 F 0.00 -1.00 F 0.00 -1.00 #N/A7 G -0.59 -0.81 G -0.59 -0.81 #N/A8 H -0.95 -0.31 H -0.95 -0.31 #N/A9 I -0.95 0.31 I -0.95 0.31 #N/A
10 J -0.59 0.81 J -0.59 0.81 #N/A
START END1 2 START A B 0.0000 1.00001 2 END A B 0.5878 0.80901 2 BLANK A B #N/A #N/A1 3 START A C 0.0000 1.00001 3 END A C 0.9511 0.30901 3 BLANK A C #N/A #N/A1 4 START A D 0.0000 1.00001 4 END A D 0.9511 -0.30901 4 BLANK A D #N/A #N/A1 5 START A E 0.0000 1.00001 5 END A E 0.5878 -0.80901 5 BLANK A E #N/A #N/A1 6 START A F 0.0000 1.00001 6 END A F 0.0000 -1.00001 6 BLANK A F #N/A #N/A1 7 START A G 0.0000 1.00001 7 END A G -0.5878 -0.80901 7 BLANK A G #N/A #N/A1 8 START A H 0.0000 1.00001 8 END A H -0.9511 -0.30901 8 BLANK A H #N/A #N/A1 9 START A I 0.0000 1.00001 9 END A I -0.9511 0.30901 9 BLANK A I #N/A #N/A1 10 START A J 0.0000 1.00001 10 END A J -0.5878 0.80901 10 BLANK A J #N/A #N/A2 3 START B C 0.5878 0.80902 3 END B C 0.9511 0.30902 3 BLANK B C #N/A #N/A2 4 START B D 0.5878 0.80902 4 END B D 0.9511 -0.30902 4 BLANK B D #N/A #N/A2 5 START B E 0.5878 0.80902 5 END B E 0.5878 -0.80902 5 BLANK B E #N/A #N/A2 6 START B F 0.5878 0.80902 6 END B F 0.0000 -1.0000
2 6 BLANK B F #N/A #N/A2 7 START B G 0.5878 0.80902 7 END B G -0.5878 -0.80902 7 BLANK B G #N/A #N/A2 8 START B H 0.5878 0.80902 8 END B H -0.9511 -0.30902 8 BLANK B H #N/A #N/A2 9 START B I 0.5878 0.80902 9 END B I -0.9511 0.30902 9 BLANK B I #N/A #N/A2 10 START B J 0.5878 0.80902 10 END B J -0.5878 0.80902 10 BLANK B J #N/A #N/A3 4 START C D 0.9511 0.30903 4 END C D 0.9511 -0.30903 4 BLANK C D #N/A #N/A3 5 START C E 0.9511 0.30903 5 END C E 0.5878 -0.80903 5 BLANK C E #N/A #N/A3 6 START C F 0.9511 0.30903 6 END C F 0.0000 -1.00003 6 BLANK C F #N/A #N/A3 7 START C G 0.9511 0.30903 7 END C G -0.5878 -0.80903 7 BLANK C G #N/A #N/A3 8 START C H 0.9511 0.30903 8 END C H -0.9511 -0.30903 8 BLANK C H #N/A #N/A3 9 START C I 0.9511 0.30903 9 END C I -0.9511 0.30903 9 BLANK C I #N/A #N/A3 10 START C J 0.9511 0.30903 10 END C J -0.5878 0.80903 10 BLANK C J #N/A #N/A4 5 START D E 0.9511 -0.30904 5 END D E 0.5878 -0.80904 5 BLANK D E #N/A #N/A4 6 START D F 0.9511 -0.30904 6 END D F 0.0000 -1.00004 6 BLANK D F #N/A #N/A4 7 START D G 0.9511 -0.30904 7 END D G -0.5878 -0.80904 7 BLANK D G #N/A #N/A4 8 START D H 0.9511 -0.30904 8 END D H -0.9511 -0.30904 8 BLANK D H #N/A #N/A4 9 START D I 0.9511 -0.30904 9 END D I -0.9511 0.30904 9 BLANK D I #N/A #N/A4 10 START D J 0.9511 -0.30904 10 END D J -0.5878 0.80904 10 BLANK D J #N/A #N/A5 6 START E F 0.5878 -0.80905 6 END E F 0.0000 -1.0000
5 6 BLANK E F #N/A #N/A5 7 START E G 0.5878 -0.80905 7 END E G -0.5878 -0.80905 7 BLANK E G #N/A #N/A5 8 START E H 0.5878 -0.80905 8 END E H -0.9511 -0.30905 8 BLANK E H #N/A #N/A5 9 START E I 0.5878 -0.80905 9 END E I -0.9511 0.30905 9 BLANK E I #N/A #N/A5 10 START E J 0.5878 -0.80905 10 END E J -0.5878 0.80905 10 BLANK E J #N/A #N/A6 7 START F G 0.0000 -1.00006 7 END F G -0.5878 -0.80906 7 BLANK F G #N/A #N/A6 8 START F H 0.0000 -1.00006 8 END F H -0.9511 -0.30906 8 BLANK F H #N/A #N/A6 9 START F I 0.0000 -1.00006 9 END F I -0.9511 0.30906 9 BLANK F I #N/A #N/A6 10 START F J 0.0000 -1.00006 10 END F J -0.5878 0.80906 10 BLANK F J #N/A #N/A7 8 START G H -0.5878 -0.80907 8 END G H -0.9511 -0.30907 8 BLANK G H #N/A #N/A7 9 START G I -0.5878 -0.80907 9 END G I -0.9511 0.30907 9 BLANK G I #N/A #N/A7 10 START G J -0.5878 -0.80907 10 END G J -0.5878 0.80907 10 BLANK G J #N/A #N/A8 9 START H I -0.9511 -0.30908 9 END H I -0.9511 0.30908 9 BLANK H I #N/A #N/A8 10 START H J -0.9511 -0.30908 10 END H J -0.5878 0.80908 10 BLANK H J #N/A #N/A9 10 START I J -0.9511 0.30909 10 END I J -0.5878 0.80909 10 BLANK I J #N/A #N/A
B C D E F G H I J#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A
0.8090 #N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A#N/A 0.3090 #N/A #N/A #N/A #N/A #N/A #N/A #N/A#N/A #N/A -0.3090 #N/A #N/A #N/A #N/A #N/A #N/A#N/A #N/A #N/A -0.8090 #N/A #N/A #N/A #N/A #N/A#N/A #N/A #N/A #N/A -1.0000 #N/A #N/A #N/A #N/A#N/A #N/A #N/A #N/A #N/A -0.8090 #N/A #N/A #N/A#N/A #N/A #N/A #N/A #N/A #N/A -0.3090 #N/A #N/A#N/A #N/A #N/A #N/A #N/A #N/A #N/A 0.3090 #N/A#N/A #N/A #N/A #N/A #N/A #N/A #N/A #N/A 0.8090
Y-ValueX-Value ALL A B C D E F G H
A 0.00 1.00 1.00B 0.59 0.81 0.81C 0.95 0.31 0.31D 0.95 -0.31 -0.31E 0.59 -0.81 -0.81F 0.00 -1.00 -1.00G -0.59 -0.81 -0.81H -0.95 -0.31 -0.31I -0.95 0.31J -0.59 0.81
Y-ValueI J
0.310.81
16 8 4 2 1 M FPerson #1Person #2Person #3Person #4Person #5# M # F
1 M M M M M 5 02 M M M M F 4 13 M M M F M 4 14 M M M F F 3 25 M M F M M 4 16 M M F M F 3 27 M M F F M 3 28 M M F F F 2 39 M F M M M 4 1
10 M F M M F 3 211 M F M F M 3 212 M F M F F 2 313 M F F M M 3 214 M F F M F 2 315 M F F F M 2 316 M F F F F 1 417 F M M M M 4 118 F M M M F 3 219 F M M F M 3 220 F M M F F 2 321 F M F M M 3 222 F M F M F 2 323 F M F F M 2 324 F M F F F 1 425 F F M M M 3 226 F F M M F 2 327 F F M F M 2 328 F F M F F 1 429 F F F M M 2 330 F F F M F 1 431 F F F F M 1 432 F F F F F 0 5
Person #1 Person #2 Person #3 Person #4 Person #5 Probability # CA # Not CA1 10% 10% 10% 10% 10% 0.001% 5 02 10% 10% 10% 10% 90% 0.009% 4 13 10% 10% 10% 90% 10% 0.009% 4 14 10% 10% 10% 90% 90% 0.081% 3 25 10% 10% 90% 10% 10% 0.009% 4 16 10% 10% 90% 10% 90% 0.081% 3 27 10% 10% 90% 90% 10% 0.081% 3 28 10% 10% 90% 90% 90% 0.729% 2 39 10% 90% 10% 10% 10% 0.009% 4 1
10 10% 90% 10% 10% 90% 0.081% 3 211 10% 90% 10% 90% 10% 0.081% 3 212 10% 90% 10% 90% 90% 0.729% 2 313 10% 90% 90% 10% 10% 0.081% 3 214 10% 90% 90% 10% 90% 0.729% 2 315 10% 90% 90% 90% 10% 0.729% 2 316 10% 90% 90% 90% 90% 6.561% 1 417 90% 10% 10% 10% 10% 0.009% 4 118 90% 10% 10% 10% 90% 0.081% 3 219 90% 10% 10% 90% 10% 0.081% 3 220 90% 10% 10% 90% 90% 0.729% 2 321 90% 10% 90% 10% 10% 0.081% 3 222 90% 10% 90% 10% 90% 0.729% 2 323 90% 10% 90% 90% 10% 0.729% 2 324 90% 10% 90% 90% 90% 6.561% 1 425 90% 90% 10% 10% 10% 0.081% 3 226 90% 90% 10% 10% 90% 0.729% 2 327 90% 90% 10% 90% 10% 0.729% 2 328 90% 90% 10% 90% 90% 6.561% 1 429 90% 90% 90% 10% 10% 0.729% 2 330 90% 90% 90% 10% 90% 6.561% 1 431 90% 90% 90% 90% 10% 6.561% 1 432 90% 90% 90% 90% 90% 59.049% 0 5
# CA # non-CA % of Occurrences0 5 59.049% 0.590491 4 32.805% 0.328052 3 7.290% 0.07293 2 0.810% 0.00814 1 0.045% 0.000455 0 0.001% 0.00001
SELECT COUNT(*) as numstarts, SUM(CASE WHEN StopType IS NOT NULL THEN 1 ELSE 0 END) as numstops, AVG(CASE WHEN StopType IS NOT NULL THEN 1.0 ELSE 0 END ) as stoprateFROM SubscribersWHERE StartDate = '2005-12-28'
numstarts numstops stoprate2,409 484 20.09%
stop rate 15%starts 2,409
250 0.00% 0.00%251 0.00% 0.00%252 0.00% 0.00%253 0.00% 0.00%254 0.00% 0.00%255 0.00% 0.00%256 0.00% 0.00%257 0.00% 0.00%258 0.00% 0.00%259 0.00% 0.00%260 0.00% 0.00%261 0.00% 0.00%262 0.00% 0.00%263 0.00% 0.00%264 0.00% 0.00%265 0.00% 0.00%266 0.00% 0.00%267 0.00% 0.00%268 0.00% 0.00%269 0.00% 0.00%270 0.00% 0.00%271 0.00% 0.00%272 0.00% 0.00%273 0.00% 0.00%274 0.00% 0.00%275 0.00% 0.00%276 0.00% 0.00%277 0.00% 0.00%278 0.00% 0.00%279 0.00% 0.00%280 0.00% 0.00%281 0.00% 0.00%282 0.00% 0.00%283 0.00% 0.00%284 0.00% 0.00%285 0.00% 0.00%286 0.00% 0.00%287 0.00% 0.00%288 0.00% 0.00%
Proportion of Combinations
0.00%
0.25%
0.50%
0.75%
1.00%
1.25%
1.50%
1.75%
2.00%
2.25%
2.50%
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
Number of Stops
Proportion of Combinations
Cumulative Proportion
289 0.00% 0.00%290 0.00% 0.00%291 0.00% 0.00%292 0.00% 0.00%293 0.00% 0.00%294 0.00% 0.00%295 0.00% 0.01%296 0.00% 0.01%297 0.00% 0.01%298 0.00% 0.01%299 0.00% 0.02%300 0.00% 0.02%301 0.00% 0.02%302 0.01% 0.03%303 0.01% 0.04%304 0.01% 0.05%305 0.01% 0.06%306 0.01% 0.07%307 0.02% 0.09%308 0.02% 0.11%309 0.02% 0.13%310 0.03% 0.16%311 0.03% 0.19%312 0.04% 0.23%313 0.05% 0.27%314 0.05% 0.33%315 0.06% 0.39%316 0.07% 0.47%317 0.09% 0.56%318 0.10% 0.66%319 0.12% 0.77%320 0.13% 0.91%321 0.15% 1.06%322 0.18% 1.24%323 0.20% 1.44%324 0.23% 1.67%325 0.26% 1.93%326 0.29% 2.23%327 0.33% 2.56%328 0.37% 2.92%329 0.41% 3.34%330 0.46% 3.80%331 0.51% 4.30%332 0.56% 4.87%333 0.62% 5.48%334 0.68% 6.16%335 0.74% 6.90%336 0.81% 7.71%337 0.88% 8.58%338 0.95% 9.53%339 1.02% 10.55%340 1.10% 11.65%341 1.18% 12.83%342 1.25% 14.08%
343 1.33% 15.41%344 1.41% 16.83%345 1.49% 18.32%346 1.57% 19.89%347 1.65% 21.54%348 1.72% 23.27%349 1.80% 25.06%350 1.87% 26.93%351 1.93% 28.86%352 1.99% 30.85%353 2.05% 32.90%354 2.10% 35.00%355 2.15% 37.15%356 2.19% 39.34%357 2.22% 41.55%358 2.24% 43.80%359 2.26% 46.06%360 2.27% 48.33%361 2.28% 50.61%362 2.27% 52.88%363 2.26% 55.14%364 2.24% 57.38%365 2.22% 59.60%366 2.19% 61.79%367 2.15% 63.94%368 2.10% 66.04%369 2.05% 68.09%370 2.00% 70.09%371 1.94% 72.02%372 1.87% 73.90%373 1.80% 75.70%374 1.73% 77.43%375 1.66% 79.09%376 1.58% 80.68%377 1.51% 82.19%378 1.43% 83.62%379 1.35% 84.97%380 1.28% 86.25%381 1.20% 87.45%382 1.12% 88.57%383 1.05% 89.62%384 0.98% 90.59%385 0.91% 91.50%386 0.84% 92.34%387 0.77% 93.11%388 0.71% 93.82%389 0.65% 94.48%390 0.60% 95.07%391 0.54% 95.62%392 0.49% 96.11%393 0.45% 96.56%394 0.40% 96.96%395 0.36% 97.32%396 0.33% 97.65%
397 0.29% 97.94%398 0.26% 98.20%399 0.23% 98.43%400 0.21% 98.64%401 0.18% 98.82%402 0.16% 98.98%403 0.14% 99.12%404 0.12% 99.25%405 0.11% 99.35%406 0.09% 99.45%407 0.08% 99.53%408 0.07% 99.60%409 0.06% 99.66%410 0.05% 99.71%411 0.04% 99.76%412 0.04% 99.80%413 0.03% 99.83%414 0.03% 99.86%415 0.02% 99.88%416 0.02% 99.90%417 0.02% 99.92%418 0.01% 99.93%419 0.01% 99.94%420 0.01% 99.95%421 0.01% 99.96%422 0.01% 99.97%423 0.01% 99.97%424 0.00% 99.98%425 0.00% 99.98%426 0.00% 99.99%427 0.00% 99.99%428 0.00% 99.99%429 0.00% 99.99%430 0.00% 99.99%431 0.00% 100.00%432 0.00% 100.00%433 0.00% 100.00%434 0.00% 100.00%435 0.00% 100.00%436 0.00% 100.00%437 0.00% 100.00%438 0.00% 100.00%439 0.00% 100.00%440 0.00% 100.00%441 0.00% 100.00%442 0.00% 100.00%443 0.00% 100.00%444 0.00% 100.00%445 0.00% 100.00%446 0.00% 100.00%447 0.00% 100.00%448 0.00% 100.00%449 0.00% 100.00%450 0.00% 100.00%
451 0.00% 100.00%452 0.00% 100.00%453 0.00% 100.00%454 0.00% 100.00%455 0.00% 100.00%456 0.00% 100.00%457 0.00% 100.00%458 0.00% 100.00%459 0.00% 100.00%460 0.00% 100.00%461 0.00% 100.00%462 0.00% 100.00%463 0.00% 100.00%464 0.00% 100.00%465 0.00% 100.00%466 0.00% 100.00%467 0.00% 100.00%468 0.00% 100.00%469 0.00% 100.00%470 0.00% 100.00%471 0.00% 100.00%472 0.00% 100.00%473 0.00% 100.00%474 0.00% 100.00%475 0.00% 100.00%476 0.00% 100.00%477 0.00% 100.00%478 0.00% 100.00%479 0.00% 100.00%480 0.00% 100.00%481 0.00% 100.00%482 0.00% 100.00%483 0.00% 100.00%484 0.00% 100.00%485 0.00% 100.00%486 0.00% 100.00%487 0.00% 100.00%488 0.00% 100.00%489 0.00% 100.00%490 0.00% 100.00%491 0.00% 100.00%492 0.00% 100.00%493 0.00% 100.00%494 0.00% 100.00%495 0.00% 100.00%496 0.00% 100.00%497 0.00% 100.00%498 0.00% 100.00%499 0.00% 100.00%500 0.00% 100.00%501 0.00% 100.00%502 0.00% 100.00%503 0.00% 100.00%504 0.00% 100.00%
505 0.00% 100.00%506 0.00% 100.00%507 0.00% 100.00%508 0.00% 100.00%509 0.00% 100.00%510 0.00% 100.00%511 0.00% 100.00%512 0.00% 100.00%513 0.00% 100.00%514 0.00% 100.00%515 0.00% 100.00%516 0.00% 100.00%517 0.00% 100.00%518 0.00% 100.00%519 0.00% 100.00%520 0.00% 100.00%521 0.00% 100.00%522 0.00% 100.00%523 0.00% 100.00%524 0.00% 100.00%525 0.00% 100.00%526 0.00% 100.00%527 0.00% 100.00%528 0.00% 100.00%529 0.00% 100.00%530 0.00% 100.00%531 0.00% 100.00%532 0.00% 100.00%533 0.00% 100.00%534 0.00% 100.00%535 0.00% 100.00%536 0.00% 100.00%537 0.00% 100.00%538 0.00% 100.00%539 0.00% 100.00%540 0.00% 100.00%541 0.00% 100.00%542 0.00% 100.00%543 0.00% 100.00%544 0.00% 100.00%545 0.00% 100.00%546 0.00% 100.00%547 0.00% 100.00%548 0.00% 100.00%549 0.00% 100.00%550 0.00% 100.00%551 0.00% 100.00%552 0.00% 100.00%553 0.00% 100.00%554 0.00% 100.00%555 0.00% 100.00%
0.00%
0.25%
0.50%
0.75%
1.00%
1.25%
1.50%
1.75%
2.00%
2.25%
2.50%
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
Number of Stops
Proportion of Combinations
Cumulative Proportion
4842,409 20.1%
Stop Rate Expected DifferenceProb of Being That Far Off17.00% 409.5 -74.5 0.01%18.00% 433.6 -50.4 0.77%18.50% 445.7 -38.3 4.33%18.75% 451.7 -32.3 8.86%19.00% 457.7 -26.3 16.56%19.25% 463.7 -20.3 28.35%19.50% 469.8 -14.2 44.70%19.75% 475.8 -8.2 65.23%19.90% 479.4 -4.6 79.06%20.00% 481.8 -2.2 88.67%20.10% 484.2 0.2 98.42%20.25% 487.8 3.8 87.01%20.50% 493.8 9.8 64.00%20.75% 499.9 15.9 44.12%21.00% 505.9 21.9 28.43%21.25% 511.9 27.9 17.08%21.50% 517.9 33.9 9.56%21.75% 524.0 40.0 4.97%22.00% 530.0 46.0 2.41%22.50% 542.0 58.0 0.45%23.00% 554.1 70.1 0.06%
20% stop r 20%
Width Low BounHigh BounConfidence1 3 483 485 4.42%7 15 477 491 27.95%
12 25 472 496 45.80%25 51 459 509 79.46%37 75 447 521 93.91%39 79 445 523 95.18%50 101 434 534 98.88%63 126 421 547 99.86%75 151 409 559 99.99%
SELECT stoprate - 1.96 * stderr as conflower, stoprate + 1.96 * stderr as confupper, stoprate, stderr, numstarts, numstopsFROM (SELECT SQRT(stoprate * (1 - stoprate)/numstarts) as stderr, stoprate, numstarts, numstops FROM (SELECT COUNT(*) as numstarts, SUM(CASE WHEN StopType IS NOT NULL THEN 1 ELSE 0 END) as numstops, AVG(CASE WHEN StopType IS NOT NULL THEN 1.0 ELSE 0 END) as stoprate FROM Subscribers WHERE StartDate = '2005-12-28') s ) s
conflower confupper stoprate stderr numstarts numstops18.50% 21.68% 20.09% 0.81% 2,409 484
SELECT Market, stoprate - 1.96 * stderr as conflower, stoprate + 1.96 * stderr as confupper, stoprate, stderr, numstarts, numstopsFROM (SELECT Market, SQRT(stoprate * (1 - stoprate)/numstarts) as stderr, stoprate, numstarts, numstops FROM (SELECT market, COUNT(*) as numstarts, SUM(CASE WHEN StopType IS NOT NULL THEN 1 ELSE 0 END) as numstops, AVG(CASE WHEN StopType IS NOT NULL THEN 1.0 ELSE 0 END) as stoprate FROM Subscribers WHERE StartDate in ('2005-12-26') GROUP BY Market) s ) s
Market conflower confupper stoprate stderr numstarts numstopsGotham 33.2% 37.2% 35.2% 1.0% 2,256 794Smallville 17.8% 24.0% 20.9% 1.6% 666 139Metropolis 31.2% 36.7% 34.0% 1.4% 1,134 385
95% ConfidenceMarket Starts Stops Stop Rate Lower BouUpper BouStderr
1 Gotham 2,256 794 35.2% 33.2% 37.2% 1.0%2 Smallville 666 139 20.9% 17.8% 24.0% 1.6%3 Metropolis 1,134 385 34.0% 31.2% 36.7% 1.4%
p q n pq/n2.0% Gotham 35.2% 64.8% 2,256 0.0001013.1% Metropolis 20.9% 79.1% 666 0.0002482.8% 0.000349 1.9% 7.666786
1.20% -0.67% 3.07%1.20% -2.46% 4.86%
Smallville
Metropolis
Gotham
Smallville
Metropolis
Gotham
SELECT Market, SUM(1-isstopped) as actives, SUM(isstopped) as stopsFROM (SELECT s.*, (CASE WHEN StopType IS NOT NULL THEN 1 ELSE 0 END) as isstopped FROM Subscribers s) sWHERE StartDate in ('2005-12-26')GROUP BY MarketORDER BY Market
market actives stopsGotham 1,462 794Metropolis 749 385Smallville 527 139
market numstarts numstops stoprateGotham 2,256 794 35.2% 733.1 60.9Metropolis 666 139 20.9% 216.4 -77.4Smallville 1,134 385 34.0% 368.5 16.5
4,056 1,318 32.5%
Expected DeviationActives Stops Total Actives Stops Active Stops
Gotham 1,462 794 2,256 1,522.9 733.1 -60.9 60.9Metropolis 749 385 1,134 765.5 368.5 -16.5 16.5Smallville 527 139 666 449.6 216.4 77.4 -77.4TOTAL 2,738 1,318 4,056 2,738.0 1,318.0 0.0 0.0
CHI-SquareActive Stops
2.4 5.1
0.4 0.7
13.3 27.7
16.1 33.5 49.62 0.0000000017%
FROM SQLEXCEL CALCULATION FOR EXPECTED, DEVIATION, AND CHI-SQUAREExpected DeviationChi-Square
ActivesStopsTotalActivesStopsActivesStopsActivesStopsGoth ##### 2,256 ### 733.1 ### 60.9 2.44 5.06
Metro###### 1,134 765.5 368.5 ### 16.5 0.36 0.74
Small###### 666 449.6 216.4 77.4 ### ### ###
TOTA### ### 4,056 2,738 1,318 0.0 0.0 ### ### 49.62 0.0000000017%
Actives Stops TotalExpected Deviation CHI-Square
Actives Stops Active Stops ActiveGotham 1,462 794 2,256 1,522.9 733.1 -60.9 60.9 2.4
Metropolis 749 385 1,134 765.5 368.5 -16.5 16.5 0.4
Smallville 527 139 666 449.6 216.4 77.4 -77.4 13.3
TOTAL 2,738 1,318 4,056 2,738.0 1,318.0 0.0 0.0 16.1
CHI-SquareStops
5.1
0.7
27.7
33.5
0.3829 0.0602 0.0385 0.0244
3.84 7.81 11.07 18.311 3 5 10 15 1 3 5 10
DOF 1 (3DOF 3 (7DOF 5 (1DOF 10 (180.00 1.0000 1.0000 1.0000 1.0000 1.0000 0.3829 0.0309 0.0015 0.00000.25 0.6171 0.9691 0.9985 1.0000 1.0000 0.1376 0.0502 0.0064 0.00000.50 0.4795 0.9189 0.9921 1.0000 1.0000 0.0930 0.0575 0.0120 0.00000.75 0.3865 0.8614 0.9801 1.0000 1.0000 0.0692 0.0601 0.0175 0.00011.00 0.3173 0.8013 0.9626 0.9998 1.0000 0.0538 0.0602 0.0226 0.00031.25 0.2636 0.7410 0.9400 0.9995 1.0000 0.0429 0.0588 0.0269 0.00061.50 0.2207 0.6823 0.9131 0.9989 1.0000 0.0348 0.0564 0.0305 0.00101.75 0.1859 0.6259 0.8825 0.9979 1.0000 0.0286 0.0535 0.0334 0.00162.00 0.1573 0.5724 0.8491 0.9963 1.0000 0.0237 0.0502 0.0356 0.00232.25 0.1336 0.5222 0.8136 0.9940 0.9999 0.0198 0.0469 0.0371 0.00322.50 0.1138 0.4753 0.7765 0.9909 0.9999 0.0166 0.0435 0.0380 0.00422.75 0.0973 0.4318 0.7385 0.9867 0.9998 0.0140 0.0402 0.0385 0.00533.00 0.0833 0.3916 0.7000 0.9814 0.9996 0.0118 0.0370 0.0385 0.00653.25 0.0714 0.3547 0.6615 0.9749 0.9993 0.0101 0.0339 0.0381 0.00783.50 0.0614 0.3208 0.6234 0.9671 0.9990 0.0086 0.0310 0.0374 0.00923.75 0.0528 0.2898 0.5859 0.9579 0.9984 0.0073 0.0283 0.0365 0.01064.00 0.0455 0.2615 0.5494 0.9473 0.9977 0.0062 0.0258 0.0354 0.01204.25 0.0393 0.2357 0.5140 0.9354 0.9968 0.0054 0.0234 0.0341 0.01344.50 0.0339 0.2123 0.4799 0.9220 0.9956 0.0046 0.0212 0.0327 0.01474.75 0.0293 0.1910 0.4471 0.9072 0.9940 0.0040 0.0192 0.0313 0.01615.00 0.0253 0.1718 0.4159 0.8912 0.9921 0.0034 0.0174 0.0297 0.01735.25 0.0219 0.1544 0.3861 0.8739 0.9898 0.0029 0.0157 0.0282 0.01855.50 0.0190 0.1386 0.3579 0.8554 0.9870 0.0025 0.0142 0.0266 0.01965.75 0.0165 0.1244 0.3313 0.8358 0.9836 0.0022 0.0128 0.0251 0.02056.00 0.0143 0.1116 0.3062 0.8153 0.9797 0.0019 0.0115 0.0236 0.02146.25 0.0124 0.1001 0.2826 0.7938 0.9752 0.0016 0.0104 0.0221 0.02226.50 0.0108 0.0897 0.2606 0.7717 0.9701 0.0014 0.0094 0.0207 0.02286.75 0.0094 0.0803 0.2399 0.7488 0.9642 0.0012 0.0084 0.0193 0.02347.00 0.0082 0.0719 0.2206 0.7254 0.9576 0.0011 0.0076 0.0179 0.02387.25 0.0071 0.0643 0.2027 0.7017 0.9503 0.0009 0.0068 0.0167 0.02417.50 0.0062 0.0576 0.1860 0.6775 0.9423 0.0008 0.0061 0.0155 0.02437.75 0.0054 0.0515 0.1706 0.6532 0.9334 0.0007 0.0055 0.0143 0.02448.00 0.0047 0.0460 0.1562 0.6288 0.9238 0.0006 0.0049 0.0133 0.02448.25 0.0041 0.0411 0.1430 0.6044 0.9134 0.0005 0.0044 0.0122 0.02438.50 0.0036 0.0367 0.1307 0.5801 0.9022 0.0005 0.0039 0.0113 0.02418.75 0.0031 0.0328 0.1195 0.5560 0.8902 0.0004 0.0035 0.0104 0.02399.00 0.0027 0.0293 0.1091 0.5321 0.8775 0.0003 0.0031 0.0096 0.02369.25 0.0024 0.0261 0.0995 0.5086 0.8641 0.0003 0.0028 0.0088 0.02329.50 0.0021 0.0233 0.0907 0.4854 0.8500 0.0003 0.0025 0.0081 0.02279.75 0.0018 0.0208 0.0826 0.4627 0.8352 0.0002 0.0022 0.0074 0.0222
10.00 0.0016 0.0186 0.0752 0.4405 0.8197 0.0002 0.0020 0.0068 0.021710.25 0.0014 0.0166 0.0685 0.4188 0.8037 0.0002 0.0018 0.0062 0.021110.50 0.0012 0.0148 0.0622 0.3978 0.7872 0.0002 0.0016 0.0057 0.020410.75 0.0010 0.0132 0.0566 0.3773 0.7701 0.0001 0.0014 0.0052 0.019811.00 0.0009 0.0117 0.0514 0.3575 0.7526 0.0001 0.0013 0.0047 0.019111.25 0.0008 0.0104 0.0466 0.3384 0.7347 0.0001 0.0011 0.0043 0.018511.50 0.0007 0.0093 0.0423 0.3199 0.7164 0.0001 0.0010 0.0039 0.017811.75 0.0006 0.0083 0.0384 0.3021 0.6978 0.0001 0.0009 0.0036 0.0171
12.00 0.0005 0.0074 0.0348 0.2851 0.6790 0.0001 0.0008 0.0033 0.016412.25 0.0005 0.0066 0.0315 0.2687 0.6600 0.0001 0.0007 0.0030 0.015712.50 0.0004 0.0059 0.0285 0.2530 0.6409 0.0001 0.0006 0.0027 0.015012.75 0.0004 0.0052 0.0258 0.2380 0.6216 0.0000 0.0006 0.0025 0.014313.00 0.0003 0.0046 0.0234 0.2237 0.6023 0.0000 0.0005 0.0022 0.013613.25 0.0003 0.0041 0.0211 0.2100 0.5830 0.0000 0.0005 0.0020 0.013013.50 0.0002 0.0037 0.0191 0.1970 0.5637 0.0000 0.0004 0.0018 0.012313.75 0.0002 0.0033 0.0173 0.1847 0.5446 0.0000 0.0004 0.0017 0.011714.00 0.0002 0.0029 0.0156 0.1730 0.5255 0.0000 0.0003 0.0015 0.011114.25 0.0002 0.0026 0.0141 0.1619 0.5067 0.0000 0.0003 0.0014 0.010514.50 0.0001 0.0023 0.0127 0.1514 0.4880 0.0000 0.0003 0.0012 0.009914.75 0.0001 0.0020 0.0115 0.1414 0.4696 0.0000 0.0002 0.0011 0.009415.00 0.0001 0.0018 0.0104 0.1321 0.4514 0.0000 0.0002 0.0010 0.008915.25 0.0001 0.0016 0.0093 0.1232 0.4336 0.0000 0.0002 0.0009 0.008315.50 0.0001 0.0014 0.0084 0.1149 0.4160 0.0000 0.0002 0.0008 0.007915.75 0.0001 0.0013 0.0076 0.1070 0.3989 0.0000 0.0001 0.0008 0.007416.00 0.0001 0.0011 0.0068 0.0996 0.3821 0.0000 0.0001 0.0007 0.006916.25 0.0001 0.0010 0.0062 0.0927 0.3656 0.0000 0.0001 0.0006 0.006516.50 0.0000 0.0009 0.0056 0.0862 0.3496 0.0000 0.0001 0.0006 0.006116.75 0.0000 0.0008 0.0050 0.0801 0.3340 0.0000 0.0001 0.0005 0.005717.00 0.0000 0.0007 0.0045 0.0744 0.3189 0.0000 0.0001 0.0005 0.005417.25 0.0000 0.0006 0.0040 0.0690 0.3041 0.0000 0.0001 0.0004 0.005017.50 0.0000 0.0006 0.0036 0.0640 0.2899 0.0000 0.0001 0.0004 0.004717.75 0.0000 0.0005 0.0033 0.0593 0.2760 0.0000 0.0001 0.0003 0.004418.00 0.0000 0.0004 0.0029 0.0550 0.2627 0.0000 0.0000 0.0003 0.004118.25 0.0000 0.0004 0.0026 0.0509 0.2498 0.0000 0.0000 0.0003 0.003818.50 0.0000 0.0003 0.0024 0.0471 0.2373 0.0000 0.0000 0.0002 0.003518.75 0.0000 0.0003 0.0021 0.0436 0.2253 0.0000 0.0000 0.0002 0.003319.00 0.0000 0.0003 0.0019 0.0403 0.2137 0.0000 0.0000 0.0002 0.003119.25 0.0000 0.0002 0.0017 0.0372 0.2026 0.0000 0.0000 0.0002 0.002819.50 0.0000 0.0002 0.0016 0.0344 0.1920 0.0000 0.0000 0.0002 0.002619.75 0.0000 0.0002 0.0014 0.0317 0.1817 0.0000 0.0000 0.0001 0.002520.00 0.0000 0.0002 0.0012 0.0293 0.1719 0.0000 0.0000 0.0001 0.002320.25 0.0000 0.0002 0.0011 0.0270 0.1626 0.0000 0.0000 0.0001 0.002120.50 0.0000 0.0001 0.0010 0.0249 0.1536 0.0000 0.0000 0.0001 0.002020.75 0.0000 0.0001 0.0009 0.0229 0.1450 0.0000 0.0000 0.0001 0.001821.00 0.0000 0.0001 0.0008 0.0211 0.1368 0.0000 0.0000 0.0001 0.001721.25 0.0000 0.0001 0.0007 0.0194 0.1290 0.0000 0.0000 0.0001 0.001621.50 0.0000 0.0001 0.0007 0.0179 0.1216 0.0000 0.0000 0.0001 0.001421.75 0.0000 0.0001 0.0006 0.0164 0.1145 0.0000 0.0000 0.0001 0.001322.00 0.0000 0.0001 0.0005 0.0151 0.1078 0.0000 0.0000 0.0001 0.001222.25 0.0000 0.0001 0.0005 0.0139 0.1014 0.0000 0.0000 0.0000 0.001122.50 0.0000 0.0001 0.0004 0.0128 0.0953 0.0000 0.0000 0.0000 0.001022.75 0.0000 0.0000 0.0004 0.0117 0.0896 0.0000 0.0000 0.0000 0.001023.00 0.0000 0.0000 0.0003 0.0107 0.0841 0.0000 0.0000 0.0000 0.000923.25 0.0000 0.0000 0.0003 0.0099 0.0790 0.0000 0.0000 0.0000 0.000823.50 0.0000 0.0000 0.0003 0.0090 0.0741 0.0000 0.0000 0.0000 0.000823.75 0.0000 0.0000 0.0002 0.0083 0.0695 0.0000 0.0000 0.0000 0.000724.00 0.0000 0.0000 0.0002 0.0076 0.0651 0.0000 0.0000 0.0000 0.000624.25 0.0000 0.0000 0.0002 0.0070 0.0610 0.0000 0.0000 0.0000 0.000624.50 0.0000 0.0000 0.0002 0.0064 0.0571 0.0000 0.0000 0.0000 0.000524.75 0.0000 0.0000 0.0002 0.0058 0.0534 0.0000 0.0000 0.0000 0.000525.00 0.0000 0.0000 0.0001 0.0053 0.0499 0.0000 0.0000 0.0000 0.000525.25 0.0000 0.0000 0.0001 0.0049 0.0467 0.0000 0.0000 0.0000 0.0004
25.50 0.0000 0.0000 0.0001 0.0045 0.0436 0.0000 0.0000 0.0000 0.000425.75 0.0000 0.0000 0.0001 0.0041 0.0407 0.0000 0.0000 0.0000 0.000426.00 0.0000 0.0000 0.0001 0.0037 0.0380 0.0000 0.0000 0.0000 0.000326.25 0.0000 0.0000 0.0001 0.0034 0.0355 0.0000 0.0000 0.0000 0.000326.50 0.0000 0.0000 0.0001 0.0031 0.0331 0.0000 0.0000 0.0000 0.000326.75 0.0000 0.0000 0.0001 0.0029 0.0308 0.0000 0.0000 0.0000 0.000227.00 0.0000 0.0000 0.0001 0.0026 0.0287 0.0000 0.0000 0.0000 0.000227.25 0.0000 0.0000 0.0001 0.0024 0.0268 0.0000 0.0000 0.0000 0.000227.50 0.0000 0.0000 0.0000 0.0022 0.0249 0.0000 0.0000 0.0000 0.000227.75 0.0000 0.0000 0.0000 0.0020 0.0232 0.0000 0.0000 0.0000 0.000228.00 0.0000 0.0000 0.0000 0.0018 0.0216 0.0000 0.0000 0.0000 0.000228.25 0.0000 0.0000 0.0000 0.0016 0.0201 0.0000 0.0000 0.0000 0.000128.50 0.0000 0.0000 0.0000 0.0015 0.0186 0.0000 0.0000 0.0000 0.000128.75 0.0000 0.0000 0.0000 0.0014 0.0173 0.0000 0.0000 0.0000 0.000129.00 0.0000 0.0000 0.0000 0.0012 0.0161 0.0000 0.0000 0.0000 0.000129.25 0.0000 0.0000 0.0000 0.0011 0.0149 0.0000 0.0000 0.0000 0.000129.50 0.0000 0.0000 0.0000 0.0010 0.0139 0.0000 0.0000 0.0000 0.000129.75 0.0000 0.0000 0.0000 0.0009 0.0129 0.0000 0.0000 0.0000 0.000130.00 0.0000 0.0000 0.0000 0.0009 0.0119 0.0000 0.0000 0.0000 0.000130.25 0.0000 0.0000 0.0000 0.0008 0.0111 0.0000 0.0000 0.0000 0.000130.50 0.0000 0.0000 0.0000 0.0007 0.0102 0.0000 0.0000 0.0000 0.000130.75 0.0000 0.0000 0.0000 0.0006 0.0095 0.0000 0.0000 0.0000 0.000131.00 0.0000 0.0000 0.0000 0.0006 0.0088 0.0000 0.0000 0.0000 0.000131.25 0.0000 0.0000 0.0000 0.0005 0.0081 0.0000 0.0000 0.0000 0.000031.50 0.0000 0.0000 0.0000 0.0005 0.0075 0.0000 0.0000 0.0000 0.000031.75 0.0000 0.0000 0.0000 0.0004 0.0070 0.0000 0.0000 0.0000 0.000032.00 0.0000 0.0000 0.0000 0.0004 0.0064 0.0000 0.0000 0.0000 0.000032.25 0.0000 0.0000 0.0000 0.0004 0.0060 0.0000 0.0000 0.0000 0.000032.50 0.0000 0.0000 0.0000 0.0003 0.0055 0.0000 0.0000 0.0000 0.000032.75 0.0000 0.0000 0.0000 0.0003 0.0051 0.0000 0.0000 0.0000 0.000033.00 0.0000 0.0000 0.0000 0.0003 0.0047 0.0000 0.0000 0.0000 0.000033.25 0.0000 0.0000 0.0000 0.0002 0.0043 0.0000 0.0000 0.0000 0.000033.50 0.0000 0.0000 0.0000 0.0002 0.0040 0.0000 0.0000 0.0000 0.000033.75 0.0000 0.0000 0.0000 0.0002 0.0037 0.0000 0.0000 0.0000 0.000034.00 0.0000 0.0000 0.0000 0.0002 0.0034 0.0000 0.0000 0.0000 0.000034.25 0.0000 0.0000 0.0000 0.0002 0.0031 0.0000 0.0000 0.0000 0.000034.50 0.0000 0.0000 0.0000 0.0002 0.0029 0.0000 0.0000 0.0000 0.000034.75 0.0000 0.0000 0.0000 0.0001 0.0027 0.0000 0.0000 0.0000 0.000035.00 0.0000 0.0000 0.0000 0.0001 0.0025 0.0000 0.0000 0.0000 0.000035.25 0.0000 0.0000 0.0000 0.0001 0.0023 0.0000 0.0000 0.0000 0.000035.50 0.0000 0.0000 0.0000 0.0001 0.0021 0.0000 0.0000 0.0000 0.000035.75 0.0000 0.0000 0.0000 0.0001 0.0019 0.0000 0.0000 0.0000 0.000036.00 0.0000 0.0000 0.0000 0.0001 0.0018 0.0000 0.0000 0.0000 0.000036.25 0.0000 0.0000 0.0000 0.0001 0.0016 0.0000 0.0000 0.0000 0.000036.50 0.0000 0.0000 0.0000 0.0001 0.0015 0.0000 0.0000 0.0000 0.000036.75 0.0000 0.0000 0.0000 0.0001 0.0014 0.0000 0.0000 0.0000 0.000037.00 0.0000 0.0000 0.0000 0.0001 0.0013 0.0000 0.0000 0.0000 0.000037.25 0.0000 0.0000 0.0000 0.0001 0.0012 0.0000 0.0000 0.0000 0.000037.50 0.0000 0.0000 0.0000 0.0000 0.0011 0.0000 0.0000 0.0000 0.000037.75 0.0000 0.0000 0.0000 0.0000 0.0010 0.0000 0.0000 0.0000 0.000038.00 0.0000 0.0000 0.0000 0.0000 0.0009 0.0000 0.0000 0.0000 0.000038.25 0.0000 0.0000 0.0000 0.0000 0.0008 0.0000 0.0000 0.0000 0.000038.50 0.0000 0.0000 0.0000 0.0000 0.0008 0.0000 0.0000 0.0000 0.000038.75 0.0000 0.0000 0.0000 0.0000 0.0007 0.0000 0.0000 0.0000 0.0000
39.00 0.0000 0.0000 0.0000 0.0000 0.0006 0.0000 0.0000 0.0000 0.000039.25 0.0000 0.0000 0.0000 0.0000 0.0006 0.0000 0.0000 0.0000 0.000039.50 0.0000 0.0000 0.0000 0.0000 0.0005 0.0000 0.0000 0.0000 0.000039.75 0.0000 0.0000 0.0000 0.0000 0.0005 0.0000 0.0000 0.0000 0.000040.00 0.0000 0.0000 0.0000 0.0000 0.0005 0.0000 0.0000 0.0000 0.000040.25 0.0000 0.0000 0.0000 0.0000 0.0004 0.0000 0.0000 0.0000 0.000040.50 0.0000 0.0000 0.0000 0.0000 0.0004 0.0000 0.0000 0.0000 0.000040.75 0.0000 0.0000 0.0000 0.0000 0.0003 0.0000 0.0000 0.0000 0.000041.00 0.0000 0.0000 0.0000 0.0000 0.0003 0.0000 0.0000 0.0000 0.000041.25 0.0000 0.0000 0.0000 0.0000 0.0003 0.0000 0.0000 0.0000 0.000041.50 0.0000 0.0000 0.0000 0.0000 0.0003 0.0000 0.0000 0.0000 0.000041.75 0.0000 0.0000 0.0000 0.0000 0.0002 0.0000 0.0000 0.0000 0.000042.00 0.0000 0.0000 0.0000 0.0000 0.0002 0.0000 0.0000 0.0000 0.000042.25 0.0000 0.0000 0.0000 0.0000 0.0002 0.0000 0.0000 0.0000 0.000042.50 0.0000 0.0000 0.0000 0.0000 0.0002 0.0000 0.0000 0.0000 0.000042.75 0.0000 0.0000 0.0000 0.0000 0.0002 0.0000 0.0000 0.0000 0.000043.00 0.0000 0.0000 0.0000 0.0000 0.0002 0.0000 0.0000 0.0000 0.000043.25 0.0000 0.0000 0.0000 0.0000 0.0001 0.0000 0.0000 0.0000 0.000043.50 0.0000 0.0000 0.0000 0.0000 0.0001 0.0000 0.0000 0.0000 0.000043.75 0.0000 0.0000 0.0000 0.0000 0.0001 0.0000 0.0000 0.0000 0.000044.00 0.0000 0.0000 0.0000 0.0000 0.0001 0.0000 0.0000 0.0000 0.000044.25 0.0000 0.0000 0.0000 0.0000 0.0001 0.0000 0.0000 0.0000 0.000044.50 0.0000 0.0000 0.0000 0.0000 0.0001 0.0000 0.0000 0.0000 0.000044.75 0.0000 0.0000 0.0000 0.0000 0.0001 0.0000 0.0000 0.0000 0.000045.00 0.0000 0.0000 0.0000 0.0000 0.0001 0.0000 0.0000 0.0000 0.000045.25 0.0000 0.0000 0.0000 0.0000 0.0001 0.0000 0.0000 0.0000 0.000045.50 0.0000 0.0000 0.0000 0.0000 0.0001 0.0000 0.0000 0.0000 0.000045.75 0.0000 0.0000 0.0000 0.0000 0.0001 0.0000 0.0000 0.0000 0.000046.00 0.0000 0.0000 0.0000 0.0000 0.0001 0.0000 0.0000 0.0000 0.000046.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000046.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000046.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000047.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000047.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000047.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000047.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000048.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000048.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000048.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000048.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000049.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000049.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000049.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000049.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000050.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000050.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000050.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000050.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000051.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000051.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000051.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000051.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000052.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000052.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
52.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000052.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000053.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000053.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000053.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000053.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000054.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000054.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000054.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000054.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000055.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000055.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000055.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000055.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000056.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000056.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000056.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000056.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000057.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000057.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000057.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000057.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000058.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000058.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000058.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000058.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000059.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000059.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000059.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000059.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000060.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000060.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000060.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000060.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000061.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000061.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000061.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000061.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000062.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000062.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000062.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000062.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000063.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000063.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000063.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000063.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000064.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000064.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000064.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000064.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000065.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000065.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000065.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000065.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
66.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000066.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000066.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000066.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000067.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000067.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000067.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000067.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000068.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000068.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000068.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000068.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000069.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000069.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000069.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000069.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000070.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000070.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000070.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000070.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000071.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000071.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000071.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000071.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000072.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000072.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000072.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000072.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000073.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000073.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000073.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000073.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000074.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000074.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000074.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000074.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000075.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000075.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000075.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000075.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000076.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000076.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000076.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000076.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000077.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000077.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000077.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000077.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000078.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000078.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000078.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000078.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000079.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000079.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
79.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000079.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000080.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000080.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000080.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000080.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000081.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000081.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000081.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000081.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000082.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000082.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000082.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000082.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000083.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000083.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000083.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000083.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000084.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000084.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000084.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000084.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000085.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000085.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000085.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000085.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000086.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000086.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000086.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000086.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000087.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000087.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000087.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000087.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000088.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000088.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000088.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000088.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000089.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000089.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000089.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000089.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000090.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000090.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000090.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000090.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000091.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000091.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000091.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000091.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000092.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000092.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000092.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000092.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
93.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000093.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000093.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000093.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000094.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000094.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000094.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000094.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000095.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000095.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000095.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000095.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000096.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000096.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000096.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000096.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000097.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000097.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000097.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000097.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000098.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000098.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000098.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000098.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000099.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000099.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000099.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.000099.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
100.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000100.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000100.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000100.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000101.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000101.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000101.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000101.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000102.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000102.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000102.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000102.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000103.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000103.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000103.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000103.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000104.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000104.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000104.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000104.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000105.00 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000105.25 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000105.50 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000105.75 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000
SELECT Market, isstopped, val, exp, SQUARE(val - exp) / exp as chisquareFROM (SELECT cells.Market, cells.isstopped, (1.0*r.cnt * c.cnt / (SELECT COUNT(*) FROM Subscribers WHERE StartDate in ('2005-12-26') ) ) as exp, cells.cnt as val FROM (SELECT Market, (CASE WHEN StopType IS NOT NULL THEN 1 ELSE 0 END) as isstopped, COUNT(*) as cnt FROM Subscribers WHERE StartDate in ('2005-12-26') GROUP BY Market, (CASE WHEN StopType IS NOT NULL THEN 1 ELSE 0 END) ) cells LEFT OUTER JOIN (SELECT Market, COUNT(*) as cnt FROM Subscribers WHERE StartDate in ('2005-12-26') GROUP BY Market ) r ON cells.Market = r.Market LEFT OUTER JOIN (SELECT (CASE WHEN StopType IS NOT NULL THEN 1 ELSE 0 END) as isstopped, COUNT(*) as cnt FROM Subscribers WHERE StartDate in ('2005-12-26') GROUP BY (CASE WHEN StopType IS NOT NULL THEN 1 ELSE 0 END) ) c ON cells.isstopped = c.isstopped ) aORDER BY Market, isstopped
Market isstoppedval exp chisquareGotham 0 1,462 1,522.9 2.44Gotham 1 794 733.1 5.06Metropoli 0 749 765.5 0.36Metropoli 1 385 368.5 0.74Smallville 0 527 449.6 13.33Smallville 1 139 216.4 27.69
(6 row(s) affected)
0.0193
25.0015
DOF 15 (25.00)0.00000.00000.00000.00000.00000.00000.00000.00000.00000.00010.00010.00020.00030.00040.00050.00070.00090.00120.00150.00190.00230.00280.00330.00390.00450.00520.00590.00660.00730.00810.00880.00960.01040.01120.01200.01270.01340.01410.01480.01540.01600.01660.01710.01750.01790.01830.01860.0188
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
CHI-Square Value
0.01900.01920.01930.01930.01930.01930.01920.01900.01890.01870.01840.01820.01790.01750.01720.01680.01640.01600.01560.01520.01470.01430.01380.01340.01290.01250.01200.01160.01110.01070.01020.00980.00940.00900.00860.00820.00780.00740.00710.00670.00640.00610.00580.00550.00520.00490.00460.00440.00410.00390.00370.00350.00330.0031
0.00290.00270.00250.00240.00220.00210.00200.00180.00170.00160.00150.00140.00130.00120.00120.00110.00100.00090.00090.00080.00080.00070.00070.00060.00060.00050.00050.00050.00040.00040.00040.00030.00030.00030.00030.00020.00020.00020.00020.00020.00020.00020.00010.00010.00010.00010.00010.00010.00010.00010.00010.00010.00010.0001
0.00010.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000
0.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000
0.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000
0.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000
0.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.00000.0000
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
CHI-Square Value
SELECT GroupName, COUNT(*) as numorderlines, COUNT(DISTINCT o.OrderId) as numorders, COUNT(DISTINCT o.CustomerId) as numcustomersFROM Orders o LEFT OUTER JOIN OrderLines ol ON o.OrderId = ol.OrderId LEFT OUTER JOIN Products p ON ol.ProductId = p.ProductIdGROUP BY GroupNameORDER BY GroupName
GroupNamnumorderli numordersnumcustomersErr:512 9 9 6APPAREL 12,348 10,976 10,680ARTWORK 56,498 45,430 44,660BOOK 113,210 86,564 85,122CALENDA 9,872 8,983 8,795FREEBIE 28,073 22,261 21,809GAME 18,469 11,972 11,780OCCASION 41,713 37,898 37,238OTHER 5,825 5,002 4,903
SELECT State, GroupName, numcustomersFROM (SELECT o.State, p.GroupName, COUNT(DISTINCT o.CustomerId) as numcustomers, ROW_NUMBER() OVER (PARTITION BY state ORDER BY COUNT(DISTINCT o.CustomerId) desc ) as seqnum FROM Orders o LEFT OUTER JOIN OrderLines ol ON o.OrderId = ol.OrderId LEFT OUTER JOIN Products p ON ol.ProductId = p. ProductId GROUP BY o.state, p.GroupName) aWHERE seqnum = 1ORDER BY numcustomers DESC
State GroupNamnumcustomersNY BOOK 24,421NJ BOOK 9,503CA BOOK 7,724FL BOOK 4,906CT BOOK 4,283PA BOOK 3,278MA BOOK 3,104TX BOOK 2,686IL BOOK 2,404MI BOOK 1,823VA BOOK 1,803MD BOOK 1,744
Number of Customers
0
10,000
20,000
30,000
40,000
50,000
60,000
70,000
80,000
90,000
6
10,680
44,660
85,122
8,795
21,809
11,780
37,238
4,903
Number of Customers
OH BOOK 1,713WA BOOK 1,355GA BOOK 1,178AZ BOOK 1,093NC BOOK 997CO BOOK 965DC BOOK 896MN BOOK 806WI BOOK 719MO BOOK 631OR BOOK 612IN BOOK 556TN BOOK 480RI BOOK 455SC BOOK 363KY BOOK 350LA BOOK 350VT BOOK 336ME BOOK 330NM BOOK 323NH BOOK 320DE BOOK 279NV BOOK 272AL BOOK 259KS BOOK 220IA BOOK 210UT BOOK 193OK BOOK 168HI BOOK 148
BOOK 141NE BOOK 109AR BOOK 103PR BOOK 98ID BOOK 84MS BOOK 79WV BOOK 67AK BOOK 43WY BOOK 42SD BOOK 35MT BOOK 34ND BOOK 26AE ARTWORK 20VI BOOK 9AP BOOK 8AA ARTWORK 5GU BOOK 3FR BOOK 2BC BOOK 2NF APPAREL 2NS BOOK 2ON GAME 2SP BOOK 2SR OCCASION 1VC APPAREL 1
UK BOOK 1US BOOK 1YU APPAREL 1PC GAME 1PE BOOK 1PQ CALENDA 1SK OTHER 1SO OCCASION 1QC ARTWORK 1QL OCCASION 1NT OCCASION 1NL ARTWORK 1NB APPAREL 1MG BOOK 1MB CALENDA 1BD OCCASION 1CH CALENDA 1CN OCCASION 1DF BOOK 1EN CALENDA 1AB GAME 1. FREEBIE 1GD CALENDA 1KM ARTWORK 1KW CALENDA 1LC BOOK 1
Number of Customers
0
10,000
20,000
30,000
40,000
50,000
60,000
70,000
80,000
90,000
6
10,680
44,660
85,122
8,795
21,809
11,780
37,238
4,903
Number of Customers
SELECT State, GroupName, val, exp, SQUARE(val - exp) / exp as chisquareFROM (SELECT cells.State, cells. GroupName, 1.0*r.cnt * c.cnt / (SELECT COUNT(DISTINCT CustomerId) FROM Orders) as exp, cells.cnt as val FROM (SELECT State, GroupName, COUNT(DISTINCT o.CustomerId) as cnt FROM Orders o LEFT OUTER JOIN Orderlines ol ON o.OrderId = ol. OrderId LEFT OUTER JOIN Products p ON ol.ProductId = p.ProductId GROUP BY State, GroupName ) cells LEFT OUTER JOIN (SELECT State, COUNT(DISTINCT CustomerId) as cnt FROM Orders o GROUP BY State ) r ON cells.State = r.State LEFT OUTER JOIN (SELECT GroupName, COUNT(DISTINCT CustomerId) as cnt FROM Orders o LEFT OUTER JOIN OrderLines ol ON o.OrderId = ol.OrderId LEFT OUTER JOIN Products p ON ol.ProductId = p.ProductId GROUP BY GroupName ) c ON cells.GroupName = c.GroupName) aORDER BY chisquare DESC
State GroupNamval exp chisquare STATENY GAME 2,599 3,306.4 151.4 NYFL ARTWORK 1,848 2,391.6 123.5 FLNY FREEBIE 5,289 6,121.4 113.2 NYNY ARTWORK 13,592 12,535.2 89.1 NYNJ ARTWORK 5,636 4,992.6 82.9 NJNY OCCASION 9,710 10,452.0 52.7 NYNJ GAME 1,074 1,316.9 44.8 NJAP OTHER 5 0.5 44.2 APFL APPAREL 725 571.9 41.0 FLMA GAME 560 428.9 40.1 MANJ CALENDA 785 983.2 40.0 NJ
CALENDA 43 17.0 39.6APPAREL 49 20.7 38.8
MI ARTWORK 709 892.7 37.8PQ OTHER 1 0.0 36.7AB OTHER 1 0.0 36.7SK OTHER 1 0.0 36.7. OTHER 1 0.0 36.7QL OTHER 1 0.0 36.7CT ARTWORK 2,475 2,202.8 33.6CT APPAREL 403 526.8 29.1
NH GAME 85 47.9 28.7ON GAME 2 0.1 28.3FL BOOK 4,906 4,558.3 26.5MT GAME 20 6.9 24.9WA GAME 257 190.0 23.6AK GAME 22 8.1 23.6IN OCCASION 329 252.0 23.5OH OCCASION 900 768.1 22.7AZ ARTWORK 424 533.9 22.6VA GAME 332 258.4 21.0MA ARTWORK 1,442 1,625.9 20.8KY ARTWORK 121 181.6 20.2NJ OCCASION 4,453 4,162.9 20.2NF APPAREL 2 0.2 19.8KW CALENDA 1 0.0 19.6MB CALENDA 1 0.0 19.6EN CALENDA 1 0.0 19.6GD CALENDA 1 0.0 19.6CH CALENDA 1 0.0 19.6UK CALENDA 1 0.0 19.6PQ CALENDA 1 0.0 19.6SK CALENDA 1 0.0 19.6AB CALENDA 1 0.0 19.6NC FREEBIE 353 279.2 19.5DC OCCASION 298 384.0 19.3
OTHER 23 9.5 19.2PA CALENDA 248 327.1 19.1VA OCCASION 941 816.8 18.9DC ARTWORK 551 460.6 17.7ON OTHER 1 0.1 17.4BC OTHER 1 0.1 17.4NS OTHER 1 0.1 17.4HI ARTWORK 35 69.3 17.0IN ARTWORK 231 302.3 16.8SC GAME 87 56.5 16.5OR ARTWORK 251 323.9 16.4NJ FREEBIE 2,238 2,438.0 16.4AB APPAREL 1 0.1 15.8PQ APPAREL 1 0.1 15.8YU APPAREL 1 0.1 15.8NB APPAREL 1 0.1 15.8QL APPAREL 1 0.1 15.8MB APPAREL 1 0.1 15.8VC APPAREL 1 0.1 15.8MI GAME 296 235.5 15.6IL BOOK 2,404 2,598.2 14.5MB GAME 1 0.1 14.2AB GAME 1 0.1 14.2PC GAME 1 0.1 14.2PQ GAME 1 0.1 14.2MN ARTWORK 361 439.9 14.1MD GAME 304 245.2 14.1VA FREEBIE 559 478.4 13.6AZ FREEBIE 320 260.7 13.5
AP GAME 5 1.1 13.5SC OCCASION 227 178.6 13.1NC GAME 195 150.8 12.9MD FREEBIE 530 454.0 12.7KY OCCASION 195 151.5 12.5IA GAME 50 30.8 11.9NY BOOK 24,421 23,892.2 11.7LA ARTWORK 128 172.2 11.4NY CALENDA 2,636 2,468.6 11.4AE CALENDA 8 2.6 11.2MA FREEBIE 887 794.0 10.9CA OCCASION 3,294 3,488.7 10.9AE APPAREL 9 3.2 10.8PA ARTWORK 1,528 1,661.2 10.7WI GAME 140 106.6 10.5MA CALENDA 378 320.2 10.4WY OTHER 8 2.7 10.3VT APPAREL 24 45.6 10.2TN GAME 100 72.8 10.2VA ARTWORK 880 979.6 10.1WV OCCASION 56 36.7 10.1IL ARTWORK 1,479 1,363.2 9.8OH APPAREL 174 220.3 9.7NM GAME 61 41.3 9.4PR BOOK 98 72.3 9.1ME ARTWORK 145 185.7 8.9NS CALENDA 1 0.1 8.9BC CALENDA 1 0.1 8.9ON CALENDA 1 0.1 8.9WA ARTWORK 641 720.2 8.7MI BOOK 1,823 1,701.5 8.7NY OTHER 1,485 1,376.2 8.6OH FREEBIE 512 449.8 8.6GA BOOK 1,178 1,282.5 8.5MS GAME 24 13.4 8.5KY FREEBIE 116 88.7 8.4
GAME 9 22.8 8.4SC FREEBIE 134 104.6 8.3NE APPAREL 26 14.9 8.2VT OTHER 34 20.9 8.2WY FREEBIE 22 12.1 8.1MI CALENDA 138 175.8 8.1NM CALENDA 15 30.8 8.1TX GAME 442 386.3 8.0MD CALENDA 145 183.1 7.9NC BOOK 997 1,089.8 7.9CA BOOK 7,724 7,974.7 7.9VT GAME 70 50.3 7.7DE FREEBIE 97 73.7 7.3NV CALENDA 14 28.4 7.3NV FREEBIE 93 70.4 7.2VT CALENDA 54 37.5 7.2OR APPAREL 101 77.5 7.1CA CALENDA 900 824.0 7.0
PE APPAREL 1 0.1 7.0NS APPAREL 1 0.1 7.0BC APPAREL 1 0.1 7.0ON APPAREL 1 0.1 7.0UT CALENDA 6 16.7 6.9AB FREEBIE 1 0.1 6.8UK FREEBIE 1 0.1 6.8SK FREEBIE 1 0.1 6.8NB FREEBIE 1 0.1 6.8MB FREEBIE 1 0.1 6.8EN FREEBIE 1 0.1 6.8NT FREEBIE 1 0.1 6.8. FREEBIE 1 0.1 6.8PQ FREEBIE 1 0.1 6.8SC ARTWORK 176 214.2 6.8VI GAME 4 1.2 6.7MI FREEBIE 490 435.9 6.7ME OCCASION 187 154.8 6.7ID GAME 22 12.8 6.6CA GAME 1,189 1,103.6 6.6NY Err:512 5 1.7 6.5ME CALENDA 52 36.6 6.5WA FREEBIE 399 351.7 6.4KS APPAREL 14 27.1 6.3NS GAME 1 0.1 6.2BC GAME 1 0.1 6.2GA CALENDA 161 132.5 6.1WV GAME 20 11.6 6.0TX CALENDA 330 288.4 6.0AR GAME 25 15.4 6.0UT BOOK 193 162.1 5.9AE BOOK 13 25.1 5.9CA APPAREL 1,077 1,000.6 5.8TN OTHER 17 30.3 5.8DE OCCASION 153 125.9 5.8DE GAME 55 39.8 5.8RI GAME 80 61.2 5.8TN OCCASION 266 230.0 5.6AZ BOOK 1,093 1,017.5 5.6MN OCCASION 412 366.8 5.6PA OCCASION 1,473 1,385.1 5.6MA OTHER 147 178.5 5.6NE ARTWORK 44 62.4 5.4OR GAME 107 85.4 5.4HI OTHER 14 7.6 5.4RI FREEBIE 138 113.3 5.4NM OCCASION 104 130.4 5.4NF CALENDA 1 0.1 5.3ME GAME 65 49.0 5.2GA OCCASION 615 561.0 5.2AL OCCASION 144 119.4 5.1MT BOOK 34 49.8 5.0SC BOOK 363 408.2 5.0TX FREEBIE 775 715.3 5.0
CA OTHER 412 459.3 4.9NM ARTWORK 129 156.4 4.8SC CALENDA 28 42.2 4.8VA CALENDA 223 192.9 4.7AL FREEBIE 88 70.0 4.7SD GAME 9 4.5 4.6CT GAME 530 581.0 4.5RI ARTWORK 200 232.1 4.4IN FREEBIE 173 147.6 4.4AK BOOK 43 58.8 4.3OH CALENDA 154 181.4 4.1GA FREEBIE 365 328.6 4.0KS ARTWORK 92 113.3 4.0TX BOOK 2,686 2,791.7 4.0TN BOOK 480 525.8 4.0PA BOOK 3,278 3,166.3 3.9AP APPAREL 3 1.0 3.9PR ARTWORK 26 37.9 3.8NE OCCASION 66 52.1 3.7MN APPAREL 125 105.2 3.7ME FREEBIE 109 90.7 3.7
OCCASION 56 72.1 3.6NF GAME 1 0.2 3.6AE ARTWORK 20 13.2 3.5DE ARTWORK 128 151.0 3.5MD OCCASION 827 775.2 3.5NE GAME 24 16.5 3.4
BOOK 141 164.8 3.4WV BOOK 67 84.0 3.4KS GAME 40 29.9 3.4WI BOOK 719 770.1 3.4PQ OCCASION 1 0.2 3.3SO OCCASION 1 0.2 3.3BD OCCASION 1 0.2 3.3SK OCCASION 1 0.2 3.3UK OCCASION 1 0.2 3.3NT OCCASION 1 0.2 3.3CN OCCASION 1 0.2 3.3QL OCCASION 1 0.2 3.3SR OCCASION 1 0.2 3.3NB OCCASION 1 0.2 3.3MB OCCASION 1 0.2 3.3AB OCCASION 1 0.2 3.3TX Err:512 1 0.2 3.3MO GAME 111 93.5 3.3MS BOOK 79 96.5 3.2NV GAME 49 38.0 3.2AR ARTWORK 45 58.4 3.1NH OCCASION 173 151.5 3.1MO FREEBIE 196 173.2 3.0MO BOOK 631 675.8 3.0AA ARTWORK 5 2.4 3.0HI CALENDA 20 13.6 3.0PR OCCASION 22 31.6 2.9
KS FREEBIE 68 55.3 2.9AL ARTWORK 123 143.2 2.9OK FREEBIE 59 47.4 2.8IL FREEBIE 709 665.7 2.8UT OCCASION 57 70.9 2.7MO APPAREL 100 84.8 2.7UT APPAREL 13 20.3 2.6LA OCCASION 163 143.6 2.6ON FREEBIE 1 0.2 2.6NS FREEBIE 1 0.2 2.6BC FREEBIE 1 0.2 2.6FR FREEBIE 1 0.2 2.6DE CALENDA 21 29.7 2.6IN GAME 94 79.7 2.6GU CALENDA 1 0.2 2.5VT OCCASION 179 158.9 2.5MN FREEBIE 238 214.8 2.5PQ ARTWORK 1 0.2 2.5NT ARTWORK 1 0.2 2.5CH ARTWORK 1 0.2 2.5QL ARTWORK 1 0.2 2.5NL ARTWORK 1 0.2 2.5EN ARTWORK 1 0.2 2.5KW ARTWORK 1 0.2 2.5QC ARTWORK 1 0.2 2.5NB ARTWORK 1 0.2 2.5SK ARTWORK 1 0.2 2.5KM ARTWORK 1 0.2 2.5AB ARTWORK 1 0.2 2.5UK ARTWORK 1 0.2 2.5MB ARTWORK 1 0.2 2.5OK CALENDA 26 19.1 2.5PA FREEBIE 856 811.2 2.5OH ARTWORK 874 921.2 2.4PR OTHER 1 4.2 2.4WI ARTWORK 373 404.1 2.4NE FREEBIE 39 30.5 2.4NJ APPAREL 1,141 1,193.9 2.3AK FREEBIE 21 15.1 2.3OK APPAREL 16 23.2 2.2IN CALENDA 48 59.5 2.2KS OCCASION 109 94.5 2.2VA BOOK 1,803 1,867.2 2.2WI APPAREL 111 96.6 2.1NJ OTHER 514 548.1 2.1IA FREEBIE 68 57.1 2.1DC APPAREL 95 110.1 2.1NM BOOK 323 298.2 2.1RI CALENDA 36 45.7 2.1NH APPAREL 34 43.4 2.1VT BOOK 336 363.3 2.0CO OTHER 45 55.6 2.0GA OTHER 86 73.9 2.0NH BOOK 320 346.2 2.0
AR FREEBIE 36 28.5 2.0HI BOOK 148 132.0 1.9NC APPAREL 153 136.7 1.9GA ARTWORK 637 672.9 1.9KY OTHER 26 19.9 1.8GU APPAREL 1 0.3 1.8AE GAME 1 3.5 1.8TN FREEBIE 150 134.7 1.7IA APPAREL 21 27.9 1.7NH ARTWORK 164 181.6 1.7CT BOOK 4,283 4,198.6 1.7MN GAME 130 116.0 1.7LA FREEBIE 96 84.1 1.7KS OTHER 17 12.4 1.7AE OTHER 3 1.4 1.7ND BOOK 26 20.2 1.7PA OTHER 165 182.4 1.7LA APPAREL 33 41.2 1.6AP CALENDA 2 0.8 1.6AZ APPAREL 142 127.7 1.6ME BOOK 330 353.9 1.6MT CALENDA 8 5.2 1.6IL CALENDA 289 268.5 1.6OK BOOK 168 185.0 1.6CO FREEBIE 267 247.4 1.6AK APPAREL 4 7.4 1.5ND FREEBIE 8 5.2 1.5GA GAME 194 177.5 1.5GU GAME 1 0.3 1.5MD ARTWORK 893 929.7 1.4LA BOOK 350 328.3 1.4AZ GAME 155 140.8 1.4NC CALENDA 125 112.6 1.4PA APPAREL 374 397.3 1.4NS BOOK 2 0.9 1.4BC BOOK 2 0.9 1.4FR BOOK 2 0.9 1.4LA OTHER 14 18.9 1.3MN BOOK 806 838.4 1.3NF FREEBIE 1 0.3 1.2SP FREEBIE 1 0.3 1.2NM FREEBIE 86 76.4 1.2NE OTHER 4 6.9 1.2TX ARTWORK 1,423 1,464.7 1.2WV APPAREL 7 10.5 1.2AP ARTWORK 2 4.2 1.2CO CALENDA 89 99.8 1.2WV ARTWORK 37 44.1 1.1VA APPAREL 218 234.3 1.1DC GAME 133 121.5 1.1
FREEBIE 49 42.2 1.1VT FREEBIE 103 93.1 1.1OK OTHER 14 10.7 1.0OH BOOK 1,713 1,755.8 1.0
SD APPAREL 2 4.1 1.0MI OTHER 108 98.0 1.0IN OTHER 39 33.2 1.0RI APPAREL 48 55.5 1.0CA ARTWORK 4,249 4,184.0 1.0TX APPAREL 332 350.3 1.0CT OCCASION 1,795 1,836.8 0.9MA OCCASION 1,320 1,355.7 0.9BC OCCASION 1 0.4 0.9PE OCCASION 1 0.4 0.9ON OCCASION 1 0.4 0.9NS OCCASION 1 0.4 0.9WV FREEBIE 26 21.5 0.9OR OCCASION 286 270.1 0.9KY CALENDA 30 35.8 0.9SD ARTWORK 13 17.0 0.9FL FREEBIE 1,135 1,167.9 0.9ME APPAREL 38 44.4 0.9MS CALENDA 13 10.0 0.9CA FREEBIE 2,000 2,043.2 0.9AR OTHER 4 6.4 0.9PR GAME 7 10.0 0.9SC APPAREL 58 51.2 0.9MT ARTWORK 31 26.2 0.9IL APPAREL 343 326.0 0.9MS ARTWORK 44 50.7 0.9SC OTHER 19 23.5 0.9NE BOOK 109 119.0 0.8NM APPAREL 43 37.4 0.8OK ARTWORK 106 97.1 0.8MT FREEBIE 16 12.8 0.8AL APPAREL 29 34.3 0.8RI OTHER 30 25.5 0.8HI OCCASION 51 57.8 0.8MS OCCASION 48 42.2 0.8ID BOOK 84 92.5 0.8HI GAME 22 18.3 0.8UT OTHER 12 9.3 0.8CO ARTWORK 487 506.5 0.8ID OCCASION 35 40.5 0.7OR FREEBIE 169 158.2 0.7MS FREEBIE 29 24.7 0.7IA BOOK 210 222.7 0.7AL BOOK 259 273.0 0.7AL GAME 43 37.8 0.7IN BOOK 556 576.1 0.7FL OCCASION 1,957 1,994.1 0.7LA GAME 51 45.4 0.7AL OTHER 19 15.7 0.7VA OTHER 99 107.5 0.7UK BOOK 1 0.4 0.7SK BOOK 1 0.4 0.7PQ BOOK 1 0.4 0.7. BOOK 1 0.4 0.7
AB BOOK 1 0.4 0.7US BOOK 1 0.4 0.7QL BOOK 1 0.4 0.7YU BOOK 1 0.4 0.7DF BOOK 1 0.4 0.7MB BOOK 1 0.4 0.7EN BOOK 1 0.4 0.7NT BOOK 1 0.4 0.7SR BOOK 1 0.4 0.7NB BOOK 1 0.4 0.7LC BOOK 1 0.4 0.7MG BOOK 1 0.4 0.7MT OCCASION 18 21.8 0.7AR APPAREL 17 14.0 0.7OH OTHER 93 101.1 0.7PR FREEBIE 22 18.5 0.7ND ARTWORK 8 10.6 0.6AR BOOK 103 111.4 0.6WY APPAREL 4 5.9 0.6AK CALENDA 8 6.1 0.6MO ARTWORK 340 354.6 0.6NS ARTWORK 1 0.5 0.6ON ARTWORK 1 0.5 0.6BC ARTWORK 1 0.5 0.6NM OTHER 14 17.2 0.6DC OTHER 56 50.6 0.6CT OTHER 230 241.8 0.6AK OTHER 2 3.4 0.6ND CALENDA 1 2.1 0.6WY BOOK 42 47.2 0.6VI OTHER 1 0.5 0.5WI OCCASION 350 336.9 0.5AA BOOK 3 4.5 0.5VI ARTWORK 3 4.5 0.5OK OCCASION 87 80.9 0.5IN APPAREL 78 72.3 0.5OK GAME 29 25.6 0.5MD BOOK 1,744 1,772.0 0.4CT CALENDA 420 433.8 0.4VI OCCASION 5 3.7 0.4MO OTHER 43 38.9 0.4AP FREEBIE 3 2.1 0.4PR APPAREL 11 9.1 0.4IA ARTWORK 110 116.9 0.4DE OTHER 14 16.6 0.4WI CALENDA 74 79.6 0.4CO APPAREL 128 121.1 0.4MN OTHER 44 48.3 0.4AE FREEBIE 8 6.4 0.4TN APPAREL 61 66.0 0.4RI OCCASION 202 193.5 0.4DC BOOK 896 877.9 0.4MS OTHER 7 5.6 0.4MS APPAREL 10 12.1 0.4
RI BOOK 455 442.3 0.4NV APPAREL 38 34.5 0.4HI APPAREL 19 16.6 0.4OR OTHER 32 35.6 0.4AA APPAREL 1 0.6 0.3MN CALENDA 92 86.6 0.3ID OTHER 4 5.3 0.3WA OTHER 74 79.1 0.3NF BOOK 2 1.3 0.3SP BOOK 2 1.3 0.3VI FREEBIE 3 2.2 0.3VT ARTWORK 183 190.6 0.3FL GAME 617 630.8 0.3HI FREEBIE 37 33.8 0.3NF OCCASION 1 0.6 0.3NC OTHER 67 62.8 0.3AL CALENDA 31 28.2 0.3DE BOOK 279 287.8 0.3MA APPAREL 399 388.8 0.3AK ARTWORK 28 30.9 0.3MT OTHER 2 2.9 0.3IA OTHER 11 12.8 0.3ID CALENDA 8 9.6 0.3GU BOOK 3 2.2 0.3MT APPAREL 5 6.3 0.3LA CALENDA 31 33.9 0.3NC ARTWORK 560 571.8 0.2MO OCCASION 304 295.6 0.2WA BOOK 1,355 1,372.7 0.2AR OCCASION 52 48.7 0.2SD BOOK 35 32.3 0.2DC FREEBIE 218 224.9 0.2FL OTHER 270 262.6 0.2MO CALENDA 66 69.8 0.2TN CALENDA 51 54.3 0.2KY GAME 51 47.9 0.2AZ OTHER 62 58.6 0.2AR CALENDA 13 11.5 0.2UT ARTWORK 81 85.1 0.2IA CALENDA 21 23.0 0.2NJ Err:512 1 0.7 0.2GA APPAREL 166 160.9 0.2WA APPAREL 167 172.2 0.2WI OTHER 47 44.4 0.2WY CALENDA 4 4.9 0.2KY APPAREL 46 43.4 0.2WV OTHER 4 4.8 0.1CO GAME 138 133.6 0.1MI APPAREL 219 213.5 0.1NE CALENDA 11 12.3 0.1ME OTHER 22 20.4 0.1IL OTHER 154 149.7 0.1DE APPAREL 34 36.1 0.1OR CALENDA 61 63.8 0.1
NH FREEBIE 92 88.7 0.1SP ARTWORK 1 0.7 0.1NF ARTWORK 1 0.7 0.1WA OCCASION 609 600.5 0.1NY APPAREL 2,979 2,997.7 0.1ND APPAREL 2 2.5 0.1NC OCCASION 484 476.8 0.1OH GAME 238 243.0 0.1CO OCCASION 416 422.4 0.1SD OCCASION 13 14.1 0.1UT GAME 21 22.4 0.1AE OCCASION 10 11.0 0.1NV OTHER 17 15.8 0.1ND OCCASION 8 8.8 0.1KS CALENDA 21 22.3 0.1KS BOOK 220 216.0 0.1IA OCCASION 100 97.4 0.1DC CALENDA 93 90.7 0.1UT FREEBIE 40 41.5 0.1NH OTHER 21 19.9 0.1NV ARTWORK 147 144.2 0.1PA GAME 443 438.2 0.1WV CALENDA 8 8.7 0.1MD APPAREL 219 222.3 0.0OR BOOK 612 617.4 0.0KY BOOK 350 346.2 0.0IL OCCASION 1,130 1,136.6 0.0SD CALENDA 3 3.3 0.0WY GAME 7 6.5 0.0FL CALENDA 475 471.0 0.0AZ CALENDA 107 105.1 0.0IL GAME 363 359.6 0.0ID APPAREL 11 11.6 0.0PR CALENDA 7 7.5 0.0NV BOOK 272 274.8 0.0CT FREEBIE 1,081 1,075.7 0.0VI BOOK 9 8.5 0.0WA CALENDA 140 141.8 0.0ND OTHER 1 1.2 0.0AZ OCCASION 442 445.1 0.0WY OCCASION 20 20.6 0.0NJ BOOK 9,503 9,515.8 0.0NH CALENDA 35 35.8 0.0ND GAME 3 2.8 0.0NV OCCASION 119 120.2 0.0ON BOOK 1 0.9 0.0PE BOOK 1 0.9 0.0MD OTHER 101 102.1 0.0SD FREEBIE 8 8.3 0.0TX OTHER 162 160.8 0.0MA BOOK 3,104 3,098.9 0.0ID ARTWORK 49 48.5 0.0ID FREEBIE 24 23.7 0.0MI OCCASION 746 744.3 0.0
WY ARTWORK 25 24.7 0.0AK OCCASION 26 25.7 0.0
ARTWORK 86 86.5 0.0AP BOOK 8 8.1 0.0AA OCCASION 2 2.0 0.0WI FREEBIE 197 197.3 0.0TX OCCASION 1,222 1,221.3 0.0CO BOOK 965 965.5 0.0TN ARTWORK 276 275.9 0.0
GROUP OBSERVED EXPECTED CHI-SQUAREGAME 2,599 3,306.4 151.4 NY GAME 2,598 3,306.10ARTWORK 1,848 2,391.6 123.5 FL ARTWORK 1,847 2,391.30FREEBIE 5,289 6,121.4 113.2 NY FREEBIE 5,288 6,121.00ARTWORK 13,592 12,535.2 89.1 NY ARTWORK 13,591 12,534.80ARTWORK 5,636 4,992.6 82.9 NJ ARTWORK 5,635 4,992.20OCCASION 9,710 10,452.0 52.7 NY OCCASION 9,709 10,451.60GAME 1,074 1,316.9 44.8 AP OTHER 5 0.4OTHER 5 0.5 44.2 NJ GAME 1,073 1,316.70APPAREL 725 571.9 41.0 FL APPAREL 724 571.8GAME 560 428.9 40.1 NJ CALENDAR 784 983CALENDAR 785 983.2 40.0 MA GAME 559 428.8
151.7123.9113.4
8982.852.847.345.140.540.339.6
WITH pmg as ( SELECT o.PaymentType, Month(o.OrderDate) as mon, p.GroupName, 1.0*COUNT(*) as cnt FROM Orders o JOIN OrderLines ol ON o.OrderId = ol.OrderId JOIN Products p ON ol.ProductId = p.ProductId GROUP BY o.PaymentType, Month(o.OrderDate), p.GroupName ), pmgmarg as ( SELECT pmg.*, SUM(cnt) OVER (PARTITION BY PaymentType) as cnt_pt, SUM(cnt) OVER (PARTITION BY mon) as cnt_mon, SUM(cnt) OVER (PARTITION BY GroupName) as cnt_gn, SUM(cnt) OVER () as cnt_all FROM pmg ), pmgexp as ( SELECT pmgmarg.*, (cnt_pt * cnt_mon * cnt_gn) / POWER(cnt_all, 2) as ExpectedValue FROM pmgmarg )SELECT pmgexp.*, SQUARE(cnt - ExpectedValue) / ExpectedValue as chi2FROM pmgexpORDER BY chi2 DESC
PaymentTymon GroupNamcnt cnt_pt cnt_mon cnt_gn cnt_allOC 8 APPAREL 2,120 10,641 18,349 12,348 286,017?? 3 APPAREL 110 390 17,239 12,348 286,017OC 10 APPAREL 612 10,641 20,476 12,348 286,017DB 7 Err:512 8 17,878 15,794 9 286,017OC 4 APPAREL 204 10,641 14,462 12,348 286,017MC 6 OCCASION 1,755 71,006 21,839 41,713 286,017VI 6 OCCASION 2,456 113,043 21,839 41,713 286,017VI 12 GAME 2,712 113,043 57,033 18,469 286,017OC 9 APPAREL 186 10,641 16,543 12,348 286,017MC 12 GAME 1,716 71,006 57,033 18,469 286,017DB 11 ARTWORK 1,179 17,878 45,850 56,498 286,017VI 1 FREEBIE 204 113,043 24,760 28,073 286,017MC 11 FREEBIE 1,893 71,006 45,850 28,073 286,017OC 3 APPAREL 149 10,641 17,239 12,348 286,017VI 11 FREEBIE 2,745 113,043 45,850 28,073 286,017AE 6 OCCASION 1,461 73,059 21,839 41,713 286,017AE 12 CALENDA 970 73,059 57,033 9,872 286,017VI 2 BOOK 3,268 113,043 14,611 113,210 286,017VI 12 CALENDA 1,350 113,043 57,033 9,872 286,017AE 1 FREEBIE 122 73,059 24,760 28,073 286,017DB 11 BOOK 1,807 17,878 45,850 113,210 286,017AE 12 OTHER 637 73,059 57,033 5,825 286,017VI 7 OCCASION 1,498 113,043 15,794 41,713 286,017VI 4 BOOK 3,188 113,043 14,462 113,210 286,017MC 1 FREEBIE 127 71,006 24,760 28,073 286,017VI 4 FREEBIE 103 113,043 14,462 28,073 286,017MC 12 CALENDA 877 71,006 57,033 9,872 286,017
VI 2 FREEBIE 151 113,043 14,611 28,073 286,017DB 1 BOOK 1,039 17,878 24,760 113,210 286,017AE 1 ARTWORK 1,841 73,059 24,760 56,498 286,017AE 11 FREEBIE 1,714 73,059 45,850 28,073 286,017VI 5 OCCASION 1,642 113,043 19,061 41,713 286,017MC 6 FREEBIE 902 71,006 21,839 28,073 286,017VI 12 OTHER 802 113,043 57,033 5,825 286,017MC 5 FREEBIE 808 71,006 19,061 28,073 286,017VI 3 BOOK 3,522 113,043 17,239 113,210 286,017AE 4 FREEBIE 61 73,059 14,462 28,073 286,017VI 3 OCCASION 499 113,043 17,239 41,713 286,017VI 5 FREEBIE 1,166 113,043 19,061 28,073 286,017MC 4 FREEBIE 59 71,006 14,462 28,073 286,017MC 7 OCCASION 945 71,006 15,794 41,713 286,017AE 2 FREEBIE 70 73,059 14,611 28,073 286,017AE 12 OCCASION 1,416 73,059 57,033 41,713 286,017VI 1 BOOK 4,828 113,043 24,760 113,210 286,017MC 4 BOOK 1,985 71,006 14,462 113,210 286,017AE 12 GAME 1,394 73,059 57,033 18,469 286,017MC 2 BOOK 1,990 71,006 14,611 113,210 286,017AE 6 BOOK 1,530 73,059 21,839 113,210 286,017OC 7 APPAREL 98 10,641 15,794 12,348 286,017VI 9 BOOK 3,318 113,043 16,543 113,210 286,017AE 11 CALENDA 691 73,059 45,850 9,872 286,017VI 6 BOOK 2,586 113,043 21,839 113,210 286,017VI 11 APPAREL 393 113,043 45,850 12,348 286,017DB 6 BOOK 217 17,878 21,839 113,210 286,017VI 6 FREEBIE 1,251 113,043 21,839 28,073 286,017VI 11 CALENDA 972 113,043 45,850 9,872 286,017MC 2 FREEBIE 95 71,006 14,611 28,073 286,017VI 5 CALENDA 40 113,043 19,061 9,872 286,017DB 9 CALENDA 117 17,878 16,543 9,872 286,017AE 11 OCCASION 1,146 73,059 45,850 41,713 286,017MC 12 OTHER 518 71,006 57,033 5,825 286,017DB 10 ARTWORK 463 17,878 20,476 56,498 286,017MC 12 FREEBIE 1,878 71,006 57,033 28,073 286,017AE 3 ARTWORK 1,256 73,059 17,239 56,498 286,017AE 11 APPAREL 214 73,059 45,850 12,348 286,017DB 12 FREEBIE 110 17,878 57,033 28,073 286,017DB 8 OCCASION 332 17,878 18,349 41,713 286,017MC 11 CALENDA 645 71,006 45,850 9,872 286,017VI 7 CALENDA 31 113,043 15,794 9,872 286,017VI 12 FREEBIE 2,797 113,043 57,033 28,073 286,017AE 3 OCCASION 331 73,059 17,239 41,713 286,017VI 6 CALENDA 88 113,043 21,839 9,872 286,017MC 5 OCCASION 1,009 71,006 19,061 41,713 286,017AE 5 FREEBIE 740 73,059 19,061 28,073 286,017VI 8 OCCASION 1,445 113,043 18,349 41,713 286,017MC 3 BOOK 2,180 71,006 17,239 113,210 286,017VI 12 ARTWORK 3,669 113,043 57,033 56,498 286,017DB 1 OCCASION 402 17,878 24,760 41,713 286,017AE 2 BOOK 1,927 73,059 14,611 113,210 286,017DB 1 ARTWORK 510 17,878 24,760 56,498 286,017DB 10 CALENDA 121 17,878 20,476 9,872 286,017AE 6 CALENDA 35 73,059 21,839 9,872 286,017AE 4 ARTWORK 1,036 73,059 14,462 56,498 286,017AE 8 GAME 106 73,059 18,349 18,469 286,017
AE 10 ARTWORK 1,396 73,059 20,476 56,498 286,017AE 5 CALENDA 22 73,059 19,061 9,872 286,017DB 11 GAME 32 17,878 45,850 18,469 286,017AE 3 BOOK 2,210 73,059 17,239 113,210 286,017MC 3 OCCASION 347 71,006 17,239 41,713 286,017AE 11 OTHER 408 73,059 45,850 5,825 286,017AE 1 GAME 188 73,059 24,760 18,469 286,017AE 5 ARTWORK 1,297 73,059 19,061 56,498 286,017DB 1 FREEBIE 20 17,878 24,760 28,073 286,017DB 7 BOOK 599 17,878 15,794 113,210 286,017AE 7 ARTWORK 1,092 73,059 15,794 56,498 286,017DB 1 OTHER 90 17,878 24,760 5,825 286,017VI 4 CALENDA 51 113,043 14,462 9,872 286,017AE 4 BOOK 1,860 73,059 14,462 113,210 286,017MC 6 CALENDA 45 71,006 21,839 9,872 286,017VI 12 OCCASION 2,692 113,043 57,033 41,713 286,017MC 5 CALENDA 31 71,006 19,061 9,872 286,017AE 7 OCCASION 838 73,059 15,794 41,713 286,017VI 11 OCCASION 2,115 113,043 45,850 41,713 286,017DB 9 APPAREL 113 17,878 16,543 12,348 286,017AE 1 BOOK 3,007 73,059 24,760 113,210 286,017AE 11 ARTWORK 2,788 73,059 45,850 56,498 286,017AE 7 CALENDA 23 73,059 15,794 9,872 286,017OC 11 BOOK 420 10,641 45,850 113,210 286,017OC 12 ARTWORK 219 10,641 57,033 56,498 286,017DB 10 FREEBIE 17 17,878 20,476 28,073 286,017OC 12 BOOK 562 10,641 57,033 113,210 286,017OC 6 FREEBIE 165 10,641 21,839 28,073 286,017AE 2 ARTWORK 994 73,059 14,611 56,498 286,017AE 5 OCCASION 961 73,059 19,061 41,713 286,017AE 6 FREEBIE 765 73,059 21,839 28,073 286,017AE 7 BOOK 1,229 73,059 15,794 113,210 286,017MC 12 OCCASION 1,649 71,006 57,033 41,713 286,017AE 5 BOOK 1,527 73,059 19,061 113,210 286,017MC 9 BOOK 1,992 71,006 16,543 113,210 286,017VI 6 ARTWORK 1,331 113,043 21,839 56,498 286,017DB 11 APPAREL 23 17,878 45,850 12,348 286,017MC 12 ARTWORK 2,318 71,006 57,033 56,498 286,017VI 1 ARTWORK 2,331 113,043 24,760 56,498 286,017VI 1 APPAREL 238 113,043 24,760 12,348 286,017AE 2 OCCASION 335 73,059 14,611 41,713 286,017VI 10 APPAREL 182 113,043 20,476 12,348 286,017VI 9 ARTWORK 970 113,043 16,543 56,498 286,017DB 4 FREEBIE 5 17,878 14,462 28,073 286,017MC 7 CALENDA 32 71,006 15,794 9,872 286,017VI 1 OCCASION 1,092 113,043 24,760 41,713 286,017MC 6 BOOK 1,735 71,006 21,839 113,210 286,017MC 6 ARTWORK 781 71,006 21,839 56,498 286,017DB 12 GAME 96 17,878 57,033 18,469 286,017DB 12 APPAREL 45 17,878 57,033 12,348 286,017AE 10 APPAREL 95 73,059 20,476 12,348 286,017DB 8 BOOK 271 17,878 18,349 113,210 286,017AE 4 CALENDA 31 73,059 14,462 9,872 286,017AE 9 BOOK 2,020 73,059 16,543 113,210 286,017DB 9 FREEBIE 16 17,878 16,543 28,073 286,017MC 10 APPAREL 94 71,006 20,476 12,348 286,017VI 8 BOOK 2,418 113,043 18,349 113,210 286,017
AE 1 APPAREL 134 73,059 24,760 12,348 286,017DB 2 FREEBIE 10 17,878 14,611 28,073 286,017MC 11 APPAREL 306 71,006 45,850 12,348 286,017DB 5 BOOK 290 17,878 19,061 113,210 286,017DB 3 FREEBIE 20 17,878 17,239 28,073 286,017AE 1 OCCASION 672 73,059 24,760 41,713 286,017VI 8 CALENDA 120 113,043 18,349 9,872 286,017VI 3 FREEBIE 458 113,043 17,239 28,073 286,017OC 1 FREEBIE 13 10,641 24,760 28,073 286,017DB 2 ARTWORK 288 17,878 14,611 56,498 286,017MC 1 APPAREL 135 71,006 24,760 12,348 286,017DB 7 OCCASION 240 17,878 15,794 41,713 286,017AE 9 APPAREL 75 73,059 16,543 12,348 286,017?? 1 APPAREL 11 390 24,760 12,348 286,017VI 2 OCCASION 613 113,043 14,611 41,713 286,017DB 12 BOOK 1,115 17,878 57,033 113,210 286,017MC 11 OCCASION 1,340 71,006 45,850 41,713 286,017DB 8 FREEBIE 30 17,878 18,349 28,073 286,017AE 10 GAME 196 73,059 20,476 18,469 286,017VI 7 BOOK 2,088 113,043 15,794 113,210 286,017VI 12 APPAREL 734 113,043 57,033 12,348 286,017OC 11 OCCASION 128 10,641 45,850 41,713 286,017VI 11 OTHER 516 113,043 45,850 5,825 286,017DB 7 OTHER 54 17,878 15,794 5,825 286,017MC 4 CALENDA 40 71,006 14,462 9,872 286,017DB 11 FREEBIE 156 17,878 45,850 28,073 286,017OC 11 ARTWORK 200 10,641 45,850 56,498 286,017DB 11 OCCASION 266 17,878 45,850 41,713 286,017DB 6 FREEBIE 48 17,878 21,839 28,073 286,017DB 7 GAME 123 17,878 15,794 18,469 286,017AE 4 OCCASION 367 73,059 14,462 41,713 286,017MC 7 BOOK 1,261 71,006 15,794 113,210 286,017AE 2 CALENDA 45 73,059 14,611 9,872 286,017OC 8 ARTWORK 50 10,641 18,349 56,498 286,017AE 8 BOOK 1,543 73,059 18,349 113,210 286,017VI 2 CALENDA 97 113,043 14,611 9,872 286,017VI 10 GAME 357 113,043 20,476 18,469 286,017DB 8 CALENDA 85 17,878 18,349 9,872 286,017DB 5 FREEBIE 39 17,878 19,061 28,073 286,017MC 12 APPAREL 436 71,006 57,033 12,348 286,017VI 8 ARTWORK 1,166 113,043 18,349 56,498 286,017DB 2 OCCASION 213 17,878 14,611 41,713 286,017OC 6 BOOK 198 10,641 21,839 113,210 286,017VI 8 OTHER 64 113,043 18,349 5,825 286,017AE 1 CALENDA 320 73,059 24,760 9,872 286,017MC 1 OCCASION 691 71,006 24,760 41,713 286,017VI 9 OTHER 54 113,043 16,543 5,825 286,017MC 8 ARTWORK 695 71,006 18,349 56,498 286,017OC 3 ARTWORK 50 10,641 17,239 56,498 286,017AE 3 FREEBIE 291 73,059 17,239 28,073 286,017MC 11 OTHER 334 71,006 45,850 5,825 286,017MC 1 BOOK 2,764 71,006 24,760 113,210 286,017DB 9 GAME 12 17,878 16,543 18,469 286,017MC 12 BOOK 5,108 71,006 57,033 113,210 286,017VI 4 GAME 496 113,043 14,462 18,469 286,017OC 8 BOOK 162 10,641 18,349 113,210 286,017OC 4 FREEBIE 5 10,641 14,462 28,073 286,017
VI 7 OTHER 53 113,043 15,794 5,825 286,017AE 7 GAME 155 73,059 15,794 18,469 286,017AE 12 APPAREL 466 73,059 57,033 12,348 286,017?? 1 BOOK 37 390 24,760 113,210 286,017OC 5 BOOK 173 10,641 19,061 113,210 286,017OC 1 BOOK 242 10,641 24,760 113,210 286,017AE 11 GAME 580 73,059 45,850 18,469 286,017AE 6 APPAREL 142 73,059 21,839 12,348 286,017VI 4 OCCASION 650 113,043 14,462 41,713 286,017OC 4 ARTWORK 41 10,641 14,462 56,498 286,017DB 9 ARTWORK 114 17,878 16,543 56,498 286,017MC 11 ARTWORK 1,949 71,006 45,850 56,498 286,017AE 2 GAME 143 73,059 14,611 18,469 286,017DB 6 GAME 29 17,878 21,839 18,469 286,017AE 8 OTHER 34 73,059 18,349 5,825 286,017AE 9 OTHER 28 73,059 16,543 5,825 286,017VI 9 CALENDA 132 113,043 16,543 9,872 286,017DB 10 GAME 26 17,878 20,476 18,469 286,017MC 3 OTHER 29 71,006 17,239 5,825 286,017VI 11 BOOK 6,646 113,043 45,850 113,210 286,017AE 7 OTHER 26 73,059 15,794 5,825 286,017MC 9 APPAREL 95 71,006 16,543 12,348 286,017MC 8 BOOK 1,542 71,006 18,349 113,210 286,017OC 7 BOOK 139 10,641 15,794 113,210 286,017VI 5 BOOK 2,647 113,043 19,061 113,210 286,017MC 2 OCCASION 388 71,006 14,611 41,713 286,017DB 8 GAME 22 17,878 18,349 18,469 286,017OC 6 ARTWORK 84 10,641 21,839 56,498 286,017MC 2 CALENDA 58 71,006 14,611 9,872 286,017DB 6 CALENDA 6 17,878 21,839 9,872 286,017OC 7 ARTWORK 52 10,641 15,794 56,498 286,017VI 3 CALENDA 144 113,043 17,239 9,872 286,017DB 4 GAME 13 17,878 14,462 18,469 286,017OC 12 OCCASION 205 10,641 57,033 41,713 286,017OC 11 APPAREL 23 10,641 45,850 12,348 286,017VI 12 BOOK 8,365 113,043 57,033 113,210 286,017OC 1 OCCASION 66 10,641 24,760 41,713 286,017OC 6 APPAREL 70 10,641 21,839 12,348 286,017DB 2 BOOK 473 17,878 14,611 113,210 286,017AE 9 GAME 176 73,059 16,543 18,469 286,017MC 8 CALENDA 84 71,006 18,349 9,872 286,017MC 9 ARTWORK 646 71,006 16,543 56,498 286,017OC 10 BOOK 201 10,641 20,476 113,210 286,017VI 3 OTHER 71 113,043 17,239 5,825 286,017VI 10 ARTWORK 1,827 113,043 20,476 56,498 286,017AE 3 OTHER 36 73,059 17,239 5,825 286,017?? 11 APPAREL 12 390 45,850 12,348 286,017VI 9 APPAREL 189 113,043 16,543 12,348 286,017OC 2 FREEBIE 13 10,641 14,611 28,073 286,017DB 5 CALENDA 6 17,878 19,061 9,872 286,017DB 3 GAME 25 17,878 17,239 18,469 286,017OC 3 OCCASION 42 10,641 17,239 41,713 286,017DB 1 CALENDA 92 17,878 24,760 9,872 286,017AE 12 BOOK 5,367 73,059 57,033 113,210 286,017VI 3 ARTWORK 1,155 113,043 17,239 56,498 286,017MC 8 GAME 205 71,006 18,349 18,469 286,017VI 1 GAME 502 113,043 24,760 18,469 286,017
OC 5 ARTWORK 79 10,641 19,061 56,498 286,017VI 2 OTHER 62 113,043 14,611 5,825 286,017VI 6 OTHER 108 113,043 21,839 5,825 286,017MC 3 GAME 361 71,006 17,239 18,469 286,017OC 12 APPAREL 43 10,641 57,033 12,348 286,017DB 2 GAME 20 17,878 14,611 18,469 286,017DB 8 Err:512 1 17,878 18,349 9 286,017DB 12 CALENDA 179 17,878 57,033 9,872 286,017OC 4 OCCASION 34 10,641 14,462 41,713 286,017DB 8 ARTWORK 151 17,878 18,349 56,498 286,017MC 3 CALENDA 87 71,006 17,239 9,872 286,017AE 4 OTHER 32 73,059 14,462 5,825 286,017DB 2 OTHER 40 17,878 14,611 5,825 286,017MC 8 OTHER 45 71,006 18,349 5,825 286,017OC 9 ARTWORK 67 10,641 16,543 56,498 286,017MC 4 GAME 307 71,006 14,462 18,469 286,017DB 6 OCCASION 268 17,878 21,839 41,713 286,017AE 12 FREEBIE 1,614 73,059 57,033 28,073 286,017OC 6 OCCASION 171 10,641 21,839 41,713 286,017MC 5 BOOK 1,665 71,006 19,061 113,210 286,017VI 1 OTHER 132 113,043 24,760 5,825 286,017AE 3 GAME 204 73,059 17,239 18,469 286,017VI 10 OCCASION 1,342 113,043 20,476 41,713 286,017AE 2 OTHER 35 73,059 14,611 5,825 286,017VI 1 CALENDA 424 113,043 24,760 9,872 286,017MC 3 FREEBIE 324 71,006 17,239 28,073 286,017OC 11 GAME 61 10,641 45,850 18,469 286,017MC 9 OTHER 41 71,006 16,543 5,825 286,017?? 12 BOOK 5 390 57,033 113,210 286,017AE 10 BOOK 1,861 73,059 20,476 113,210 286,017DB 10 OCCASION 249 17,878 20,476 41,713 286,017DB 7 FREEBIE 52 17,878 15,794 28,073 286,017OC 10 ARTWORK 95 10,641 20,476 56,498 286,017MC 1 CALENDA 278 71,006 24,760 9,872 286,017MC 9 CALENDA 88 71,006 16,543 9,872 286,017DB 8 APPAREL 18 17,878 18,349 12,348 286,017AE 6 OTHER 66 73,059 21,839 5,825 286,017MC 4 OTHER 35 71,006 14,462 5,825 286,017OC 9 FREEBIE 26 10,641 16,543 28,073 286,017MC 4 OCCASION 423 71,006 14,462 41,713 286,017MC 1 OTHER 76 71,006 24,760 5,825 286,017VI 9 GAME 332 113,043 16,543 18,469 286,017AE 9 CALENDA 93 73,059 16,543 9,872 286,017MC 11 BOOK 4,213 71,006 45,850 113,210 286,017MC 8 OCCASION 774 71,006 18,349 41,713 286,017AE 5 OTHER 57 73,059 19,061 5,825 286,017?? 7 APPAREL 5 390 15,794 12,348 286,017MC 9 OCCASION 701 71,006 16,543 41,713 286,017DB 4 APPAREL 13 17,878 14,462 12,348 286,017MC 10 GAME 253 71,006 20,476 18,469 286,017AE 8 CALENDA 109 73,059 18,349 9,872 286,017OC 5 CALENDA 4 10,641 19,061 9,872 286,017MC 10 BOOK 1,827 71,006 20,476 113,210 286,017AE 4 APPAREL 108 73,059 14,462 12,348 286,017DB 6 ARTWORK 203 17,878 21,839 56,498 286,017OC 8 CALENDA 4 10,641 18,349 9,872 286,017MC 7 OTHER 44 71,006 15,794 5,825 286,017
VI 11 ARTWORK 3,342 113,043 45,850 56,498 286,017AE 11 BOOK 4,366 73,059 45,850 113,210 286,017MC 7 FREEBIE 461 71,006 15,794 28,073 286,017OC 10 GAME 22 10,641 20,476 18,469 286,017OC 4 CALENDA 2 10,641 14,462 9,872 286,017DB 5 APPAREL 24 17,878 19,061 12,348 286,017MC 4 APPAREL 108 71,006 14,462 12,348 286,017VI 4 OTHER 77 113,043 14,462 5,825 286,017VI 9 FREEBIE 550 113,043 16,543 28,073 286,017AE 3 CALENDA 108 73,059 17,239 9,872 286,017VI 7 FREEBIE 701 113,043 15,794 28,073 286,017?? 6 FREEBIE 9 390 21,839 28,073 286,017AE 12 ARTWORK 3,068 73,059 57,033 56,498 286,017AE 5 APPAREL 159 73,059 19,061 12,348 286,017DB 9 OCCASION 194 17,878 16,543 41,713 286,017VI 5 OTHER 111 113,043 19,061 5,825 286,017OC 12 GAME 177 10,641 57,033 18,469 286,017DB 2 APPAREL 18 17,878 14,611 12,348 286,017DB 5 ARTWORK 183 17,878 19,061 56,498 286,017OC 6 CALENDA 10 10,641 21,839 9,872 286,017DB 1 APPAREL 39 17,878 24,760 12,348 286,017?? 12 FREEBIE 17 390 57,033 28,073 286,017MC 6 OTHER 75 71,006 21,839 5,825 286,017VI 9 OCCASION 1,057 113,043 16,543 41,713 286,017OC 2 ARTWORK 73 10,641 14,611 56,498 286,017VI 2 APPAREL 197 113,043 14,611 12,348 286,017MC 5 OTHER 64 71,006 19,061 5,825 286,017OC 1 APPAREL 19 10,641 24,760 12,348 286,017OC 3 FREEBIE 37 10,641 17,239 28,073 286,017?? 9 FREEBIE 7 390 16,543 28,073 286,017OC 8 OTHER 2 10,641 18,349 5,825 286,017?? 6 BOOK 1 390 21,839 113,210 286,017MC 6 GAME 408 71,006 21,839 18,469 286,017OC 9 CALENDA 7 10,641 16,543 9,872 286,017?? 12 OCCASION 1 390 57,033 41,713 286,017MC 9 GAME 216 71,006 16,543 18,469 286,017AE 5 GAME 261 73,059 19,061 18,469 286,017OC 3 CALENDA 8 10,641 17,239 9,872 286,017DB 10 APPAREL 33 17,878 20,476 12,348 286,017VI 6 GAME 628 113,043 21,839 18,469 286,017MC 2 GAME 189 71,006 14,611 18,469 286,017OC 2 OCCASION 53 10,641 14,611 41,713 286,017OC 1 OTHER 6 10,641 24,760 5,825 286,017VI 4 ARTWORK 1,031 113,043 14,462 56,498 286,017VI 5 ARTWORK 1,376 113,043 19,061 56,498 286,017?? 5 BOOK 1 390 19,061 113,210 286,017DB 4 OCCASION 164 17,878 14,462 41,713 286,017DB 4 CALENDA 16 17,878 14,462 9,872 286,017AE 8 ARTWORK 1,008 73,059 18,349 56,498 286,017?? 11 OCCASION 1 390 45,850 41,713 286,017DB 7 APPAREL 60 17,878 15,794 12,348 286,017MC 2 OTHER 51 71,006 14,611 5,825 286,017AE 9 FREEBIE 361 73,059 16,543 28,073 286,017OC 1 ARTWORK 147 10,641 24,760 56,498 286,017?? 7 BOOK 1 390 15,794 113,210 286,017?? 10 FREEBIE 7 390 20,476 28,073 286,017?? 12 APPAREL 8 390 57,033 12,348 286,017
AE 2 APPAREL 129 73,059 14,611 12,348 286,017OC 3 OTHER 4 10,641 17,239 5,825 286,017OC 2 CALENDA 8 10,641 14,611 9,872 286,017?? 2 BOOK 1 390 14,611 113,210 286,017OC 1 CALENDA 18 10,641 24,760 9,872 286,017AE 8 OCCASION 747 73,059 18,349 41,713 286,017AE 10 CALENDA 213 73,059 20,476 9,872 286,017DB 7 CALENDA 20 17,878 15,794 9,872 286,017OC 9 OTHER 4 10,641 16,543 5,825 286,017OC 9 BOOK 206 10,641 16,543 113,210 286,017DB 5 OCCASION 142 17,878 19,061 41,713 286,017DB 12 ARTWORK 768 17,878 57,033 56,498 286,017?? 6 APPAREL 4 390 21,839 12,348 286,017DB 10 BOOK 559 17,878 20,476 113,210 286,017DB 3 CALENDA 23 17,878 17,239 9,872 286,017DB 11 CALENDA 122 17,878 45,850 9,872 286,017?? 9 BOOK 2 390 16,543 113,210 286,017OC 10 FREEBIE 55 10,641 20,476 28,073 286,017OC 1 GAME 42 10,641 24,760 18,469 286,017OC 3 BOOK 218 10,641 17,239 113,210 286,017DB 12 OCCASION 469 17,878 57,033 41,713 286,017?? 3 OTHER 2 390 17,239 5,825 286,017VI 11 GAME 1,095 113,043 45,850 18,469 286,017VI 7 GAME 359 113,043 15,794 18,469 286,017OC 5 GAME 31 10,641 19,061 18,469 286,017AE 1 OTHER 104 73,059 24,760 5,825 286,017AE 6 GAME 319 73,059 21,839 18,469 286,017OC 8 OCCASION 78 10,641 18,349 41,713 286,017DB 1 GAME 79 17,878 24,760 18,469 286,017VI 8 GAME 423 113,043 18,349 18,469 286,017MC 7 GAME 220 71,006 15,794 18,469 286,017OC 5 FREEBIE 87 10,641 19,061 28,073 286,017?? 4 BOOK 2 390 14,462 113,210 286,017OC 8 FREEBIE 50 10,641 18,349 28,073 286,017DB 6 APPAREL 43 17,878 21,839 12,348 286,017?? 3 BOOK 3 390 17,239 113,210 286,017AE 10 OCCASION 706 73,059 20,476 41,713 286,017AE 10 FREEBIE 467 73,059 20,476 28,073 286,017VI 2 GAME 334 113,043 14,611 18,469 286,017OC 7 OTHER 5 10,641 15,794 5,825 286,017VI 10 BOOK 3,090 113,043 20,476 113,210 286,017?? 7 FREEBIE 5 390 15,794 28,073 286,017VI 7 ARTWORK 1,164 113,043 15,794 56,498 286,017?? 11 FREEBIE 11 390 45,850 28,073 286,017DB 3 ARTWORK 241 17,878 17,239 56,498 286,017AE 8 APPAREL 175 73,059 18,349 12,348 286,017MC 10 OTHER 123 71,006 20,476 5,825 286,017DB 3 OTHER 13 17,878 17,239 5,825 286,017OC 6 OTHER 9 10,641 21,839 5,825 286,017OC 12 CALENDA 89 10,641 57,033 9,872 286,017DB 4 BOOK 323 17,878 14,462 113,210 286,017VI 4 APPAREL 218 113,043 14,462 12,348 286,017MC 1 ARTWORK 1,278 71,006 24,760 56,498 286,017VI 2 ARTWORK 1,079 113,043 14,611 56,498 286,017OC 8 GAME 32 10,641 18,349 18,469 286,017OC 10 CALENDA 17 10,641 20,476 9,872 286,017DB 12 OTHER 88 17,878 57,033 5,825 286,017
MC 8 APPAREL 222 71,006 18,349 12,348 286,017VI 3 APPAREL 325 113,043 17,239 12,348 286,017AE 10 OTHER 88 73,059 20,476 5,825 286,017?? 5 APPAREL 3 390 19,061 12,348 286,017VI 8 FREEBIE 759 113,043 18,349 28,073 286,017DB 9 OTHER 13 17,878 16,543 5,825 286,017OC 2 APPAREL 15 10,641 14,611 12,348 286,017DB 4 OTHER 11 17,878 14,462 5,825 286,017OC 2 GAME 25 10,641 14,611 18,469 286,017VI 5 GAME 449 113,043 19,061 18,469 286,017OC 10 OCCASION 94 10,641 20,476 41,713 286,017DB 9 BOOK 377 17,878 16,543 113,210 286,017VI 10 OTHER 185 113,043 20,476 5,825 286,017AE 6 ARTWORK 1,154 73,059 21,839 56,498 286,017MC 3 APPAREL 206 71,006 17,239 12,348 286,017?? 3 ARTWORK 8 390 17,239 56,498 286,017MC 11 GAME 693 71,006 45,850 18,469 286,017OC 7 FREEBIE 46 10,641 15,794 28,073 286,017?? 4 GAME 3 390 14,462 18,469 286,017DB 8 OTHER 16 17,878 18,349 5,825 286,017?? 10 OCCASION 1 390 20,476 41,713 286,017MC 9 FREEBIE 373 71,006 16,543 28,073 286,017OC 4 OTHER 6 10,641 14,462 5,825 286,017OC 7 GAME 29 10,641 15,794 18,469 286,017DB 3 OCCASION 139 17,878 17,239 41,713 286,017?? 12 ARTWORK 21 390 57,033 56,498 286,017OC 9 GAME 31 10,641 16,543 18,469 286,017OC 5 APPAREL 23 10,641 19,061 12,348 286,017DB 11 OTHER 48 17,878 45,850 5,825 286,017OC 12 OTHER 52 10,641 57,033 5,825 286,017OC 5 OCCASION 117 10,641 19,061 41,713 286,017MC 2 APPAREL 140 71,006 14,611 12,348 286,017MC 4 ARTWORK 674 71,006 14,462 56,498 286,017?? 1 OCCASION 2 390 24,760 41,713 286,017?? 3 OCCASION 1 390 17,239 41,713 286,017OC 4 BOOK 232 10,641 14,462 113,210 286,017DB 3 APPAREL 38 17,878 17,239 12,348 286,017?? 4 APPAREL 2 390 14,462 12,348 286,017AE 7 APPAREL 158 73,059 15,794 12,348 286,017MC 8 FREEBIE 473 71,006 18,349 28,073 286,017OC 5 OTHER 10 10,641 19,061 5,825 286,017?? 9 ARTWORK 2 390 16,543 56,498 286,017OC 11 CALENDA 50 10,641 45,850 9,872 286,017AE 7 FREEBIE 373 73,059 15,794 28,073 286,017AE 3 APPAREL 206 73,059 17,239 12,348 286,017OC 10 OTHER 11 10,641 20,476 5,825 286,017DB 3 BOOK 450 17,878 17,239 113,210 286,017VI 5 APPAREL 306 113,043 19,061 12,348 286,017VI 10 FREEBIE 824 113,043 20,476 28,073 286,017?? 12 CALENDA 1 390 57,033 9,872 286,017DB 5 GAME 68 17,878 19,061 18,469 286,017?? 4 OTHER 1 390 14,462 5,825 286,017?? 5 ARTWORK 3 390 19,061 56,498 286,017OC 2 OTHER 8 10,641 14,611 5,825 286,017?? 5 FREEBIE 4 390 19,061 28,073 286,017MC 5 GAME 290 71,006 19,061 18,469 286,017MC 3 ARTWORK 820 71,006 17,239 56,498 286,017
DB 5 OTHER 20 17,878 19,061 5,825 286,017VI 7 APPAREL 283 113,043 15,794 12,348 286,017VI 6 APPAREL 357 113,043 21,839 12,348 286,017?? 1 GAME 1 390 24,760 18,469 286,017MC 10 CALENDA 186 71,006 20,476 9,872 286,017MC 10 OCCASION 763 71,006 20,476 41,713 286,017AE 8 FREEBIE 443 73,059 18,349 28,073 286,017DB 4 ARTWORK 168 17,878 14,462 56,498 286,017?? 1 CALENDA 2 390 24,760 9,872 286,017?? 11 ARTWORK 15 390 45,850 56,498 286,017?? 10 APPAREL 2 390 20,476 12,348 286,017OC 11 OTHER 31 10,641 45,850 5,825 286,017?? 7 ARTWORK 3 390 15,794 56,498 286,017MC 7 APPAREL 177 71,006 15,794 12,348 286,017DB 10 OTHER 29 17,878 20,476 5,825 286,017?? 4 ARTWORK 5 390 14,462 56,498 286,017OC 7 OCCASION 81 10,641 15,794 41,713 286,017?? 6 OTHER 1 390 21,839 5,825 286,017OC 9 OCCASION 85 10,641 16,543 41,713 286,017OC 11 FREEBIE 161 10,641 45,850 28,073 286,017?? 2 ARTWORK 3 390 14,611 56,498 286,017?? 12 OTHER 1 390 57,033 5,825 286,017?? 6 ARTWORK 7 390 21,839 56,498 286,017?? 3 FREEBIE 3 390 17,239 28,073 286,017VI 10 CALENDA 272 113,043 20,476 9,872 286,017?? 12 GAME 6 390 57,033 18,469 286,017AE 9 ARTWORK 847 73,059 16,543 56,498 286,017?? 3 GAME 1 390 17,239 18,469 286,017AE 9 OCCASION 606 73,059 16,543 41,713 286,017MC 1 GAME 389 71,006 24,760 18,469 286,017?? 4 CALENDA 1 390 14,462 9,872 286,017MC 5 ARTWORK 923 71,006 19,061 56,498 286,017OC 4 GAME 37 10,641 14,462 18,469 286,017MC 7 ARTWORK 764 71,006 15,794 56,498 286,017?? 2 CALENDA 1 390 14,611 9,872 286,017OC 3 GAME 39 10,641 17,239 18,469 286,017OC 12 FREEBIE 203 10,641 57,033 28,073 286,017AE 4 GAME 234 73,059 14,462 18,469 286,017?? 8 FREEBIE 2 390 18,349 28,073 286,017DB 7 ARTWORK 199 17,878 15,794 56,498 286,017OC 2 BOOK 211 10,641 14,611 113,210 286,017VI 8 APPAREL 318 113,043 18,349 12,348 286,017?? 1 ARTWORK 6 390 24,760 56,498 286,017VI 3 GAME 445 113,043 17,239 18,469 286,017DB 6 OTHER 29 17,878 21,839 5,825 286,017?? 10 ARTWORK 5 390 20,476 56,498 286,017MC 6 APPAREL 237 71,006 21,839 12,348 286,017?? 9 OCCASION 3 390 16,543 41,713 286,017MC 10 ARTWORK 1,009 71,006 20,476 56,498 286,017?? 2 APPAREL 1 390 14,611 12,348 286,017DB 2 CALENDA 31 17,878 14,611 9,872 286,017MC 10 FREEBIE 501 71,006 20,476 28,073 286,017MC 5 APPAREL 203 71,006 19,061 12,348 286,017OC 6 GAME 52 10,641 21,839 18,469 286,017?? 9 APPAREL 1 390 16,543 12,348 286,017?? 8 ARTWORK 5 390 18,349 56,498 286,017MC 2 ARTWORK 716 71,006 14,611 56,498 286,017
SELECT YEAR(OrderDate), ol.ProductId, COUNT(*) as cntFROM Orders o JOIN OrderLines ol ON o.OrderId = ol.OrderId JOIN Products p ON ol.ProductId = p.ProductIdWHERE PaymentType = 'OC' and MONTH(OrderDate) = 8 and GroupName = 'APPAREL'GROUP BY YEAR(OrderDate), ol.ProductIdORDER BY cnt DESC
(No columnProductId cnt2014 12510 2,1062015 13165 22015 13320 12015 13334 12016 13973 12015 12831 12015 12834 12015 13164 12014 10823 12014 10827 12013 11016 12015 11016 12014 11124 12014 11125 1
ExpectedVachi2 Payment TMonth Product Actual Expected Chi-Square29.5 148,287.40 OC 8 APPAREL 2,120 29.5 148,287.40
1.0 11,704.30 ?? 3 APPAREL 110 1.0 11,704.3032.9 10,197.28 OC 10 APPAREL 612 32.9 10,197.28
0.0 2,044.29 DB 7 Err:512 8 0.0 2,044.2923.2 1,406.81 OC 4 APPAREL 204 23.2 1,406.81
790.7 1,175.99 MC 6 OCCASION 1,755 790.7 1,175.991,258.8 1,138.55 VI 6 OCCASION 2,456 1,258.8 1,138.551,455.6 1,084.56 VI 12 GAME 2,712 1,455.6 1,084.56
26.6 956.59 OC 9 APPAREL 186 26.6 956.59914.3 703.01566.1 663.51960.5 595.83
1,117.2 538.6927.7 531.49
1,778.6 525.04813.6 515.22502.8 434.04
2,285.7 422.12778.0 420.50620.8 400.74
1,134.4 398.82296.7 390.32910.4 379.29
2,262.4 378.67603.3 376.06561.0 373.93488.7 308.53
566.8 305.03612.6 296.81
1,249.3 280.221,149.5 277.191,098.7 268.66
532.1 257.05459.1 256.17464.5 254.11
2,696.9 252.47362.6 250.85993.7 246.26739.4 246.09352.4 244.27571.8 243.51366.3 239.69
2,124.7 236.363,873.4 235.251,421.1 223.76
940.7 218.411,435.7 213.972,208.0 208.21
25.4 207.952,588.0 205.93
404.2 203.433,416.5 201.87
782.3 193.76540.3 193.47847.2 192.47625.5 191.99356.0 191.37260.0 186.18
35.7 185.241,708.1 184.95
288.4 182.88252.8 174.73
1,389.7 171.56869.8 171.44505.6 168.20349.9 164.49167.3 162.23392.9 161.80215.5 157.92
2,212.5 154.44642.2 150.81297.9 147.91690.1 147.34477.9 143.77
1,057.7 141.861,694.0 139.444,452.7 137.92
225.7 137.681,477.3 136.92
305.7 136.5044.2 133.60
192.5 128.91729.7 128.56302.7 127.78
1,033.2 127.43168.1 126.93185.1 126.60
1,743.0 125.15624.2 123.07238.5 120.42408.4 118.94961.8 116.85151.9 114.54390.8 110.97796.9 109.26
31.5 108.50197.3 108.47
1,462.2 108.23187.1 107.95
3,287.4 107.85163.3 107.21588.4 105.91
2,642.8 105.4244.6 104.67
2,503.4 101.322,313.5 97.34
139.2 97.05675.2 96.45419.1 95.57125.6 93.92839.9 91.93
79.7 91.14737.2 89.43710.1 88.67547.5 86.37
1,596.9 84.742,064.9 83.791,927.2 83.091,625.6 82.591,705.0 82.04
123.7 82.002,796.9 81.991,933.1 81.92
422.5 80.56544.3 80.48349.4 80.19
1,291.5 80.0588.7 79.01
135.3 78.901,427.2 78.722,146.0 78.711,071.0 78.51
230.2 78.23153.9 77.06225.8 75.77454.0 73.75127.5 73.04
1,672.6 72.16101.5 72.02219.5 71.72
2,870.5 71.33
273.0 70.8189.6 70.76
491.4 69.96471.6 69.92105.8 69.55922.4 67.97250.3 67.84668.7 66.41
90.4 66.28180.4 64.17265.4 64.05144.0 64.04182.4 63.27
1.5 62.47842.2 62.37
1,411.1 62.121,660.1 61.71
112.6 60.57337.7 59.48
2,470.8 59.31973.2 58.77248.8 58.63369.1 58.51
20.1 57.14123.9 56.83281.3 55.81337.0 55.66418.0 55.26134.0 55.18
63.7 55.07538.8 54.75
1,552.0 54.56128.8 54.54134.8 53.39
1,855.2 52.53199.3 52.52522.6 52.46
39.6 52.10116.9 51.95611.3 50.26
1,432.5 49.59133.2 47.82321.6 47.50147.7 47.43218.3 47.38896.5 47.09133.2 47.06899.8 46.62126.7 46.42432.2 46.13231.8 45.04
2,433.0 45.0266.8 44.93
5,604.3 43.95369.1 43.64270.2 43.33
52.8 43.28
127.1 43.23260.5 42.73628.9 42.22
13.4 41.81280.7 41.32364.6 41.23756.3 41.08240.8 40.56833.6 40.44106.3 40.10204.3 39.88
2,248.5 39.88241.0 39.85
88.1 39.6995.5 39.5786.1 39.17
225.7 38.8882.6 38.8387.2 38.81
7,172.7 38.6882.2 38.39
177.3 38.211,803.1 37.80
232.6 37.652,981.9 37.61
529.0 37.5974.1 36.60
160.5 36.46125.2 36.07
47.1 35.88116.1 35.37235.2 35.34
58.4 35.27309.5 35.26
73.6 34.838,922.2 34.80
134.3 34.7735.1 34.77
361.5 34.40272.9 34.39157.2 34.11811.3 33.66301.5 33.52138.8 33.09
1,598.6 32.6389.7 32.13
2.7 32.05282.3 30.82
53.4 30.5241.1 30.0069.6 28.5693.5 28.4053.4 27.87
5,766.4 27.661,345.9 27.07
294.1 27.02631.9 26.71
140.1 26.63117.6 26.29175.8 26.14276.4 25.93
91.6 25.7959.0 25.76
0.0 25.74123.0 25.44
78.5 25.20226.6 25.20147.7 24.96
75.2 24.8418.6 24.6292.8 24.60
121.6 24.50231.8 24.37199.1 23.86
1,429.9 23.70118.5 23.26
1,873.0 23.10199.3 22.73284.3 22.70
1,180.3 22.1776.0 22.13
337.8 22.02420.1 21.97110.1 21.9383.6 21.7430.8 21.59
2,070.2 21.15186.7 20.82
96.9 20.80150.5 20.45212.2 20.43141.8 20.38
49.5 20.06113.6 19.9573.1 19.8760.4 19.60
523.6 19.33125.2 19.33422.2 19.27145.9 19.15
4,505.4 18.98664.3 18.10
99.2 17.920.9 17.82
599.0 17.3839.0 17.36
328.2 17.25161.8 17.22
24.5 17.132,012.1 17.02
159.5 16.62269.7 16.47
23.6 16.2479.9 16.10
3,579.6 15.774,635.7 15.69
384.9 15.0749.2 15.0318.6 14.7951.4 14.64
155.0 14.25116.4 13.34641.7 13.12152.0 12.73612.7 12.73
2.9 12.642,877.7 12.58
210.2 12.47150.8 12.37153.4 11.73137.0 11.67
39.4 11.65235.3 11.64
28.0 11.6166.8 11.58
7.6 11.49110.4 11.36953.6 11.22107.4 11.01249.3 10.97
96.4 10.8739.8 10.8563.0 10.70
2.2 10.3513.9 10.1911.8 9.87
350.1 9.5821.2 9.5511.3 9.43
265.2 9.13314.4 9.07
22.1 9.0355.3 8.96
557.4 8.95234.2 8.73
79.3 8.7118.8 8.68
1,129.1 8.521,488.1 8.45
10.3 8.38131.8 7.85
31.2 7.41925.8 7.29
9.1 7.2342.6 7.0973.9 7.08
414.8 6.97182.0 6.72
8.5 6.642.7 6.623.4 6.42
161.1 6.4113.1 6.2918.8 6.17
7.9 6.0131.8 5.99
683.6 5.89180.5 5.84
34.1 5.8112.5 5.81
243.6 5.81173.8 5.81704.2 5.78
1.3 5.73506.6 5.42
37.2 5.4298.9 5.39
8.9 5.3874.8 5.2359.5 5.14
253.9 5.07519.9 4.99
0.5 4.831,170.2 4.83
403.1 4.8245.8 4.78
128.8 4.78360.2 4.72
99.6 4.6799.9 4.39
468.3 4.38253.2 4.35
69.6 4.357.8 4.32
67.0 4.3258.9 4.31
9.3 4.27762.8 4.23513.4 4.19372.9 4.06
12.0 4.063,203.2 4.00
2.1 3.941,233.1 3.87
6.1 3.85212.9 3.72202.3 3.70103.5 3.66
21.9 3.6516.5 3.4473.2 3.39
357.8 3.39246.8 3.35
1,214.2 3.351,140.7 3.34
44.1 3.3126.3 3.2872.6 3.27
196.7 3.26294.1 3.24106.5 3.22
1.1 3.14711.8 3.1321.1 3.0823.5 3.0618.4 2.9835.1 2.91
486.5 2.88111.1 2.63409.3 2.55164.8 2.47
1,101.9 2.46184.8 2.44
4.6 2.43735.0 2.40
57.7 2.361.3 2.34
23.4 2.324.1 2.32
403.1 2.2511.0 2.2437.9 2.11
157.2 2.1015.4 2.0739.7 1.9230.6 1.8958.4 1.8443.2 1.79
103.4 1.78156.6 1.76709.2 1.75
4.9 1.743.4 1.72
213.0 1.7046.5 1.56
0.9 1.55174.2 1.50447.1 1.50
14.4 1.374.5 1.35
58.9 1.34396.0 1.33190.1 1.33
15.5 1.31426.5 1.29325.2 1.14794.3 1.11
2.7 1.0676.9 1.04
0.4 0.895.1 0.89
11.1 0.852.6 0.82
305.6 0.79845.4 0.76
24.3 0.75269.5 0.68372.6 0.66
2.2 0.64175.5 0.63741.4 0.63460.0 0.63178.6 0.63
1.2 0.6012.3 0.57
1.2 0.5234.7 0.40
4.3 0.37169.3 0.35
26.1 0.333.9 0.31
85.7 0.260.6 0.26
89.8 0.25167.4 0.25
3.9 0.221.6 0.225.9 0.212.3 0.21
279.3 0.195.0 0.19
834.7 0.181.5 0.18
616.3 0.17396.9 0.16
0.7 0.15934.7 0.15
34.7 0.15774.5 0.14
0.7 0.1441.4 0.14
208.3 0.13238.5 0.09
2.5 0.08195.0 0.08215.2 0.08313.1 0.08
6.7 0.07440.0 0.06
27.8 0.055.5 0.05
234.1 0.043.3 0.03
1,004.1 0.020.9 0.02
31.5 0.01498.9 0.01204.3 0.01
52.5 0.001.0 0.004.9 0.00
716.5 0.00
