Question 1: How to analyze and sort out your questions in the questionnaire survey is to understand how to analyze and sort out the data obtained from the survey.

Usually, tables are used to organize data, and bar charts, line charts or fan charts are used to describe data.

Pay attention to the list when sorting out the data with tables. The first column is the classification of the situation you want to know, the second column is the mark, the third column is the number of people and the fourth column is the percentage.

When recording data with a pen, the word "positive" is usually used, and one pen represents one data.

After the number of people is classified and counted, the data can be described by bar chart, line chart or fan chart, and the data can also be analyzed by frequency distribution histogram.

Question 2: How to write the data analysis of the questionnaire? You should analyze the data according to the designed questionnaire and then combine your analysis ideas, that is, what conclusions you should draw through the questionnaire. This is data analysis.

Question 3: How to analyze the data after entering a good questionnaire? When designing, we should consider the convenience of statistics to facilitate summary. Just use excel.

Question 4: How to analyze the questionnaire with data analysis method? Among them, a new table named "Summary" is created as a template, then this table is copied and renamed as 1, the first questionnaire result is entered, and then another table is copied and the second questionnaire result is entered. . . Until the input is complete. Then enter the summation formula in the summary table. B2 formula is as follows: =SUM ('Summary (2): Summary (4)'! B3) Summary (2) is the name of the first questionnaire result table, and summary (4) is the name of the last questionnaire table. For simplicity, I made three result tables, and then copied the formula into all the cells.

Question 5: How to analyze questionnaire data with Excel?

Among them, a new table named "Summary" is created as a template, then this table is copied and renamed as 1, the first questionnaire result is entered, and then another table is copied and the second questionnaire result is entered. . . Until the input is complete.

Then enter the summation formula in the summary table.

B2 formula is as follows:

= Su Wa ('Summary (2): Summary (4)'! B3)

Abstract (2) is the name of the first questionnaire result table, and abstract (4) is the name of the last questionnaire table. For simplicity, I made three result tables, and then copied the formula into all the cells.

Question 6:/kloc-Is there a big difference in data analysis between 0/00 questionnaires and 200 questionnaires? Generally speaking, the more questionnaires are published, the more answers will be received, but the accuracy may decrease (because respondents may submit them repeatedly). Therefore, if it is not necessary, it is not recommended to publish too many questionnaires.

However, if more submitters are needed to explain the contents of the questionnaire, you can try to publish more questionnaires. Therefore, the more questionnaires, the lower the accuracy may be, but the more respondents, the better the general answer to the question.

Question 7: How to use Excel to sort out, count and analyze the questionnaire? 2007 edition data-data analysis

The 97-2003 edition seems to have been forgotten in the tool.

You use help to search,

Question 8: How to sort the data of test papers from high to low? You can export the original data and analyze it yourself. Many of his analyses can't be realized unless you pay.

Question 9: How to input the questionnaire results into excel, and then analyze them with spss. Since you want to use SPSS to do statistics, why not directly input the data into SPSS, so go around?

The method is simple.

First of all, you have to make a small transformation, from "very dissatisfied -3 -2-1 0 1 2 3 very satisfied" to "very dissatisfied 1 2 3 4 5 6 7 very satisfied" because there seems to be no negative number in SPSS, (I'm not sure about the specifics, I always use positive numbers).

Then, enter the variable naming interface and select the second item in the lower left corner, similar to EXCEL. Name the variables, and name 40 questions in turn, such as Q 1\Q2\Q3-Q40. Whatever you want, or distinguish according to your different dimensions.

Finally, when you return to the data entry page, the topic you named will appear. Start typing your questionnaires one by one.

I don't know what the attached questionnaire means, so I don't know how to say it.

But in fact, EXCEL can also do general data analysis.

It is also very simple to directly convert EXCEL data into SPSS. You can open EXCEL files directly in SPSS software. !

Question 10: How to analyze the data of the questionnaire? It is best to have a 25-point tutorial. In fact, the analysis should be oriented: according to age, gender, wealth, fat and thin, height,,, a lot of oriented analysis, you ask too much. Can you tell me more about the contents of your questionnaire? In fact, it is still analyzed according to the key words in your questionnaire. Do a good job of classifying several data. It is suggested to use a website data for background analysis, which will be very convenient.