jump to content

Collecting and Analysing Numerical Data

You may want to analyse the numerical data that is collected for the performance indicators or you may want to collect new data. Here you will find resources to assist you in developing questionnaires and surveys, Following, an introduction to performance metrics, the page contains information about questionnaires and surveys, trial methodology, data analysis and economic analysis

Performance metrics

Each of the metrics contained in the framework has an accompanying detailed technical definition. These have been developed by Welsh Government and local authority data and information specialists though the National Reporting Sub-group.

These technical definitions, designed to be used by data and information specialists within each local authority, have been developed to provide a consistent collective understanding of the parameters for collection (what and how we count) for each metric to ensure that the same data is collected across Wales. These set reporting requirements are available here: Metric technical definitions catalogue

 

The Metric technical definitions catalogue contains details of:

  • A framework of performance metrics that must be collected and submitted to Welsh Government each year for adults, children, and carers across Wales.
  • Anonymous person level data that must be collected and submitted to Welsh Government each year on key aspects of social care and the people who use social services in Wales.
  • Aggregated data on specific aspects of social care that must be collected and submitted to Welsh Government each year.

Questionnaires and surveys

This resource provides practical guidance on how to design a questionnaire or a survey. It has a good level of detail about what should be considered when preparing such a tool.

 

Data collection tips. Developing a survey Innovation Network

This gives clear guidance on how to develop a survey. The information would also be relevant to developing questionnaires. In particular, this resource contains guidance about how to word survey questions.

 

Survey monkey

There are number sites where you can create a survey or questionnaires and ask people to complete it online. You can create a short, simple survey on Survey Monkey for free, but if you have a lot of items, want to ask a lot of people to participate or want to use more complicated response formats you will probably need to pay to use this site. Using digital survey methods may increase participation.

 

Trial methodology

The use of experiments in social care is relatively limited. However, there are occasions when using this approach is beneficial.

 

Experimental and quasi-experimental research Colorado State University

This introduction to experimental research provides clear guidance on how to prepare and run a clinical experiment or a trial. It also has a good section on the important ethical considerations when conducting this type of research.

Data analysis

For the Performance and Implementation Monitoring Framework most often you will want to analyse numerical data by using descriptive statistics (i.e., how often something is happening, what is the average outcome score). It is also possible however that you might want to run some statistical tests (for instance, to see if an outcome has improved significantly after an intervention). Some resources that might help are:

Statistics: an introduction Colorado State University

Provides detailed and accessible explanations of statistical terms and the main types of analysis. It covers descriptive statics, correlations and comparing group differences.

Analyzing quantitative data University of Wisconsin

This short document introduces basic descriptive statics including frequencies, range, standard deviation, median, mode and mean.

Glossary of key data analysis terms Wilder Research

This brief document provides helpful explanations of statistical terms relating to descriptive statistics, sampling, and significance. It also provides information about some statistical tests.

Economic analysis

Starting out on social return on investment 

Social Return on Investment (SROI) is one form of economic evaluation. It looks at the social value created. This short document provides an accessible introduction to SROI, but if you want to conduct an economic evaluation accessing additional support would be advantageous.

 

A guide to social return on investment

This document provides more detail about how to use and conduct a Social Return on Investment but again we would still recommend accessing additional support if this is possible.