Chapter 14 Data Analysis Using Statistical Tools

14.1 Introduction

Data analysis is one of the most crucial stages in the research process. After collecting data through surveys, interviews, experiments, or observations, researchers must analyze the data to extract meaningful insights and answer research questions.

Statistical tools help researchers organize, summarize, interpret, and present data in a systematic manner. Proper data analysis enables scholars to test hypotheses, identify patterns, and draw valid conclusions.

In modern research, several statistical software programs are widely used for data analysis, including SPSS, Microsoft Excel, R, Python, and STATA. Among these tools, SPSS and Excel are particularly popular among postgraduate students and PhD scholars because they are user-friendly and efficient for statistical analysis.

14.2 Importance of Data Analysis in Research

Data analysis plays a vital role in research for several reasons.

1. Interpretation of Data

Raw data collected from respondents must be analyzed to derive meaningful interpretations.

2. Hypothesis Testing

Statistical techniques help determine whether hypotheses are supported or rejected.

3. Identification of Patterns

Analysis reveals trends, relationships, and patterns in the data.

4. Evidence-Based Conclusions

Research conclusions must be supported by reliable data analysis.

14.3 Stages of Data Analysis

The process of data analysis usually involves several steps.

1. Data Editing

Data editing involves checking collected data for errors, inconsistencies, and missing values.

2. Data Coding

Coding involves assigning numerical values or symbols to responses so that they can be analyzed statistically.

Example:

Response	Code
Male	1
Female	2

3. Data Classification

Data classification refers to grouping data into categories or classes to facilitate analysis.

Example:

Grouping respondents according to age groups or educational qualifications.

4. Data Tabulation

Tabulation involves presenting data in tables for easier interpretation.

Example:

Age Group	Number of Respondents
18–25	80
26–35	60
36–45	40

14.4 Data Analysis Using Microsoft Excel

Microsoft Excel is one of the most commonly used tools for basic statistical analysis.

Common Excel Functions Used in Research

AVERAGE
MEDIAN
MODE
COUNT
STANDARD DEVIATION

Advantages of Excel

Easy to use
Suitable for small datasets
Good for creating charts and graphs

Example

A researcher analyzing student scores can use Excel to calculate:

Average score
Highest and lowest scores
Percentage distribution

Excel can also be used to create bar charts, pie charts, and histograms for data visualization.

14.5 Data Analysis Using SPSS

SPSS (Statistical Package for the Social Sciences) is one of the most widely used statistical software packages in academic research.

SPSS provides powerful tools for both descriptive and inferential statistical analysis.

14.5.1 Features of SPSS

Data management and coding
Descriptive statistics
Hypothesis testing
Correlation analysis
Regression analysis
Graphical presentation of data

14.5.2 Structure of SPSS Interface

SPSS consists of two main sections:

Data View

Displays data in rows and columns similar to a spreadsheet.

Variable View

Defines characteristics of variables such as:

Variable name
Type
Label
Measurement scale

14.6 Descriptive Analysis Using SPSS

Descriptive statistics summarize the characteristics of the dataset.

Common descriptive statistics include:

Mean
Median
Mode
Standard deviation
Frequency distribution

Example

A researcher analyzing survey responses may calculate the average satisfaction level of employees.

Steps in SPSS:

Enter data in Data View
Click "Analyze"
Select "Descriptive Statistics"
Choose "Frequencies" or "Descriptives"

14.7 Correlation Analysis in SPSS

Correlation analysis measures the strength and direction of the relationship between two variables.

Example:

Relationship between:

Study hours
Student academic performance

Steps in SPSS

Click "Analyze"
Select "Correlate"
Choose "Bivariate Correlation"
Select variables

The output will show the correlation coefficient (r).

14.8 Regression Analysis in SPSS

Regression analysis examines how one or more independent variables influence a dependent variable.

Example:

A researcher may examine how:

Training
Work environment
Motivation

affect employee productivity.

Steps in SPSS

Click "Analyze"
Select "Regression"
Choose "Linear Regression"
Select dependent and independent variables

The output includes:

R-square value
Coefficients
Significance levels

14.9 Hypothesis Testing Using SPSS

SPSS allows researchers to conduct various hypothesis tests.

Common Tests Used in Research

Statistical Test	Purpose
t-test	Compare means of two groups
Chi-square test	Analyze relationships between categorical variables
ANOVA	Compare means of three or more groups
Correlation	Measure relationship between variables
Regression	Predict dependent variable

14.10 Data Visualization

Presenting data visually helps readers understand research findings more effectively.

Common Visualization Techniques

Bar charts
Pie charts
Line graphs
Histograms
Scatter plots

Visual representations enhance the clarity and impact of research results.

14.11 Example of Data Analysis in a PhD Study

Research Topic

Impact of Training Programs on Employee Performance.

Data Collection

Survey conducted among 250 employees
Structured questionnaire using Likert scale

Data Analysis

Using SPSS, the researcher performed:

Descriptive statistics
Correlation analysis
Regression analysis

Findings

Results indicated that training programs had a significant positive effect on employee performance.

14.12 Ethical Considerations in Data Analysis

Researchers must ensure ethical practices during data analysis.

Important principles include:

Avoid manipulation of data
Report results honestly
Maintain confidentiality of respondents
Ensure transparency in statistical procedures

14.13 Limitations of Statistical Tools

While statistical tools are powerful, researchers must recognize their limitations.

Incorrect data entry may lead to inaccurate results
Statistical significance does not always imply practical significance
Misinterpretation of statistical outputs may occur without proper training

14.14 Conclusion

Data analysis is a critical component of the research process. By applying statistical tools such as Excel and SPSS, researchers can organize, analyze, and interpret data effectively.

For PhD scholars and postgraduate researchers, understanding statistical analysis techniques is essential for producing credible, reliable, and scientifically valid research outcomes.

Proper use of statistical software enhances the quality of research and supports evidence-based conclusions.