If you have decided to fulfill the goals of your bachelor’s or master’s thesis with the help of a questionnaire survey and you have already realized it, another difficult task is waiting for you. Questionnaires need to be processed and evaluated and the results processed into graphs or tables. MS Excel plays a big role here. If you don’t understand it too much, it’s time to meet.
First, I recommend to rewrite or copy all the questions and answers from the questionnaire to Excel and create a basis for further work, ie creating tables or graphs. Then a lengthy work consisting of counting the answers for each question awaits you. If you have everything counted, the number of respondents is written in Excel for each answer variation, I highly recommend using the sum (Ʃ) function to verify that you have the full number of respondents for each question (Everyone answered?), Because it does not exceptionally happen that recalculation, some respondent or answer is omitted.
Now you have to decide if you want to process the results into graphs or tables (both are possible at the same time). The graphs are clearer at first glance, but especially the color variations of the graphs can make the work more expensive. Anyway, I recommend to display the graphs, as well as tables, the results converted to percentages (relative values). If you can work in Excel, it’s a matter of minutes. If you do not dare to do so, we will be happy to help you with this, as well as with the whole processing of the questionnaire.
Excel offers several variations of graphs, but in general it is possible to recommend pie charts if you have uniform results and do not differentiate or compare categories. If you want to compare more categories in research, such as men and women, employed and unemployed, etc., bar graphs are more appropriate. Line graphs are useful for continuous phenomena and are used rather rarely (eg to affect the development of a variable). When creating a graph I recommend displaying the values for better clarity.
It is advisable to pay attention to the labels of the x and y axes, or if they are not described in the graph, it is necessary to pay attention in the graph label. If you have a description or a graph title directly in the graph generated by Excel, it is no longer meaningful to repeat its name in the label.
Charting in the bachelor’s or master’s thesis text should also be of a certain level, the graphs should ideally be the same big, but not too much, and their uniformity must be observed. If this is too much for you, contact the experts on our website, where they know all the rules and rules and add quality and level to your work.