{"id":1814,"date":"2024-02-15T21:22:39","date_gmt":"2024-02-15T21:22:39","guid":{"rendered":"https:\/\/summersnow.eu.org\/?p=1814"},"modified":"2024-02-15T21:22:39","modified_gmt":"2024-02-15T21:22:39","slug":"induction-of-questionnaire-design-and-spss-statistical-analysis-in-graduation-design-project","status":"publish","type":"post","link":"https:\/\/summersnow.eu.org\/?p=1814","title":{"rendered":"Induction of Questionnaire Design and SPSS Statistical Analysis in Graduation Design Project"},"content":{"rendered":"\n<p>Graduation design projects every year are inseparable from user research methods, especially the use of market survey method based on questionnaire. Questionnaire surveys are mainly used to measure behavioral data and user attitude data that cannot be obtained from background big data, as well as based on user groups to validate and evaluate issue prioritization.<\/p>\n\n\n\n<p>The basic design method of the questionnaire can be summarized as one formula + two question types + three avoidances + four theories. &#8220;One formula&#8221; is to lock in the questionnaire outline (first purpose of questionnaire = dimension A + dimension B + dimension C). &#8220;Two question types&#8221; are yes-no questions and closed-questions. For yes-no questions, avoid using the word &#8220;no&#8221; and balance positivity and negativity. Closed-questions must follow exhaustiveness and mutual exclusivity, and retain exit items. Avoid extreme options, pay attention to the order of options, and put those that meet social expectations last. &#8220;Three avoidances&#8221; are to avoid tendentious descriptions, avoid vague wording, and avoid double questions. &#8220;Four theories&#8221; are that high-frequency behaviors use frequency questions, and low-frequency behaviors use possibility questions; high-frequency behaviors have a small time span, and low-frequency behaviors have a large time span; when the number of a certain behavior exceeds 5 times, it is an estimate instead of counting for the user; when asking about the frequency or number of times, use less fill-in-the-blanks and more distributed options commonly.<\/p>\n\n\n\n<p>The questionnaire outline of &#8220;First purpose of questionnaire = dimension A + dimension B + dimension C&#8221; is actually just a main structure of the questionnaire, which dismantles the problem in a multi-dimensional manner. A key point in questionnaire design is to break down the specific questions and options from dimensions based on the questionnaire outline. Each question needs to be written with a purpose and analysis method to ensure the rationality of the questionnaire design.<\/p>\n\n\n\n<p>After the first draft of the questionnaire is completed, it needs to be pre-tested, usually with a sample of 20-100 people. Using these sample data also requires testing the reliability and validity of the questionnaire. Specific testing methods can be obtained through literature search. For example, you can refer to the article &#8220;<a href=\"https:\/\/zhuanlan.zhihu.com\/p\/350171180\" target=\"_blank\" rel=\"noreferrer noopener\">\u8c03\u67e5\u95ee\u5377\u7684\u4fe1\u5ea6\u5206\u6790\u548c\u6548\u5ea6\u5206\u6790<\/a>&#8220;.<\/p>\n\n\n\n<p>Several points need to be emphasized here. The split-half reliability method is not suitable for measuring factual questionnaires. It is often used for reliability analysis of attitude and opinion questionnaires, such as Likert scale questions. Alpha reliability coefficient method is mainly used to evaluate the consistency of continuous variables and ordinal variables, such as Likert scale questions. The retest reliability method tests the same group of subjects twice, and then calculates the correlation coefficient of the scores obtained from the two tests, such as categorical variable questions. General fact-finding questions and dimensionless single questions are not subject to reliability analysis. The statistical analysis of content validity mainly uses the single item and sum correlation analysis method to obtain the evaluation results, that is, calculate the correlation coefficient between each item score and the total item score, and judge whether it is valid based on whether the correlation is significant; if there are negative questions in the scale, items should be reversely processed before calculating the total score. Structural validity is the most commonly used validity index, and the method used to analyze structural validity is factor analysis.<\/p>\n\n\n\n<p>The SPSS statistical analysis process of questionnaire results includes four steps: defining variables, data entry, statistical analysis and result saving. There are as many variables as there are questions in a questionnaire, and the answer to each question is the value of the variable. Variables in multiple-choice questions are often defined using multiple dichotomies. The basic idea is to set each option of the question into a variable, and then split each option into two options, that is, check the item and not check the item. When entering data, one row represents one questionnaire, so if there are several questionnaires, there will be several rows of data. There are two types of statistical analysis: graphing analysis and numerical analysis. In SPSS, except for the survival curve graph used in survival analysis, which is integrated into the Analyze menu, other statistical drawing functions are placed in the Graph menu, and the numerical statistical analysis process is done all in the Analyze menu.<\/p>\n\n\n\n<p><strong>\u53c2\u8003\u8bd1\u6587<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>\u6bd5\u4e1a\u8bbe\u8ba1\u8bfe\u9898\u4e2d\u7684\u95ee\u5377\u8bbe\u8ba1\u4e0e<\/strong><strong>SPSS<\/strong><strong>\u7edf\u8ba1\u5206\u6790\u5f52\u7eb3<\/strong><strong><\/strong><\/p>\n\n\n\n<p><strong>\u5173\u952e\u8bcd<\/strong>\uff1a\u6bd5\u4e1a\u8bbe\u8ba1\uff0c\u95ee\u5377\uff0cSPSS<\/p>\n\n\n\n<p>\u6bcf\u5e74\u7684\u6bd5\u4e1a\u8bbe\u8ba1\u8bfe\u9898\u90fd\u79bb\u4e0d\u5f00\u7528\u6237\u7814\u7a76\u65b9\u6cd5\uff0c\u5c24\u5176\u662f\u4ee5\u95ee\u5377\u4e3a\u4e3b\u7684\u5e02\u573a\u8c03\u67e5\u65b9\u6cd5\u7684\u8fd0\u7528\uff0c\u95ee\u5377\u8c03\u67e5\u4e3b\u8981\u662f\u7528\u4e8e\u6d4b\u91cf\u540e\u53f0\u5927\u6570\u636e\u83b7\u53d6\u4e0d\u5230\u7684\u884c\u4e3a\u6570\u636e\u548c\u7528\u6237\u6001\u5ea6\u6570\u636e\uff0c\u4ee5\u53ca\u6839\u636e\u7528\u6237\u5206\u7fa4\u6765\u9a8c\u8bc1\u548c\u8bc4\u4f30\u95ee\u9898\u7684\u4f18\u5148\u7ea7\u3002<\/p>\n\n\n\n<p>\u95ee\u5377\u57fa\u7840\u8bbe\u8ba1\u65b9\u6cd5\u53ef\u4ee5\u6982\u51b5\u4e3a\u4e00\u4e2a\u516c\u5f0f+\u4e24\u79cd\u9898\u578b+\u4e09\u4e2a\u907f\u514d+\u56db\u4e2a\u7406\u8bba\u3002\u201c\u4e00\u4e2a\u516c\u5f0f\u201d\u4e3a\u9501\u5b9a\u95ee\u5377\u5927\u7eb2\uff08\u95ee\u5377\u7b2c\u4e00\u76ee\u7684=\u7ef4\u5ea6A+\u7ef4\u5ea6B+\u7ef4\u5ea6C\uff09\u3002\u201c\u4e24\u79cd\u9898\u578b\u201d\u4e3a\u662f\u5426\u9898\u578b\u548c\u5c01\u95ed\u5f0f\u9898\u578b\uff0c\u662f\u5426\u9898\u578b\u907f\u514d\u4f7f\u7528\u201c\u4e0d\u201d\u5b57\uff0c\u5e73\u8861\u80af\u5b9a\u6027\u548c\u5426\u5b9a\u6027\uff1b\u5c01\u95ed\u5f0f\u9898\u578b\u9700\u9075\u5faa\u7a77\u5c3d\u6027\u3001\u4e92\u65a5\u6027\uff0c\u4fdd\u7559\u9000\u51fa\u9879\uff0c\u907f\u514d\u9009\u9879\u6781\u7aef\u5316\uff0c\u6ce8\u610f\u9009\u9879\u6392\u5e8f\uff0c\u7b26\u5408\u793e\u4f1a\u671f\u8bb8\u7684\u653e\u5728\u6700\u540e\u3002\u201c\u4e09\u4e2a\u907f\u514d\u201d\u4e3a\u907f\u514d\u503e\u5411\u6027\u63cf\u8ff0\u3001\u907f\u514d\u63aa\u8f9e\u6a21\u7cca\u3001\u907f\u514d\u53cc\u91cd\u95ee\u9898\u3002\u201c\u56db\u4e2a\u7406\u8bba\u201d\u4e3a\u9ad8\u9891\u884c\u4e3a\u7528\u9891\u6b21\u63d0\u95ee\u3001\u4f4e\u9891\u884c\u4e3a\u7528\u53ef\u80fd\u6027\u63d0\u95ee\uff1b\u9ad8\u9891\u884c\u4e3a\u65f6\u95f4\u8de8\u5ea6\u5c0f\u3001\u4f4e\u9891\u884c\u4e3a\u65f6\u95f4\u8de8\u5ea6\u5927\uff1b\u5f53\u67d0\u4e2a\u884c\u4e3a\u6b21\u6570\u8d85\u8fc75\u6b21\u4ee5\u4e0a\uff0c\u7528\u6237\u4e0d\u4f1a\u8fdb\u884c\u8ba1\u6570\uff0c\u800c\u662f\u4f30\u7b97\uff1b\u63d0\u95ee\u9891\u6b21\u6216\u6b21\u6570\u65f6\uff0c\u5c11\u7528\u586b\u7a7a\u5f0f\uff0c\u5e38\u7528\u5206\u5e03\u5f0f\u9009\u9879\u3002<\/p>\n\n\n\n<p>\u201c\u95ee\u5377\u7b2c\u4e00\u76ee\u7684=\u7ef4\u5ea6A+\u7ef4\u5ea6B+\u7ef4\u5ea6C\u201d\u7684\u95ee\u5377\u5927\u7eb2\u5b9e\u9645\u53ea\u662f\u4e00\u79cd\u95ee\u5377\u4e3b\u4f53\u7ed3\u6784\uff0c\u662f\u4ee5\u591a\u7ef4\u5ea6\u65b9\u5f0f\u5bf9\u95ee\u9898\u8fdb\u884c\u62c6\u89e3\u3002\u95ee\u5377\u8bbe\u8ba1\u7684\u4e00\u4e2a\u5173\u952e\u70b9\u5c31\u662f\u4f9d\u636e\u95ee\u5377\u5927\u7eb2\uff0c\u4ece\u7ef4\u5ea6\u62c6\u5206\u51fa\u5177\u4f53\u95ee\u9898\u548c\u9009\u9879\u540e\uff0c\u6bcf\u4e2a\u95ee\u9898\u90fd\u9700\u8981\u5199\u4e0a\u76ee\u7684\u548c\u5206\u6790\u65b9\u6cd5\uff0c\u786e\u4fdd\u95ee\u5377\u8bbe\u8ba1\u7684\u5408\u7406\u6027\u3002<\/p>\n\n\n\n<p>\u95ee\u5377\u521d\u7a3f\u5b8c\u6210\u540e\u9700\u8981\u8fdb\u884c\u9884\u5148\u6d4b\u8bd5\uff0c\u901a\u5e38\u9009\u62e920-100\u4eba\u7684\u6837\u672c\u3002\u5229\u7528\u8fd9\u4e9b\u6837\u672c\u6570\u636e\u8fd8\u9700\u8981\u5bf9\u95ee\u5377\u7684\u4fe1\u5ea6\u548c\u6548\u5ea6\u8fdb\u884c\u68c0\u9a8c\uff0c\u5173\u4e8e\u5177\u4f53\u7684\u68c0\u9a8c\u65b9\u6cd5\u53ef\u4ee5\u901a\u8fc7\u6587\u732e\u68c0\u7d22\u83b7\u53d6\uff0c\u5982\u4e0b\u6587\u53ef\u4ee5\u53c2\u8003\u201c<a href=\"https:\/\/zhuanlan.zhihu.com\/p\/350171180\" target=\"_blank\" rel=\"noreferrer noopener\">\u8c03\u67e5\u95ee\u5377\u7684\u4fe1\u5ea6\u5206\u6790\u548c\u6548\u5ea6\u5206\u6790<\/a>\u201d\u3002<\/p>\n\n\n\n<p>\u8fd9\u91cc\u9700\u8981\u5f3a\u8c03\u51e0\u70b9\uff0c\u5206\u534a\u4fe1\u5ea6\u6cd5\u4e0d\u9002\u5408\u6d4b\u91cf\u4e8b\u5b9e\u6027\u95ee\u5377\uff0c\u5e38\u7528\u4e8e\u6001\u5ea6\u3001\u610f\u89c1\u5f0f\u95ee\u5377\u7684\u4fe1\u5ea6\u5206\u6790\uff0c\u5982\u91cc\u514b\u7279\u91cf\u8868\u9898\u578b\u3002Alpha\u4fe1\u5ea6\u7cfb\u6570\u6cd5\u4e3b\u8981\u7528\u4e8e\u8bc4\u4ef7\u8fde\u7eed\u53d8\u91cf\u548c\u987a\u5e8f\u53d8\u91cf\u7684\u4e00\u81f4\u6027\uff0c\u5982\u91cc\u514b\u7279\u91cf\u8868\u9898\u578b\u3002\u91cd\u6d4b\u4fe1\u5ea6\u6cd5\u5bf9\u540c\u4e00\u7ec4\u88ab\u8bd5\u8005\u5148\u540e\u4e24\u6b21\u8fdb\u884c\u6d4b\u67e5\uff0c\u7136\u540e\u8ba1\u7b97\u4e24\u6b21\u6d4b\u67e5\u6240\u5f97\u5206\u6570\u7684\u76f8\u5173\u7cfb\u6570\uff0c\u5982\u5206\u7c7b\u53d8\u91cf\u9898\u578b\u3002\u4e00\u822c\u4e8b\u5b9e\u6027\u8c03\u67e5\u9898\u578b\u548c\u65e0\u7ef4\u5ea6\u7684\u5355\u4e2a\u9898\u76ee\u4e0d\u505a\u4fe1\u5ea6\u5206\u6790\u3002\u5185\u5bb9\u6548\u5ea6\u7684\u7edf\u8ba1\u5206\u6790\u4e3b\u8981\u91c7\u7528\u5355\u9879\u4e0e\u603b\u548c\u76f8\u5173\u5206\u6790\u6cd5\u83b7\u5f97\u8bc4\u4ef7\u7ed3\u679c\uff0c\u5373\u8ba1\u7b97\u6bcf\u4e2a\u9898\u9879\u5f97\u5206\u4e0e\u9898\u9879\u603b\u5206\u7684\u76f8\u5173\u7cfb\u6570\uff0c\u6839\u636e\u76f8\u5173\u662f\u5426\u663e\u8457\u5224\u65ad\u662f\u5426\u6709\u6548\uff1b\u82e5\u91cf\u8868\u4e2d\u6709\u53cd\u610f\u9898\u9879\uff0c\u5e94\u5c06\u5176\u9006\u5411\u5904\u7406\u540e\u518d\u8ba1\u7b97\u603b\u5206\u3002\u7ed3\u6784\u6548\u5ea6\u662f\u6700\u5e38\u4f7f\u7528\u7684\u6548\u5ea6\u6307\u6807\uff0c\u7ed3\u6784\u6548\u5ea6\u5206\u6790\u6240\u91c7\u7528\u7684\u65b9\u6cd5\u662f\u56e0\u5b50\u5206\u6790\u3002 \u95ee\u5377\u7ed3\u679c\u7684SPSS\u7edf\u8ba1\u5206\u6790\u8fc7\u7a0b\u5305\u542b\u5b9a\u4e49\u53d8\u91cf\u3001\u6570\u636e\u5f55\u5165\u3001\u7edf\u8ba1\u5206\u6790\u548c\u7ed3\u679c\u4fdd\u5b58\u56db\u4e2a\u6b65\u9aa4\u3002\u4e00\u4efd\u95ee\u5377\u6709\u591a\u5c11\u4e2a\u95ee\u9898\u5c31\u8981\u6709\u591a\u5c11\u4e2a\u53d8\u91cf\u4e0e\u4e4b\u5bf9\u5e94\uff0c\u6bcf\u4e00\u4e2a\u95ee\u9898\u7684\u7b54\u6848\u5373\u4e3a\u53d8\u91cf\u7684\u53d6\u503c\u3002\u591a\u9009\u9898\u7684\u53d8\u91cf\u5e38\u5e38\u91c7\u7528\u591a\u91cd\u4e8c\u5206\u6cd5\u5b9a\u4e49\uff0c\u5176\u57fa\u672c\u601d\u60f3\u662f\u628a\u8be5\u9898\u6bcf\u4e00\u4e2a\u9009\u9879\u8bbe\u7f6e\u6210\u4e00\u4e2a\u53d8\u91cf\uff0c\u7136\u540e\u5c06\u6bcf\u4e00\u4e2a\u9009\u9879\u62c6\u5206\u4e3a\u4e24\u4e2a\u9009\u9879\u9879\uff0c\u5373\u9009\u4e2d\u8be5\u9879\u548c\u4e0d\u9009\u4e2d\u8be5\u9879\u3002\u6570\u636e\u5f55\u5165\u65f6\uff0c\u4e00\u884c\u4ee3\u8868\u4e00\u4efd\u95ee\u5377\uff0c\u6240\u4ee5\u6709\u51e0\u4efd\u95ee\u5377\uff0c\u5c31\u8981\u6709\u51e0\u884c\u7684\u6570\u636e\u3002\u7edf\u8ba1\u5206\u6790\u6709\u4f5c\u56fe\u5206\u6790\u548c\u6570\u503c\u5206\u6790\u4e24\u7c7b\uff0c\u5728SPSS\u4e2d\uff0c\u9664\u4e86\u751f\u5b58\u5206\u6790\u6240\u7528\u7684\u751f\u5b58\u66f2\u7ebf\u56fe\u88ab\u6574\u5408\u5230Analyze\u83dc\u5355\u4e2d\u5916\uff0c\u5176\u4ed6\u7684\u7edf\u8ba1\u7ed8\u56fe\u529f\u80fd\u5747\u653e\u7f6e\u5728Graph\u83dc\u5355\u4e2d\uff0c\u6570\u503c\u7edf\u8ba1\u5206\u6790\u8fc7\u7a0b\u5747\u5728Analyze\u83dc\u5355\u4e2d\u5b8c\u6210\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Graduation design projects every year are inseparable f &#8230;.&nbsp;&nbsp;<a class=\" special\" href=\"https:\/\/summersnow.eu.org\/?p=1814\">Read More<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[45,131,132],"class_list":["post-1814","post","type-post","status-publish","format-standard","hentry","category-9","tag-graduation-design","tag-questionnaire","tag-spss"],"views":427,"_links":{"self":[{"href":"https:\/\/summersnow.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/summersnow.eu.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/summersnow.eu.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/summersnow.eu.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/summersnow.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1814"}],"version-history":[{"count":1,"href":"https:\/\/summersnow.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1814\/revisions"}],"predecessor-version":[{"id":1815,"href":"https:\/\/summersnow.eu.org\/index.php?rest_route=\/wp\/v2\/posts\/1814\/revisions\/1815"}],"wp:attachment":[{"href":"https:\/\/summersnow.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/summersnow.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/summersnow.eu.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}