Shulou(Shulou.com)06/01 Report--

In this issue, the editor will bring you a large number of paper questionnaires about how to use software such as excel or spss to count a large number of paper questionnaires. The article is rich in content and analyzed and described from a professional point of view. I hope you can get something after reading this article.

When collecting data with paper questionnaires, there is always a problem, that is, how to analyze the data quickly and accurately. If the input is not standardized, it is likely to be unable to analyze or enter the wrong data. If there is a mistake in the input of the data that is finally collected, the loss will outweigh the gain.

Here SPSSAU provides a method to help you enter data in a more standardized way, while avoiding the above problems, including the following steps:

First, input data; second, upload data

1 input data

First of all, the paper questionnaire and online questionnaire are input, and the method is referred to the following figure:

2 upload data

The input data can be uploaded directly to SPSSAU for analysis.

EXCEL format (including xls and xlsx) and SPSS format (SAV) data are currently supported in SPSSAU systems.

Specific steps:

1. Data upload reference (algorithm only knows numbers).

If the data is in SPSS format, please upload it directly.

For data in EXCEL format, refer to the following figure:

Special hint

The uploaded data is raw data, for example, if there are 100 samples or subjects, there should be 100 rows; 1 row represents 1 sample or subject; 1 column represents 1 attribute; it cannot be statistical data.

Users of questionnaire Star, questionnaire Network and Tencent questionnaire can also export data directly in the interface and save it.

Special hint:

If it appears as garbled after uploading SPSS format (but the SPSS software opens and shows normal), the solution is to arbitrarily modify a title of SPSS data and save it, and then upload it.

The algorithm only recognizes numbers, so for non-digital format data, the processing is as follows:

Special hint

In the figure above, the four columns of title 1, title 2, title 4 and title 6 are all numbers; SPSSAU does not do any processing.

Title 5 is all text, while SPSSAU automatically replaces the text with numbers and labels the numbers. An is represented by 1, B is represented by 2, C is represented by 3, D is represented by 4 and E is represented by 5.

If part of title 3 is text and part is number, SPSSAU will process the text to null value, and the number will remain the same.

The above is the editor for you to share how to use excel or spss and other software statistics of a large number of paper questionnaires, if you happen to have similar doubts, you might as well refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.