还剩19页未读,继续阅读
本资源只提供10页预览,全部文档请下载后查看!喜欢就下载吧,查找使用更方便
文本内容:
关于中国人民大学本科生上网收费问题的调查报告指导老师贾俊平调查员袁德刚顾严徐景阳戴乐班级公管学院国民经济管理系2000本调查时间2002年12月从2002-2003学年度的第一学期起,中国人民大学的网络资源开始试行由校外公司管理,该公司提出的收费方案遭到在校生的抵制,至今仍未达成一致意见,学生在宿舍上网依然免费但收费是必然的,只是时间和方式的问题
一、调查方案1.调查目的为了了解人民大学在校本科生对宿舍上网收费问题的看法、态度,并为学校提供决策建议,我们对部分本科生做了问卷调查2.调查的对象和单位调查对象为中国人民大学本科生,调查单位为部分本科生3.调查项目及调查问卷我们对在校本科生本学期(2002-2003学年度的第一学期)以来的上网情况(包括上网时间、途径、支出、目的以及关心的校园网指标等)和对收费的态度(包括收费方式、价格)进行了调查;并且调查了网络对他们的重要性,以及将来的收费方案不能令他们满意时他们将采取的行动问卷见附-14.调查程序考虑到调查员的实际情况,我们采取了抽样问卷调查的方式(由调查员直接到宿舍发放问卷并回收),对四个年级的本科生分别做了调查,每年级各发60份问卷(男、女生各30份)5.调查时间
(1)对本学期(2002-2003学年度的第一学期)以来的情况进行调查;
(2)调查问卷发放时间为2002年12月10日2100,当晚收回;
(3)数据整理在12月11日、12日进行;
(4)数据分析从13日开始;
(5)21日完成调查报告6.调查的组织与实施由每位调查员负责调查一个年级对于男生受调查者,采取直接到宿舍发放问卷的方式;对于女生受调查者,采取由每位调查员各委托一位女同学到女生楼发放问卷并收回
二、数据的预处理问卷回收以后,我们对它们进行了审核和筛选,具体情况如表-1所示表-1调查问卷发放、回收及筛选情况表单位份 男生 女生 发放回收有效发放回收有效’02级302523292824’01级302923302824’00级303027313128’99级303023303028我们原本打算在每个年级调查60人,其中男生、女生各30人,但由于调查员在分配问卷时出现了失误,导致对02级女生的问卷少发放了一份、00级女生多发放了一份由于缺乏调查经验,出现了问卷未收回的情况在筛选问卷时,我们发现收回的问卷中有一些项目未填满;有些第2题(单项选择题)选择了不只一项;有些第8题选项未排序;有1份第7题填写的答案(认为合理的收费标准为1000元/月)明显不符合逻辑;还有些问卷同时含有上述前三个问题的两个甚至是三个问题我们对这些不符合要求的问卷进行了剔除最后,我们对符合要求的问卷(共200份)按照年级(由低到高)和性别(先女生后男生)顺序进行了编号原始数据见附-2
三、数据分析我们将问卷的10个问题分为三大类,从人大本科生上网的基本情况、上网收费方案以及其它情况三个方面进行了分析
(1)上网基本情况分析我们对被调查者平均每周的上网时间、最主要的上网途径、平均每周的上网支出、以及主要的上网目的进行了分析,希望能据此对他们在这四个方面的基本情况有所了解1.上网时间分析表-2平均每周上网时间分布情况表回答类别人数/人频率/%向上累积/%向下累积/%3小时以下3216161003~6小时
3517.
533.5846~9小时
3316.
55066.59~12小时
2914.
564.55012小时以上
7135.
510035.5合计200100——如表-2数据所示,有
35.5%的被调查者每周上网时间超过12小时;有
66.5%的被调查者每周上网时间在6小时以上;而每周上网时间在3小时以下的仅占全部被调查者的16%平均每周上网时间人数分布如图-1所示图表1032353329710Sheet1编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q10102级女ACBCEAB10CBADECB202级女ADBADECC30BACDEBB302级女BCBACDAB10ABCDECB列1样本数据个数200402级女CCDCECA8DABCECB样本均值
9.5925502级女DAAACDAB15BACDECB平均
9.5925样本标准差
6.9640277254602级女ACAECC10ABCDEAA标准误差
0.4924311229抽样平均误差
0.4924311229702级女ACBFCB0CBADEBD中值10置信水平
0.05802级女ACACDBB5CBADEBD模式10自由度
1.99902级女ACACEA0BCADEBB标准偏差
6.9640277254t值
1.97195731741002级女BCBABCDEBA5CBADEDC样本方差
48.4976821608误差范围
0.97105315611102级女DCECDEFBB10CABDECC峰值
2.6829413002置信下限
8.62144684391202级女ADBDEAA
2.5ACBDECA偏斜度
1.4262835201置信上限
10.56355315611302级女ACBACDEBA5BCDAEBC区域401402级女BBDCDEBA0BACDECC最小值01502级女BDCCDECA5BCADEBB最大值401602级女ACBCEAB15BCADEEC求和
1918.51702级女ACBDCA5BCADECB计数2001802级女AABCDFCA5CBADECB1902级女ACBCDB20ACBDECA2002级女AECCDECB10CBADEAB2102级女AEAAEEA5CBADECA2202级女CCDCDECC15ABCDECB2302级女BABFCA10BCDAEAB2402级女CACDEAC30BADCECC2502级男EABADEBA3DBCAEEC2602级男CACCDEEB15BCADEEC2702级男CACACDEBA20BADCEEC2802级男AEEEAA5ABCDEBC2902级男AEEEAA5CBADEAC3002级男DADAEBB15BADCEEB3102级男DCDACDFCB8BCADEBD3202级男BCCCFCC10BCADECD3302级男BCCACECB20BADCECC3402级男CCECDEAB15BCDAECC3502级男EECBBA10BCADEAB3602级男EACADEBA0DBCAEDC3702级男CCDBCDECB15ABCDECA3802级男ECEFDE20ABDCEEC3902级男CCDACEAA1CBADEAC4002级男CACAEBB15BADCEEB4102级男CCDADEFBC30BCADEBB4202级男ACAFCC30BCADEBD4302级男BCCCEBA6BACDEDC4402级男CCDBCAB10ABCDEEB4502级男EABCDEEA5BADCECC4602级男CBCBBB4BADCECA4702级男DCBBDCB10DABCECB4801级女BCCCDFCB15BACDECD4901级女EABABCDEBB10BCADEEC5001级女CAACDEBA5CBADECC5101级女BAADECA3ABDCEBB5201级女BAAABCDEAA3ABDCEAD5301级女EACACDECA10CABDEDC5401级女BCCDEBA5CBADECC5501级女CAAACDEBA3CBADEAC5601级女DAAADEBA5CBADEBC5701级女DAAACDEBA5CBADECC5801级女CAAADECA5BCDAEDC5901级女CAABDEBB3CBADECB6001级女CAAFEA1CBADEEC6101级女DCDBCDEBA10BCDAEDC6201级女DACACEBA10BDACEDC6301级女CCDBADEDA8BDCAEBA6401级女DAAACDEBB15CBADEDC6501级女EABABCDEBB20CBADECD6601级女EAAABCDEBB20BCADEBC6701级女BAAACDBA20BCADEBC6801级女DAAACECA5DCBAECB6901级女DACADEBA5CBADEEC7001级女EAABAA10CBADEBB7101级女CAADEBA0BCADECC7201级男EABACDEBB15BADCECB7301级男AABBCB10BCADEBB7401级男AAAACECA5BCADEEC7501级男BEDCDD20BACDEBB7601级男AABEBA5BCDAEDC7701级男CAAABCDEBA1ABCDECC7801级男EAAABCEAA10BACDEEB7901级男AAAADEAA3BCADECC8001级男EAAAEBC20CBADECD8101级男EAAACEBB15BCDAEDC8201级男EAAACEBA2ABCDEDC8301级男EAAAEBA5CBADEDC8401级男ACAABB15CBDAEBB8501级男AABACDEDA10CBADEAC8601级男DAAACEDA5CBADECC8701级男EAEACDEBB15CBADEEC8801级男BAACEAA5CBADECC8901级男DAABCAA2BCADEDC9001级男BAABCEAB15BCDAEBB9101级男CAAABEBA10CBADECC9201级男EAAABCDEEB5CBADEEC9301级男EAAABDEEB10CABDEEC9401级男EAAACDEBB5CBADEDC9500级女AAAEDB10BADCECC9600级女DAAACDEBA10BCADECC9700级女EAAADEFAB10ABCDECC9800级女AEAADEDC30BADCECA9900级女EAAABCDEFBB10ABCDEDC10000级女CAAACDECB10CBADECC10100级女DAAABCDEDA10CBADEEB10200级女EEEADECB10BCADEEC10300级女DAADEBA2BCADEDC10400级女EAADEBA5ABCDEDC10500级女EAAABDEBA5CBADEAC10600级女EAEADEBB10ABDCECC10700级女EAAACDECA10CBADEDB10800级女BABACEAB10BCADECC10900级女EAAAAB15BACDEDD11000级女CEAAEBA6BDACEEC11100级女BEADEBA3BCADECC11200级女BAAADEDA10BCADEDC11300级女EAAACDEBA5ABCDEDB11400级女AAACDEAA10BACDEBB11500级女BCBCDECA2BACDEDB11600级女DAAABCDEBA3CABDEDC11700级女EAAACDEBA5BADCECB11800级女CAAABCDEEA0CBADEEC11900级女BCAADEBB15BCADECC12000级女DAAACDBB5BCADEDB12100级女BEBDEBA5BCADEDC12200级女BAAADECB10CBDAEBD12300级男EAAABEBA5BCADEEB12400级男EAAABCDEAA0BCADEBD12500级男EAAAECB5CBADECC12600级男BAAABCDEAA5BCADECD12700级男EAAAEBB10BACDECB12800级男EAAABEBA10BCADEEC12900级男EAAAEAB20CBADEDC13000级男CAAACDDB5BCADEDC13100级男EAAADEBB10BCADECB13200级男EAAADEAB10BCADECC13300级男AAAEDA5CBADEBB13400级男BAAACDEAB10BADCEDC13500级男EAAABEAB10BCADEDC13600级男BABECC30ACBDECB13700级男AAAACBA5CBADEBB13800级男EAAABCDEAA2CBADECD13900级男BAACDECA5CBADECC14000级男DAAACEBB10ABCDEDC14100级男EAAACEEB12ACBDECB14200级男EAAABCDEFBC10BACDEEC14300级男EABABCDEBA5BACDEEC14400级男EAAABCDEBA5ABDCEDB14500级男BAAABCDEAA10BACDECC14600级男BAACBB20BACDEBC14700级男CAACDEFAA20BACDEDC14800级男BAAAEAB10BCADECA14900级男EABADEAA5ABCDEDC15099级女ECDBCCB10CBADEDB15199级女EACABCAC10CBDAEEB15299级女EAAADEBB10CBADEDB15399级女CABADEAA5BCADEAC15499级女CAADEFCA5BCADEDC15599级女BABCCA5CABDEAB15699级女ADBECA2CBADEAD15799级女EAADEAA10BACDEDB15899级女EAEBCAC40BCADEEA15999级女AAADAA5CDBAEBB16099级女DCBDECB15BACDECB16199级女EEEDEBA5BCADEEC16299级女DDBCCA5CBADEAB16399级女CAADEAA5CBADEDB16499级女ADAADEFCA10CABDECC16599级女EDDADECB10BACDEDB16699级女EAADEBB10BACDEED16799级女DAAABA10CBADEEC16899级女CAAABB10CBDAEDB16999级女EAAADEDA5BACDEDC17099级女CAAADEBB10BCADEDC17199级女EAAACDEBB10BCADEDC17299级女EAAABB15BADCECC17399级女EABADEBB10CBADEBC17499级女CAAADECA10CBDAEDC17599级女BAAADEBA5CBADECC17699级女DAAADDB10ACBDECC17799级女EAAACDEDA0BADCEDC17899级男EABDEDA10BCADEDB17999级男EABDEAB20BACDEEC18099级男EABBDEFAB20BACDEDC18199级男AAAECA0BCDAEBB18299级男EABABEDC30ACBDEDC18399级男DACBDEBA5BACDEEC18499级男DABDEBC30ABDCECC18599级男EAAABCDEAB20BACDEEB18699级男DAACDBA5CBADECC18799级男BAABCA0CBADEAD18899级男EAAABDBB10CABDECB18999级男EACABDEBB10CBADEDC19099级男BAABCAA5CABDEBB19199级男EABBCEBB10BCADEDB19299级男DAAABCEBB15CBADECC19399级男EABABEBB10BCADECC19499级男EAAAEBA5CBDAEEC19599级男CACECA5ABCDEDC19699级男BAAEBB15BACDEDB19799级男DABAEBA5CBADEDC19899级男EAAABCAB10CABDECC19999级男EAACDBB10BCADECB20099级男EAABCEBB15ABCDECBSheet
29.5925合理收费算术平均
11918.
519.592510频率累积%第1题
113216.00%回答类别人数(人)百分比向上累积向下累积
123533.50%3小时以下3216161003220011接收频率累积%
33350.00%3--6小时
3517.
533.
58467168210042964.50%6--9小时
3316.
55066.5100133313小时以下
3216.00%
571100.00%9--12小时
2914.
564.550129100413--6小时
3533.50%
00100.00%12小时以上
7135.
510035.520071516--9小时
3350.00%合计200100——#VALUE!19--12小时
2964.50%112小时以上
71100.00%
10.00%111111111111111111第2题1上网途径人数(人)频率(%)2宿舍14472A2网吧21B2信息楼
3517.5C2图书馆
73.5D2其它126E2220022222222222222222第3题22回答类别人数(人)百分比向上累积向下累积20114575710011420025元以下
4120.
577.5431558625--10元
2110.
58822.517645210--20元147951219024220元以上1051005200102合计200100——2223333333333333333第4题33’02级’01级’00级’99级3女生男生女生男生女生男生女生男生3下载文件
20.
833333333339.
130434782654.
166666666773.
913043478367.
857142857174.
074074074157.
142857142939.13043478263打游戏
4.
166666666721.
739130434829.
166666666743.
478260869614.
285714285733.
333333333310.
714285714356.52173913043聊天
62.
547.
82608695655056.
521739130439.
285714285751.
85185185192534.78260869573收发邮件
58.
333333333343.
478260869670.
833333333334.
782608695778.
571428571448.
148148148167.
857142857139.13043478263浏览网页
54.
166666666765.
217391304370.
833333333382.
608695652285.
714285714381.
481481481564.
285714285769.56521739133其它
16.
666666666721.
73913043488.
333333333307.
14285714297.
40740740747.
14285714294.
3478260873242324232827282333330.
050.
090.
130.
170.
190.
20.
160.
091.
085430.
010.
050.
070.
10.
040.
090.
030.
130.
522630.
150.
110.
120.
130.
110.
140.
070.
080.
9145.
530.
140.
10.
170.
080.
220.
130.
190.
091.
125640.
130.
150.
170.
190.
240.
220.
180.
161.
447240.
040.
050.
0200.
020.
020.
020.
010.18944人次百分比4下载文件
10854.0%4打游戏
5226.0%4聊天
9145.5%4收发邮件
11256.0%4浏览网页
14472.0%4其它
189.0%4合计
525262.5%44444444444444444455第5题5收费方式人数(人)频率(%)5按电脑包月
442222.0%5按端口包月
8743.
543.5%5按实际上网时间
4321.
521.5%5按流量
178.
58.5%5其它
94.
54.5%552005555第6题55回答类别人数(人)百分比向上累积向下累积510元以下
10351.5%
51.5%
100.0%103200510--20元
8040.0%
91.5%
48.5%18397520--50元
157.5%
99.0%
8.5%19817550--100元
10.5%
99.5%
1.0%19925100元以上
10.5%
100.0%
0.5%20015合计
200100.0%——55555555555555555555第7题5’02级’01级’00级’99级5女生
9.
60416666678.
16666666678.
42857142869.1785714286242428285男生
11.
82608695659.
04347826099.
407407407411.52173913042323272355方差分析无重复双因素分析5男女有差异5SUMMARY计数求和平均方差年级无差异5行
1435.
37797619058.
84449404760.44038392275行
2441.
798711755210.
44967793882.035847459255列
1221.
430253623210.
71512681162.46846488725列
2217.
21014492758.
60507246380.38439928595列
3217.
8359788368.
9179894180.47905993675列
4220.
70031055910.
35015527952.7452174395555方差分析5差异源SSdfMSFP-valueFcrit5行
5.
153230649115.
153230649116.
73288186370.
026409769510.12796246875列
6.
504783245232.
16826108177.
04048760890.
071617299.27661858445误差
0.
923910900330.307970300155总计
12.581924794675收费人数(人)频率向上累积
50105.0%
5.0%
5131.5%
6.5%
5263.0%
9.5%
52.
510.5%
10.0%
5384.0%
14.0%
410.5%
14.5%
55527.5%
42.0%
621.0%
43.0%
831.5%
44.5%
106432.0%
76.5%
1210.5%
77.0%
152211.0%
88.0%
20157.5%
95.5%
3084.0%
99.5%
4010.5%
100.0%合计200100%—Sheet3Q8Q8CBADEBCBACDEAB人数频率ABCDEBA稳定
3115.5%DABCEAD速度
9547.5%BACDEAB价格
6934.5%ABCDEBA维护
52.5%CBADEBC其它
00.0%CBADEBC合计
200100.0%BCADECB
5125.5%CBADEBC
8341.5%CABDEAC
6231.0%ACBDECA
42.0%BCDAECB
00.0%BACDEAB
200100.0%BCADECBBCADECB首选频率1次选频率2前两位合计频率合计BCADECB稳定
3115.5%
5125.5%
8241.0%CBADEBC速度
9547.5%
8341.5%
17889.0%ACBDECA价格
6934.5%
6231.0%
13165.5%CBADEBC维护
52.5%
42.0%
94.5%CBADEBC其它
00.0%
00.0%
00.0%ABCDEBA合计
200100.0%
200100.0%
400200.0%BCDAECBBADCEABDBCAEBDBCADECBBADCEABABCDEBACBADEBCBADCEABBCADECBBCADECBBADCEABBCDAECBBCADECBDBCAEBDABCDEBAABDCEBACBADEBCBADCEABBCADECBBCADECBBACDEABABCDEBABADCEABBADCEABDABCEADBACDEABBCADECBCBADEBCABDCEBAABDCEBACABDEACCBADEBCCBADEBCCBADEBCCBADEBCBCDAECBCBADEBCCBADEBCBCDAECB第9题BDACEDBBDCAEDBCECCCEDDCBADEBCBEEBCBEECBADEBCCECECCDDBCADECBCBBBCCABBCADECBCAADDCDDDCBAECDAEDCCEAECBADEBCBBCEEDACCBADEBCBCACEDDEBCADECBBCBCDCECBADCEABDCCDDCBABCADECBCADDABCCBCADECBCDCDCDEDBACDEABBCEBDDABBCDAECBCEDACCDDABCDEBABADCDBCCBACDEABEEBEECDCBCADECBCBDCCCEECBADEBCCBCDDDEDBCDAECBCDBBDCDDABCDEBAAEBCBEDDCBADEBCCCCEDEDCCBDAEBCCCEEDDDCCBADEBCACBDCCCCCBADEBCCCEBBCBADEBCCDDCBADEBCDCCBCADECBDDCBCDAECBBDCBADEBC’02级’01级’00级’99级影响程度人数(人)频率向上累积向下累积CBADEBC人数比例人数比例人数比例人数比例没有影响
157.5%
7.5%
100.0%CABDEAC没有影响
612.8%
36.4%
11.8%
59.8%有较小影响
3015.0%
22.5%
92.5%CBADEBC有较小影响
1021.3%
1021.3%
610.9%
47.8%有一定影响
6934.5%
57.0%
77.5%BADCEAB有一定影响
2042.6%
1531.9%
2138.2%
1325.5%有较大影响
5326.5%
83.5%
43.0%BCADECB有较大影响
36.4%
1123.4%
1934.5%
2039.2%影响非常大
3316.5%
100.0%
16.5%ABCDEBA影响非常大
817.0%
817.0%
814.5%
917.6%合计
200100.0%——BADCEAB合计
47100.0%
47100.0%
55100.0%
51100.0%ABCDEBACBADEBCCBADEBBBCADECBBCADECBABCDEBACBADEBCABDCEBACBADEBCBCADECBBACDEABBDACEDBBCADECBBCADECBABCDEBABACDEABBACDEAACABDEACBADCEABCBADEBCBCADECBBCADECBBCADECB第10题CBDAEBC回答类别人数(人)频率BCADECB被迫接受
105.0%BCADECB选择其他方式
6331.5%CBADEBC抗议
11055.0%BCADECB其它
178.5%BACDEAB合计
200100.0%BCADECBCBADEBCBCADECBBCADECBBCADECBCBADEBCBADCEABBCADECBACBDECACBADEBCCBADEBCCBADEBCABCDEBAACBDECABACDEABBACDEABABDCEBABACDEABBACDEABBACDEABBCADECBABCDEBACBADEBCCBDAEBCCBADEBCBCADECBBCADECBCABDEACCBADEBCBACDEABBCADECBCDBAEDCBACDEABBCADECCCBADEBCCBADEBCCABDEACBACDEABBACDEAACBADEBCCBDAEBBBACDEAABCADECBBCADECCBADCEABCBADEBCCBDAEBCCBADEBCACBDECABADCEABBCADECBBACDEABBACDEABBCDAECBACBDECABACDEABABDCEBABACDEABCBADEBCCBADEBCCABDEACCBADEBCCABDEACBCADECBCBADEBCBCADECBCBDAEBCABCDEBABACDEABCBADEBCCABDEACBCADECBABCDEBA图-1平均每周上网时间人数分布图2.上网途径分析表-3最主要上网途径分布表上网途径人数(人)频率(%)宿舍14472网吧21信息楼
3517.5图书馆
73.5其它126由表-3做出饼图如图-2所示被调查的在校本科生最主要上网途径的众数为“宿舍”(异众比率为28%),即有72%的被调查者首选在宿舍上网;排在第二位的是在信息楼上网,占总调查人数的
17.5%可见在宿舍使用校园网是本科生现在最主要的上网途径,如果宿舍网络出现问题必然会对大多数人造成影响图表
372117.
53.56Sheet1编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q10102级女ACBCEAB10CBADECB202级女ADBADECC30BACDEBB302级女BCBACDAB10ABCDECB402级女CCDCECA8DABCECB502级女DAAACDAB15BACDECB602级女ACAECC10ABCDEAA702级女ACBFCB0CBADEBD802级女ACACDBB5CBADEBD902级女ACACEA0BCADEBB1002级女BCBABCDEBA5CBADEDC1102级女DCECDEFBB10CABDECC1202级女ADBDEAA
2.5ACBDECA1302级女ACBACDEBA5BCDAEBC1402级女BBDCDEBA0BACDECC1502级女BDCCDECA5BCADEBB1602级女ACBCEAB15BCADEEC1702级女ACBDCA5BCADECB1802级女AABCDFCA5CBADECB1902级女ACBCDB20ACBDECA2002级女AECCDECB10CBADEAB2102级女AEAAEEA5CBADECA2202级女CCDCDECC15ABCDECB2302级女BABFCA10BCDAEAB2402级女CACDEAC30BADCECC2502级男EABADEBA3DBCAEEC2602级男CACCDEEB15BCADEEC2702级男CACACDEBA20BADCEEC2802级男AEEEAA5ABCDEBC2902级男AEEEAA5CBADEAC3002级男DADAEBB15BADCEEB3102级男DCDACDFCB8BCADEBD3202级男BCCCFCC10BCADECD3302级男BCCACECB20BADCECC3402级男CCECDEAB15BCDAECC3502级男EECBBA10BCADEAB3602级男EACADEBA0DBCAEDC3702级男CCDBCDECB15ABCDECA3802级男ECEFDE20ABDCEEC3902级男CCDACEAA1CBADEAC4002级男CACAEBB15BADCEEB4102级男CCDADEFBC30BCADEBB4202级男ACAFCC30BCADEBD4302级男BCCCEBA6BACDEDC4402级男CCDBCAB10ABCDEEB4502级男EABCDEEA5BADCECC4602级男CBCBBB4BADCECA4702级男DCBBDCB10DABCECB4801级女BCCCDFCB15BACDECD4901级女EABABCDEBB10BCADEEC5001级女CAACDEBA5CBADECC5101级女BAADECA3ABDCEBB5201级女BAAABCDEAA3ABDCEAD5301级女EACACDECA10CABDEDC5401级女BCCDEBA5CBADECC5501级女CAAACDEBA3CBADEAC5601级女DAAADEBA5CBADEBC5701级女DAAACDEBA5CBADECC5801级女CAAADECA5BCDAEDC5901级女CAABDEBB3CBADECB6001级女CAAFEA1CBADEEC6101级女DCDBCDEBA10BCDAEDC6201级女DACACEBA10BDACEDC6301级女CCDBADEDA8BDCAEBA6401级女DAAACDEBB15CBADEDC6501级女EABABCDEBB20CBADECD6601级女EAAABCDEBB20BCADEBC6701级女BAAACDBA20BCADEBC6801级女DAAACECA5DCBAECB6901级女DACADEBA5CBADEEC7001级女EAABAA10CBADEBB7101级女CAADEBA0BCADECC7201级男EABACDEBB15BADCECB7301级男AABBCB10BCADEBB7401级男AAAACECA5BCADEEC7501级男BEDCDD20BACDEBB7601级男AABEBA5BCDAEDC7701级男CAAABCDEBA1ABCDECC7801级男EAAABCEAA10BACDEEB7901级男AAAADEAA3BCADECC8001级男EAAAEBC20CBADECD8101级男EAAACEBB15BCDAEDC8201级男EAAACEBA2ABCDEDC8301级男EAAAEBA5CBADEDC8401级男ACAABB15CBDAEBB8501级男AABACDEDA10CBADEAC8601级男DAAACEDA5CBADECC8701级男EAEACDEBB15CBADEEC8801级男BAACEAA5CBADECC8901级男DAABCAA2BCADEDC9001级男BAABCEAB15BCDAEBB9101级男CAAABEBA10CBADECC9201级男EAAABCDEEB5CBADEEC9301级男EAAABDEEB10CABDEEC9401级男EAAACDEBB5CBADEDC9500级女AAAEDB10BADCECC9600级女DAAACDEBA10BCADECC9700级女EAAADEFAB10ABCDECC9800级女AEAADEDC30BADCECA9900级女EAAABCDEFBB10ABCDEDC10000级女CAAACDECB10CBADECC10100级女DAAABCDEDA10CBADEEB10200级女EEEADECB10BCADEEC10300级女DAADEBA2BCADEDC10400级女EAADEBA5ABCDEDC10500级女EAAABDEBA5CBADEAC10600级女EAEADEBB10ABDCECC10700级女EAAACDECA10CBADEDB10800级女BABACEAB10BCADECC10900级女EAAAAB15BACDEDD11000级女CEAAEBA6BDACEEC11100级女BEADEBA3BCADECC11200级女BAAADEDA10BCADEDC11300级女EAAACDEBA5ABCDEDB11400级女AAACDEAA10BACDEBB11500级女BCBCDECA2BACDEDB11600级女DAAABCDEBA3CABDEDC11700级女EAAACDEBA5BADCECB11800级女CAAABCDEEA0CBADEEC11900级女BCAADEBB15BCADECC12000级女DAAACDBB5BCADEDB12100级女BEBDEBA5BCADEDC12200级女BAAADECB10CBDAEBD12300级男EAAABEBA5BCADEEB12400级男EAAABCDEAA0BCADEBD12500级男EAAAECB5CBADECC12600级男BAAABCDEAA5BCADECD12700级男EAAAEBB10BACDECB12800级男EAAABEBA10BCADEEC12900级男EAAAEAB20CBADEDC13000级男CAAACDDB5BCADEDC13100级男EAAADEBB10BCADECB13200级男EAAADEAB10BCADECC13300级男AAAEDA5CBADEBB13400级男BAAACDEAB10BADCEDC13500级男EAAABEAB10BCADEDC13600级男BABECC30ACBDECB13700级男AAAACBA5CBADEBB13800级男EAAABCDEAA2CBADECD13900级男BAACDECA5CBADECC14000级男DAAACEBB10ABCDEDC14100级男EAAACEEB12ACBDECB14200级男EAAABCDEFBC10BACDEEC14300级男EABABCDEBA5BACDEEC14400级男EAAABCDEBA5ABDCEDB14500级男BAAABCDEAA10BACDECC14600级男BAACBB20BACDEBC14700级男CAACDEFAA20BACDEDC14800级男BAAAEAB10BCADECA14900级男EABADEAA5ABCDEDC15099级女ECDBCCB10CBADEDB15199级女EACABCAC10CBDAEEB15299级女EAAADEBB10CBADEDB15399级女CABADEAA5BCADEAC15499级女CAADEFCA5BCADEDC15599级女BABCCA5CABDEAB15699级女ADBECA2CBADEAD15799级女EAADEAA10BACDEDB15899级女EAEBCAC40BCADEEA15999级女AAADAA5CDBAEBB16099级女DCBDECB15BACDECB16199级女EEEDEBA5BCADEEC16299级女DDBCCA5CBADEAB16399级女CAADEAA5CBADEDB16499级女ADAADEFCA10CABDECC16599级女EDDADECB10BACDEDB16699级女EAADEBB10BACDEED16799级女DAAABA10CBADEEC16899级女CAAABB10CBDAEDB16999级女EAAADEDA5BACDEDC17099级女CAAADEBB10BCADEDC17199级女EAAACDEBB10BCADEDC17299级女EAAABB15BADCECC17399级女EABADEBB10CBADEBC17499级女CAAADECA10CBDAEDC17599级女BAAADEBA5CBADECC17699级女DAAADDB10ACBDECC17799级女EAAACDEDA0BADCEDC17899级男EABDEDA10BCADEDB17999级男EABDEAB20BACDEEC18099级男EABBDEFAB20BACDEDC18199级男AAAECA0BCDAEBB18299级男EABABEDC30ACBDEDC18399级男DACBDEBA5BACDEEC18499级男DABDEBC30ABDCECC18599级男EAAABCDEAB20BACDEEB18699级男DAACDBA5CBADECC18799级男BAABCA0CBADEAD18899级男EAAABDBB10CABDECB18999级男EACABDEBB10CBADEDC19099级男BAABCAA5CABDEBB19199级男EABBCEBB10BCADEDB19299级男DAAABCEBB15CBADECC19399级男EABABEBB10BCADECC19499级男EAAAEBA5CBDAEEC19599级男CACECA5ABCDEDC19699级男BAAEBB15BACDEDB19799级男DABAEBA5CBADEDC19899级男EAAABCAB10CABDECC19999级男EAACDBB10BCADECB20099级男EAABCEBB15ABCDECBSheet
29.5925合理收费算术平均第1题回答类别人数(人)百分比向上累积向下累积3小时以下321616100322003--6小时
3517.
533.584671686--9小时
3316.
55066.51001339--12小时
2914.
564.55012910012小时以上
7135.
510035.520071合计200100——#VALUE!第2题上网途径人数(人)频率(%)宿舍14472A网吧21B信息楼
3517.5C图书馆
73.5D其它126E200第3题回答类别人数(人)百分比向上累积向下累积011457571001142005元以下
4120.
577.543155865--10元
2110.
58822.51764510--20元14795121902420元以上105100520010合计200100——第4题’02级’01级’00级’99级女生男生女生男生女生男生女生男生下载文件
20.
833333333339.
130434782654.
166666666773.
913043478367.
857142857174.
074074074157.
142857142939.1304347826打游戏
4.
166666666721.
739130434829.
166666666743.
478260869614.
285714285733.
333333333310.
714285714356.5217391304聊天
62.
547.
82608695655056.
521739130439.
285714285751.
85185185192534.7826086957收发邮件
58.
333333333343.
478260869670.
833333333334.
782608695778.
571428571448.
148148148167.
857142857139.1304347826浏览网页
54.
166666666765.
217391304370.
833333333382.
608695652285.
714285714381.
481481481564.
285714285769.5652173913其它
16.
666666666721.
73913043488.
333333333307.
14285714297.
40740740747.
14285714294.
34782608724232423282728230.
050.
090.
130.
170.
190.
20.
160.
091.
08540.
010.
050.
070.
10.
040.
090.
030.
130.
52260.
150.
110.
120.
130.
110.
140.
070.
080.
9145.
50.
140.
10.
170.
080.
220.
130.
190.
091.
12560.
130.
150.
170.
190.
240.
220.
180.
161.
44720.
040.
050.
0200.
020.
020.
020.
010.189人次百分比下载文件
10854.0%打游戏
5226.0%聊天
9145.5%收发邮件
11256.0%浏览网页
14472.0%其它
189.0%合计
525262.5%第5题收费方式人数(人)频率(%)按电脑包月
442222.0%按端口包月
8743.
543.5%按实际上网时间
4321.
521.5%按流量
178.
58.5%其它
94.
54.5%200Sheet3图-2最主要上网途径的构成3.上网支出分析表-4平均每周上网支出累积回答类别人数(人)频率(%)向上累积(%)向下累积(%)011457571005元以下
4120.
577.5435--10元
2110.
58822.510--20元147951220元以上1051005合计200100——由表-4所示数据可以看出,一半以上被调查者每周上网支出为零,占总被调查者百分比为57%,其异众比率为43%,所以用“0元”来反映平均每周上网支出的一般情况,代表性不是非常理想;但可以说明半数以上的被调查者享受着免费的网络将分布情况做向下累积处理(见图-3),很明显可以看出只有10人(占全体被调查者的5%)每周上网支出超过20元,而支出在20元以下者占到了95%,绝大多数被调查者上网花销不大图表320086452410Sheet1编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q10102级女ACBCEAB10CBADECB202级女ADBADECC30BACDEBB302级女BCBACDAB10ABCDECB402级女CCDCECA8DABCECB502级女DAAACDAB15BACDECB602级女ACAECC10ABCDEAA702级女ACBFCB0CBADEBD802级女ACACDBB5CBADEBD902级女ACACEA0BCADEBB1002级女BCBABCDEBA5CBADEDC1102级女DCECDEFBB10CABDECC1202级女ADBDEAA
2.5ACBDECA1302级女ACBACDEBA5BCDAEBC1402级女BBDCDEBA0BACDECC1502级女BDCCDECA5BCADEBB1602级女ACBCEAB15BCADEEC1702级女ACBDCA5BCADECB1802级女AABCDFCA5CBADECB1902级女ACBCDB20ACBDECA2002级女AECCDECB10CBADEAB2102级女AEAAEEA5CBADECA2202级女CCDCDECC15ABCDECB2302级女BABFCA10BCDAEAB2402级女CACDEAC30BADCECC2502级男EABADEBA3DBCAEEC2602级男CACCDEEB15BCADEEC2702级男CACACDEBA20BADCEEC2802级男AEEEAA5ABCDEBC2902级男AEEEAA5CBADEAC3002级男DADAEBB15BADCEEB3102级男DCDACDFCB8BCADEBD3202级男BCCCFCC10BCADECD3302级男BCCACECB20BADCECC3402级男CCECDEAB15BCDAECC3502级男EECBBA10BCADEAB3602级男EACADEBA0DBCAEDC3702级男CCDBCDECB15ABCDECA3802级男ECEFDE20ABDCEEC3902级男CCDACEAA1CBADEAC4002级男CACAEBB15BADCEEB4102级男CCDADEFBC30BCADEBB4202级男ACAFCC30BCADEBD4302级男BCCCEBA6BACDEDC4402级男CCDBCAB10ABCDEEB4502级男EABCDEEA5BADCECC4602级男CBCBBB4BADCECA4702级男DCBBDCB10DABCECB4801级女BCCCDFCB15BACDECD4901级女EABABCDEBB10BCADEEC5001级女CAACDEBA5CBADECC5101级女BAADECA3ABDCEBB5201级女BAAABCDEAA3ABDCEAD5301级女EACACDECA10CABDEDC5401级女BCCDEBA5CBADECC5501级女CAAACDEBA3CBADEAC5601级女DAAADEBA5CBADEBC5701级女DAAACDEBA5CBADECC5801级女CAAADECA5BCDAEDC5901级女CAABDEBB3CBADECB6001级女CAAFEA1CBADEEC6101级女DCDBCDEBA10BCDAEDC6201级女DACACEBA10BDACEDC6301级女CCDBADEDA8BDCAEBA6401级女DAAACDEBB15CBADEDC6501级女EABABCDEBB20CBADECD6601级女EAAABCDEBB20BCADEBC6701级女BAAACDBA20BCADEBC6801级女DAAACECA5DCBAECB6901级女DACADEBA5CBADEEC7001级女EAABAA10CBADEBB7101级女CAADEBA0BCADECC7201级男EABACDEBB15BADCECB7301级男AABBCB10BCADEBB7401级男AAAACECA5BCADEEC7501级男BEDCDD20BACDEBB7601级男AABEBA5BCDAEDC7701级男CAAABCDEBA1ABCDECC7801级男EAAABCEAA10BACDEEB7901级男AAAADEAA3BCADECC8001级男EAAAEBC20CBADECD8101级男EAAACEBB15BCDAEDC8201级男EAAACEBA2ABCDEDC8301级男EAAAEBA5CBADEDC8401级男ACAABB15CBDAEBB8501级男AABACDEDA10CBADEAC8601级男DAAACEDA5CBADECC8701级男EAEACDEBB15CBADEEC8801级男BAACEAA5CBADECC8901级男DAABCAA2BCADEDC9001级男BAABCEAB15BCDAEBB9101级男CAAABEBA10CBADECC9201级男EAAABCDEEB5CBADEEC9301级男EAAABDEEB10CABDEEC9401级男EAAACDEBB5CBADEDC9500级女AAAEDB10BADCECC9600级女DAAACDEBA10BCADECC9700级女EAAADEFAB10ABCDECC9800级女AEAADEDC30BADCECA9900级女EAAABCDEFBB10ABCDEDC10000级女CAAACDECB10CBADECC10100级女DAAABCDEDA10CBADEEB10200级女EEEADECB10BCADEEC10300级女DAADEBA2BCADEDC10400级女EAADEBA5ABCDEDC10500级女EAAABDEBA5CBADEAC10600级女EAEADEBB10ABDCECC10700级女EAAACDECA10CBADEDB10800级女BABACEAB10BCADECC10900级女EAAAAB15BACDEDD11000级女CEAAEBA6BDACEEC11100级女BEADEBA3BCADECC11200级女BAAADEDA10BCADEDC11300级女EAAACDEBA5ABCDEDB11400级女AAACDEAA10BACDEBB11500级女BCBCDECA2BACDEDB11600级女DAAABCDEBA3CABDEDC11700级女EAAACDEBA5BADCECB11800级女CAAABCDEEA0CBADEEC11900级女BCAADEBB15BCADECC12000级女DAAACDBB5BCADEDB12100级女BEBDEBA5BCADEDC12200级女BAAADECB10CBDAEBD12300级男EAAABEBA5BCADEEB12400级男EAAABCDEAA0BCADEBD12500级男EAAAECB5CBADECC12600级男BAAABCDEAA5BCADECD12700级男EAAAEBB10BACDECB12800级男EAAABEBA10BCADEEC12900级男EAAAEAB20CBADEDC13000级男CAAACDDB5BCADEDC13100级男EAAADEBB10BCADECB13200级男EAAADEAB10BCADECC13300级男AAAEDA5CBADEBB13400级男BAAACDEAB10BADCEDC13500级男EAAABEAB10BCADEDC13600级男BABECC30ACBDECB13700级男AAAACBA5CBADEBB13800级男EAAABCDEAA2CBADECD13900级男BAACDECA5CBADECC14000级男DAAACEBB10ABCDEDC14100级男EAAACEEB12ACBDECB14200级男EAAABCDEFBC10BACDEEC14300级男EABABCDEBA5BACDEEC14400级男EAAABCDEBA5ABDCEDB14500级男BAAABCDEAA10BACDECC14600级男BAACBB20BACDEBC14700级男CAACDEFAA20BACDEDC14800级男BAAAEAB10BCADECA14900级男EABADEAA5ABCDEDC15099级女ECDBCCB10CBADEDB15199级女EACABCAC10CBDAEEB15299级女EAAADEBB10CBADEDB15399级女CABADEAA5BCADEAC15499级女CAADEFCA5BCADEDC15599级女BABCCA5CABDEAB15699级女ADBECA2CBADEAD15799级女EAADEAA10BACDEDB15899级女EAEBCAC40BCADEEA15999级女AAADAA5CDBAEBB16099级女DCBDECB15BACDECB16199级女EEEDEBA5BCADEEC16299级女DDBCCA5CBADEAB16399级女CAADEAA5CBADEDB16499级女ADAADEFCA10CABDECC16599级女EDDADECB10BACDEDB16699级女EAADEBB10BACDEED16799级女DAAABA10CBADEEC16899级女CAAABB10CBDAEDB16999级女EAAADEDA5BACDEDC17099级女CAAADEBB10BCADEDC17199级女EAAACDEBB10BCADEDC17299级女EAAABB15BADCECC17399级女EABADEBB10CBADEBC17499级女CAAADECA10CBDAEDC17599级女BAAADEBA5CBADECC17699级女DAAADDB10ACBDECC17799级女EAAACDEDA0BADCEDC17899级男EABDEDA10BCADEDB17999级男EABDEAB20BACDEEC18099级男EABBDEFAB20BACDEDC18199级男AAAECA0BCDAEBB18299级男EABABEDC30ACBDEDC18399级男DACBDEBA5BACDEEC18499级男DABDEBC30ABDCECC18599级男EAAABCDEAB20BACDEEB18699级男DAACDBA5CBADECC18799级男BAABCA0CBADEAD18899级男EAAABDBB10CABDECB18999级男EACABDEBB10CBADEDC19099级男BAABCAA5CABDEBB19199级男EABBCEBB10BCADEDB19299级男DAAABCEBB15CBADECC19399级男EABABEBB10BCADECC19499级男EAAAEBA5CBDAEEC19599级男CACECA5ABCDEDC19699级男BAAEBB15BACDEDB19799级男DABAEBA5CBADEDC19899级男EAAABCAB10CABDECC19999级男EAACDBB10BCADECB20099级男EAABCEBB15ABCDECBSheet
29.5925合理收费算术平均第1题回答类别人数(人)百分比向上累积向下累积3小时以下321616100322003--6小时
3517.
533.584671686--9小时
3316.
55066.51001339--12小时
2914.
564.55012910012小时以上
7135.
510035.520071合计200100——#VALUE!第2题上网途径人数(人)频率(%)宿舍14472A网吧21B信息楼
3517.5C图书馆
73.5D其它126E200第3题回答类别人数(人)百分比向上累积向下累积011457571001142005元以下
4120.
577.543155865--10元
2110.
58822.51764510--20元14795121902420元以上105100520010合计200100——Sheet3图-3平均每周上网支出向下累积4.上网目的分析表-5上网主要目的分布表
(1) 人次(人)百分比下载文件
10854.0%打游戏
5226.0%聊天
9145.5%收发邮件
11256.0%浏览网页
14472.0%其它
189.0%合计
525262.5%由表-5做出柱状图(见图-4),可以看出被调查者上网的主要目的排在前三位的是“浏览网页”(占全体被调查者的72%)、“收发邮件”(占全体被调查者的56%)和“下载文件”(占全体被调查者的54%);“聊天”排在第四位,占全体被调查者的
45.5%;“打游戏”和“其它”两项较少,分别占26%和9%图表
10.
540.
260.
4550.
560.
720.09Sheet1编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q10102级女ACBCEAB10CBADECB202级女ADBADECC30BACDEBB302级女BCBACDAB10ABCDECB402级女CCDCECA8DABCECB502级女DAAACDAB15BACDECB602级女ACAECC10ABCDEAA702级女ACBFCB0CBADEBD802级女ACACDBB5CBADEBD902级女ACACEA0BCADEBB1002级女BCBABCDEBA5CBADEDC1102级女DCECDEFBB10CABDECC1202级女ADBDEAA
2.5ACBDECA1302级女ACBACDEBA5BCDAEBC1402级女BBDCDEBA0BACDECC1502级女BDCCDECA5BCADEBB1602级女ACBCEAB15BCADEEC1702级女ACBDCA5BCADECB1802级女AABCDFCA5CBADECB1902级女ACBCDB20ACBDECA2002级女AECCDECB10CBADEAB2102级女AEAAEEA5CBADECA2202级女CCDCDECC15ABCDECB2302级女BABFCA10BCDAEAB2402级女CACDEAC30BADCECC2502级男EABADEBA3DBCAEEC2602级男CACCDEEB15BCADEEC2702级男CACACDEBA20BADCEEC2802级男AEEEAA5ABCDEBC2902级男AEEEAA5CBADEAC3002级男DADAEBB15BADCEEB3102级男DCDACDFCB8BCADEBD3202级男BCCCFCC10BCADECD3302级男BCCACECB20BADCECC3402级男CCECDEAB15BCDAECC3502级男EECBBA10BCADEAB3602级男EACADEBA0DBCAEDC3702级男CCDBCDECB15ABCDECA3802级男ECEFDE20ABDCEEC3902级男CCDACEAA1CBADEAC4002级男CACAEBB15BADCEEB4102级男CCDADEFBC30BCADEBB4202级男ACAFCC30BCADEBD4302级男BCCCEBA6BACDEDC4402级男CCDBCAB10ABCDEEB4502级男EABCDEEA5BADCECC4602级男CBCBBB4BADCECA4702级男DCBBDCB10DABCECB4801级女BCCCDFCB15BACDECD4901级女EABABCDEBB10BCADEEC5001级女CAACDEBA5CBADECC5101级女BAADECA3ABDCEBB5201级女BAAABCDEAA3ABDCEAD5301级女EACACDECA10CABDEDC5401级女BCCDEBA5CBADECC5501级女CAAACDEBA3CBADEAC5601级女DAAADEBA5CBADEBC5701级女DAAACDEBA5CBADECC5801级女CAAADECA5BCDAEDC5901级女CAABDEBB3CBADECB6001级女CAAFEA1CBADEEC6101级女DCDBCDEBA10BCDAEDC6201级女DACACEBA10BDACEDC6301级女CCDBADEDA8BDCAEBA6401级女DAAACDEBB15CBADEDC6501级女EABABCDEBB20CBADECD6601级女EAAABCDEBB20BCADEBC6701级女BAAACDBA20BCADEBC6801级女DAAACECA5DCBAECB6901级女DACADEBA5CBADEEC7001级女EAABAA10CBADEBB7101级女CAADEBA0BCADECC7201级男EABACDEBB15BADCECB7301级男AABBCB10BCADEBB7401级男AAAACECA5BCADEEC7501级男BEDCDD20BACDEBB7601级男AABEBA5BCDAEDC7701级男CAAABCDEBA1ABCDECC7801级男EAAABCEAA10BACDEEB7901级男AAAADEAA3BCADECC8001级男EAAAEBC20CBADECD8101级男EAAACEBB15BCDAEDC8201级男EAAACEBA2ABCDEDC8301级男EAAAEBA5CBADEDC8401级男ACAABB15CBDAEBB8501级男AABACDEDA10CBADEAC8601级男DAAACEDA5CBADECC8701级男EAEACDEBB15CBADEEC8801级男BAACEAA5CBADECC8901级男DAABCAA2BCADEDC9001级男BAABCEAB15BCDAEBB9101级男CAAABEBA10CBADECC9201级男EAAABCDEEB5CBADEEC9301级男EAAABDEEB10CABDEEC9401级男EAAACDEBB5CBADEDC9500级女AAAEDB10BADCECC9600级女DAAACDEBA10BCADECC9700级女EAAADEFAB10ABCDECC9800级女AEAADEDC30BADCECA9900级女EAAABCDEFBB10ABCDEDC10000级女CAAACDECB10CBADECC10100级女DAAABCDEDA10CBADEEB10200级女EEEADECB10BCADEEC10300级女DAADEBA2BCADEDC10400级女EAADEBA5ABCDEDC10500级女EAAABDEBA5CBADEAC10600级女EAEADEBB10ABDCECC10700级女EAAACDECA10CBADEDB10800级女BABACEAB10BCADECC10900级女EAAAAB15BACDEDD11000级女CEAAEBA6BDACEEC11100级女BEADEBA3BCADECC11200级女BAAADEDA10BCADEDC11300级女EAAACDEBA5ABCDEDB11400级女AAACDEAA10BACDEBB11500级女BCBCDECA2BACDEDB11600级女DAAABCDEBA3CABDEDC11700级女EAAACDEBA5BADCECB11800级女CAAABCDEEA0CBADEEC11900级女BCAADEBB15BCADECC12000级女DAAACDBB5BCADEDB12100级女BEBDEBA5BCADEDC12200级女BAAADECB10CBDAEBD12300级男EAAABEBA5BCADEEB12400级男EAAABCDEAA0BCADEBD12500级男EAAAECB5CBADECC12600级男BAAABCDEAA5BCADECD12700级男EAAAEBB10BACDECB12800级男EAAABEBA10BCADEEC12900级男EAAAEAB20CBADEDC13000级男CAAACDDB5BCADEDC13100级男EAAADEBB10BCADECB13200级男EAAADEAB10BCADECC13300级男AAAEDA5CBADEBB13400级男BAAACDEAB10BADCEDC13500级男EAAABEAB10BCADEDC13600级男BABECC30ACBDECB13700级男AAAACBA5CBADEBB13800级男EAAABCDEAA2CBADECD13900级男BAACDECA5CBADECC14000级男DAAACEBB10ABCDEDC14100级男EAAACEEB12ACBDECB14200级男EAAABCDEFBC10BACDEEC14300级男EABABCDEBA5BACDEEC14400级男EAAABCDEBA5ABDCEDB14500级男BAAABCDEAA10BACDECC14600级男BAACBB20BACDEBC14700级男CAACDEFAA20BACDEDC14800级男BAAAEAB10BCADECA14900级男EABADEAA5ABCDEDC15099级女ECDBCCB10CBADEDB15199级女EACABCAC10CBDAEEB15299级女EAAADEBB10CBADEDB15399级女CABADEAA5BCADEAC15499级女CAADEFCA5BCADEDC15599级女BABCCA5CABDEAB15699级女ADBECA2CBADEAD15799级女EAADEAA10BACDEDB15899级女EAEBCAC40BCADEEA15999级女AAADAA5CDBAEBB16099级女DCBDECB15BACDECB16199级女EEEDEBA5BCADEEC16299级女DDBCCA5CBADEAB16399级女CAADEAA5CBADEDB16499级女ADAADEFCA10CABDECC16599级女EDDADECB10BACDEDB16699级女EAADEBB10BACDEED16799级女DAAABA10CBADEEC16899级女CAAABB10CBDAEDB16999级女EAAADEDA5BACDEDC17099级女CAAADEBB10BCADEDC17199级女EAAACDEBB10BCADEDC17299级女EAAABB15BADCECC17399级女EABADEBB10CBADEBC17499级女CAAADECA10CBDAEDC17599级女BAAADEBA5CBADECC17699级女DAAADDB10ACBDECC17799级女EAAACDEDA0BADCEDC17899级男EABDEDA10BCADEDB17999级男EABDEAB20BACDEEC18099级男EABBDEFAB20BACDEDC18199级男AAAECA0BCDAEBB18299级男EABABEDC30ACBDEDC18399级男DACBDEBA5BACDEEC18499级男DABDEBC30ABDCECC18599级男EAAABCDEAB20BACDEEB18699级男DAACDBA5CBADECC18799级男BAABCA0CBADEAD18899级男EAAABDBB10CABDECB18999级男EACABDEBB10CBADEDC19099级男BAABCAA5CABDEBB19199级男EABBCEBB10BCADEDB19299级男DAAABCEBB15CBADECC19399级男EABABEBB10BCADECC19499级男EAAAEBA5CBDAEEC19599级男CACECA5ABCDEDC19699级男BAAEBB15BACDEDB19799级男DABAEBA5CBADEDC19899级男EAAABCAB10CABDECC19999级男EAACDBB10BCADECB20099级男EAABCEBB15ABCDECBSheet
29.5925合理收费算术平均第1题回答类别人数(人)百分比向上累积向下累积3小时以下321616100322003--6小时
3517.
533.584671686--9小时
3316.
55066.51001339--12小时
2914.
564.55012910012小时以上
7135.
510035.520071合计200100——#VALUE!第2题上网途径人数(人)频率(%)宿舍14472A网吧21B信息楼
3517.5C图书馆
73.5D其它126E200第3题回答类别人数(人)百分比向上累积向下累积011457571001142005元以下
4120.
577.543155865--10元
2110.
58822.51764510--20元14795121902420元以上105100520010合计200100——第4题’02级’01级’00级’99级女生男生女生男生女生男生女生男生下载文件
20.
833333333339.
130434782654.
166666666773.
913043478367.
857142857174.
074074074157.
142857142939.1304347826打游戏
4.
166666666721.
739130434829.
166666666743.
478260869614.
285714285733.
333333333310.
714285714356.5217391304聊天
62.
547.
82608695655056.
521739130439.
285714285751.
85185185192534.7826086957收发邮件
58.
333333333343.
478260869670.
833333333334.
782608695778.
571428571448.
148148148167.
857142857139.1304347826浏览网页
54.
166666666765.
217391304370.
833333333382.
608695652285.
714285714381.
481481481564.
285714285769.5652173913其它
16.
666666666721.
73913043488.
333333333307.
14285714297.
40740740747.
14285714294.
34782608724232423282728230.
050.
090.
130.
170.
190.
20.
160.
091.
08540.
010.
050.
070.
10.
040.
090.
030.
130.
52260.
150.
110.
120.
130.
110.
140.
070.
080.
9145.
50.
140.
10.
170.
080.
220.
130.
190.
091.
12560.
130.
150.
170.
190.
240.
220.
180.
161.
44720.
040.
050.
0200.
020.
020.
020.
010.189人次百分比下载文件
10854.0%打游戏
5226.0%聊天
9145.5%收发邮件
11256.0%浏览网页
14472.0%其它
189.0%合计
525262.5%Sheet3图-4上网主要目的柱状图此外,我们还对上网主要目的由年级和性别所产生的差异(如表-6所示)做了简要分析大二(01级)、大三(00级)的学生以及大四(99级)的女生选择“下载文件”的较多;各年级的男生选择“打游戏”的普遍比同年级的女生要多;而各年级的女生选择“收发邮件”的普遍比同年级的男生多;各年级学生选择“浏览网页”的均超过半数;大一(02级)选择“其它”的高于其他各年级,我们重新核实了原始问卷,发现其中大部分在“其它”一栏中填写了“完成上机作业”,可见对一年级的学生来说,通过网络完成课业任务的占有一定的比重表-6上网主要目的分布表
(2)单位%’02级’01级’00级’99级女生男生女生男生女生男生女生男生下载文件
20.
8339.
1354.
1773.
967.
8674.
0757.
1439.13打游戏
4.
1721.
7429.
1743.
4814.
2933.
3310.
7156.52聊天
62.
547.
835056.
5239.
2951.
852534.78收发邮件
58.
3343.
4870.
8334.
7878.
5748.
1567.
8639.13浏览网页
54.
1765.
2270.
8382.
6185.
7181.
4864.
2969.57其它
16.
6721.
748.
3307.
147.
417.
144.35
(2)上网收费方案分析我们在这一环节对被调查者希望实行的上网收费方式、能接受的最高收费、以及认为合理的收费标准逐一进行了分析,希望了解他们对尚未出台的收费方案的期望
1.上网收费方式分析表-7上网收费方式分布表收费方式人数(人)频率(%)按电脑包月4422按端口包月
8743.5按实际上网时间
4321.5按流量
178.5其它
94.5如表-7所示,被调查者选择的收费方式集中在“按电脑包月”、“按端口包月”、“按实际上网时间”三类,分别占22%、
43.5%、
21.5%众数项“按端口包月”的异众比率为57%,所以用它来反映被调查者希望的收费方式代表性较差(如图-5所示)图表
40.
220.
4350.
2150.
0850.045Sheet1编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q101女ACBCEAB10CBADECB2女ADBADECC30BACDEBB3女BCBACDAB10ABCDECB4女CCDCECA8DABCECB5女DAAACDAB15BACDECB6女ACAECC10ABCDEAA7女ACBFCB0CBADEBD8女ACACDBB5CBADEBD9女ACACEA0BCADEBB10女BCBABCDEBA5CBADEDC11女DCECDEFBB10CABDECC12女ADBDEAA
2.5ACBDECA13女ACBACDEBA5BCDAEBC14女BBDCDEBA0BACDECC15女BDCCDECA5BCADEBB16女ACBCEAB15BCADEEC17女ACBDCA5BCADECB18女AABCDFCA5CBADECB19女ACBCDB20ACBDECA20女AECCDECB10CBADEAB21女AEAAEEA5CBADECA22女CCDCDECC15ABCDECB23女BABFCA10BCDAEAB24女CACDEAC30BADCECC25男EABADEBA3DBCAEEC26男CACCDEEB15BCADEEC27男CACACDEBA20BADCEEC28男AEEEAA5ABCDEBC29男AEEEAA5CBADEAC30男DADAEBB15BADCEEB31男DCDACDFCB8BCADEBD32男BCCCFCC10BCADECD33男BCCACECB20BADCECC34男CCECDEAB15BCDAECC35男EECBBA10BCADEAB36男EACADEBA0DBCAEDC37男CCDBCDECB15ABCDECA38男ECEFDE20ABDCEEC39男CCDACEAA1CBADEAC40男CACAEBB15BADCEEB41男CCDADEFBC30BCADEBB42男ACAFCC30BCADEBD43男BCCCEBA6BACDEDC44男CCDBCAB10ABCDEEB45男EABCDEEA5BADCECC46男CBCBBB4BADCECA47男DCBBDCB10DABCECB48女BCCCDFCB15BACDECD49女EABABCDEBB10BCADEEC50女CAACDEBA5CBADECC51女BAADECA3ABDCEBB52女BAAABCDEAA3ABDCEAD53女EACACDECA10CABDEDC54女BCCDEBA5CBADECC55女CAAACDEBA3CBADEAC56女DAAADEBA5CBADEBC57女DAAACDEBA5CBADECC58女CAAADECA5BCDAEDC59女CAABDEBB3CBADECB60女CAAFEA1CBADEEC61女DCDBCDEBA10BCDAEDC62女DACACEBA10BDACEDC63女CCDBADEDA8BDCAEBA64女DAAACDEBB15CBADEDC65女EABABCDEBB20CBADECD66女EAAABCDEBB20BCADEBC67女BAAACDBA20BCADEBC68女DAAACECA5DCBAECB69女DACADEBA5CBADEEC70女EAABAA10CBADEBB71女CAADEBA0BCADECC72男EABACDEBB15BADCECB73男AABBCB10BCADEBB74男AAAACECA5BCADEEC75男BEDCDD20BACDEBB76男AABEBA5BCDAEDC77男CAAABCDEBA1ABCDECC78男EAAABCEAA10BACDEEB79男AAAADEAA3BCADECC80男EAAAEBC20CBADECD81男EAAACEBB15BCDAEDC82男EAAACEBA2ABCDEDC83男EAAAEBA5CBADEDC84男ACAABB15CBDAEBB85男AABACDEDA10CBADEAC86男DAAACEDA5CBADECC87男EAEACDEBB15CBADEEC88男BAACEAA5CBADECC89男DAABCAA2BCADEDC90男BAABCEAB15BCDAEBB91男CAAABEBA10CBADECC92男EAAABCDEEB5CBADEEC93男EAAABDEEB10CABDEEC94男EAAACDEBB5CBADEDC95女AAAEDB10BADCECC96女DAAACDEBA10BCADECC97女EAAADEFAB10ABCDECC98女AEAADEDC30BADCECA99女EAAABCDEFBB10ABCDEDC100女CAAACDECB10CBADECC101女DAAABCDEDA10CBADEEB102女EEEADECB10BCADEEC103女DAADEBA2BCADEDC104女EAADEBA5ABCDEDC105女EAAABDEBA5CBADEAC106女EAEADEBB10ABDCECC107女EAAACDECA10CBADEDB108女BABACEAB10BCADECC109女EAAAAB15BACDEDD110女CEAAEBA6BDACEEC111女BEADEBA3BCADECC112女BAAADEDA10BCADEDC113女EAAACDEBA5ABCDEDB114女AAACDEAA10BACDEBB115女BCBCDECA2BACDEDB116女DAAABCDEBA3CABDEDC117女EAAACDEBA5BADCECB118女CAAABCDEEA0CBADEEC119女BCAADEBB15BCADECC120女DAAACDBB5BCADEDB121女BEBDEBA5BCADEDC122女BAAADECB10CBDAEBD123男EAAABEBA5BCADEEB124男EAAABCDEAA0BCADEBD125男EAAAECB5CBADECC126男BAAABCDEAA5BCADECD127男EAAAEBB10BACDECB128男EAAABEBA10BCADEEC129男EAAAEAB20CBADEDC130男CAAACDDB5BCADEDC131男EAAADEBB10BCADECB132男EAAADEAB10BCADECC133男AAAEDA5CBADEBB134男BAAACDEAB10BADCEDC135男EAAABEAB10BCADEDC136男BABECC30ACBDECB137男AAAACBA5CBADEBB138男EAAABCDEAA2CBADECD139男BAACDECA5CBADECC140男DAAACEBB10ABCDEDC141男EAAACEEB12ACBDECB142男EAAABCDEFBC10BACDEEC143男EABABCDEBA5BACDEEC144男EAAABCDEBA5ABDCEDB145男BAAABCDEAA10BACDECC146男BAACBB20BACDEBC147男CAACDEFAA20BACDEDC148男BAAAEAB10BCADECA149男EABADEAA5ABCDEDC150女ECDBCCB10CBADEDB151女EACABCAC10CBDAEEB152女EAAADEBB10CBADEDB153女CABADEAA5BCADEAC154女CAADEFCA5BCADEDC155女BABCCA5CABDEAB156女ADBECA2CBADEAD157女EAADEAA10BACDEDB158女EAEBCAC40BCADEEA159女AAADAA5CDBAEBB160女DCBDECB15BACDECB161女EEEDEBA5BCADEEC162女DDBCCA5CBADEAB163女CAADEAA5CBADEDB164女ADAADEFCA10CABDECC165女EDDADECB10BACDEDB166女EAADEBB10BACDEED167女DAAABA10CBADEEC168女CAAABB10CBDAEDB169女EAAADEDA5BACDEDC170女CAAADEBB10BCADEDC171女EAAACDEBB10BCADEDC172女EAAABB15BADCECC173女EABADEBB10CBADEBC174女CAAADECA10CBDAEDC175女BAAADEBA5CBADECC176女DAAADDB10ACBDECC177女EAAACDEDA0BADCEDC178男EABDEDA10BCADEDB179男EABDEAB20BACDEEC180男EABBDEFAB20BACDEDC181男AAAECA0BCDAEBB182男EABABEDC30ACBDEDC183男DACBDEBA5BACDEEC184男DABDEBC30ABDCECC185男EAAABCDEAB20BACDEEB186男DAACDBA5CBADECC187男BAABCA0CBADEAD188男EAAABDBB10CABDECB189男EACABDEBB10CBADEDC190男BAABCAA5CABDEBB191男EABBCEBB10BCADEDB192男DAAABCEBB15CBADECC193男EABABEBB10BCADECC194男EAAAEBA5CBDAEEC195男CACECA5ABCDEDC196男BAAEBB15BACDEDB197男DABAEBA5CBADEDC198男EAAABCAB10CABDECC199男EAACDBB10BCADECB200男EAABCEBB15ABCDECBSheet
29.5925合理收费算术平均回答类别人数(人)百分比向下累积
321616100322003517.
533.
584671683316.
55066.
51001332914.
564.
5501291007135.
510035.520071合计200100——#VALUE!上网途径人数(人)宿舍14472A网吧21B信息楼
3517.5C图书馆
73.5D其它126E200回答类别人数(人)百分比向下累积
011457571001142004120.
577.
543155862110.
58822.517645147951219024105100520010合计200100——’02级’01级’00级’99级女生男生女生男生女生男生女生男生下载文件
20.
833333333339.
130434782654.
166666666773.
913043478367.
857142857174.
074074074157.
142857142939.1304347826打游戏
4.
166666666721.
739130434829.
166666666743.
478260869614.
285714285733.
333333333310.
714285714356.5217391304聊天
62.
547.
82608695655056.
521739130439.
285714285751.
85185185192534.7826086957收发邮件
58.
333333333343.
478260869670.
833333333334.
782608695778.
571428571448.
148148148167.
857142857139.1304347826浏览网页
54.
166666666765.
217391304370.
833333333382.
608695652285.
714285714381.
481481481564.
285714285769.5652173913其它
16.
666666666721.
73913043488.
333333333307.
14285714297.
40740740747.
14285714294.
34782608724232423282728230.
050.
090.
130.
170.
190.
20.
160.
091.
08540.
010.
050.
070.
10.
040.
090.
030.
130.
52260.
150.
110.
120.
130.
110.
140.
070.
080.
9145.
50.
140.
10.
170.
080.
220.
130.
190.
091.
12560.
130.
150.
170.
190.
240.
220.
180.
161.
44720.
040.
050.
0200.
020.
020.
020.
010.189人次百分比下载文件
10854.0%打游戏
5226.0%聊天
9145.5%收发邮件
11256.0%浏览网页
14472.0%其它
189.0%合计
525262.5%收费方式人数(人)按电脑包月
442222.0%按端口包月
8743.
543.5%按实际上网时间
4321.
521.5%按流量
178.
58.5%其它
94.
54.5%200Sheet3图-5上网收费方式分布
2.最高收费分析表-8最高收费分布情况表回答类别人数/人百分比向上累积向下累积10元以下
10351.5%
51.5%
100.0%10~20元
8040.0%
91.5%
48.5%20~50元
157.5%
99.0%
8.5%50~100元
10.5%
99.5%
1.0%100元以上
10.5%
100.0%
0.5%合计
200100.0%——如表-8所示,只有17人能接受每月20元以上的收费标准,而其他
91.5%的人只能接受20元以下的标准这一情况通过向下累积图(见图-6)可以得到更明显的显示图表5200971721Sheet1编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q10102级女ACBCEAB10CBADECB202级女ADBADECC30BACDEBB302级女BCBACDAB10ABCDECB402级女CCDCECA8DABCECB502级女DAAACDAB15BACDECB602级女ACAECC10ABCDEAA702级女ACBFCB0CBADEBD802级女ACACDBB5CBADEBD902级女ACACEA0BCADEBB1002级女BCBABCDEBA5CBADEDC1102级女DCECDEFBB10CABDECC1202级女ADBDEAA
2.5ACBDECA1302级女ACBACDEBA5BCDAEBC1402级女BBDCDEBA0BACDECC1502级女BDCCDECA5BCADEBB1602级女ACBCEAB15BCADEEC1702级女ACBDCA5BCADECB1802级女AABCDFCA5CBADECB1902级女ACBCDB20ACBDECA2002级女AECCDECB10CBADEAB2102级女AEAAEEA5CBADECA2202级女CCDCDECC15ABCDECB2302级女BABFCA10BCDAEAB2402级女CACDEAC30BADCECC2502级男EABADEBA3DBCAEEC2602级男CACCDEEB15BCADEEC2702级男CACACDEBA20BADCEEC2802级男AEEEAA5ABCDEBC2902级男AEEEAA5CBADEAC3002级男DADAEBB15BADCEEB3102级男DCDACDFCB8BCADEBD3202级男BCCCFCC10BCADECD3302级男BCCACECB20BADCECC3402级男CCECDEAB15BCDAECC3502级男EECBBA10BCADEAB3602级男EACADEBA0DBCAEDC3702级男CCDBCDECB15ABCDECA3802级男ECEFDE20ABDCEEC3902级男CCDACEAA1CBADEAC4002级男CACAEBB15BADCEEB4102级男CCDADEFBC30BCADEBB4202级男ACAFCC30BCADEBD4302级男BCCCEBA6BACDEDC4402级男CCDBCAB10ABCDEEB4502级男EABCDEEA5BADCECC4602级男CBCBBB4BADCECA4702级男DCBBDCB10DABCECB4801级女BCCCDFCB15BACDECD4901级女EABABCDEBB10BCADEEC5001级女CAACDEBA5CBADECC5101级女BAADECA3ABDCEBB5201级女BAAABCDEAA3ABDCEAD5301级女EACACDECA10CABDEDC5401级女BCCDEBA5CBADECC5501级女CAAACDEBA3CBADEAC5601级女DAAADEBA5CBADEBC5701级女DAAACDEBA5CBADECC5801级女CAAADECA5BCDAEDC5901级女CAABDEBB3CBADECB6001级女CAAFEA1CBADEEC6101级女DCDBCDEBA10BCDAEDC6201级女DACACEBA10BDACEDC6301级女CCDBADEDA8BDCAEBA6401级女DAAACDEBB15CBADEDC6501级女EABABCDEBB20CBADECD6601级女EAAABCDEBB20BCADEBC6701级女BAAACDBA20BCADEBC6801级女DAAACECA5DCBAECB6901级女DACADEBA5CBADEEC7001级女EAABAA10CBADEBB7101级女CAADEBA0BCADECC7201级男EABACDEBB15BADCECB7301级男AABBCB10BCADEBB7401级男AAAACECA5BCADEEC7501级男BEDCDD20BACDEBB7601级男AABEBA5BCDAEDC7701级男CAAABCDEBA1ABCDECC7801级男EAAABCEAA10BACDEEB7901级男AAAADEAA3BCADECC8001级男EAAAEBC20CBADECD8101级男EAAACEBB15BCDAEDC8201级男EAAACEBA2ABCDEDC8301级男EAAAEBA5CBADEDC8401级男ACAABB15CBDAEBB8501级男AABACDEDA10CBADEAC8601级男DAAACEDA5CBADECC8701级男EAEACDEBB15CBADEEC8801级男BAACEAA5CBADECC8901级男DAABCAA2BCADEDC9001级男BAABCEAB15BCDAEBB9101级男CAAABEBA10CBADECC9201级男EAAABCDEEB5CBADEEC9301级男EAAABDEEB10CABDEEC9401级男EAAACDEBB5CBADEDC9500级女AAAEDB10BADCECC9600级女DAAACDEBA10BCADECC9700级女EAAADEFAB10ABCDECC9800级女AEAADEDC30BADCECA9900级女EAAABCDEFBB10ABCDEDC10000级女CAAACDECB10CBADECC10100级女DAAABCDEDA10CBADEEB10200级女EEEADECB10BCADEEC10300级女DAADEBA2BCADEDC10400级女EAADEBA5ABCDEDC10500级女EAAABDEBA5CBADEAC10600级女EAEADEBB10ABDCECC10700级女EAAACDECA10CBADEDB10800级女BABACEAB10BCADECC10900级女EAAAAB15BACDEDD11000级女CEAAEBA6BDACEEC11100级女BEADEBA3BCADECC11200级女BAAADEDA10BCADEDC11300级女EAAACDEBA5ABCDEDB11400级女AAACDEAA10BACDEBB11500级女BCBCDECA2BACDEDB11600级女DAAABCDEBA3CABDEDC11700级女EAAACDEBA5BADCECB11800级女CAAABCDEEA0CBADEEC11900级女BCAADEBB15BCADECC12000级女DAAACDBB5BCADEDB12100级女BEBDEBA5BCADEDC12200级女BAAADECB10CBDAEBD12300级男EAAABEBA5BCADEEB12400级男EAAABCDEAA0BCADEBD12500级男EAAAECB5CBADECC12600级男BAAABCDEAA5BCADECD12700级男EAAAEBB10BACDECB12800级男EAAABEBA10BCADEEC12900级男EAAAEAB20CBADEDC13000级男CAAACDDB5BCADEDC13100级男EAAADEBB10BCADECB13200级男EAAADEAB10BCADECC13300级男AAAEDA5CBADEBB13400级男BAAACDEAB10BADCEDC13500级男EAAABEAB10BCADEDC13600级男BABECC30ACBDECB13700级男AAAACBA5CBADEBB13800级男EAAABCDEAA2CBADECD13900级男BAACDECA5CBADECC14000级男DAAACEBB10ABCDEDC14100级男EAAACEEB12ACBDECB14200级男EAAABCDEFBC10BACDEEC14300级男EABABCDEBA5BACDEEC14400级男EAAABCDEBA5ABDCEDB14500级男BAAABCDEAA10BACDECC14600级男BAACBB20BACDEBC14700级男CAACDEFAA20BACDEDC14800级男BAAAEAB10BCADECA14900级男EABADEAA5ABCDEDC15099级女ECDBCCB10CBADEDB15199级女EACABCAC10CBDAEEB15299级女EAAADEBB10CBADEDB15399级女CABADEAA5BCADEAC15499级女CAADEFCA5BCADEDC15599级女BABCCA5CABDEAB15699级女ADBECA2CBADEAD15799级女EAADEAA10BACDEDB15899级女EAEBCAC40BCADEEA15999级女AAADAA5CDBAEBB16099级女DCBDECB15BACDECB16199级女EEEDEBA5BCADEEC16299级女DDBCCA5CBADEAB16399级女CAADEAA5CBADEDB16499级女ADAADEFCA10CABDECC16599级女EDDADECB10BACDEDB16699级女EAADEBB10BACDEED16799级女DAAABA10CBADEEC16899级女CAAABB10CBDAEDB16999级女EAAADEDA5BACDEDC17099级女CAAADEBB10BCADEDC17199级女EAAACDEBB10BCADEDC17299级女EAAABB15BADCECC17399级女EABADEBB10CBADEBC17499级女CAAADECA10CBDAEDC17599级女BAAADEBA5CBADECC17699级女DAAADDB10ACBDECC17799级女EAAACDEDA0BADCEDC17899级男EABDEDA10BCADEDB17999级男EABDEAB20BACDEEC18099级男EABBDEFAB20BACDEDC18199级男AAAECA0BCDAEBB18299级男EABABEDC30ACBDEDC18399级男DACBDEBA5BACDEEC18499级男DABDEBC30ABDCECC18599级男EAAABCDEAB20BACDEEB18699级男DAACDBA5CBADECC18799级男BAABCA0CBADEAD18899级男EAAABDBB10CABDECB18999级男EACABDEBB10CBADEDC19099级男BAABCAA5CABDEBB19199级男EABBCEBB10BCADEDB19299级男DAAABCEBB15CBADECC19399级男EABABEBB10BCADECC19499级男EAAAEBA5CBDAEEC19599级男CACECA5ABCDEDC19699级男BAAEBB15BACDEDB19799级男DABAEBA5CBADEDC19899级男EAAABCAB10CABDECC19999级男EAACDBB10BCADECB20099级男EAABCEBB15ABCDECBSheet
29.5925合理收费算术平均第1题回答类别人数(人)百分比向上累积向下累积3小时以下321616100322003--6小时
3517.
533.584671686--9小时
3316.
55066.51001339--12小时
2914.
564.55012910012小时以上
7135.
510035.520071合计200100——#VALUE!第2题上网途径人数(人)频率(%)宿舍14472A网吧21B信息楼
3517.5C图书馆
73.5D其它126E200第3题回答类别人数(人)百分比向上累积向下累积011457571001142005元以下
4120.
577.543155865--10元
2110.
58822.51764510--20元14795121902420元以上105100520010合计200100——第4题’02级’01级’00级’99级女生男生女生男生女生男生女生男生下载文件
20.
833333333339.
130434782654.
166666666773.
913043478367.
857142857174.
074074074157.
142857142939.1304347826打游戏
4.
166666666721.
739130434829.
166666666743.
478260869614.
285714285733.
333333333310.
714285714356.5217391304聊天
62.
547.
82608695655056.
521739130439.
285714285751.
85185185192534.7826086957收发邮件
58.
333333333343.
478260869670.
833333333334.
782608695778.
571428571448.
148148148167.
857142857139.1304347826浏览网页
54.
166666666765.
217391304370.
833333333382.
608695652285.
714285714381.
481481481564.
285714285769.5652173913其它
16.
666666666721.
73913043488.
333333333307.
14285714297.
40740740747.
14285714294.
34782608724232423282728230.
050.
090.
130.
170.
190.
20.
160.
091.
08540.
010.
050.
070.
10.
040.
090.
030.
130.
52260.
150.
110.
120.
130.
110.
140.
070.
080.
9145.
50.
140.
10.
170.
080.
220.
130.
190.
091.
12560.
130.
150.
170.
190.
240.
220.
180.
161.
44720.
040.
050.
0200.
020.
020.
020.
010.189人次百分比下载文件
10854.0%打游戏
5226.0%聊天
9145.5%收发邮件
11256.0%浏览网页
14472.0%其它
189.0%合计
525262.5%第5题收费方式人数(人)频率(%)按电脑包月
442222.0%按端口包月
8743.
543.5%按实际上网时间
4321.
521.5%按流量
178.
58.5%其它
94.
54.5%200第6题回答类别人数(人)百分比向上累积向下累积10元以下
10351.5%
51.5%
100.0%10320010--20元
8040.0%
91.5%
48.5%1839720--50元
157.5%
99.0%
8.5%1981750--100元
10.5%
99.5%
1.0%1992100元以上
10.5%
100.0%
0.5%2001合计
200100.0%——Sheet3图-6最高收费人数累积
3.合理收费标准分析对所有数据进行汇总,得到合理收费的算术平均值为
9.5925元/月,再对总体均值进行区间估计(见表-9)表-9总体均值置信区间计算表样本数据个数200样本均值
9.5925样本标准差
6.96402773抽样平均误差
0.49243112置信水平
0.95自由度
1.99t值
1.97195732误差范围
0.97105316置信下限
8.62144684置信上限
10.5635532我们有95%的把握认为被调查者认为的合理收费水平在
8.62144684元/月和
10.5635532元/月之间另外,整理数据后的综合情况如表-9所示表-10合理收费分布表单位元/每月收费人数/人频率向上累积
0105.0%
5.0%
131.5%
6.5%
263.0%
9.5%
2.
510.5%
10.0%
384.0%
14.0%续表
410.5%
14.5%
55527.5%
42.0%
621.0%
43.0%
831.5%
44.5%
106432.0%
76.5%
1210.5%
77.0%
152211.0%
88.0%
20157.5%
95.5%
3084.0%
99.5%
4010.5%
100.0%合计200100%—根据表-10所示数据,
76.5%的被调查者认为校园网合理的收费应在10元以下;认为10元/月是合理的收费标准的最多(占32%),其次是5元/月(占
27.5%),可以近似看作是这一分布的两个众数(如图-7所示)图表610361815523641221581Sheet1编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q10102级女ACBCEAB10CBADECB202级女ADBADECC30BACDEBB302级女BCBACDAB10ABCDECB402级女CCDCECA8DABCECB502级女DAAACDAB15BACDECB602级女ACAECC10ABCDEAA702级女ACBFCB0CBADEBD802级女ACACDBB5CBADEBD902级女ACACEA0BCADEBB1002级女BCBABCDEBA5CBADEDC1102级女DCECDEFBB10CABDECC1202级女ADBDEAA
2.5ACBDECA1302级女ACBACDEBA5BCDAEBC1402级女BBDCDEBA0BACDECC1502级女BDCCDECA5BCADEBB1602级女ACBCEAB15BCADEEC1702级女ACBDCA5BCADECB1802级女AABCDFCA5CBADECB1902级女ACBCDB20ACBDECA2002级女AECCDECB10CBADEAB2102级女AEAAEEA5CBADECA2202级女CCDCDECC15ABCDECB2302级女BABFCA10BCDAEAB2402级女CACDEAC30BADCECC2502级男EABADEBA3DBCAEEC2602级男CACCDEEB15BCADEEC2702级男CACACDEBA20BADCEEC2802级男AEEEAA5ABCDEBC2902级男AEEEAA5CBADEAC3002级男DADAEBB15BADCEEB3102级男DCDACDFCB8BCADEBD3202级男BCCCFCC10BCADECD3302级男BCCACECB20BADCECC3402级男CCECDEAB15BCDAECC3502级男EECBBA10BCADEAB3602级男EACADEBA0DBCAEDC3702级男CCDBCDECB15ABCDECA3802级男ECEFDE20ABDCEEC3902级男CCDACEAA1CBADEAC4002级男CACAEBB15BADCEEB4102级男CCDADEFBC30BCADEBB4202级男ACAFCC30BCADEBD4302级男BCCCEBA6BACDEDC4402级男CCDBCAB10ABCDEEB4502级男EABCDEEA5BADCECC4602级男CBCBBB4BADCECA4702级男DCBBDCB10DABCECB4801级女BCCCDFCB15BACDECD4901级女EABABCDEBB10BCADEEC5001级女CAACDEBA5CBADECC5101级女BAADECA3ABDCEBB5201级女BAAABCDEAA3ABDCEAD5301级女EACACDECA10CABDEDC5401级女BCCDEBA5CBADECC5501级女CAAACDEBA3CBADEAC5601级女DAAADEBA5CBADEBC5701级女DAAACDEBA5CBADECC5801级女CAAADECA5BCDAEDC5901级女CAABDEBB3CBADECB6001级女CAAFEA1CBADEEC6101级女DCDBCDEBA10BCDAEDC6201级女DACACEBA10BDACEDC6301级女CCDBADEDA8BDCAEBA6401级女DAAACDEBB15CBADEDC6501级女EABABCDEBB20CBADECD6601级女EAAABCDEBB20BCADEBC6701级女BAAACDBA20BCADEBC6801级女DAAACECA5DCBAECB6901级女DACADEBA5CBADEEC7001级女EAABAA10CBADEBB7101级女CAADEBA0BCADECC7201级男EABACDEBB15BADCECB7301级男AABBCB10BCADEBB7401级男AAAACECA5BCADEEC7501级男BEDCDD20BACDEBB7601级男AABEBA5BCDAEDC7701级男CAAABCDEBA1ABCDECC7801级男EAAABCEAA10BACDEEB7901级男AAAADEAA3BCADECC8001级男EAAAEBC20CBADECD8101级男EAAACEBB15BCDAEDC8201级男EAAACEBA2ABCDEDC8301级男EAAAEBA5CBADEDC8401级男ACAABB15CBDAEBB8501级男AABACDEDA10CBADEAC8601级男DAAACEDA5CBADECC8701级男EAEACDEBB15CBADEEC8801级男BAACEAA5CBADECC8901级男DAABCAA2BCADEDC9001级男BAABCEAB15BCDAEBB9101级男CAAABEBA10CBADECC9201级男EAAABCDEEB5CBADEEC9301级男EAAABDEEB10CABDEEC9401级男EAAACDEBB5CBADEDC9500级女AAAEDB10BADCECC9600级女DAAACDEBA10BCADECC9700级女EAAADEFAB10ABCDECC9800级女AEAADEDC30BADCECA9900级女EAAABCDEFBB10ABCDEDC10000级女CAAACDECB10CBADECC10100级女DAAABCDEDA10CBADEEB10200级女EEEADECB10BCADEEC10300级女DAADEBA2BCADEDC10400级女EAADEBA5ABCDEDC10500级女EAAABDEBA5CBADEAC10600级女EAEADEBB10ABDCECC10700级女EAAACDECA10CBADEDB10800级女BABACEAB10BCADECC10900级女EAAAAB15BACDEDD11000级女CEAAEBA6BDACEEC11100级女BEADEBA3BCADECC11200级女BAAADEDA10BCADEDC11300级女EAAACDEBA5ABCDEDB11400级女AAACDEAA10BACDEBB11500级女BCBCDECA2BACDEDB11600级女DAAABCDEBA3CABDEDC11700级女EAAACDEBA5BADCECB11800级女CAAABCDEEA0CBADEEC11900级女BCAADEBB15BCADECC12000级女DAAACDBB5BCADEDB12100级女BEBDEBA5BCADEDC12200级女BAAADECB10CBDAEBD12300级男EAAABEBA5BCADEEB12400级男EAAABCDEAA0BCADEBD12500级男EAAAECB5CBADECC12600级男BAAABCDEAA5BCADECD12700级男EAAAEBB10BACDECB12800级男EAAABEBA10BCADEEC12900级男EAAAEAB20CBADEDC01013000级男CAAACDDB5BCADEDC1313100级男EAAADEBB10BCADECB2613200级男EAAADEAB10BCADECC
2.5113300级男AAAEDA5CBADEBB3813400级男BAAACDEAB10BADCEDC4113500级男EAAABEAB10BCADEDC55513600级男BABECC30ACBDECB6213700级男AAAACBA5CBADEBB8313800级男EAAABCDEAA2CBADECD106413900级男BAACDECA5CBADECC152214000级男DAAACEBB10ABCDEDC201514100级男EAAACEEB12ACBDECB30814200级男EAAABCDEFBC10BACDEEC40114300级男EABABCDEBA5BACDEEC
120.0114400级男EAAABCDEBA5ABDCEDB14500级男BAAABCDEAA10BACDECC14600级男BAACBB20BACDEBC14700级男CAACDEFAA20BACDEDC14800级男BAAAEAB10BCADECA14900级男EABADEAA5ABCDEDC15099级女ECDBCCB10CBADEDB15199级女EACABCAC10CBDAEEB15299级女EAAADEBB10CBADEDB15399级女CABADEAA5BCADEAC15499级女CAADEFCA5BCADEDC15599级女BABCCA5CABDEAB15699级女ADBECA2CBADEAD15799级女EAADEAA10BACDEDB15899级女EAEBCAC40BCADEEA15999级女AAADAA5CDBAEBB16099级女DCBDECB15BACDECB16199级女EEEDEBA5BCADEEC16299级女DDBCCA5CBADEAB16399级女CAADEAA5CBADEDB16499级女ADAADEFCA10CABDECC16599级女EDDADECB10BACDEDB16699级女EAADEBB10BACDEED16799级女DAAABA10CBADEEC16899级女CAAABB10CBDAEDB16999级女EAAADEDA5BACDEDC17099级女CAAADEBB10BCADEDC17199级女EAAACDEBB10BCADEDC17299级女EAAABB15BADCECC17399级女EABADEBB10CBADEBC17499级女CAAADECA10CBDAEDC17599级女BAAADEBA5CBADECC17699级女DAAADDB10ACBDECC17799级女EAAACDEDA0BADCEDC17899级男EABDEDA10BCADEDB17999级男EABDEAB20BACDEEC18099级男EABBDEFAB20BACDEDC18199级男AAAECA0BCDAEBB18299级男EABABEDC30ACBDEDC18399级男DACBDEBA5BACDEEC18499级男DABDEBC30ABDCECC18599级男EAAABCDEAB20BACDEEB18699级男DAACDBA5CBADECC18799级男BAABCA0CBADEAD18899级男EAAABDBB10CABDECB18999级男EACABDEBB10CBADEDC19099级男BAABCAA5CABDEBB19199级男EABBCEBB10BCADEDB19299级男DAAABCEBB15CBADECC19399级男EABABEBB10BCADECC19499级男EAAAEBA5CBDAEEC19599级男CACECA5ABCDEDC19699级男BAAEBB15BACDEDB19799级男DABAEBA5CBADEDC19899级男EAAABCAB10CABDECC19999级男EAACDBB10BCADECB20099级男EAABCEBB15ABCDECBSheet
29.5925合理收费算术平均
1918.
59.5925第1题回答类别人数(人)百分比向上累积向下累积3小时以下321616100322003--6小时
3517.
533.584671686--9小时
3316.
55066.51001339--12小时
2914.
564.55012910012小时以上
7135.
510035.520071合计200100——#VALUE!第2题上网途径人数(人)频率(%)宿舍14472A网吧21B信息楼
3517.5C图书馆
73.5D其它126E200第3题回答类别人数(人)百分比向上累积向下累积011457571001142005元以下
4120.
577.543155865--10元
2110.
58822.51764510--20元14795121902420元以上105100520010合计200100——第4题’02级’01级’00级’99级女生男生女生男生女生男生女生男生下载文件
20.
833333333339.
130434782654.
166666666773.
913043478367.
857142857174.
074074074157.
142857142939.1304347826打游戏
4.
166666666721.
739130434829.
166666666743.
478260869614.
285714285733.
333333333310.
714285714356.5217391304聊天
62.
547.
82608695655056.
521739130439.
285714285751.
85185185192534.7826086957收发邮件
58.
333333333343.
478260869670.
833333333334.
782608695778.
571428571448.
148148148167.
857142857139.1304347826浏览网页
54.
166666666765.
217391304370.
833333333382.
608695652285.
714285714381.
481481481564.
285714285769.5652173913其它
16.
666666666721.
73913043488.
333333333307.
14285714297.
40740740747.
14285714294.
34782608724232423282728230.
050.
090.
130.
170.
190.
20.
160.
091.
08540.
010.
050.
070.
10.
040.
090.
030.
130.
52260.
150.
110.
120.
130.
110.
140.
070.
080.
9145.
50.
140.
10.
170.
080.
220.
130.
190.
091.
12560.
130.
150.
170.
190.
240.
220.
180.
161.
44720.
040.
050.
0200.
020.
020.
020.
010.189人次百分比下载文件
10854.0%打游戏
5226.0%聊天
9145.5%收发邮件
11256.0%浏览网页
14472.0%其它
189.0%合计
525262.5%第5题收费方式人数(人)频率(%)按电脑包月
442222.0%按端口包月
8743.
543.5%按实际上网时间
4321.
521.5%按流量
178.
58.5%其它
94.
54.5%200第6题回答类别人数(人)百分比向上累积向下累积10元以下
10351.5%
51.5%
100.0%10320010--20元
8040.0%
91.5%
48.5%1839720--50元
157.5%
99.0%
8.5%1981750--100元
10.5%
99.5%
1.0%1992100元以上
10.5%
100.0%
0.5%2001合计
200100.0%——第7题’02级’01级’00级’99级女生
9.
60416666678.
16666666678.
42857142869.178571428624242828男生
11.
82608695659.
04347826099.
407407407411.521739130423232723方差分析无重复双因素分析男女有差异SUMMARY计数求和平均方差年级无差异行
1435.
37797619058.
84449404760.4403839227行
2441.
798711755210.
44967793882.0358474592列
1221.
430253623210.
71512681162.4684648872列
2217.
21014492758.
60507246380.3843992859列
3217.
8359788368.
9179894180.4790599367列
4220.
70031055910.
35015527952.7452174395方差分析差异源SSdfMSFP-valueFcrit行
5.
153230649115.
153230649116.
73288186370.
026409769510.1279624687列
6.
504783245232.
16826108177.
04048760890.
071617299.2766185844误差
0.
923910900330.3079703001总计
12.58192479467收费人数(人)频率向上累积
0105.0%
5.0%
131.5%
6.5%
263.0%
9.5%
2.
510.5%
10.0%
384.0%
14.0%
410.5%
14.5%
55527.5%
42.0%
621.0%
43.0%
831.5%
44.5%
106432.0%
76.5%
1210.5%
77.0%
152211.0%
88.0%
20157.5%
95.5%
3084.0%
99.5%
4010.5%
100.0%合计200100%—Sheet3图-7合理收费分布情况我们还将全部200个数据按年级和性别不同分为8个组,并分别求出了各组数据的均值,如表-11所示表-11不同年级不同性别的被调查者认为的合理收费单位元/月 ’02级’01级’00级’99级女生
9.
6041666678.
1666666678.
4285714299.178571429男生
11.
826086969.
0434782619.
40740740711.52173913然后,我们以年级和性别为因素对合理收费做了双因素方差分析
(1)建立假设对行因素(性别)H0μ1=μ2性别之间无显著差别H1μ1=μ2性别之间有显著差别对列因素(年级)H0μ1=μ2=μ3=μ4年级之间无显著差别H1μ1=μ2=μ3=μ4年级之间有显著差别
(2)计算F值(见表-12)表-12双因素方差分析表差异源离差平方和自由度均方F值P-值F统计量行
5.
1532306515.
15323064916.
732881860.
0264110.128列
6.
5047832532.
1682610827.
0404876090.
071629.27662误差
0.
923910930.3079703———总计
12.58192487————
(3)统计决策对行因素(性别)F=
16.73288186F统计量=
10.128故不能接受H0,说明不同性别的被调查者对合理收费水平的看法有显著差异;对列因素(年级)F=
7.040487609F统计量=
9.27662故不能拒绝H0,说明不同年级的被调查者对合理收费水平的看法没有显著差异
(三)其他情况分析我们将被调查者关心的校园网指标、不能上网对他们的影响、以及他们将对不能接受的收费方案采取的行动分别进行的分析1.对被调查者关心的校园网指标的排序的分析(首选指标和前两位指标排序的情况如表-13所示)表-13校园网指标排序情况表单位人次 首选频率1次选频率2前两位合计频率合计稳定
3115.5%
5125.5%
8241.0%速度
9547.5%
8341.5%
17889.0%价格
6934.5%
6231.0%
13165.5%维护
52.5%
42.0%
94.5%其它
00.0%
00.0%
00.0%合计
200100.0%
200100.0%
400200.0%占全体被调查者
47.5%的人首选了速度作为他(她)最关心的指标,其次是价格指标(占
34.5%),如图-8所示图表
70.
1550.
4750.
3450.0250Sheet1编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q10102级女ACBCEAB10CBADECB202级女ADBADECC30BACDEBB302级女BCBACDAB10ABCDECB402级女CCDCECA8DABCECB502级女DAAACDAB15BACDECB602级女ACAECC10ABCDEAA702级女ACBFCB0CBADEBD802级女ACACDBB5CBADEBD902级女ACACEA0BCADEBB1002级女BCBABCDEBA5CBADEDC1102级女DCECDEFBB10CABDECC1202级女ADBDEAA
2.5ACBDECA1302级女ACBACDEBA5BCDAEBC1402级女BBDCDEBA0BACDECC1502级女BDCCDECA5BCADEBB1602级女ACBCEAB15BCADEEC1702级女ACBDCA5BCADECB1802级女AABCDFCA5CBADECB1902级女ACBCDB20ACBDECA2002级女AECCDECB10CBADEAB2102级女AEAAEEA5CBADECA2202级女CCDCDECC15ABCDECB2302级女BABFCA10BCDAEAB2402级女CACDEAC30BADCECC2502级男EABADEBA3DBCAEEC2602级男CACCDEEB15BCADEEC2702级男CACACDEBA20BADCEEC2802级男AEEEAA5ABCDEBC2902级男AEEEAA5CBADEAC3002级男DADAEBB15BADCEEB3102级男DCDACDFCB8BCADEBD3202级男BCCCFCC10BCADECD3302级男BCCACECB20BADCECC3402级男CCECDEAB15BCDAECC3502级男EECBBA10BCADEAB3602级男EACADEBA0DBCAEDC3702级男CCDBCDECB15ABCDECA3802级男ECEFDE20ABDCEEC3902级男CCDACEAA1CBADEAC4002级男CACAEBB15BADCEEB4102级男CCDADEFBC30BCADEBB4202级男ACAFCC30BCADEBD4302级男BCCCEBA6BACDEDC4402级男CCDBCAB10ABCDEEB4502级男EABCDEEA5BADCECC4602级男CBCBBB4BADCECA4702级男DCBBDCB10DABCECB4801级女BCCCDFCB15BACDECD4901级女EABABCDEBB10BCADEEC5001级女CAACDEBA5CBADECC5101级女BAADECA3ABDCEBB5201级女BAAABCDEAA3ABDCEAD5301级女EACACDECA10CABDEDC5401级女BCCDEBA5CBADECC5501级女CAAACDEBA3CBADEAC5601级女DAAADEBA5CBADEBC5701级女DAAACDEBA5CBADECC5801级女CAAADECA5BCDAEDC5901级女CAABDEBB3CBADECB6001级女CAAFEA1CBADEEC6101级女DCDBCDEBA10BCDAEDC6201级女DACACEBA10BDACEDC6301级女CCDBADEDA8BDCAEBA6401级女DAAACDEBB15CBADEDC6501级女EABABCDEBB20CBADECD6601级女EAAABCDEBB20BCADEBC6701级女BAAACDBA20BCADEBC6801级女DAAACECA5DCBAECB6901级女DACADEBA5CBADEEC7001级女EAABAA10CBADEBB7101级女CAADEBA0BCADECC7201级男EABACDEBB15BADCECB7301级男AABBCB10BCADEBB7401级男AAAACECA5BCADEEC7501级男BEDCDD20BACDEBB7601级男AABEBA5BCDAEDC7701级男CAAABCDEBA1ABCDECC7801级男EAAABCEAA10BACDEEB7901级男AAAADEAA3BCADECC8001级男EAAAEBC20CBADECD8101级男EAAACEBB15BCDAEDC8201级男EAAACEBA2ABCDEDC8301级男EAAAEBA5CBADEDC8401级男ACAABB15CBDAEBB8501级男AABACDEDA10CBADEAC8601级男DAAACEDA5CBADECC8701级男EAEACDEBB15CBADEEC8801级男BAACEAA5CBADECC8901级男DAABCAA2BCADEDC9001级男BAABCEAB15BCDAEBB9101级男CAAABEBA10CBADECC9201级男EAAABCDEEB5CBADEEC9301级男EAAABDEEB10CABDEEC9401级男EAAACDEBB5CBADEDC9500级女AAAEDB10BADCECC9600级女DAAACDEBA10BCADECC9700级女EAAADEFAB10ABCDECC9800级女AEAADEDC30BADCECA9900级女EAAABCDEFBB10ABCDEDC10000级女CAAACDECB10CBADECC10100级女DAAABCDEDA10CBADEEB10200级女EEEADECB10BCADEEC10300级女DAADEBA2BCADEDC10400级女EAADEBA5ABCDEDC10500级女EAAABDEBA5CBADEAC10600级女EAEADEBB10ABDCECC10700级女EAAACDECA10CBADEDB10800级女BABACEAB10BCADECC10900级女EAAAAB15BACDEDD11000级女CEAAEBA6BDACEEC11100级女BEADEBA3BCADECC11200级女BAAADEDA10BCADEDC11300级女EAAACDEBA5ABCDEDB11400级女AAACDEAA10BACDEBB11500级女BCBCDECA2BACDEDB11600级女DAAABCDEBA3CABDEDC11700级女EAAACDEBA5BADCECB11800级女CAAABCDEEA0CBADEEC11900级女BCAADEBB15BCADECC12000级女DAAACDBB5BCADEDB12100级女BEBDEBA5BCADEDC12200级女BAAADECB10CBDAEBD12300级男EAAABEBA5BCADEEB12400级男EAAABCDEAA0BCADEBD12500级男EAAAECB5CBADECC12600级男BAAABCDEAA5BCADECD12700级男EAAAEBB10BACDECB12800级男EAAABEBA10BCADEEC12900级男EAAAEAB20CBADEDC13000级男CAAACDDB5BCADEDC13100级男EAAADEBB10BCADECB13200级男EAAADEAB10BCADECC13300级男AAAEDA5CBADEBB13400级男BAAACDEAB10BADCEDC13500级男EAAABEAB10BCADEDC13600级男BABECC30ACBDECB13700级男AAAACBA5CBADEBB13800级男EAAABCDEAA2CBADECD13900级男BAACDECA5CBADECC14000级男DAAACEBB10ABCDEDC14100级男EAAACEEB12ACBDECB14200级男EAAABCDEFBC10BACDEEC14300级男EABABCDEBA5BACDEEC14400级男EAAABCDEBA5ABDCEDB14500级男BAAABCDEAA10BACDECC14600级男BAACBB20BACDEBC14700级男CAACDEFAA20BACDEDC14800级男BAAAEAB10BCADECA14900级男EABADEAA5ABCDEDC15099级女ECDBCCB10CBADEDB15199级女EACABCAC10CBDAEEB15299级女EAAADEBB10CBADEDB15399级女CABADEAA5BCADEAC15499级女CAADEFCA5BCADEDC15599级女BABCCA5CABDEAB15699级女ADBECA2CBADEAD15799级女EAADEAA10BACDEDB15899级女EAEBCAC40BCADEEA15999级女AAADAA5CDBAEBB16099级女DCBDECB15BACDECB16199级女EEEDEBA5BCADEEC16299级女DDBCCA5CBADEAB16399级女CAADEAA5CBADEDB16499级女ADAADEFCA10CABDECC16599级女EDDADECB10BACDEDB16699级女EAADEBB10BACDEED16799级女DAAABA10CBADEEC16899级女CAAABB10CBDAEDB16999级女EAAADEDA5BACDEDC17099级女CAAADEBB10BCADEDC17199级女EAAACDEBB10BCADEDC17299级女EAAABB15BADCECC17399级女EABADEBB10CBADEBC17499级女CAAADECA10CBDAEDC17599级女BAAADEBA5CBADECC17699级女DAAADDB10ACBDECC17799级女EAAACDEDA0BADCEDC17899级男EABDEDA10BCADEDB17999级男EABDEAB20BACDEEC18099级男EABBDEFAB20BACDEDC18199级男AAAECA0BCDAEBB18299级男EABABEDC30ACBDEDC18399级男DACBDEBA5BACDEEC18499级男DABDEBC30ABDCECC18599级男EAAABCDEAB20BACDEEB18699级男DAACDBA5CBADECC18799级男BAABCA0CBADEAD18899级男EAAABDBB10CABDECB18999级男EACABDEBB10CBADEDC19099级男BAABCAA5CABDEBB19199级男EABBCEBB10BCADEDB19299级男DAAABCEBB15CBADECC19399级男EABABEBB10BCADECC19499级男EAAAEBA5CBDAEEC19599级男CACECA5ABCDEDC19699级男BAAEBB15BACDEDB19799级男DABAEBA5CBADEDC19899级男EAAABCAB10CABDECC19999级男EAACDBB10BCADECB20099级男EAABCEBB15ABCDECBSheet
29.5925合理收费算术平均
1918.
59.5925第1题回答类别人数(人)百分比向上累积向下累积3小时以下321616100322003--6小时
3517.
533.584671686--9小时
3316.
55066.51001339--12小时
2914.
564.55012910012小时以上
7135.
510035.520071合计200100——#VALUE!第2题上网途径人数(人)频率(%)宿舍14472A网吧21B信息楼
3517.5C图书馆
73.5D其它126E200第3题回答类别人数(人)百分比向上累积向下累积011457571001142005元以下
4120.
577.543155865--10元
2110.
58822.51764510--20元14795121902420元以上105100520010合计200100——第4题’02级’01级’00级’99级女生男生女生男生女生男生女生男生下载文件
20.
833333333339.
130434782654.
166666666773.
913043478367.
857142857174.
074074074157.
142857142939.1304347826打游戏
4.
166666666721.
739130434829.
166666666743.
478260869614.
285714285733.
333333333310.
714285714356.5217391304聊天
62.
547.
82608695655056.
521739130439.
285714285751.
85185185192534.7826086957收发邮件
58.
333333333343.
478260869670.
833333333334.
782608695778.
571428571448.
148148148167.
857142857139.1304347826浏览网页
54.
166666666765.
217391304370.
833333333382.
608695652285.
714285714381.
481481481564.
285714285769.5652173913其它
16.
666666666721.
73913043488.
333333333307.
14285714297.
40740740747.
14285714294.
34782608724232423282728230.
050.
090.
130.
170.
190.
20.
160.
091.
08540.
010.
050.
070.
10.
040.
090.
030.
130.
52260.
150.
110.
120.
130.
110.
140.
070.
080.
9145.
50.
140.
10.
170.
080.
220.
130.
190.
091.
12560.
130.
150.
170.
190.
240.
220.
180.
161.
44720.
040.
050.
0200.
020.
020.
020.
010.189人次百分比下载文件
10854.0%打游戏
5226.0%聊天
9145.5%收发邮件
11256.0%浏览网页
14472.0%其它
189.0%合计
525262.5%第5题收费方式人数(人)频率(%)按电脑包月
442222.0%按端口包月
8743.
543.5%按实际上网时间
4321.
521.5%按流量
178.
58.5%其它
94.
54.5%200第6题回答类别人数(人)百分比向上累积向下累积10元以下
10351.5%
51.5%
100.0%10320010--20元
8040.0%
91.5%
48.5%1839720--50元
157.5%
99.0%
8.5%1981750--100元
10.5%
99.5%
1.0%1992100元以上
10.5%
100.0%
0.5%2001合计
200100.0%——第7题’02级’01级’00级’99级女生
9.
60416666678.
16666666678.
42857142869.178571428624242828男生
11.
82608695659.
04347826099.
407407407411.521739130423232723方差分析无重复双因素分析男女有差异SUMMARY计数求和平均方差年级无差异行
1435.
37797619058.
84449404760.4403839227行
2441.
798711755210.
44967793882.0358474592列
1221.
430253623210.
71512681162.4684648872列
2217.
21014492758.
60507246380.3843992859列
3217.
8359788368.
9179894180.4790599367列
4220.
70031055910.
35015527952.7452174395方差分析差异源SSdfMSFP-valueFcrit行
5.
153230649115.
153230649116.
73288186370.
026409769510.1279624687列
6.
504783245232.
16826108177.
04048760890.
071617299.2766185844误差
0.
923910900330.3079703001总计
12.58192479467收费人数(人)频率向上累积
0105.0%
5.0%
131.5%
6.5%
263.0%
9.5%
2.
510.5%
10.0%
384.0%
14.0%
410.5%
14.5%
55527.5%
42.0%
621.0%
43.0%
831.5%
44.5%
106432.0%
76.5%
1210.5%
77.0%
152211.0%
88.0%
20157.5%
95.5%
3084.0%
99.5%
4010.5%
100.0%合计200100%—第8题Sheet3Q8Q8CBADEBCBACDEAB人数频率’02级’01级’00级’99级ABCDEBA稳定
3115.5%DABCEAD速度
9547.5%BACDEAB价格
6934.5%ABCDEBA维护
52.5%CBADEBC其它
00.0%CBADEBC合计
200100.0%BCADECB
5125.5%CBADEBC
8341.5%CABDEAC
6231.0%ACBDECA
42.0%BCDAECB
00.0%BACDEAB
200100.0%BCADECBBCADECB首选频率1次选频率2前两位合计频率合计BCADECB稳定
3115.5%
5125.5%
8241.0%CBADEBC速度
9547.5%
8341.5%
17889.0%ACBDECA价格
6934.5%
6231.0%
13165.5%CBADEBC维护
52.5%
42.0%
94.5%CBADEBC其它
00.0%
00.0%
00.0%ABCDEBA合计
200100.0%
200100.0%
400200.0%BCDAECBBADCEABDBCAEBDBCADECBBADCEABABCDEBACBADEBCBADCEABBCADECBBCADECBBADCEABBCDAECBBCADECBDBCAEBDABCDEBAABDCEBACBADEBCBADCEABBCADECBBCADECBBACDEABABCDEBABADCEABBADCEABDABCEADBACDEABBCADECBCBADEBCABDCEBAABDCEBACABDEACCBADEBCCBADEBCCBADEBCCBADEBCBCDAECBCBADEBCCBADEBCBCDAECBBDACEDBBDCAEDBCBADEBCCBADEBCBCADECBBCADECBDCBAECDCBADEBCCBADEBCBCADECBBADCEABBCADECBBCADECBBACDEABBCDAECBABCDEBABACDEABBCADECBCBADEBCBCDAECBABCDEBACBADEBCCBDAEBCCBADEBCCBADEBCCBADEBCCBADEBCBCADECBBCDAECBCBADEBCCBADEBCCABDEACCBADEBCBADCEABBCADECBABCDEBABADCEABABCDEBACBADEBCCBADEBBBCADECBBCADECBABCDEBACBADEBCABDCEBACBADEBCBCADECBBACDEABBDACEDBBCADECBBCADECBABCDEBABACDEABBACDEAACABDEACBADCEABCBADEBCBCADECBBCADECBBCADECBCBDAEBCBCADECBBCADECBCBADEBCBCADECBBACDEABBCADECBCBADEBCBCADECBBCADECBBCADECBCBADEBCBADCEABBCADECBACBDECACBADEBCCBADEBCCBADEBCABCDEBAACBDECABACDEABBACDEABABDCEBABACDEABBACDEABBACDEABBCADECBABCDEBACBADEBCCBDAEBCCBADEBCBCADECBBCADECBCABDEACCBADEBCBACDEABBCADECBCDBAEDCBACDEABBCADECCCBADEBCCBADEBCCABDEACBACDEABBACDEAACBADEBCCBDAEBBBACDEAABCADECBBCADECCBADCEABCBADEBCCBDAEBCCBADEBCACBDECABADCEABBCADECBBACDEABBACDEABBCDAECBACBDECABACDEABABDCEBABACDEABCBADEBCCBADEBCCABDEACCBADEBCCABDEACBCADECBCBADEBCBCADECBCBDAEBCABCDEBABACDEABCBADEBCCABDEACBCADECBABCDEBA图-8首选指标排序情况有89%人被调查者将速度指标列在前两位,而价格指标被
65.5%的被调查者放在前两位(见图-9),可见速度和价格是被调查者最关心的问题图表
80.
410.
890.
6550.0450Sheet1编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q10102级女ACBCEAB10CBADECB202级女ADBADECC30BACDEBB302级女BCBACDAB10ABCDECB402级女CCDCECA8DABCECB502级女DAAACDAB15BACDECB602级女ACAECC10ABCDEAA702级女ACBFCB0CBADEBD802级女ACACDBB5CBADEBD902级女ACACEA0BCADEBB1002级女BCBABCDEBA5CBADEDC1102级女DCECDEFBB10CABDECC1202级女ADBDEAA
2.5ACBDECA1302级女ACBACDEBA5BCDAEBC1402级女BBDCDEBA0BACDECC1502级女BDCCDECA5BCADEBB1602级女ACBCEAB15BCADEEC1702级女ACBDCA5BCADECB1802级女AABCDFCA5CBADECB1902级女ACBCDB20ACBDECA2002级女AECCDECB10CBADEAB2102级女AEAAEEA5CBADECA2202级女CCDCDECC15ABCDECB2302级女BABFCA10BCDAEAB2402级女CACDEAC30BADCECC2502级男EABADEBA3DBCAEEC2602级男CACCDEEB15BCADEEC2702级男CACACDEBA20BADCEEC2802级男AEEEAA5ABCDEBC2902级男AEEEAA5CBADEAC3002级男DADAEBB15BADCEEB3102级男DCDACDFCB8BCADEBD3202级男BCCCFCC10BCADECD3302级男BCCACECB20BADCECC3402级男CCECDEAB15BCDAECC3502级男EECBBA10BCADEAB3602级男EACADEBA0DBCAEDC3702级男CCDBCDECB15ABCDECA3802级男ECEFDE20ABDCEEC3902级男CCDACEAA1CBADEAC4002级男CACAEBB15BADCEEB4102级男CCDADEFBC30BCADEBB4202级男ACAFCC30BCADEBD4302级男BCCCEBA6BACDEDC4402级男CCDBCAB10ABCDEEB4502级男EABCDEEA5BADCECC4602级男CBCBBB4BADCECA4702级男DCBBDCB10DABCECB4801级女BCCCDFCB15BACDECD4901级女EABABCDEBB10BCADEEC5001级女CAACDEBA5CBADECC5101级女BAADECA3ABDCEBB5201级女BAAABCDEAA3ABDCEAD5301级女EACACDECA10CABDEDC5401级女BCCDEBA5CBADECC5501级女CAAACDEBA3CBADEAC5601级女DAAADEBA5CBADEBC5701级女DAAACDEBA5CBADECC5801级女CAAADECA5BCDAEDC5901级女CAABDEBB3CBADECB6001级女CAAFEA1CBADEEC6101级女DCDBCDEBA10BCDAEDC6201级女DACACEBA10BDACEDC6301级女CCDBADEDA8BDCAEBA6401级女DAAACDEBB15CBADEDC6501级女EABABCDEBB20CBADECD6601级女EAAABCDEBB20BCADEBC6701级女BAAACDBA20BCADEBC6801级女DAAACECA5DCBAECB6901级女DACADEBA5CBADEEC7001级女EAABAA10CBADEBB7101级女CAADEBA0BCADECC7201级男EABACDEBB15BADCECB7301级男AABBCB10BCADEBB7401级男AAAACECA5BCADEEC7501级男BEDCDD20BACDEBB7601级男AABEBA5BCDAEDC7701级男CAAABCDEBA1ABCDECC7801级男EAAABCEAA10BACDEEB7901级男AAAADEAA3BCADECC8001级男EAAAEBC20CBADECD8101级男EAAACEBB15BCDAEDC8201级男EAAACEBA2ABCDEDC8301级男EAAAEBA5CBADEDC8401级男ACAABB15CBDAEBB8501级男AABACDEDA10CBADEAC8601级男DAAACEDA5CBADECC8701级男EAEACDEBB15CBADEEC8801级男BAACEAA5CBADECC8901级男DAABCAA2BCADEDC9001级男BAABCEAB15BCDAEBB9101级男CAAABEBA10CBADECC9201级男EAAABCDEEB5CBADEEC9301级男EAAABDEEB10CABDEEC9401级男EAAACDEBB5CBADEDC9500级女AAAEDB10BADCECC9600级女DAAACDEBA10BCADECC9700级女EAAADEFAB10ABCDECC9800级女AEAADEDC30BADCECA9900级女EAAABCDEFBB10ABCDEDC10000级女CAAACDECB10CBADECC10100级女DAAABCDEDA10CBADEEB10200级女EEEADECB10BCADEEC10300级女DAADEBA2BCADEDC10400级女EAADEBA5ABCDEDC10500级女EAAABDEBA5CBADEAC10600级女EAEADEBB10ABDCECC10700级女EAAACDECA10CBADEDB10800级女BABACEAB10BCADECC10900级女EAAAAB15BACDEDD11000级女CEAAEBA6BDACEEC11100级女BEADEBA3BCADECC11200级女BAAADEDA10BCADEDC11300级女EAAACDEBA5ABCDEDB11400级女AAACDEAA10BACDEBB11500级女BCBCDECA2BACDEDB11600级女DAAABCDEBA3CABDEDC11700级女EAAACDEBA5BADCECB11800级女CAAABCDEEA0CBADEEC11900级女BCAADEBB15BCADECC12000级女DAAACDBB5BCADEDB12100级女BEBDEBA5BCADEDC12200级女BAAADECB10CBDAEBD12300级男EAAABEBA5BCADEEB12400级男EAAABCDEAA0BCADEBD12500级男EAAAECB5CBADECC12600级男BAAABCDEAA5BCADECD12700级男EAAAEBB10BACDECB12800级男EAAABEBA10BCADEEC12900级男EAAAEAB20CBADEDC13000级男CAAACDDB5BCADEDC13100级男EAAADEBB10BCADECB13200级男EAAADEAB10BCADECC13300级男AAAEDA5CBADEBB13400级男BAAACDEAB10BADCEDC13500级男EAAABEAB10BCADEDC13600级男BABECC30ACBDECB13700级男AAAACBA5CBADEBB13800级男EAAABCDEAA2CBADECD13900级男BAACDECA5CBADECC14000级男DAAACEBB10ABCDEDC14100级男EAAACEEB12ACBDECB14200级男EAAABCDEFBC10BACDEEC14300级男EABABCDEBA5BACDEEC14400级男EAAABCDEBA5ABDCEDB14500级男BAAABCDEAA10BACDECC14600级男BAACBB20BACDEBC14700级男CAACDEFAA20BACDEDC14800级男BAAAEAB10BCADECA14900级男EABADEAA5ABCDEDC15099级女ECDBCCB10CBADEDB15199级女EACABCAC10CBDAEEB15299级女EAAADEBB10CBADEDB15399级女CABADEAA5BCADEAC15499级女CAADEFCA5BCADEDC15599级女BABCCA5CABDEAB15699级女ADBECA2CBADEAD15799级女EAADEAA10BACDEDB15899级女EAEBCAC40BCADEEA15999级女AAADAA5CDBAEBB16099级女DCBDECB15BACDECB16199级女EEEDEBA5BCADEEC16299级女DDBCCA5CBADEAB16399级女CAADEAA5CBADEDB16499级女ADAADEFCA10CABDECC16599级女EDDADECB10BACDEDB16699级女EAADEBB10BACDEED16799级女DAAABA10CBADEEC16899级女CAAABB10CBDAEDB16999级女EAAADEDA5BACDEDC17099级女CAAADEBB10BCADEDC17199级女EAAACDEBB10BCADEDC17299级女EAAABB15BADCECC17399级女EABADEBB10CBADEBC17499级女CAAADECA10CBDAEDC17599级女BAAADEBA5CBADECC17699级女DAAADDB10ACBDECC17799级女EAAACDEDA0BADCEDC17899级男EABDEDA10BCADEDB17999级男EABDEAB20BACDEEC18099级男EABBDEFAB20BACDEDC18199级男AAAECA0BCDAEBB18299级男EABABEDC30ACBDEDC18399级男DACBDEBA5BACDEEC18499级男DABDEBC30ABDCECC18599级男EAAABCDEAB20BACDEEB18699级男DAACDBA5CBADECC18799级男BAABCA0CBADEAD18899级男EAAABDBB10CABDECB18999级男EACABDEBB10CBADEDC19099级男BAABCAA5CABDEBB19199级男EABBCEBB10BCADEDB19299级男DAAABCEBB15CBADECC19399级男EABABEBB10BCADECC19499级男EAAAEBA5CBDAEEC19599级男CACECA5ABCDEDC19699级男BAAEBB15BACDEDB19799级男DABAEBA5CBADEDC19899级男EAAABCAB10CABDECC19999级男EAACDBB10BCADECB20099级男EAABCEBB15ABCDECBSheet
29.5925合理收费算术平均
1918.
59.5925第1题回答类别人数(人)百分比向上累积向下累积3小时以下321616100322003--6小时
3517.
533.584671686--9小时
3316.
55066.51001339--12小时
2914.
564.55012910012小时以上
7135.
510035.520071合计200100——#VALUE!第2题上网途径人数(人)频率(%)宿舍14472A网吧21B信息楼
3517.5C图书馆
73.5D其它126E200第3题回答类别人数(人)百分比向上累积向下累积011457571001142005元以下
4120.
577.543155865--10元
2110.
58822.51764510--20元14795121902420元以上105100520010合计200100——第4题’02级’01级’00级’99级女生男生女生男生女生男生女生男生下载文件
20.
833333333339.
130434782654.
166666666773.
913043478367.
857142857174.
074074074157.
142857142939.1304347826打游戏
4.
166666666721.
739130434829.
166666666743.
478260869614.
285714285733.
333333333310.
714285714356.5217391304聊天
62.
547.
82608695655056.
521739130439.
285714285751.
85185185192534.7826086957收发邮件
58.
333333333343.
478260869670.
833333333334.
782608695778.
571428571448.
148148148167.
857142857139.1304347826浏览网页
54.
166666666765.
217391304370.
833333333382.
608695652285.
714285714381.
481481481564.
285714285769.5652173913其它
16.
666666666721.
73913043488.
333333333307.
14285714297.
40740740747.
14285714294.
34782608724232423282728230.
050.
090.
130.
170.
190.
20.
160.
091.
08540.
010.
050.
070.
10.
040.
090.
030.
130.
52260.
150.
110.
120.
130.
110.
140.
070.
080.
9145.
50.
140.
10.
170.
080.
220.
130.
190.
091.
12560.
130.
150.
170.
190.
240.
220.
180.
161.
44720.
040.
050.
0200.
020.
020.
020.
010.189人次百分比下载文件
10854.0%打游戏
5226.0%聊天
9145.5%收发邮件
11256.0%浏览网页
14472.0%其它
189.0%合计
525262.5%第5题收费方式人数(人)频率(%)按电脑包月
442222.0%按端口包月
8743.
543.5%按实际上网时间
4321.
521.5%按流量
178.
58.5%其它
94.
54.5%200第6题回答类别人数(人)百分比向上累积向下累积10元以下
10351.5%
51.5%
100.0%10320010--20元
8040.0%
91.5%
48.5%1839720--50元
157.5%
99.0%
8.5%1981750--100元
10.5%
99.5%
1.0%1992100元以上
10.5%
100.0%
0.5%2001合计
200100.0%——第7题’02级’01级’00级’99级女生
9.
60416666678.
16666666678.
42857142869.178571428624242828男生
11.
82608695659.
04347826099.
407407407411.521739130423232723方差分析无重复双因素分析男女有差异SUMMARY计数求和平均方差年级无差异行
1435.
37797619058.
84449404760.4403839227行
2441.
798711755210.
44967793882.0358474592列
1221.
430253623210.
71512681162.4684648872列
2217.
21014492758.
60507246380.3843992859列
3217.
8359788368.
9179894180.4790599367列
4220.
70031055910.
35015527952.7452174395方差分析差异源SSdfMSFP-valueFcrit行
5.
153230649115.
153230649116.
73288186370.
026409769510.1279624687列
6.
504783245232.
16826108177.
04048760890.
071617299.2766185844误差
0.
923910900330.3079703001总计
12.58192479467收费人数(人)频率向上累积
0105.0%
5.0%
131.5%
6.5%
263.0%
9.5%
2.
510.5%
10.0%
384.0%
14.0%
410.5%
14.5%
55527.5%
42.0%
621.0%
43.0%
831.5%
44.5%
106432.0%
76.5%
1210.5%
77.0%
152211.0%
88.0%
20157.5%
95.5%
3084.0%
99.5%
4010.5%
100.0%合计200100%—第8题Sheet3Q8Q8CBADEBCBACDEAB人数频率’02级’01级’00级’99级ABCDEBA稳定
3115.5%DABCEAD速度
9547.5%BACDEAB价格
6934.5%ABCDEBA维护
52.5%CBADEBC其它
00.0%CBADEBC合计
200100.0%BCADECB
5125.5%CBADEBC
8341.5%CABDEAC
6231.0%ACBDECA
42.0%BCDAECB
00.0%BACDEAB
200100.0%BCADECBBCADECB首选频率1次选频率2前两位合计频率合计BCADECB稳定
3115.5%
5125.5%
8241.0%CBADEBC速度
9547.5%
8341.5%
17889.0%ACBDECA价格
6934.5%
6231.0%
13165.5%CBADEBC维护
52.5%
42.0%
94.5%CBADEBC其它
00.0%
00.0%
00.0%ABCDEBA合计
200100.0%
200100.0%
400200.0%BCDAECBBADCEABDBCAEBDBCADECBBADCEABABCDEBACBADEBCBADCEABBCADECBBCADECBBADCEABBCDAECBBCADECBDBCAEBDABCDEBAABDCEBACBADEBCBADCEABBCADECBBCADECBBACDEABABCDEBABADCEABBADCEABDABCEADBACDEABBCADECBCBADEBCABDCEBAABDCEBACABDEACCBADEBCCBADEBCCBADEBCCBADEBCBCDAECBCBADEBCCBADEBCBCDAECBBDACEDBBDCAEDBCBADEBCCBADEBCBCADECBBCADECBDCBAECDCBADEBCCBADEBCBCADECBBADCEABBCADECBBCADECBBACDEABBCDAECBABCDEBABACDEABBCADECBCBADEBCBCDAECBABCDEBACBADEBCCBDAEBCCBADEBCCBADEBCCBADEBCCBADEBCBCADECBBCDAECBCBADEBCCBADEBCCABDEACCBADEBCBADCEABBCADECBABCDEBABADCEABABCDEBACBADEBCCBADEBBBCADECBBCADECBABCDEBACBADEBCABDCEBACBADEBCBCADECBBACDEABBDACEDBBCADECBBCADECBABCDEBABACDEABBACDEAACABDEACBADCEABCBADEBCBCADECBBCADECBBCADECBCBDAEBCBCADECBBCADECBCBADEBCBCADECBBACDEABBCADECBCBADEBCBCADECBBCADECBBCADECBCBADEBCBADCEABBCADECBACBDECACBADEBCCBADEBCCBADEBCABCDEBAACBDECABACDEABBACDEABABDCEBABACDEABBACDEABBACDEABBCADECBABCDEBACBADEBCCBDAEBCCBADEBCBCADECBBCADECBCABDEACCBADEBCBACDEABBCADECBCDBAEDCBACDEABBCADECCCBADEBCCBADEBCCABDEACBACDEABBACDEAACBADEBCCBDAEBBBACDEAABCADECBBCADECCBADCEABCBADEBCCBDAEBCCBADEBCACBDECABADCEABBCADECBBACDEABBACDEABBCDAECBACBDECABACDEABABDCEBABACDEABCBADEBCCBADEBCCABDEACCBADEBCCABDEACBCADECBCBADEBCBCADECBCBDAEBCABCDEBABACDEABCBADEBCCABDEACBCADECBABCDEBA图-9前两位指标排序情况
2.不能上网对被调查者的影响分析表-14不能上网对生活的影响情况分布
(1)影响程度人数/人频率向上累积向下累积没有影响
157.5%
7.5%
100.0%有较小影响
3015.0%
22.5%
92.5%有一定影响
6934.5%
57.0%
77.5%有较大影响
5326.5%
83.5%
43.0%影响非常大
3316.5%
100.0%
16.5%合计
200100.0%——由表-14可见,不上网对被调查者“有一定影响”和“较大影响”的比重高达61%;选择“没影响”的只占到了
7.5%;而“影响较小”或“没有影响”的仅占全体被调查者的
22.
5.%其向下累积情况如图-10所示图表
1110.
9250.
7750.
430.165Sheet1编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q101女ACBCEAB10CBADECB2女ADBADECC30BACDEBB3女BCBACDAB10ABCDECB4女CCDCECA8DABCECB5女DAAACDAB15BACDECB6女ACAECC10ABCDEAA7女ACBFCB0CBADEBD8女ACACDBB5CBADEBD9女ACACEA0BCADEBB10女BCBABCDEBA5CBADEDC11女DCECDEFBB10CABDECC12女ADBDEAA
2.5ACBDECA13女ACBACDEBA5BCDAEBC14女BBDCDEBA0BACDECC15女BDCCDECA5BCADEBB16女ACBCEAB15BCADEEC17女ACBDCA5BCADECB18女AABCDFCA5CBADECB19女ACBCDB20ACBDECA20女AECCDECB10CBADEAB21女AEAAEEA5CBADECA22女CCDCDECC15ABCDECB23女BABFCA10BCDAEAB24女CACDEAC30BADCECC25男EABADEBA3DBCAEEC26男CACCDEEB15BCADEEC27男CACACDEBA20BADCEEC28男AEEEAA5ABCDEBC29男AEEEAA5CBADEAC30男DADAEBB15BADCEEB31男DCDACDFCB8BCADEBD32男BCCCFCC10BCADECD33男BCCACECB20BADCECC34男CCECDEAB15BCDAECC35男EECBBA10BCADEAB36男EACADEBA0DBCAEDC37男CCDBCDECB15ABCDECA38男ECEFDE20ABDCEEC39男CCDACEAA1CBADEAC40男CACAEBB15BADCEEB41男CCDADEFBC30BCADEBB42男ACAFCC30BCADEBD43男BCCCEBA6BACDEDC44男CCDBCAB10ABCDEEB45男EABCDEEA5BADCECC46男CBCBBB4BADCECA47男DCBBDCB10DABCECB48女BCCCDFCB15BACDECD49女EABABCDEBB10BCADEEC50女CAACDEBA5CBADECC51女BAADECA3ABDCEBB52女BAAABCDEAA3ABDCEAD53女EACACDECA10CABDEDC54女BCCDEBA5CBADECC55女CAAACDEBA3CBADEAC56女DAAADEBA5CBADEBC57女DAAACDEBA5CBADECC58女CAAADECA5BCDAEDC59女CAABDEBB3CBADECB60女CAAFEA1CBADEEC61女DCDBCDEBA10BCDAEDC62女DACACEBA10BDACEDC63女CCDBADEDA8BDCAEBA64女DAAACDEBB15CBADEDC65女EABABCDEBB20CBADECD66女EAAABCDEBB20BCADEBC67女BAAACDBA20BCADEBC68女DAAACECA5DCBAECB69女DACADEBA5CBADEEC70女EAABAA10CBADEBB71女CAADEBA0BCADECC72男EABACDEBB15BADCECB73男AABBCB10BCADEBB74男AAAACECA5BCADEEC75男BEDCDD20BACDEBB76男AABEBA5BCDAEDC77男CAAABCDEBA1ABCDECC78男EAAABCEAA10BACDEEB79男AAAADEAA3BCADECC80男EAAAEBC20CBADECD81男EAAACEBB15BCDAEDC82男EAAACEBA2ABCDEDC83男EAAAEBA5CBADEDC84男ACAABB15CBDAEBB85男AABACDEDA10CBADEAC86男DAAACEDA5CBADECC87男EAEACDEBB15CBADEEC88男BAACEAA5CBADECC89男DAABCAA2BCADEDC90男BAABCEAB15BCDAEBB91男CAAABEBA10CBADECC92男EAAABCDEEB5CBADEEC93男EAAABDEEB10CABDEEC94男EAAACDEBB5CBADEDC95女AAAEDB10BADCECC96女DAAACDEBA10BCADECC97女EAAADEFAB10ABCDECC98女AEAADEDC30BADCECA99女EAAABCDEFBB10ABCDEDC100女CAAACDECB10CBADECC101女DAAABCDEDA10CBADEEB102女EEEADECB10BCADEEC103女DAADEBA2BCADEDC104女EAADEBA5ABCDEDC105女EAAABDEBA5CBADEAC106女EAEADEBB10ABDCECC107女EAAACDECA10CBADEDB108女BABACEAB10BCADECC109女EAAAAB15BACDEDD110女CEAAEBA6BDACEEC111女BEADEBA3BCADECC112女BAAADEDA10BCADEDC113女EAAACDEBA5ABCDEDB114女AAACDEAA10BACDEBB115女BCBCDECA2BACDEDB116女DAAABCDEBA3CABDEDC117女EAAACDEBA5BADCECB118女CAAABCDEEA0CBADEEC119女BCAADEBB15BCADECC120女DAAACDBB5BCADEDB121女BEBDEBA5BCADEDC122女BAAADECB10CBDAEBD123男EAAABEBA5BCADEEB124男EAAABCDEAA0BCADEBD125男EAAAECB5CBADECC126男BAAABCDEAA5BCADECD127男EAAAEBB10BACDECB128男EAAABEBA10BCADEEC129男EAAAEAB20CBADEDC130男CAAACDDB5BCADEDC131男EAAADEBB10BCADECB132男EAAADEAB10BCADECC133男AAAEDA5CBADEBB134男BAAACDEAB10BADCEDC135男EAAABEAB10BCADEDC136男BABECC30ACBDECB137男AAAACBA5CBADEBB138男EAAABCDEAA2CBADECD139男BAACDECA5CBADECC140男DAAACEBB10ABCDEDC141男EAAACEEB12ACBDECB142男EAAABCDEFBC10BACDEEC143男EABABCDEBA5BACDEEC144男EAAABCDEBA5ABDCEDB145男BAAABCDEAA10BACDECC146男BAACBB20BACDEBC147男CAACDEFAA20BACDEDC148男BAAAEAB10BCADECA149男EABADEAA5ABCDEDC150女ECDBCCB10CBADEDB151女EACABCAC10CBDAEEB152女EAAADEBB10CBADEDB153女CABADEAA5BCADEAC154女CAADEFCA5BCADEDC155女BABCCA5CABDEAB156女ADBECA2CBADEAD157女EAADEAA10BACDEDB158女EAEBCAC40BCADEEA159女AAADAA5CDBAEBB160女DCBDECB15BACDECB161女EEEDEBA5BCADEEC162女DDBCCA5CBADEAB163女CAADEAA5CBADEDB164女ADAADEFCA10CABDECC165女EDDADECB10BACDEDB166女EAADEBB10BACDEED167女DAAABA10CBADEEC168女CAAABB10CBDAEDB169女EAAADEDA5BACDEDC170女CAAADEBB10BCADEDC171女EAAACDEBB10BCADEDC172女EAAABB15BADCECC173女EABADEBB10CBADEBC174女CAAADECA10CBDAEDC175女BAAADEBA5CBADECC176女DAAADDB10ACBDECC177女EAAACDEDA0BADCEDC178男EABDEDA10BCADEDB179男EABDEAB20BACDEEC180男EABBDEFAB20BACDEDC181男AAAECA0BCDAEBB182男EABABEDC30ACBDEDC183男DACBDEBA5BACDEEC184男DABDEBC30ABDCECC185男EAAABCDEAB20BACDEEB186男DAACDBA5CBADECC187男BAABCA0CBADEAD188男EAAABDBB10CABDECB189男EACABDEBB10CBADEDC190男BAABCAA5CABDEBB191男EABBCEBB10BCADEDB192男DAAABCEBB15CBADECC193男EABABEBB10BCADECC194男EAAAEBA5CBDAEEC195男CACECA5ABCDEDC196男BAAEBB15BACDEDB197男DABAEBA5CBADEDC198男EAAABCAB10CABDECC199男EAACDBB10BCADECB200男EAABCEBB15ABCDECBSheet
29.5925合理收费算术平均
1918.
59.5925回答类别人数(人)百分比向下累积
321616100322003517.
533.
584671683316.
55066.
51001332914.
564.
5501291007135.
510035.520071合计200100——#VALUE!上网途径人数(人)宿舍14472A网吧21B信息楼
3517.5C图书馆
73.5D其它126E200回答类别人数(人)百分比向下累积
011457571001142004120.
577.
543155862110.
58822.517645147951219024105100520010合计200100——’02级’01级’00级’99级女生男生女生男生女生男生女生男生下载文件
20.
833333333339.
130434782654.
166666666773.
913043478367.
857142857174.
074074074157.
142857142939.1304347826打游戏
4.
166666666721.
739130434829.
166666666743.
478260869614.
285714285733.
333333333310.
714285714356.5217391304聊天
62.
547.
82608695655056.
521739130439.
285714285751.
85185185192534.7826086957收发邮件
58.
333333333343.
478260869670.
833333333334.
782608695778.
571428571448.
148148148167.
857142857139.1304347826浏览网页
54.
166666666765.
217391304370.
833333333382.
608695652285.
714285714381.
481481481564.
285714285769.5652173913其它
16.
666666666721.
73913043488.
333333333307.
14285714297.
40740740747.
14285714294.
34782608724232423282728230.
050.
090.
130.
170.
190.
20.
160.
091.
08540.
010.
050.
070.
10.
040.
090.
030.
130.
52260.
150.
110.
120.
130.
110.
140.
070.
080.
9145.
50.
140.
10.
170.
080.
220.
130.
190.
091.
12560.
130.
150.
170.
190.
240.
220.
180.
161.
44720.
040.
050.
0200.
020.
020.
020.
010.189人次百分比下载文件
10854.0%打游戏
5226.0%聊天
9145.5%收发邮件
11256.0%浏览网页
14472.0%其它
189.0%合计
525262.5%收费方式人数(人)按电脑包月
442222.0%按端口包月
8743.
543.5%按实际上网时间
4321.
521.5%按流量
178.
58.5%其它
94.
54.5%200回答类别人数(人)百分比向上累积向下累积
10351.5%
51.5%
100.0%
1032008040.0%
91.5%
48.5%
18397157.5%
99.0%
8.5%
1981710.5%
99.5%
1.0%
199210.5%
100.0%
0.5%2001合计
200100.0%——女生
9.
60416666678.
16666666678.
42857142869.178571428624242828男生
11.
82608695659.
04347826099.
407407407411.521739130423232723方差分析无重复双因素分析男女有差异SUMMARY计数求和平均方差年级无差异行
1435.
37797619058.
84449404760.4403839227行
2441.
798711755210.
44967793882.0358474592列
1221.
430253623210.
71512681162.4684648872列
2217.
21014492758.
60507246380.3843992859列
3217.
8359788368.
9179894180.4790599367列
4220.
70031055910.
35015527952.7452174395方差分析差异源SSdfMSFP-valueFcrit行
5.
153230649115.
153230649116.
73288186370.
026409769510.1279624687列
6.
504783245232.
16826108177.
04048760890.
071617299.2766185844误差
0.
923910900330.3079703001总计
12.58192479467收费人数(人)频率向上累积
0105.0%
5.0%
131.5%
6.5%
263.0%
9.5%
2.
510.5%
10.0%
384.0%
14.0%
410.5%
14.5%
55527.5%
42.0%
621.0%
43.0%
831.5%
44.5%
106432.0%
76.5%
1210.5%
77.0%
152211.0%
88.0%
20157.5%
95.5%
3084.0%
99.5%
4010.5%
100.0%合计200100%—Sheet3Q8Q8CBADEBCBACDEAB人数频率ABCDEBA稳定
3115.5%DABCEAD速度
9547.5%BACDEAB价格
6934.5%ABCDEBA维护
52.5%CBADEBC其它
00.0%CBADEBC合计
200100.0%BCADECB
5125.5%CBADEBC
8341.5%CABDEAC
6231.0%ACBDECA
42.0%BCDAECB
00.0%BACDEAB
200100.0%BCADECBBCADECB首选次选前两位合计频率合计BCADECB稳定
3115.5%
5125.5%
8241.0%CBADEBC速度
9547.5%
8341.5%
17889.0%ACBDECA价格
6934.5%
6231.0%
13165.5%CBADEBC维护
52.5%
42.0%
94.5%CBADEBC其它
00.0%
00.0%
00.0%ABCDEBA合计
200100.0%
200100.0%
400200.0%BCDAECBBADCEABDBCAEBDBCADECBBADCEABABCDEBACBADEBCBADCEABBCADECBBCADECBBADCEABBCDAECBBCADECBDBCAEBDABCDEBAABDCEBACBADEBCBADCEABBCADECBBCADECBBACDEABABCDEBABADCEABBADCEABDABCEADBACDEABBCADECBCBADEBCABDCEBAABDCEBACABDEACCBADEBCCBADEBCCBADEBCCBADEBCBCDAECBCBADEBCCBADEBCBCDAECBBDACEDBBDCAEDBCECCCEDDCBADEBCBEEBCBEECBADEBCCECECCDDBCADECBCBBBCCABBCADECBCAADDCDDDCBAECDAEDCCEAECBADEBCBBCEEDACCBADEBCBCACEDDEBCADECBBCBCDCECBADCEABDCCDDCBABCADECBCADDABCCBCADECBCDCDCDEDBACDEABBCEBDDABBCDAECBCEDACCDDABCDEBABADCDBCCBACDEABEEBEECDCBCADECBCBDCCCEECBADEBCCBCDDDEDBCDAECBCDBBDCDDABCDEBAAEBCBEDDCBADEBCCCCEDEDCCBDAEBCCCEEDDDCCBADEBCACBDCCCCCBADEBCCCEBBCBADEBCCDDCBADEBCDCCBCADECBDDCBCDAECBBDCBADEBC’02级’01级’00级’99级影响程度人数(人)频率向上累积向下累积CBADEBC人数比例人数比例人数比例人数比例没有影响
157.5%
7.5%
100.0%CABDEAC没有影响
612.8%
36.4%
11.8%
59.8%有较小影响
3015.0%
22.5%
92.5%CBADEBC有较小影响
1021.3%
1021.3%
610.9%
47.8%有一定影响
6934.5%
57.0%
77.5%BADCEAB有一定影响
2042.6%
1531.9%
2138.2%
1325.5%有较大影响
5326.5%
83.5%
43.0%BCADECB有较大影响
36.4%
1123.4%
1934.5%
2039.2%影响非常大
3316.5%
100.0%
16.5%ABCDEBA影响非常大
817.0%
817.0%
814.5%
917.6%合计
200100.0%——BADCEAB合计
47100.0%
47100.0%
55100.0%
51100.0%ABCDEBACBADEBCCBADEBBBCADECBBCADECBABCDEBACBADEBCABDCEBACBADEBCBCADECBBACDEABBDACEDBBCADECBBCADECBABCDEBABACDEABBACDEAACABDEACBADCEABCBADEBCBCADECBBCADECBBCADECBCBDAEBC回答类别人数(人)频率BCADECB被迫接受
105.0%BCADECB选择其他方式
6331.5%CBADEBC抗议
11055.0%BCADECB其它
178.5%BACDEAB合计
200100.0%BCADECBCBADEBCBCADECBBCADECBBCADECBCBADEBCBADCEABBCADECBACBDECACBADEBCCBADEBCCBADEBCABCDEBAACBDECABACDEABBACDEABABDCEBABACDEABBACDEABBACDEABBCADECBABCDEBACBADEBCCBDAEBCCBADEBCBCADECBBCADECBCABDEACCBADEBCBACDEABBCADECBCDBAEDCBACDEABBCADECCCBADEBCCBADEBCCABDEACBACDEABBACDEAACBADEBCCBDAEBBBACDEAABCADECBBCADECCBADCEABCBADEBCCBDAEBCCBADEBCACBDECABADCEABBCADECBBACDEABBACDEABBCDAECBACBDECABACDEABABDCEBABACDEABCBADEBCCBADEBCCABDEACCBADEBCCABDEACBCADECBCBADEBCBCADECBCBDAEBCABCDEBABACDEABCBADEBCCABDEACBCADECBABCDEBA图-10不能上网的影响程度累积另外我们就本题所研究的问题对不同年级进行了比较,其具体情况如表-15所示表-15不能上网对生活的影响情况分布
(2)单位人 ’02级’01级’00级’99级人数比例人数比例人数比例人数比例没有影响A
612.8%
36.4%
11.8%
59.8%有较小影响B
1021.3%
1021.3%
610.9%
47.8%有一定影响C
2042.6%
1531.9%
2138.2%
1325.5%有较大影响D
36.4%
1123.4%
1934.5%
2039.2%影响非常大E
817.0%
817.0%
814.5%
917.6%合计
47100.0%
47100.0%
55100.0%
51100.0%在02级的被调查者中,认为不能上网对其生活有一定影响的占到了总被调查者的
42.6%有较小影响的占
21.3%,无影响的占
12.8%,均高于其它年级;99级的被调查者中,认为不能上网有较大的和非常大影响的占到了这一组被调查者的
56.8%,在所有年级中是最高的从直观来看,随着年级的增大,不能上网对被调查者生活的影响程度也在增大由表-15做出管状图如图-11所示图表
10.
12765957450.
06382978720.
01818181820.
09803921570.
21276595740.
21276595740.
10909090910.
07843137250.
42553191490.
31914893620.
38181818180.
25490196080.
06382978720.
23404255320.
34545454550.
39215686270.
1702127660.
1702127660.
14545454550.1764705882Sheet1编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q10102级女ACBCEAB10CBADECB202级女ADBADECC30BACDEBB302级女BCBACDAB10ABCDECB列1样本数据个数200402级女CCDCECA8DABCECB样本均值
9.5925502级女DAAACDAB15BACDECB平均
9.5925样本标准差
6.9640277254602级女ACAECC10ABCDEAA标准误差
0.4924311229抽样平均误差
0.4924311229702级女ACBFCB0CBADEBD中值10置信水平
0.05802级女ACACDBB5CBADEBD模式10自由度
1.99902级女ACACEA0BCADEBB标准偏差
6.9640277254t值
1.97195731741002级女BCBABCDEBA5CBADEDC样本方差
48.4976821608误差范围
0.97105315611102级女DCECDEFBB10CABDECC峰值
2.6829413002置信下限
8.62144684391202级女ADBDEAA
2.5ACBDECA偏斜度
1.4262835201置信上限
10.56355315611302级女ACBACDEBA5BCDAEBC区域401402级女BBDCDEBA0BACDECC最小值01502级女BDCCDECA5BCADEBB最大值401602级女ACBCEAB15BCADEEC求和
1918.51702级女ACBDCA5BCADECB计数2001802级女AABCDFCA5CBADECB1902级女ACBCDB20ACBDECA2002级女AECCDECB10CBADEAB2102级女AEAAEEA5CBADECA2202级女CCDCDECC15ABCDECB2302级女BABFCA10BCDAEAB2402级女CACDEAC30BADCECC2502级男EABADEBA3DBCAEEC2602级男CACCDEEB15BCADEEC2702级男CACACDEBA20BADCEEC2802级男AEEEAA5ABCDEBC2902级男AEEEAA5CBADEAC3002级男DADAEBB15BADCEEB3102级男DCDACDFCB8BCADEBD3202级男BCCCFCC10BCADECD3302级男BCCACECB20BADCECC3402级男CCECDEAB15BCDAECC3502级男EECBBA10BCADEAB3602级男EACADEBA0DBCAEDC3702级男CCDBCDECB15ABCDECA3802级男ECEFDE20ABDCEEC3902级男CCDACEAA1CBADEAC4002级男CACAEBB15BADCEEB4102级男CCDADEFBC30BCADEBB4202级男ACAFCC30BCADEBD4302级男BCCCEBA6BACDEDC4402级男CCDBCAB10ABCDEEB4502级男EABCDEEA5BADCECC4602级男CBCBBB4BADCECA4702级男DCBBDCB10DABCECB4801级女BCCCDFCB15BACDECD4901级女EABABCDEBB10BCADEEC5001级女CAACDEBA5CBADECC5101级女BAADECA3ABDCEBB5201级女BAAABCDEAA3ABDCEAD5301级女EACACDECA10CABDEDC5401级女BCCDEBA5CBADECC5501级女CAAACDEBA3CBADEAC5601级女DAAADEBA5CBADEBC5701级女DAAACDEBA5CBADECC5801级女CAAADECA5BCDAEDC5901级女CAABDEBB3CBADECB6001级女CAAFEA1CBADEEC6101级女DCDBCDEBA10BCDAEDC6201级女DACACEBA10BDACEDC6301级女CCDBADEDA8BDCAEBA6401级女DAAACDEBB15CBADEDC6501级女EABABCDEBB20CBADECD6601级女EAAABCDEBB20BCADEBC6701级女BAAACDBA20BCADEBC6801级女DAAACECA5DCBAECB6901级女DACADEBA5CBADEEC7001级女EAABAA10CBADEBB7101级女CAADEBA0BCADECC7201级男EABACDEBB15BADCECB7301级男AABBCB10BCADEBB7401级男AAAACECA5BCADEEC7501级男BEDCDD20BACDEBB7601级男AABEBA5BCDAEDC7701级男CAAABCDEBA1ABCDECC7801级男EAAABCEAA10BACDEEB7901级男AAAADEAA3BCADECC8001级男EAAAEBC20CBADECD8101级男EAAACEBB15BCDAEDC8201级男EAAACEBA2ABCDEDC8301级男EAAAEBA5CBADEDC8401级男ACAABB15CBDAEBB8501级男AABACDEDA10CBADEAC8601级男DAAACEDA5CBADECC8701级男EAEACDEBB15CBADEEC8801级男BAACEAA5CBADECC8901级男DAABCAA2BCADEDC9001级男BAABCEAB15BCDAEBB9101级男CAAABEBA10CBADECC9201级男EAAABCDEEB5CBADEEC9301级男EAAABDEEB10CABDEEC9401级男EAAACDEBB5CBADEDC9500级女AAAEDB10BADCECC9600级女DAAACDEBA10BCADECC9700级女EAAADEFAB10ABCDECC9800级女AEAADEDC30BADCECA9900级女EAAABCDEFBB10ABCDEDC10000级女CAAACDECB10CBADECC10100级女DAAABCDEDA10CBADEEB10200级女EEEADECB10BCADEEC10300级女DAADEBA2BCADEDC10400级女EAADEBA5ABCDEDC10500级女EAAABDEBA5CBADEAC10600级女EAEADEBB10ABDCECC10700级女EAAACDECA10CBADEDB10800级女BABACEAB10BCADECC10900级女EAAAAB15BACDEDD11000级女CEAAEBA6BDACEEC11100级女BEADEBA3BCADECC11200级女BAAADEDA10BCADEDC11300级女EAAACDEBA5ABCDEDB11400级女AAACDEAA10BACDEBB11500级女BCBCDECA2BACDEDB11600级女DAAABCDEBA3CABDEDC11700级女EAAACDEBA5BADCECB11800级女CAAABCDEEA0CBADEEC11900级女BCAADEBB15BCADECC12000级女DAAACDBB5BCADEDB12100级女BEBDEBA5BCADEDC12200级女BAAADECB10CBDAEBD12300级男EAAABEBA5BCADEEB12400级男EAAABCDEAA0BCADEBD12500级男EAAAECB5CBADECC12600级男BAAABCDEAA5BCADECD12700级男EAAAEBB10BACDECB12800级男EAAABEBA10BCADEEC12900级男EAAAEAB20CBADEDC13000级男CAAACDDB5BCADEDC13100级男EAAADEBB10BCADECB13200级男EAAADEAB10BCADECC13300级男AAAEDA5CBADEBB13400级男BAAACDEAB10BADCEDC13500级男EAAABEAB10BCADEDC13600级男BABECC30ACBDECB13700级男AAAACBA5CBADEBB13800级男EAAABCDEAA2CBADECD13900级男BAACDECA5CBADECC14000级男DAAACEBB10ABCDEDC14100级男EAAACEEB12ACBDECB14200级男EAAABCDEFBC10BACDEEC14300级男EABABCDEBA5BACDEEC14400级男EAAABCDEBA5ABDCEDB14500级男BAAABCDEAA10BACDECC14600级男BAACBB20BACDEBC14700级男CAACDEFAA20BACDEDC14800级男BAAAEAB10BCADECA14900级男EABADEAA5ABCDEDC15099级女ECDBCCB10CBADEDB15199级女EACABCAC10CBDAEEB15299级女EAAADEBB10CBADEDB15399级女CABADEAA5BCADEAC15499级女CAADEFCA5BCADEDC15599级女BABCCA5CABDEAB15699级女ADBECA2CBADEAD15799级女EAADEAA10BACDEDB15899级女EAEBCAC40BCADEEA15999级女AAADAA5CDBAEBB16099级女DCBDECB15BACDECB16199级女EEEDEBA5BCADEEC16299级女DDBCCA5CBADEAB16399级女CAADEAA5CBADEDB16499级女ADAADEFCA10CABDECC16599级女EDDADECB10BACDEDB16699级女EAADEBB10BACDEED16799级女DAAABA10CBADEEC16899级女CAAABB10CBDAEDB16999级女EAAADEDA5BACDEDC17099级女CAAADEBB10BCADEDC17199级女EAAACDEBB10BCADEDC17299级女EAAABB15BADCECC17399级女EABADEBB10CBADEBC17499级女CAAADECA10CBDAEDC17599级女BAAADEBA5CBADECC17699级女DAAADDB10ACBDECC17799级女EAAACDEDA0BADCEDC17899级男EABDEDA10BCADEDB17999级男EABDEAB20BACDEEC18099级男EABBDEFAB20BACDEDC18199级男AAAECA0BCDAEBB18299级男EABABEDC30ACBDEDC18399级男DACBDEBA5BACDEEC18499级男DABDEBC30ABDCECC18599级男EAAABCDEAB20BACDEEB18699级男DAACDBA5CBADECC18799级男BAABCA0CBADEAD18899级男EAAABDBB10CABDECB18999级男EACABDEBB10CBADEDC19099级男BAABCAA5CABDEBB19199级男EABBCEBB10BCADEDB19299级男DAAABCEBB15CBADECC19399级男EABABEBB10BCADECC19499级男EAAAEBA5CBDAEEC19599级男CACECA5ABCDEDC19699级男BAAEBB15BACDEDB19799级男DABAEBA5CBADEDC19899级男EAAABCAB10CABDECC19999级男EAACDBB10BCADECB20099级男EAABCEBB15ABCDECBSheet
29.5925合理收费算术平均
11918.
519.592510频率累积%第1题
113216.00%回答类别人数(人)百分比向上累积向下累积
123533.50%3小时以下3216161003220011接收频率累积%
33350.00%3--6小时
3517.
533.
58467168210042964.50%6--9小时
3316.
55066.5100133313小时以下
3216.00%
571100.00%9--12小时
2914.
564.550129100413--6小时
3533.50%
00100.00%12小时以上
7135.
510035.520071516--9小时
3350.00%合计200100——#VALUE!19--12小时
2964.50%112小时以上
71100.00%
10.00%111111111111111111第2题1上网途径人数(人)频率(%)2宿舍14472A2网吧21B2信息楼
3517.5C2图书馆
73.5D2其它126E2220022222222222222222第3题22回答类别人数(人)百分比向上累积向下累积20114575710011420025元以下
4120.
577.5431558625--10元
2110.
58822.517645210--20元147951219024220元以上1051005200102合计200100——2223333333333333333第4题33’02级’01级’00级’99级3女生男生女生男生女生男生女生男生3下载文件
20.
833333333339.
130434782654.
166666666773.
913043478367.
857142857174.
074074074157.
142857142939.13043478263打游戏
4.
166666666721.
739130434829.
166666666743.
478260869614.
285714285733.
333333333310.
714285714356.52173913043聊天
62.
547.
82608695655056.
521739130439.
285714285751.
85185185192534.78260869573收发邮件
58.
333333333343.
478260869670.
833333333334.
782608695778.
571428571448.
148148148167.
857142857139.13043478263浏览网页
54.
166666666765.
217391304370.
833333333382.
608695652285.
714285714381.
481481481564.
285714285769.56521739133其它
16.
666666666721.
73913043488.
333333333307.
14285714297.
40740740747.
14285714294.
3478260873242324232827282333330.
050.
090.
130.
170.
190.
20.
160.
091.
085430.
010.
050.
070.
10.
040.
090.
030.
130.
522630.
150.
110.
120.
130.
110.
140.
070.
080.
9145.
530.
140.
10.
170.
080.
220.
130.
190.
091.
125640.
130.
150.
170.
190.
240.
220.
180.
161.
447240.
040.
050.
0200.
020.
020.
020.
010.18944人次百分比4下载文件
10854.0%4打游戏
5226.0%4聊天
9145.5%4收发邮件
11256.0%4浏览网页
14472.0%4其它
189.0%4合计
525262.5%44444444444444444455第5题5收费方式人数(人)频率(%)5按电脑包月
442222.0%5按端口包月
8743.
543.5%5按实际上网时间
4321.
521.5%5按流量
178.
58.5%5其它
94.
54.5%552005555第6题55回答类别人数(人)百分比向上累积向下累积510元以下
10351.5%
51.5%
100.0%103200510--20元
8040.0%
91.5%
48.5%18397520--50元
157.5%
99.0%
8.5%19817550--100元
10.5%
99.5%
1.0%19925100元以上
10.5%
100.0%
0.5%20015合计
200100.0%——55555555555555555555第7题5’02级’01级’00级’99级5女生
9.
60416666678.
16666666678.
42857142869.1785714286242428285男生
11.
82608695659.
04347826099.
407407407411.52173913042323272355方差分析无重复双因素分析5男女有差异5SUMMARY计数求和平均方差年级无差异5行
1435.
37797619058.
84449404760.44038392275行
2441.
798711755210.
44967793882.035847459255列
1221.
430253623210.
71512681162.46846488725列
2217.
21014492758.
60507246380.38439928595列
3217.
8359788368.
9179894180.47905993675列
4220.
70031055910.
35015527952.7452174395555方差分析5差异源SSdfMSFP-valueFcrit5行
5.
153230649115.
153230649116.
73288186370.
026409769510.12796246875列
6.
504783245232.
16826108177.
04048760890.
071617299.27661858445误差
0.
923910900330.307970300155总计
12.581924794675收费人数(人)频率向上累积
50105.0%
5.0%
5131.5%
6.5%
5263.0%
9.5%
52.
510.5%
10.0%
5384.0%
14.0%
410.5%
14.5%
55527.5%
42.0%
621.0%
43.0%
831.5%
44.5%
106432.0%
76.5%
1210.5%
77.0%
152211.0%
88.0%
20157.5%
95.5%
3084.0%
99.5%
4010.5%
100.0%合计200100%—Sheet3Q8Q8CBADEBCBACDEAB人数频率ABCDEBA稳定
3115.5%DABCEAD速度
9547.5%BACDEAB价格
6934.5%ABCDEBA维护
52.5%CBADEBC其它
00.0%CBADEBC合计
200100.0%BCADECB
5125.5%CBADEBC
8341.5%CABDEAC
6231.0%ACBDECA
42.0%BCDAECB
00.0%BACDEAB
200100.0%BCADECBBCADECB首选频率1次选频率2前两位合计频率合计BCADECB稳定
3115.5%
5125.5%
8241.0%CBADEBC速度
9547.5%
8341.5%
17889.0%ACBDECA价格
6934.5%
6231.0%
13165.5%CBADEBC维护
52.5%
42.0%
94.5%CBADEBC其它
00.0%
00.0%
00.0%ABCDEBA合计
200100.0%
200100.0%
400200.0%BCDAECBBADCEABDBCAEBDBCADECBBADCEABABCDEBACBADEBCBADCEABBCADECBBCADECBBADCEABBCDAECBBCADECBDBCAEBDABCDEBAABDCEBACBADEBCBADCEABBCADECBBCADECBBACDEABABCDEBABADCEABBADCEABDABCEADBACDEABBCADECBCBADEBCABDCEBAABDCEBACABDEACCBADEBCCBADEBCCBADEBCCBADEBCBCDAECBCBADEBCCBADEBCBCDAECB第9题BDACEDBBDCAEDBCECCCEDDCBADEBCBEEBCBEECBADEBCCECECCDDBCADECBCBBBCCABBCADECBCAADDCDDDCBAECDAEDCCEAECBADEBCBBCEEDACCBADEBCBCACEDDEBCADECBBCBCDCECBADCEABDCCDDCBABCADECBCADDABCCBCADECBCDCDCDEDBACDEABBCEBDDABBCDAECBCEDACCDDABCDEBABADCDBCCBACDEABEEBEECDCBCADECBCBDCCCEECBADEBCCBCDDDEDBCDAECBCDBBDCDDABCDEBAAEBCBEDDCBADEBCCCCEDEDCCBDAEBCCCEEDDDCCBADEBCACBDCCCCCBADEBCCCEBBCBADEBCCDDCBADEBCDCCBCADECBDDCBCDAECBBDCBADEBC’02级’01级’00级’99级影响程度人数(人)频率向上累积向下累积CBADEBC人数比例人数比例人数比例人数比例没有影响
157.5%
7.5%
100.0%CABDEAC没有影响
612.8%
36.4%
11.8%
59.8%有较小影响
3015.0%
22.5%
92.5%CBADEBC有较小影响
1021.3%
1021.3%
610.9%
47.8%有一定影响
6934.5%
57.0%
77.5%BADCEAB有一定影响
2042.6%
1531.9%
2138.2%
1325.5%有较大影响
5326.5%
83.5%
43.0%BCADECB有较大影响
36.4%
1123.4%
1934.5%
2039.2%影响非常大
3316.5%
100.0%
16.5%ABCDEBA影响非常大
817.0%
817.0%
814.5%
917.6%合计
200100.0%——BADCEAB合计
47100.0%
47100.0%
55100.0%
51100.0%ABCDEBACBADEBCCBADEBBBCADECBBCADECBABCDEBACBADEBCABDCEBACBADEBCBCADECBBACDEABBDACEDBBCADECBBCADECBABCDEBABACDEABBACDEAACABDEACBADCEABCBADEBCBCADECBBCADECBBCADECB第10题CBDAEBC回答类别人数(人)频率BCADECB被迫接受
105.0%BCADECB选择其他方式
6331.5%CBADEBC抗议
11055.0%BCADECB其它
178.5%BACDEAB合计
200100.0%BCADECBCBADEBCBCADECBBCADECBBCADECBCBADEBCBADCEABBCADECBACBDECACBADEBCCBADEBCCBADEBCABCDEBAACBDECABACDEABBACDEABABDCEBABACDEABBACDEABBACDEABBCADECBABCDEBACBADEBCCBDAEBCCBADEBCBCADECBBCADECBCABDEACCBADEBCBACDEABBCADECBCDBAEDCBACDEABBCADECCCBADEBCCBADEBCCABDEACBACDEABBACDEAACBADEBCCBDAEBBBACDEAABCADECBBCADECCBADCEABCBADEBCCBDAEBCCBADEBCACBDECABADCEABBCADECBBACDEABBACDEABBCDAECBACBDECABACDEABABDCEBABACDEABCBADEBCCBADEBCCABDEACCBADEBCCABDEACBCADECBCBADEBCBCADECBCBDAEBCABCDEBABACDEABCBADEBCCABDEACBCADECBABCDEBA图-11不能上网对各年级本科生的影响状况
3.不能满意实际收费方案的被调查者的反应分析表-16因不满意收费方案而采取的方式回答类别人数/人频率被迫接受
105.0%选择其他方式
6331.5%抗议
11055.0%其他
178.5%合计
200100.0%从表-16中看出,如果实际的方案不能令人满意,将有55%的被调查者会采取抗议的做法,而只有10人(占全体被调查者的5%)会被迫接受,其他人则会选择其它方式上网从图-12中可以明显的了解大家的反应图表
100.
050.
3150.
550.085Sheet1编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q10102级女ACBCEAB10CBADECB202级女ADBADECC30BACDEBB302级女BCBACDAB10ABCDECB402级女CCDCECA8DABCECB502级女DAAACDAB15BACDECB602级女ACAECC10ABCDEAA702级女ACBFCB0CBADEBD802级女ACACDBB5CBADEBD902级女ACACEA0BCADEBB1002级女BCBABCDEBA5CBADEDC1102级女DCECDEFBB10CABDECC1202级女ADBDEAA
2.5ACBDECA1302级女ACBACDEBA5BCDAEBC1402级女BBDCDEBA0BACDECC1502级女BDCCDECA5BCADEBB1602级女ACBCEAB15BCADEEC1702级女ACBDCA5BCADECB1802级女AABCDFCA5CBADECB1902级女ACBCDB20ACBDECA2002级女AECCDECB10CBADEAB2102级女AEAAEEA5CBADECA2202级女CCDCDECC15ABCDECB2302级女BABFCA10BCDAEAB2402级女CACDEAC30BADCECC2502级男EABADEBA3DBCAEEC2602级男CACCDEEB15BCADEEC2702级男CACACDEBA20BADCEEC2802级男AEEEAA5ABCDEBC2902级男AEEEAA5CBADEAC3002级男DADAEBB15BADCEEB3102级男DCDACDFCB8BCADEBD3202级男BCCCFCC10BCADECD3302级男BCCACECB20BADCECC3402级男CCECDEAB15BCDAECC3502级男EECBBA10BCADEAB3602级男EACADEBA0DBCAEDC3702级男CCDBCDECB15ABCDECA3802级男ECEFDE20ABDCEEC3902级男CCDACEAA1CBADEAC4002级男CACAEBB15BADCEEB4102级男CCDADEFBC30BCADEBB4202级男ACAFCC30BCADEBD4302级男BCCCEBA6BACDEDC4402级男CCDBCAB10ABCDEEB4502级男EABCDEEA5BADCECC4602级男CBCBBB4BADCECA4702级男DCBBDCB10DABCECB4801级女BCCCDFCB15BACDECD4901级女EABABCDEBB10BCADEEC5001级女CAACDEBA5CBADECC5101级女BAADECA3ABDCEBB5201级女BAAABCDEAA3ABDCEAD5301级女EACACDECA10CABDEDC5401级女BCCDEBA5CBADECC5501级女CAAACDEBA3CBADEAC5601级女DAAADEBA5CBADEBC5701级女DAAACDEBA5CBADECC5801级女CAAADECA5BCDAEDC5901级女CAABDEBB3CBADECB6001级女CAAFEA1CBADEEC6101级女DCDBCDEBA10BCDAEDC6201级女DACACEBA10BDACEDC6301级女CCDBADEDA8BDCAEBA6401级女DAAACDEBB15CBADEDC6501级女EABABCDEBB20CBADECD6601级女EAAABCDEBB20BCADEBC6701级女BAAACDBA20BCADEBC6801级女DAAACECA5DCBAECB6901级女DACADEBA5CBADEEC7001级女EAABAA10CBADEBB7101级女CAADEBA0BCADECC7201级男EABACDEBB15BADCECB7301级男AABBCB10BCADEBB7401级男AAAACECA5BCADEEC7501级男BEDCDD20BACDEBB7601级男AABEBA5BCDAEDC7701级男CAAABCDEBA1ABCDECC7801级男EAAABCEAA10BACDEEB7901级男AAAADEAA3BCADECC8001级男EAAAEBC20CBADECD8101级男EAAACEBB15BCDAEDC8201级男EAAACEBA2ABCDEDC8301级男EAAAEBA5CBADEDC8401级男ACAABB15CBDAEBB8501级男AABACDEDA10CBADEAC8601级男DAAACEDA5CBADECC8701级男EAEACDEBB15CBADEEC8801级男BAACEAA5CBADECC8901级男DAABCAA2BCADEDC9001级男BAABCEAB15BCDAEBB9101级男CAAABEBA10CBADECC9201级男EAAABCDEEB5CBADEEC9301级男EAAABDEEB10CABDEEC9401级男EAAACDEBB5CBADEDC9500级女AAAEDB10BADCECC9600级女DAAACDEBA10BCADECC9700级女EAAADEFAB10ABCDECC9800级女AEAADEDC30BADCECA9900级女EAAABCDEFBB10ABCDEDC10000级女CAAACDECB10CBADECC10100级女DAAABCDEDA10CBADEEB10200级女EEEADECB10BCADEEC10300级女DAADEBA2BCADEDC10400级女EAADEBA5ABCDEDC10500级女EAAABDEBA5CBADEAC10600级女EAEADEBB10ABDCECC10700级女EAAACDECA10CBADEDB10800级女BABACEAB10BCADECC10900级女EAAAAB15BACDEDD11000级女CEAAEBA6BDACEEC11100级女BEADEBA3BCADECC11200级女BAAADEDA10BCADEDC11300级女EAAACDEBA5ABCDEDB11400级女AAACDEAA10BACDEBB11500级女BCBCDECA2BACDEDB11600级女DAAABCDEBA3CABDEDC11700级女EAAACDEBA5BADCECB11800级女CAAABCDEEA0CBADEEC11900级女BCAADEBB15BCADECC12000级女DAAACDBB5BCADEDB12100级女BEBDEBA5BCADEDC12200级女BAAADECB10CBDAEBD12300级男EAAABEBA5BCADEEB12400级男EAAABCDEAA0BCADEBD12500级男EAAAECB5CBADECC12600级男BAAABCDEAA5BCADECD12700级男EAAAEBB10BACDECB12800级男EAAABEBA10BCADEEC12900级男EAAAEAB20CBADEDC13000级男CAAACDDB5BCADEDC13100级男EAAADEBB10BCADECB13200级男EAAADEAB10BCADECC13300级男AAAEDA5CBADEBB13400级男BAAACDEAB10BADCEDC13500级男EAAABEAB10BCADEDC13600级男BABECC30ACBDECB13700级男AAAACBA5CBADEBB13800级男EAAABCDEAA2CBADECD13900级男BAACDECA5CBADECC14000级男DAAACEBB10ABCDEDC14100级男EAAACEEB12ACBDECB14200级男EAAABCDEFBC10BACDEEC14300级男EABABCDEBA5BACDEEC14400级男EAAABCDEBA5ABDCEDB14500级男BAAABCDEAA10BACDECC14600级男BAACBB20BACDEBC14700级男CAACDEFAA20BACDEDC14800级男BAAAEAB10BCADECA14900级男EABADEAA5ABCDEDC15099级女ECDBCCB10CBADEDB15199级女EACABCAC10CBDAEEB15299级女EAAADEBB10CBADEDB15399级女CABADEAA5BCADEAC15499级女CAADEFCA5BCADEDC15599级女BABCCA5CABDEAB15699级女ADBECA2CBADEAD15799级女EAADEAA10BACDEDB15899级女EAEBCAC40BCADEEA15999级女AAADAA5CDBAEBB16099级女DCBDECB15BACDECB16199级女EEEDEBA5BCADEEC16299级女DDBCCA5CBADEAB16399级女CAADEAA5CBADEDB16499级女ADAADEFCA10CABDECC16599级女EDDADECB10BACDEDB16699级女EAADEBB10BACDEED16799级女DAAABA10CBADEEC16899级女CAAABB10CBDAEDB16999级女EAAADEDA5BACDEDC17099级女CAAADEBB10BCADEDC17199级女EAAACDEBB10BCADEDC17299级女EAAABB15BADCECC17399级女EABADEBB10CBADEBC17499级女CAAADECA10CBDAEDC17599级女BAAADEBA5CBADECC17699级女DAAADDB10ACBDECC17799级女EAAACDEDA0BADCEDC17899级男EABDEDA10BCADEDB17999级男EABDEAB20BACDEEC18099级男EABBDEFAB20BACDEDC18199级男AAAECA0BCDAEBB18299级男EABABEDC30ACBDEDC18399级男DACBDEBA5BACDEEC18499级男DABDEBC30ABDCECC18599级男EAAABCDEAB20BACDEEB18699级男DAACDBA5CBADECC18799级男BAABCA0CBADEAD18899级男EAAABDBB10CABDECB18999级男EACABDEBB10CBADEDC19099级男BAABCAA5CABDEBB19199级男EABBCEBB10BCADEDB19299级男DAAABCEBB15CBADECC19399级男EABABEBB10BCADECC19499级男EAAAEBA5CBDAEEC19599级男CACECA5ABCDEDC19699级男BAAEBB15BACDEDB19799级男DABAEBA5CBADEDC19899级男EAAABCAB10CABDECC19999级男EAACDBB10BCADECB20099级男EAABCEBB15ABCDECBSheet
29.5925合理收费算术平均
1918.
59.5925第1题回答类别人数(人)百分比向上累积向下累积3小时以下321616100322003--6小时
3517.
533.584671686--9小时
3316.
55066.51001339--12小时
2914.
564.55012910012小时以上
7135.
510035.520071合计200100——#VALUE!第2题上网途径人数(人)频率(%)宿舍14472A网吧21B信息楼
3517.5C图书馆
73.5D其它126E200第3题回答类别人数(人)百分比向上累积向下累积011457571001142005元以下
4120.
577.543155865--10元
2110.
58822.51764510--20元14795121902420元以上105100520010合计200100——第4题’02级’01级’00级’99级女生男生女生男生女生男生女生男生下载文件
20.
833333333339.
130434782654.
166666666773.
913043478367.
857142857174.
074074074157.
142857142939.1304347826打游戏
4.
166666666721.
739130434829.
166666666743.
478260869614.
285714285733.
333333333310.
714285714356.5217391304聊天
62.
547.
82608695655056.
521739130439.
285714285751.
85185185192534.7826086957收发邮件
58.
333333333343.
478260869670.
833333333334.
782608695778.
571428571448.
148148148167.
857142857139.1304347826浏览网页
54.
166666666765.
217391304370.
833333333382.
608695652285.
714285714381.
481481481564.
285714285769.5652173913其它
16.
666666666721.
73913043488.
333333333307.
14285714297.
40740740747.
14285714294.
34782608724232423282728230.
050.
090.
130.
170.
190.
20.
160.
091.
08540.
010.
050.
070.
10.
040.
090.
030.
130.
52260.
150.
110.
120.
130.
110.
140.
070.
080.
9145.
50.
140.
10.
170.
080.
220.
130.
190.
091.
12560.
130.
150.
170.
190.
240.
220.
180.
161.
44720.
040.
050.
0200.
020.
020.
020.
010.189人次百分比下载文件
10854.0%打游戏
5226.0%聊天
9145.5%收发邮件
11256.0%浏览网页
14472.0%其它
189.0%合计
525262.5%第5题收费方式人数(人)频率(%)按电脑包月
442222.0%按端口包月
8743.
543.5%按实际上网时间
4321.
521.5%按流量
178.
58.5%其它
94.
54.5%200第6题回答类别人数(人)百分比向上累积向下累积10元以下
10351.5%
51.5%
100.0%10320010--20元
8040.0%
91.5%
48.5%1839720--50元
157.5%
99.0%
8.5%1981750--100元
10.5%
99.5%
1.0%1992100元以上
10.5%
100.0%
0.5%2001合计
200100.0%——第7题’02级’01级’00级’99级女生
9.
60416666678.
16666666678.
42857142869.178571428624242828男生
11.
82608695659.
04347826099.
407407407411.521739130423232723方差分析无重复双因素分析男女有差异SUMMARY计数求和平均方差年级无差异行
1435.
37797619058.
84449404760.4403839227行
2441.
798711755210.
44967793882.0358474592列
1221.
430253623210.
71512681162.4684648872列
2217.
21014492758.
60507246380.3843992859列
3217.
8359788368.
9179894180.4790599367列
4220.
70031055910.
35015527952.7452174395方差分析差异源SSdfMSFP-valueFcrit行
5.
153230649115.
153230649116.
73288186370.
026409769510.1279624687列
6.
504783245232.
16826108177.
04048760890.
071617299.2766185844误差
0.
923910900330.3079703001总计
12.58192479467收费人数(人)频率向上累积
0105.0%
5.0%
131.5%
6.5%
263.0%
9.5%
2.
510.5%
10.0%
384.0%
14.0%
410.5%
14.5%
55527.5%
42.0%
621.0%
43.0%
831.5%
44.5%
106432.0%
76.5%
1210.5%
77.0%
152211.0%
88.0%
20157.5%
95.5%
3084.0%
99.5%
4010.5%
100.0%合计200100%—Sheet3Q8Q8CBADEBCBACDEAB人数频率ABCDEBA稳定
3115.5%DABCEAD速度
9547.5%BACDEAB价格
6934.5%ABCDEBA维护
52.5%CBADEBC其它
00.0%CBADEBC合计
200100.0%BCADECB
5125.5%CBADEBC
8341.5%CABDEAC
6231.0%ACBDECA
42.0%BCDAECB
00.0%BACDEAB
200100.0%BCADECBBCADECB首选频率1次选频率2前两位合计频率合计BCADECB稳定
3115.5%
5125.5%
8241.0%CBADEBC速度
9547.5%
8341.5%
17889.0%ACBDECA价格
6934.5%
6231.0%
13165.5%CBADEBC维护
52.5%
42.0%
94.5%CBADEBC其它
00.0%
00.0%
00.0%ABCDEBA合计
200100.0%
200100.0%
400200.0%BCDAECBBADCEABDBCAEBDBCADECBBADCEABABCDEBACBADEBCBADCEABBCADECBBCADECBBADCEABBCDAECBBCADECBDBCAEBDABCDEBAABDCEBACBADEBCBADCEABBCADECBBCADECBBACDEABABCDEBABADCEABBADCEABDABCEADBACDEABBCADECBCBADEBCABDCEBAABDCEBACABDEACCBADEBCCBADEBCCBADEBCCBADEBCBCDAECBCBADEBCCBADEBCBCDAECB第9题BDACEDBBDCAEDBCECCCEDDCBADEBCBEEBCBEECBADEBCCECECCDDBCADECBCBBBCCABBCADECBCAADDCDDDCBAECDAEDCCEAECBADEBCBBCEEDACCBADEBCBCACEDDEBCADECBBCBCDCECBADCEABDCCDDCBABCADECBCADDABCCBCADECBCDCDCDEDBACDEABBCEBDDABBCDAECBCEDACCDDABCDEBABADCDBCCBACDEABEEBEECDCBCADECBCBDCCCEECBADEBCCBCDDDEDBCDAECBCDBBDCDDABCDEBAAEBCBEDDCBADEBCCCCEDEDCCBDAEBCCCEEDDDCCBADEBCACBDCCCCCBADEBCCCEBBCBADEBCCDDCBADEBCDCCBCADECBDDCBCDAECBBDCBADEBC’02级’01级’00级’99级影响程度人数(人)频率向上累积向下累积CBADEBC人数比例人数比例人数比例人数比例没有影响
157.5%
7.5%
100.0%CABDEAC没有影响
612.8%
36.4%
11.8%
59.8%有较小影响
3015.0%
22.5%
92.5%CBADEBC有较小影响
1021.3%
1021.3%
610.9%
47.8%有一定影响
6934.5%
57.0%
77.5%BADCEAB有一定影响
2042.6%
1531.9%
2138.2%
1325.5%有较大影响
5326.5%
83.5%
43.0%BCADECB有较大影响
36.4%
1123.4%
1934.5%
2039.2%影响非常大
3316.5%
100.0%
16.5%ABCDEBA影响非常大
817.0%
817.0%
814.5%
917.6%合计
200100.0%——BADCEAB合计
47100.0%
47100.0%
55100.0%
51100.0%ABCDEBACBADEBCCBADEBBBCADECBBCADECBABCDEBACBADEBCABDCEBACBADEBCBCADECBBACDEABBDACEDBBCADECBBCADECBABCDEBABACDEABBACDEAACABDEACBADCEABCBADEBCBCADECBBCADECBBCADECB第10题CBDAEBC回答类别人数(人)频率BCADECB被迫接受
105.0%BCADECB选择其他方式
6331.5%CBADEBC抗议
11055.0%BCADECB其它
178.5%BACDEAB合计
200100.0%BCADECBCBADEBCBCADECBBCADECBBCADECBCBADEBCBADCEABBCADECBACBDECACBADEBCCBADEBCCBADEBCABCDEBAACBDECABACDEABBACDEABABDCEBABACDEABBACDEABBACDEABBCADECBABCDEBACBADEBCCBDAEBCCBADEBCBCADECBBCADECBCABDEACCBADEBCBACDEABBCADECBCDBAEDCBACDEABBCADECCCBADEBCCBADEBCCABDEACBACDEABBACDEAACBADEBCCBDAEBBBACDEAABCADECBBCADECCBADCEABCBADEBCCBDAEBCCBADEBCACBDECABADCEABBCADECBBACDEABBACDEABBCDAECBACBDECABACDEABABDCEBABACDEABCBADEBCCBADEBCCABDEACCBADEBCCABDEACBCADECBCBADEBCBCADECBCBDAEBCABCDEBABACDEABCBADEBCCABDEACBCADECBABCDEBA图-12因不满意收费方案而采取的方式棱锥图
四、决策建议通过以上的数据展示及分析,我们向有关方面提出如下建议1.根据对其他情况分析中不能满意实际收费方案的被调查者反应的分析,即如果收费方案不能令人满意,将只有5%的被调查者愿意被迫接受,我们建议有关方面充分考虑本科生的实际情况,否则有可能遭到95%的本科生的抵制2.根据对上网收费方案分析中上网方式的分析,我们建议将“按电脑包月”、“按端口包月”、“按实际上网时间”三种收费方式结合,制定一项符合本科生要求的方案(如在一定使用时间限度内按照包月的方式、超过这一限度则按照实际使用时间收费)3.根据对上网收费方案分析中合理收费的分析,我们认为合理的收费应在
8.6—
10.6元/月这一区间内;另据最高收费分析,实际费用可做适当上浮,但不应超过20元/月4.根据对其他情况分析中被调查者关心指标的分析,我们建议有关方面在制定合理方案和价格的同时,能注重作为商品的网络的性能价格比,使广大在校生能使用上价格公道、性能良好的网络资源
五、问题暨总结在本次调查以及报告完成的过程中,我们的工作出现了一些问题1.问卷的设计存在一些问题,如未注明“未注明多选的为单选”,使得一些被调查者在回答单选题时选择了不止一个答案,进而导致问卷有效率的下降;而一些问题的设计也没能充分反映出被调查者的基本情况,导致分析时得不出较为明确的结论2.问卷回收时出现了问卷丢失的现象,既说明调查的经验不足,又暴露了调查员工作的不严谨,问卷回收率不高3.数据分析时不能流畅、贴切的使用各种分析方法以及数据展示的方法,反映出对统计学基本原理和方法的了解还有待提高4.还有一些问题因调查员的水平所限未能在此说明,也需要指正
六、附录附-1调查问卷关于中国人民大学本科生上网收费问题的调查年级__性别__(此项由调查员负责填写)此次调查旨在了解我校本科生对上网收费问题的看法,请您根据本学期以来的情况回答
1.您平均每周上网时间为A.3小时以下B.3~6小时C.6~9小时D.9~12小时E.12小时以上
2.您最主要的上网途径是__A.宿舍B.网吧C.信息楼D.图书馆E.其他___(请注明)
3.您平均每周上网支出为__A.0B.5元以下C.5~10元D.10~20元E.20元以上
4.您上网的主要目的是____(可多选)A.下载各类文件(如电影、音乐)B.打游戏C.聊天D.收发邮件E.浏览网页F.其他___(请注明)
5.如果实行网络收费,您最希望以何种方式进行__A.按电脑包月 B.按端口包月C.按实际上网时间D.按流量(进出信息总量)E.其他___(请注明)
6.您能接受的每月最高收费为__A.10元以下B.10~20元C.20~50元D.50~100元E.100元以上
7.您认为合理的收费为__元/月
8.请对您最关心的校园网指标进行排序(由高到低)____A.稳定B.速度C.价格D.维护E.其他___(请注明)
9.如果不能上网,将对您的生活产生何种程度的影响__A.没有影响B.有较小影响C.有一定影响D.有较大影响E.影响非常大
10.如果实际收费方案不能令您满意,您将__A.被迫接受B.选择其他方式上网C.采取行动以示抗议D.其他___(请注明)谢谢您的合作!附-2原始数据编号年级性别Q1Q2Q3Q4Q5Q6Q7Q8Q9Q10102级女ACBCEAB10CBADECB202级女ADBADECC30BACDEBB302级女BCBACDAB10ABCDECB402级女CCDCECA8DABCECB502级女DAAACDAB15BACDECB602级女ACAECC10ABCDEAA702级女ACBFCB0CBADEBD802级女ACACDBB5CBADEBD902级女ACACEA0BCADEBB1002级女BCBABCDEBA5CBADEDC1102级女DCECDEFBB10CABDECC1202级女ADBDEAA
2.5ACBDECA1302级女ACBACDEBA5BCDAEBC1402级女BBDCDEBA0BACDECC1502级女BDCCDECA5BCADEBB1602级女ACBCEAB15BCADEEC1702级女ACBDCA5BCADECB1802级女AABCDFCA5CBADECB1902级女ACBCDB20ACBDECA2002级女AECCDECB10CBADEAB2102级女AEAAEEA5CBADECA2202级女CCDCDECC15ABCDECB2302级女BABFCA10BCDAEAB2402级女CACDEAC30BADCECC2502级男EABADEBA3DBCAEEC2602级男CACCDEEB15BCADEEC2702级男CACACDEBA20BADCEEC2802级男AEEEAA5ABCDEBC2902级男AEEEAA5CBADEAC3002级男DADAEBB15BADCEEB3102级男DCDACDFCB8BCADEBD3202级男BCCCFCC10BCADECD3302级男BCCACECB20BADCECC3402级男CCECDEAB15BCDAECC3502级男EECBBA10BCADEAB3602级男EACADEBA0DBCAEDC3702级男CCDBCDECB15ABCDECA3802级男ECEFDE20ABDCEEC3902级男CCDACEAA1CBADEAC续表4002级男CACAEBB15BADCEEB4102级男CCDADEFBC30BCADEBB4202级男ACAFCC30BCADEBD4302级男BCCCEBA6BACDEDC4402级男CCDBCAB10ABCDEEB4502级男EABCDEEA5BADCECC4602级男CBCBBB4BADCECA4702级男DCBBDCB10DABCECB4801级女BCCCDFCB15BACDECD4901级女EABABCDEBB10BCADEEC5001级女CAACDEBA5CBADECC5101级女BAADECA3ABDCEBB5201级女BAAABCDEAA3ABDCEAD5301级女EACACDECA10CABDEDC5401级女BCCDEBA5CBADECC5501级女CAAACDEBA3CBADEAC5601级女DAAADEBA5CBADEBC5701级女DAAACDEBA5CBADECC5801级女CAAADECA5BCDAEDC5901级女CAABDEBB3CBADECB6001级女CAAFEA1CBADEEC6101级女DCDBCDEBA10BCDAEDC6201级女DACACEBA10BDACEDC6301级女CCDBADEDA8BDCAEBA6401级女DAAACDEBB15CBADEDC6501级女EABABCDEBB20CBADECD6601级女EAAABCDEBB20BCADEBC6701级女BAAACDBA20BCADEBC6801级女DAAACECA5DCBAECB6901级女DACADEBA5CBADEEC7001级女EAABAA10CBADEBB7101级女CAADEBA0BCADECC7201级男EABACDEBB15BADCECB7301级男AABBCB10BCADEBB7401级男AAAACECA5BCADEEC7501级男BEDCDD20BACDEBB7601级男AABEBA5BCDAEDC7701级男CAAABCDEBA1ABCDECC7801级男EAAABCEAA10BACDEEB7901级男AAAADEAA3BCADECC续表8001级男EAAAEBC20CBADECD8101级男EAAACEBB15BCDAEDC8201级男EAAACEBA2ABCDEDC8301级男EAAAEBA5CBADEDC8401级男ACAABB15CBDAEBB8501级男AABACDEDA10CBADEAC8601级男DAAACEDA5CBADECC8701级男EAEACDEBB15CBADEEC8801级男BAACEAA5CBADECC8901级男DAABCAA2BCADEDC9001级男BAABCEAB15BCDAEBB9101级男CAAABEBA10CBADECC9201级男EAAABCDEEB5CBADEEC9301级男EAAABDEEB10CABDEEC9401级男EAAACDEBB5CBADEDC9500级女AAAEDB10BADCECC9600级女DAAACDEBA10BCADECC9700级女EAAADEFAB10ABCDECC9800级女AEAADEDC30BADCECA9900级女EAAABCDEFBB10ABCDEDC10000级女CAAACDECB10CBADECC10100级女DAAABCDEDA10CBADEEB10200级女EEEADECB10BCADEEC10300级女DAADEBA2BCADEDC10400级女EAADEBA5ABCDEDC10500级女EAAABDEBA5CBADEAC10600级女EAEADEBB10ABDCECC10700级女EAAACDECA10CBADEDB10800级女BABACEAB10BCADECC10900级女EAAAAB15BACDEDD11000级女CEAAEBA6BDACEEC11100级女BEADEBA3BCADECC11200级女BAAADEDA10BCADEDC11300级女EAAACDEBA5ABCDEDB11400级女AAACDEAA10BACDEBB11500级女BCBCDECA2BACDEDB11600级女DAAABCDEBA3CABDEDC11700级女EAAACDEBA5BADCECB11800级女CAAABCDEEA0CBADEEC11900级女BCAADEBB15BCADECC续表12000级女DAAACDBB5BCADEDB12100级女BEBDEBA5BCADEDC12200级女BAAADECB10CBDAEBD12300级男EAAABEBA5BCADEEB12400级男EAAABCDEAA0BCADEBD12500级男EAAAECB5CBADECC12600级男BAAABCDEAA5BCADECD12700级男EAAAEBB10BACDECB12800级男EAAABEBA10BCADEEC12900级男EAAAEAB20CBADEDC13000级男CAAACDDB5BCADEDC13100级男EAAADEBB10BCADECB13200级男EAAADEAB10BCADECC13300级男AAAEDA5CBADEBB13400级男BAAACDEAB10BADCEDC13500级男EAAABEAB10BCADEDC13600级男BABECC30ACBDECB13700级男AAAACBA5CBADEBB13800级男EAAABCDEAA2CBADECD13900级男BAACDECA5CBADECC14000级男DAAACEBB10ABCDEDC14100级男EAAACEEB12ACBDECB14200级男EAAABCDEFBC10BACDEEC14300级男EABABCDEBA5BACDEEC14400级男EAAABCDEBA5ABDCEDB14500级男BAAABCDEAA10BACDECC14600级男BAACBB20BACDEBC14700级男CAACDEFAA20BACDEDC14800级男BAAAEAB10BCADECA14900级男EABADEAA5ABCDEDC15099级女ECDBCCB10CBADEDB15199级女EACABCAC10CBDAEEB15299级女EAAADEBB10CBADEDB15399级女CABADEAA5BCADEAC15499级女CAADEFCA5BCADEDC15599级女BABCCA5CABDEAB15699级女ADBECA2CBADEAD15799级女EAADEAA10BACDEDB15899级女EAEBCAC40BCADEEA15999级女AAADAA5CDBAEBB16099级女DCBDECB15BACDECB续表16199级女EEEDEBA5BCADEEC16299级女DDBCCA5CBADEAB16399级女CAADEAA5CBADEDB16499级女ADAADEFCA10CABDECC16599级女EDDADECB10BACDEDB16699级女EAADEBB10BACDEED16799级女DAAABA10CBADEEC16899级女CAAABB10CBDAEDB16999级女EAAADEDA5BACDEDC17099级女CAAADEBB10BCADEDC17199级女EAAACDEBB10BCADEDC17299级女EAAABB15BADCECC17399级女EABADEBB10CBADEBC17499级女CAAADECA10CBDAEDC17599级女BAAADEBA5CBADECC17699级女DAAADDB10ACBDECC17799级女EAAACDEDA0BADCEDC17899级男EABDEDA10BCADEDB17999级男EABDEAB20BACDEEC18099级男EABBDEFAB20BACDEDC18199级男AAAECA0BCDAEBB18299级男EABABEDC30ACBDEDC18399级男DACBDEBA5BACDEEC18499级男DABDEBC30ABDCECC18599级男EAAABCDEAB20BACDEEB18699级男DAACDBA5CBADECC18799级男BAABCA0CBADEAD18899级男EAAABDBB10CABDECB18999级男EACABDEBB10CBADEDC19099级男BAABCAA5CABDEBB19199级男EABBCEBB10BCADEDB19299级男DAAABCEBB15CBADECC19399级男EABABEBB10BCADECC19499级男EAAAEBA5CBDAEEC19599级男CACECA5ABCDEDC19699级男BAAEBB15BACDEDB19799级男DABAEBA5CBADEDC19899级男EAAABCAB10CABDECC19999级男EAACDBB10BCADECB20099级男EAABCEBB15ABCDECBPAGE20。