Dissertation Data Analysis: SPSS, NVivo & Excel Guide (2026)

Dissertation data analysis: spss, NVivo, and Excel guidance for UK students in 2026 covers the three most widely used data analysis tools in British university dissertation research, providing practical step-by-step instruction for both quantitative and qualitative analysis approaches. Selecting and correctly executing the right analysis method is one of the most technically challenging aspects of completing a high-quality dissertation at UK universities including the University of Manchester, UCL, the University of Edinburgh, and King’s College London. This expert guide provides clear, accessible instruction on using SPSS for statistical analysis, NVivo for qualitative coding, and Excel for data organisation and basic analysis — helping UK students make confident, methodologically justified choices that earn merit and distinction-level marks.

Choosing the Right Data Analysis Approach for Your Dissertation

Data analysis is the process of making sense of the evidence you have collected during your dissertation research. The appropriate analytical approach depends entirely on your research design: the type of data you have collected (numerical or textual), your research questions (seeking to measure, test, or explore), and your philosophical stance (positivist, interpretivist, or pragmatist). This guide covers the three most widely used tools in UK dissertation research: SPSS for quantitative analysis, NVivo for qualitative analysis, and Excel as a versatile option for both.

Quantitative Data Analysis with SPSS

SPSS (Statistical Package for the Social Sciences), now marketed as IBM SPSS Statistics, is the most widely used statistical software in UK university psychology, social science, business, and health science departments. It is available free of charge to most UK university students through site licences. If you have collected survey data, experimental data, or any other form of numerical data, SPSS is likely to be the expected tool.

Getting started with SPSS: Import your data from a spreadsheet or enter it directly into the SPSS data editor. Ensure each row represents a single participant or case and each column represents a single variable. Code categorical variables numerically (e.g., Male = 1, Female = 2) and define value labels in the variable view.

Descriptive statistics: Begin with descriptive statistics to summarise your data. Use Analyze → Descriptive Statistics → Descriptives or Frequencies to generate means, standard deviations, ranges, and frequencies. Include these in your results chapter in clearly labelled tables.

Common inferential tests in SPSS:

Independent samples t-test: Compares the means of two independent groups (e.g., male vs female, control vs intervention). Use when you have one continuous dependent variable and one dichotomous independent variable.

Paired samples t-test: Compares the means of the same group at two time points (e.g., pre-test vs post-test). Use for within-subjects or repeated-measures designs.

One-way ANOVA: Compares the means of three or more independent groups. Follow up significant results with a post-hoc test (Tukey HSD or Bonferroni) to identify which pairs of groups differ.

Pearson correlation: Tests the linear relationship between two continuous variables. Reports a correlation coefficient (r) ranging from ‑1 to +1 and a p-value indicating statistical significance.

Linear regression: Tests whether one or more predictor variables explain variance in a continuous outcome variable. Multiple regression examines the unique contribution of several predictors simultaneously.

Chi-square test: Tests the relationship between two categorical variables (e.g., whether gender is associated with product preference category).

Reporting SPSS results: Report test statistics in APA or your required style. For a t-test: t(df) = value, p = value, d = effect size. For ANOVA: F(df1, df2) = value, p = value, η² = effect size. Always report effect sizes alongside p-values — statistical significance tells you whether an effect is likely to be real; effect size tells you how large it is.

Qualitative Data Analysis with NVivo

NVivo is a qualitative data analysis software package widely used in UK universities for managing and analysing interview transcripts, focus group recordings, survey open-text responses, and documentary data. It does not automate the analysis — the intellectual work of interpretation remains yours — but it provides a structured environment for organising, coding, and searching your data efficiently.

Setting up your NVivo project: Import your data sources — typically interview transcripts in Word format, or audio files with associated transcripts. Create a project file that will store all your data, codes, and analytical memos in one place.

Coding your data: Coding is the process of labelling segments of text with descriptive or conceptual tags (codes) that capture what those segments are about. In inductive approaches (e.g., thematic analysis), you develop codes as you read the data — these are called ‘open codes’ or ‘free nodes.’ In deductive approaches, you begin with a pre-defined coding framework derived from your theoretical or conceptual framework.

