Difference between revisions of "Guiding Questions for Data Analysis"
***** (***** | *****) |
***** (***** | *****) m |
||
| (10 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | + | = Overview<br/> = | |
| − | + | Analysing data to summarise it and look for patterns is an important part of every evaluation. The options for doing this have been grouped into two categories: [[Impact_Evaluation_-_Mixed_Methods#Quantitative_Impact_Evaluation|quantitative data]] and [[Impact_Evaluation_-_Mixed_Methods#Qualitative_Impact_Evaluation|qualitative]] data.<ref name="Better Evaluation: http://betterevaluation.org/plan/describe/look_for_patterns">Better Evaluation: http://betterevaluation.org/plan/describe/look_for_patterns</ref> | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | Caution in the concrete '''data analysis process '''is, in particular, always advised in relation to the population used, i.e. the group that is made reference to (“… among | + | |
| + | = Guiding Questions = | ||
| + | |||
| + | The entered data has to be first of all checked for both '''correctness''' (spot checks whether entered data corresponds to the information on the questionnaire sheet) and '''consistency'''. | ||
| + | |||
| + | Depending on which software has been used to enter the data, the data may then need to be transferred into specific statistical software package (e.g. from Excel to STATA). A commonly used software package for both data entry and analysis is SPSS. For simple unconditioned analytical purposes, Excel is, however, often enough.<ref name="RWI (2009)">RWI (2009)</ref> | ||
| + | |||
| + | |||
| + | |||
| + | <u>These basic purposes comprise<ref name="RWI (2009)">RWI (2009)</ref></u>: | ||
| + | *frequencies (numbers, a count of how many), | ||
| + | *percent distributions (proportion), | ||
| + | *means (average), | ||
| + | *medians (mid-point), | ||
| + | *modes (the most frequent value), | ||
| + | *money (costs, revenues, expenditures), | ||
| + | *percent change over two points in time and ratios.<span></span><span></span> | ||
| + | |||
| + | <br/> | ||
| + | |||
| + | While there is some risk of bias in working with [[Impact_Evaluation_-_Mixed_Methods#Qualitative_Impact_Evaluation|qualitative data]] in particular, the application of statistics to analyze [[Impact_Evaluation_-_Mixed_Methods#Quantitative_Impact_Evaluation|quantitative data]] does not protect from providing biased results either. Orienting data analysis too much along '''positive impact hypotheses '''(“Fuel Savings”, “Better Conditions …”) '''hampers interpretations '''most consistent with the data. The ultimate guidance should therefore be to let the data instead of the researcher tell the story.<ref name="RWI (2009)">RWI (2009)</ref> | ||
| + | |||
| + | Caution in the concrete '''data analysis process '''is, in particular, always advised in relation to the population used, i.e. the group that is made reference to (“… among female adults”, “of households having bought an improved stove during the last two years.”). Both choosing the '''logically appropriate population '''and technically applying the correct data filtering and manipulation may be sources of miscalculations.<ref name="RWI (2009)">RWI (2009)</ref> | ||
| + | |||
| + | <br/> | ||
| + | |||
| + | = Further Information = | ||
| + | |||
| + | *[[Portal:Impacts|Impact Portal on energypedia]] | ||
| + | *[https://energypedia.info/Impact Monitoring Guidelines Impact Monitoring Guidelines]<br/> | ||
| + | *[[Impact_Evaluation_-_Mixed_Methods|Impact Evaluation - Mixed Methods]] | ||
| + | *[[Materials_for_Quantitative_Methods|Materials for Quantitative Methods]] | ||
| + | |||
| + | |||
| + | |||
| + | = References<br/> = | ||
| + | |||
| + | <references /> | ||
| + | |||
| + | [[Category:Impacts]] | ||
| + | [[Category:Questionnaires_/_Interviews]] | ||
Latest revision as of 15:25, 6 October 2014
Overview
Analysing data to summarise it and look for patterns is an important part of every evaluation. The options for doing this have been grouped into two categories: quantitative data and qualitative data.[1]
Guiding Questions
The entered data has to be first of all checked for both correctness (spot checks whether entered data corresponds to the information on the questionnaire sheet) and consistency.
Depending on which software has been used to enter the data, the data may then need to be transferred into specific statistical software package (e.g. from Excel to STATA). A commonly used software package for both data entry and analysis is SPSS. For simple unconditioned analytical purposes, Excel is, however, often enough.[2]
These basic purposes comprise[2]:
- frequencies (numbers, a count of how many),
- percent distributions (proportion),
- means (average),
- medians (mid-point),
- modes (the most frequent value),
- money (costs, revenues, expenditures),
- percent change over two points in time and ratios.
While there is some risk of bias in working with qualitative data in particular, the application of statistics to analyze quantitative data does not protect from providing biased results either. Orienting data analysis too much along positive impact hypotheses (“Fuel Savings”, “Better Conditions …”) hampers interpretations most consistent with the data. The ultimate guidance should therefore be to let the data instead of the researcher tell the story.[2]
Caution in the concrete data analysis process is, in particular, always advised in relation to the population used, i.e. the group that is made reference to (“… among female adults”, “of households having bought an improved stove during the last two years.”). Both choosing the logically appropriate population and technically applying the correct data filtering and manipulation may be sources of miscalculations.[2]
Further Information
- Impact Portal on energypedia
- Monitoring Guidelines Impact Monitoring Guidelines
- Impact Evaluation - Mixed Methods
- Materials for Quantitative Methods