Thematic analysis using NVivo: Following Braun and Clarke’s six-phase model, begin by reading all data thoroughly and taking initial notes. Code systematically, line by line. Group related codes into broader categories. Develop themes that capture meaningful patterns across the data. Review themes against the entire dataset to ensure coherence. Define and name each theme. Write up your analysis, using participant quotations to illustrate each theme.

Using NVivo features: The Query function allows you to search for patterns across codes (e.g., how often a code co-occurs with another). Word frequency queries can identify terms that appear frequently across the dataset, though these should supplement rather than replace interpretative coding. Node matrices can display relationships between codes and participant characteristics.

Framework analysis: Framework analysis — widely used in health and social policy research — uses a structured matrix approach to organise and compare data across cases. It is particularly suitable when you have specific research questions and a clear analytical framework from the outset. NVivo’s matrix coding query supports this approach.

Data Analysis with Excel

Microsoft Excel is the most universally accessible data analysis tool and is appropriate for some forms of dissertation analysis, particularly descriptive statistics and straightforward inferential tests at undergraduate level. It is available free to all UK university students through Microsoft 365.

Descriptive statistics in Excel: Use the Data Analysis toolpak (accessed through Data → Data Analysis after enabling it in Add-Ins) to generate descriptive statistics, including mean, standard deviation, minimum, maximum, and quartiles. Alternatively, use built-in functions: =AVERAGE(), =STDEV(), =MEDIAN(), =MODE().

Charts and graphs in Excel: Excel produces publication-quality charts for including in your dissertation results chapter. Common chart types include bar charts (for categorical data), line graphs (for trends over time), scatter plots (for correlations), and box plots (for distributions). Always label axes clearly and include a descriptive figure caption.

Limitations of Excel for dissertation analysis: Excel is less powerful than SPSS for inferential statistics, as it offers a limited range of statistical tests and does not report effect sizes or confidence intervals as automatically. For advanced quantitative analysis (regression, ANOVA, chi-square with effect sizes, reliability analysis), SPSS, R, or STATA are more appropriate. However, Excel is entirely adequate for simple frequency analysis, crosstabulations, and descriptive summaries, and it is often the best tool for creating clear, well-formatted tables for your dissertation.

Other Data Analysis Tools Used in UK Dissertations

R: A free, open-source statistical computing environment increasingly used in UK universities, particularly in statistics, data science, psychology, and social science. R is more powerful and flexible than SPSS but has a steeper learning curve. The RStudio interface makes it more accessible to beginners.

STATA: A statistical package commonly used in economics, epidemiology, and social sciences. Powerful for panel data analysis and econometric modelling.

MAXQDA and Atlas.ti: Qualitative data analysis software alternatives to NVivo. They offer similar functionality for coding, searching, and visualising qualitative data. University licence availability varies — check with your library which packages are available.

JAMOVI: A free, open-source statistical software that offers a user-friendly interface similar to SPSS, with a growing range of statistical tests. Increasingly used as a free alternative to SPSS at undergraduate level.

Presenting Data Analysis in Your Dissertation

The results chapter of your dissertation presents the findings of your analysis. For quantitative studies: use clearly labelled tables and figures produced in SPSS or Excel; report test statistics in the required format; and present results neutrally — save interpretation for the discussion chapter. For qualitative studies: present your themes or categories with illustrative participant quotations; ensure quotations are anonymised; and explain the analytical process transparently, including how themes were developed and refined.

Frequently Asked Questions

Do I need to learn SPSS for my dissertation?
If you are conducting quantitative primary research, SPSS is almost certainly the expected tool in UK psychology, social science, business, and health science programmes. Your university will typically offer training workshops. Many tutorials are also freely available online. Plan to allow time to learn the software before you need to use it for analysis.

Is NVivo required for qualitative dissertations?
NVivo is commonly used but not universally required. Many qualitative dissertations — particularly shorter undergraduate dissertations — are analysed without software, using manual coding with printed transcripts and coloured highlighters, or using Word documents. However, NVivo adds considerable value for larger qualitative datasets and is expected in many postgraduate qualitative research projects. Check with your supervisor about the expectation on your programme.

How do I know which statistical test to use?
The choice of statistical test depends on three factors: the type of dependent variable (continuous, ordinal, or categorical), the number of groups or variables being compared, and whether the design is between-subjects or within-subjects. Your methods textbook (e.g., Field’s ‘Discovering Statistics Using SPSS’) provides decision trees for selecting the appropriate test. Your supervisor and your university’s statistics support service can also advise.

What is thematic analysis and is it appropriate for my dissertation?
Thematic analysis (particularly Braun and Clarke’s reflexive thematic analysis) is the most widely used qualitative analytical approach in UK dissertations across many disciplines. It is flexible, well-documented, and can be used with various forms of qualitative data (interviews, focus groups, documents). It is appropriate if your research questions concern experiences, meanings, or perspectives. Discuss whether thematic analysis or a more specific approach (IPA, grounded theory, discourse analysis) is most appropriate for your specific research questions with your supervisor.

Related Study Guides

For further guidance, see our related articles: Dissertation Methodology: Choosing the Right Research Methods, How to Write a Dissertation Results Chapter, How to Write a Dissertation Discussion Chapter, and How to Write a Dissertation: Complete UK Guide.

⚠️ Common Mistakes in Dissertation Data Analysis: SPSS, NVivo & Excel (And How to Avoid Them)

One of the most common mistakes UK students make in dissertation data analysis: spss, NVivo, and Excel is failing to clean and validate their data before beginning any analysis. Data cleaning — checking for missing values, outliers, data entry errors, and impossible values — is not optional; it is a foundational step that must be completed and documented in your methodology chapter before any statistical or qualitative analysis begins. Students who skip data cleaning and run SPSS analyses on unchecked datasets frequently produce results distorted by data entry errors or outliers that should have been identified and appropriately handled. In SPSS, use the Frequencies procedure for categorical variables and Descriptives for continuous variables to identify impossible values and outliers before proceeding to any inferential analysis.

Conducting SPSS analyses without testing statistical assumptions first is a second critical error. The Quality Assurance Agency for Higher Education specifies that UK dissertations must demonstrate methodological transparency and rigour. For parametric tests (t-tests, ANOVA, Pearson correlation, linear regression), normality must be tested using Shapiro-Wilk (for n < 50) or Kolmogorov-Smirnov (for larger samples), homogeneity of variance must be verified using Levene’s test, and significant outliers must be identified using box plots. If parametric assumptions are violated, you must switch to non-parametric equivalents (Mann-Whitney U instead of t-test, Kruskal-Wallis instead of ANOVA, Spearman’s rho instead of Pearson r) and explain why in your methodology chapter. Ignoring these requirements is one of the most commonly cited weaknesses in UK dissertation viva and marking feedback.

For NVivo qualitative analysis, failing to develop a systematic coding framework before beginning the coding process is a significant methodological weakness. The Office for Students emphasises that academic research integrity requires transparent, reproducible analytical processes. Your NVivo coding approach — whether inductive thematic analysis (codes emerge from the data) or deductive framework analysis (codes are predetermined from theory or the literature) — should be clearly described in your methodology chapter, with examples of how you applied the coding framework consistently across all transcripts or documents. A reflexivity journal documenting your analytical decisions, code evolution, and any revisions to your framework demonstrates the methodological rigour that examiners at UK universities expect in qualitative dissertation chapters.

Relying on Excel for statistical analyses beyond basic descriptive statistics is a fourth common error that compromises the methodological credibility of UK dissertations. While Excel is a useful tool for data organisation, basic descriptive statistics, and simple charts, it lacks the statistical depth, output clarity, and assumption-testing capabilities required for inferential analyses in dissertation research. Students who conduct independent samples t-tests, regression analyses, or chi-square tests in Excel — rather than SPSS or R — frequently produce incomplete, inaccurately calculated, or poorly formatted results that examiners immediately identify as methodologically inadequate. Excel is an appropriate tool for data organisation and initial exploration; SPSS, R, or Python are the appropriate tools for inferential statistical analysis in UK dissertation research.

💡 Expert Tips for Dissertation Data Analysis: SPSS Best Practices UK (2026)

The most important expert tip for dissertation data analysis: spss in UK university research is to match your analysis method precisely to your research question and hypothesis. Each SPSS test has a specific purpose: independent samples t-test compares means between two independent groups; paired samples t-test compares means for the same participants at two time points; one-way ANOVA compares means across three or more groups; Pearson correlation examines the strength and direction of the relationship between two continuous variables; chi-square test examines the association between two categorical variables; linear regression examines the predictive relationship between one or more predictors and a continuous outcome. Choosing the wrong test — for example, using Pearson correlation to compare means, or using a t-test for ordinal data — fundamentally invalidates your results regardless of how accurately you executed the analysis.

When reporting SPSS results in your dissertation’s results chapter, follow APA 7th edition statistical reporting conventions — the standard used at most UK universities. For t-tests, report: t(df) = value, p = value, d = value. For ANOVA: F(df1, df2) = value, p = value, η² = value. For Pearson correlation: r(n-2) = value, p = value. For chi-square: χ²(df, N) = value, p = value, φ = value (or Cramér’s V). Always report exact p-values rather than simply “p < .05,” include 95% confidence intervals for mean estimates, and report effect sizes for all statistically significant findings. UK dissertation examiners at institutions including the University of Birmingham, Durham University, and the University of Exeter consistently identify missing effect sizes as one of the most common weaknesses in results chapters.

For NVivo thematic analysis, the transition from coded data to written themes requires careful analytical synthesis that many students underestimate. Once your initial coding phase is complete, the theme identification and refinement process involves reviewing your coded segments systematically, grouping related codes into candidate themes, evaluating whether each candidate theme is coherent (internally consistent) and distinct (meaningfully different from other themes), and naming each theme with a label that captures both the content and the analytical insight it represents. The most powerful themes in NVivo thematic analysis are not simply descriptive (e.g., “Communication problems”) but analytically rich (e.g., “Structural silence: How institutional power shapes practitioners’ willingness to voice concerns”). This level of analytical sophistication is what distinguishes distinction-level from merit-level qualitative dissertation chapters at UK universities.

Both SPSS and NVivo have extensive free learning resources available to UK university students. IBM SPSS official tutorials cover every major analysis procedure through step-by-step video guidance available on YouTube. The NVivo official YouTube channel provides comprehensive tutorials for every aspect of the software, from project setup and node creation through to matrix queries and visualisations. The SAGE Research Methods database — available through most UK university library portals — provides discipline-specific guidance on both SPSS and NVivo with worked examples from educational, nursing, business, social science, and psychology research. Most UK universities also offer free SPSS and NVivo training workshops through their library, statistics support centre, or graduate school — typically booking up quickly in dissertation season, so early registration is strongly recommended.

🏫 Dissertation Data Analysis: SPSS Support — Trusted by UK Students Since 2001

Since 2001, ProjectsDeal has supported over 20,000 UK students with dissertation data analysis: spss, NVivo, Excel, R, and advanced statistical methods. Our team of 200+ PhD specialists includes dedicated quantitative researchers with expertise in SPSS inferential statistics, NVivo qualitative analysts, and mixed-methods experts with deep experience in all major dissertation analysis tools used at UK universities. Whether you need help with SPSS assumption testing, NVivo thematic coding, or complete statistical analysis chapters, our specialists deliver technically rigorous, academically sound analysis that meets the exacting standards of UK dissertation examination boards. With over 45,000 verified student reviews, our data analysis support is the most trusted in UK higher education.

Our dissertation data analysis support covers everything from initial data cleaning and assumption testing through to full results chapter writing, SPSS output interpretation, NVivo thematic framework development, statistical tables and figures, and APA-formatted appendices. We explain all analytical procedures and findings clearly, ensuring your methodology and results chapters demonstrate the depth required for distinction-level marks. All our analysis support is original, Turnitin-verified, and tailored to your specific research design, data type, and university requirements. For comprehensive guidance on every stage of your dissertation journey, explore our expert dissertation writing guide and discover how our analysis specialists can help you achieve your best possible mark.