Introduction to Data A

EMARE ICT HUB

Contents
SPSS Unit: Introduction to Data Analysis with SPSS...........................................3
1. Introduction to SPSS...............................................................................................................3
Key Takeaways..............................................................................................................................5
2. Data Entry and Management...............................................................................................6
Hands-On Exercise.......................................................................................................................8
Key Takeaways..............................................................................................................................9
3. Descriptive Statistics............................................................................................................10
Hands-On Exercise.....................................................................................................................12
Key Takeaways............................................................................................................................12
4. Data Visualization..................................................................................................................14
Hands-On Exercise.....................................................................................................................16
Key Takeaways............................................................................................................................16
5. Basic Inferential Statistics...................................................................................................17
Hands-On Exercise.....................................................................................................................19
Key Takeaways............................................................................................................................20
6. Reporting Results...................................................................................................................21
Hands-On Exercise.....................................................................................................................23
Key Takeaways............................................................................................................................23
SPSS Unit: Introduction to Data Analysis with SPSS

Unit Overview

This Unit introduces students to the basics of data analysis using SPSS
(Statistical Package for the Social Sciences). It covers data entry,
manipulation, descriptive statistics, and basic inferential statistics. By the
end of the Unit, students will be able to perform basic data analysis tasks
and interpret the results.

1. Introduction to SPSS

What is SPSS?
 Definition: SPSS (Statistical Package for the Social Sciences) is a
software tool used for statistical analysis, data management, and data
visualization. It is widely used in social sciences, market research,
health research, and other fields.

 Uses:
o Analyzing survey data.

o Conducting statistical tests (e.g., t-tests, ANOVA, regression).

o Creating charts and graphs for data visualization.

o Managing and cleaning large datasets.

Overview of SPSS and Its Uses in Data Analysis

 Data Analysis: SPSS allows users to perform a wide range of
statistical analyses, from basic descriptive statistics to advanced
inferential techniques.
  Data Management: Users can import, clean, and manipulate data
efficiently.

 Reporting: SPSS generates detailed output that can be exported for

reports and presentations.

 Applications:
o Academic research.

o Business analytics.

o Government and public policy.

o Healthcare and psychology.

Key Features and Interface

SPSS has a user-friendly interface divided into three main views:

1. Data View:
 o Displays the actual data in a spreadsheet format.

o Rows represent cases (e.g., individuals, observations).

o Columns represent variables (e.g., age, gender, income).

2. Variable View:
o Allows users to define and manage variables.

o Key properties include:

 Name: Short name for the variable (e.g., "Age").

 Type: Numeric, string, date, etc.

 Label: Full description of the variable (e.g., "Participant's

Age in Years").

 Values: Assign labels to numeric codes (e.g., 1 = Male, 2

= Female).

 Missing: Define how missing data is handled.

3. Output Viewer:
o Displays the results of statistical analyses, charts, and tables.

o Users can navigate, edit, and export output for reports.

Navigating the SPSS Interface

 Menu Bar: Contains menus for file operations, data manipulation,

analysis, and help.
o File: Open, save, and export data files.

o Edit: Copy, paste, and modify data.

o View: Customize the display (e.g., show/hide toolbars).

o Data: Manipulate datasets (e.g., sort, filter, merge).

o Transform: Create new variables or recode existing ones.

 o Analyze: Perform statistical analyses (e.g., descriptive statistics,
t-tests, regression).

o Graphs: Create charts and visualizations.

o Utilities: Access variable information and other tools.

o Help: Access tutorials, guides, and support.

 Toolbar: Provides quick access to common functions (e.g., open file,

save, print).

Getting Started with SPSS

1. Opening SPSS:
o Launch the software and select "New Dataset" or open an
existing file.

2. Entering Data:
o Switch to Data View to input data manually.

o Switch to Variable View to define variable properties.

3. Importing Data:
o Use File > Open > Data to import datasets from Excel, CSV, or
other formats.

4. Saving Data:
o Save your dataset using File > Save As (SPSS files have
a .sav extension).

Example: Exploring the Interface

1. Open SPSS and create a new dataset.

2. In Variable View, define three variables:

o Name: "ID" (Type: Numeric, Label: "Participant ID").

o Name: "Gender" (Type: String, Label: "Participant Gender",

Values: 1 = Male, 2 = Female).

o Name: "Age" (Type: Numeric, Label: "Participant Age in Years").

3. Switch to Data View and enter sample data:

o Row 1: 1, Male, 25
 o Row 2: 2, Female, 30

4. Save the dataset as SampleData.sav.

Key Takeaways

 SPSS is a powerful tool for statistical analysis, data management, and

visualization.

 The interface consists of Data View, Variable View, and Output

Viewer.

 Users can enter, import, and manipulate data efficiently.

 Familiarity with the interface is the first step toward mastering SPSS.

By the end of this section, students will understand the basics of SPSS and
be able to navigate its interface confidently.

2. Data Entry and Management

Creating a Data File

1. Entering Data Manually in Data View:
o Data View is where you input your data in a spreadsheet-like
format.

o Each row represents a case (e.g., a person, observation, or

record).

o Each column represents a variable (e.g., age, gender, income).

o Steps:
1. Open SPSS and select New Dataset.

2. Switch to Data View.

3. Enter data directly into the cells.

 Example:
 Row 1: 1, Male, 25
  Row 2: 2, Female, 30

2. Defining Variables in Variable View:

o Variable View is where you define the properties of each
variable.

o Key properties include:

 Name: Short name for the variable (e.g., "Age").

 Type: Numeric, string, date, etc.

 Label: Full description of the variable (e.g., "Participant's

Age in Years").

 Values: Assign labels to numeric codes (e.g., 1 = Male, 2

= Female).

 Missing: Define how missing data is handled.

 Measure: Specify the level of measurement (Scale,

Ordinal, Nominal).

o Steps:
1. Switch to Variable View.

2. Define variables with appropriate properties.

 Example:
 Name: "ID" (Type: Numeric, Label: "Participant ID").

 Name: "Gender" (Type: String, Label: "Participant

Gender", Values: 1 = Male, 2 = Female).

 Name: "Age" (Type: Numeric, Label: "Participant Age

in Years").

Importing Data
1. Importing Data from Excel, CSV, or Other Formats:
o SPSS allows you to import data from various file formats,
including Excel, CSV, and text files.

o Steps:
1. Go to File > Open > Data.
 2. Select the file type (e.g., Excel, CSV).

3. Choose the file and click Open.

4. Follow the prompts to specify how the data should be

imported (e.g., range of cells, variable names).

2. Handling Missing Data:

o Missing data can be represented by blanks or specific codes
(e.g., 99, -1).

o Steps:
1. In Variable View, define missing values for each variable.

2. Use Transform > Replace Missing Values to handle

missing data (e.g., replace with mean or median).

3. Data Cleaning:
o Remove duplicates, correct errors, and ensure consistency.

o Steps:
1. Use Data > Identify Duplicate Cases to find and remove
duplicates.

2. Use Transform > Recode to correct errors or standardize

values.

Data Manipulation
1. Sorting and Filtering Data:
o Sorting: Arrange data in ascending or descending order based
on one or more variables.
 Steps:
1. Go to Data > Sort Cases.

2. Select the variable(s) to sort by and choose the order

(Ascending/Descending).

o Filtering: Display only specific cases based on criteria.

 Steps:
1. Go to Data > Select Cases.

2. Choose "If condition is satisfied" and specify the

criteria (e.g., Age > 30).
 2. Recoding Variables:
o Transform existing variables into new categories or values.

o Steps:
1. Go to Transform > Recode into Different Variables.

2. Select the variable to recode and define the new values.

 Example: Recode Age into categories (1 = 18-25, 2 = 26-

35, 3 = 36+).

2. Computing New Variables:

o Create new variables based on calculations or transformations of
existing variables.

o Steps:
1. Go to Transform > Compute Variable.

2. Define the new variable name and formula (e.g., BMI =

Weight / (Height * Height)).

 Example: Create a new variable "IncomeCategory" based

on income ranges.

Hands-On Exercise

Exercise: Data Entry and Manipulation

1. Create a Dataset:
o Enter the following data manually in Data View:
 ID: 1, 2, 3

 Gender: Male, Female, Male

 Age: 25, 30, 22

o Define variables in Variable View:

 ID (Numeric), Gender (String), Age (Numeric).

2. Import Data:
o Import an Excel or CSV file containing sample data.

3. Handle Missing Data:

o Identify and replace missing values in the dataset.
 4. Manipulate Data:
o Sort the dataset by Age in ascending order.

o Filter the dataset to show only females.

o Recode Age into categories (1 = 18-25, 2 = 26-35).

o Compute a new variable "AgeGroup" based on the recoded Age

categories.

Key Takeaways

 Data Entry: Enter and define data manually in Data

View and Variable View.

 Importing Data: Import data from Excel, CSV, or other formats and
handle missing values.

 Data Manipulation: Sort, filter, recode, and compute new variables to

prepare data for analysis.

By the end of this section, students will be able to create, import, and
manipulate datasets in SPSS, ensuring they are ready for analysis.
3. Descriptive Statistics

Frequencies
1. Generating Frequency Tables for Categorical Variables:
o Frequency tables summarize the distribution of categorical
variables by showing the count and percentage of each category.

o Steps:
1. Go to Analyze > Descriptive Statistics > Frequencies.

2. Select the categorical variable(s) (e.g., Gender) and move

them to the Variable(s) box.

3. Click OK to generate the frequency table.

o Output:
 A table showing the count, percentage, valid percentage,
and cumulative percentage for each category.

2. Interpreting Frequency Distributions:

o Count: Number of cases in each category.

o Percentage: Proportion of cases in each category relative to the

total.

o Valid Percentage: Proportion of cases excluding missing

values.

o Cumulative Percentage: Running total of percentages.

Example:
o If 60% of participants are Male and 40% are Female, the
frequency table will display these percentages alongside the
counts.
Descriptives
1. Calculating Measures of Central Tendency and Dispersion:
o Central Tendency:
 Mean: Average value.

 Median: Middle value when data is sorted.

 Mode: Most frequently occurring value.

o Dispersion:
 Standard Deviation: Measure of data spread.

 Variance: Square of the standard deviation.

o Steps:
1. Go to Analyze > Descriptive Statistics > Descriptives.

2. Select the continuous variable(s) (e.g., Age) and move

them to the Variable(s) box.

3. Click Options and select the statistics you want (e.g.,

Mean, Std. Deviation).

4. Click OK to generate the output.

o Output:
 A table showing the selected statistics for each variable.

2. Interpreting Descriptives:
o Use the mean and standard deviation to understand the
distribution of data.

o Compare the mean and median to check for skewness (e.g., if

mean > median, data is right-skewed).

Example:
o If the mean Age is 30 with a standard deviation of 5, most
participants are around 25-35 years old.

Cross-Tabulations
1. Creating Cross-Tabulations for Categorical Variables:
 o Cross-tabulations (crosstabs) show the relationship between two
categorical variables.

o Steps:
1. Go to Analyze > Descriptive Statistics > Crosstabs.

2. Select the row variable (e.g., Gender) and the column

variable (e.g., Education Level).

3. Click Cells and select the percentages you want (e.g.,

Row, Column, Total).

4. Click OK to generate the crosstab.

o Output:
 A table showing the count and percentage of cases for
each combination of categories.

2. Using Chi-Square Tests for Independence:

o The chi-square test determines if there is a significant
association between two categorical variables.

o Steps:
1. In the Crosstabs dialog box, click Statistics.

2. Check Chi-square and click Continue.

3. Click OK to generate the output.

o Output:
 A table showing the chi-square statistic, degrees of
freedom, and p-value.

 Interpretation:
 If p < 0.05, there is a significant association between
the variables.

Example:
o A crosstab of Gender and Education Level might show that a
higher percentage of females have a college degree compared to
males. The chi-square test can confirm if this difference is
statistically significant.
Hands-On Exercise

Exercise: Descriptive Statistics

1. Frequencies:
o Generate a frequency table for the variable "Gender".

o Interpret the distribution (e.g., percentage of males and

females).

2. Descriptives:
o Calculate the mean, median, and standard deviation for the
variable "Age".

o Interpret the results (e.g., average age and variability).

3. Cross-Tabulations:
o Create a crosstab of "Gender" and "Education Level".

o Add row percentages and perform a chi-square test.

o Interpret the results (e.g., is there a significant association

between gender and education level?).

Key Takeaways

 Frequencies: Summarize and interpret the distribution of categorical

variables.

 Descriptives: Calculate and interpret measures of central tendency

and dispersion for continuous variables.

 Cross-Tabulations: Explore relationships between categorical

variables and test for independence using chi-square tests.

By the end of this section, students will be able to generate and interpret
descriptive statistics, providing a foundation for more advanced analyses.
4. Data Visualization

Creating Charts
1. Bar Charts:
o Used to compare categories or groups.

o Steps:
 1. Go to Graphs > Chart Builder.

2. Select Bar from the gallery.

3. Drag the categorical variable to the x-axis and the

continuous variable (if applicable) to the y-axis.

4. Customize the chart (e.g., add titles, change colors).

5. Click OK to generate the chart.

o Example: Compare the average income of different education

levels.

2. Pie Charts:
o Used to show proportions of a whole.

o Steps:
1. Go to Graphs > Chart Builder.

2. Select Pie/Polar from the gallery.

3. Drag the categorical variable to the "Slice by" area.

4. Customize the chart (e.g., add percentages, change

colors).

5. Click OK to generate the chart.

o Example: Show the percentage distribution of gender in a

dataset.

3. Histograms:
o Used to display the distribution of a continuous variable.

o Steps:
1. Go to Graphs > Chart Builder.

2. Select Histogram from the gallery.

3. Drag the continuous variable to the x-axis.

4. Customize the chart (e.g., add a normal curve, adjust bin

size).
 5. Click OK to generate the chart.

o Example: Visualize the distribution of ages in a population.

4. Scatterplots:
o Used to show the relationship between two continuous variables.

o Steps:
1. Go to Graphs > Chart Builder.

2. Select Scatter/Dot from the gallery.

3. Drag one continuous variable to the x-axis and another to

the y-axis.

4. Customize the chart (e.g., add a trend line, change point

colors).

5. Click OK to generate the chart.

o Example: Explore the relationship between income and years of

education.

5. Customizing Charts:
o Titles and Labels:
 Add a title, axis labels, and data labels to make the chart
more informative.

o Colors and Styles:

 Change colors, fonts, and styles to improve readability and
visual appeal.

o Legends:
 Add or modify legends to explain the data.

Interpreting Visualizations
1. Identifying Trends:
o Look for patterns or directions in the data (e.g., increasing,
decreasing, or no trend).

o Example: In a scatterplot, a positive trend indicates that as one

variable increases, the other also increases.

2. Identifying Patterns:
 o Look for clusters, gaps, or unusual groupings in the data.

o Example: In a histogram, multiple peaks may indicate the

presence of subgroups.

3. Identifying Outliers:
o Look for data points that are significantly different from the rest.

o Example: In a scatterplot, points far from the main cluster may

be outliers.

4. Drawing Conclusions:
o Use visualizations to support or refute hypotheses.

o Example: A bar chart showing higher income for higher

education levels supports the hypothesis that education impacts
income.

Hands-On Exercise

Exercise: Data Visualization

1. Bar Chart:
o Create a bar chart to compare the average income of different
education levels.

o Customize the chart with a title, axis labels, and colors.

2. Pie Chart:
o Create a pie chart to show the percentage distribution of gender.

o Add percentages and customize the colors.

3. Histogram:
o Create a histogram to visualize the distribution of ages.

o Add a normal curve and adjust the bin size.

4. Scatterplot:
 o Create a scatterplot to explore the relationship between income
and years of education.

o Add a trend line and customize the point colors.

5. Interpretation:
o Identify trends, patterns, and outliers in each chart.

o Write a brief interpretation of the findings.

Key Takeaways

 Creating Charts: Use SPSS to create bar charts, pie charts,

histograms, and scatterplots.

 Customizing Charts: Add titles, labels, and colors to make charts

more informative and visually appealing.

 Interpreting Visualizations: Identify trends, patterns, and outliers to

draw meaningful conclusions from the data.

By the end of this section, students will be able to create and interpret
various types of charts, enhancing their ability to communicate data insights
effectively.

5. Basic Inferential Statistics

T-tests
1. Independent Samples T-test:
o Purpose: Compare the means of two independent groups to
determine if they are significantly different.

o Example: Compare the average test scores of male and female

students.

o Steps:
1. Go to Analyze > Compare Means > Independent-
Samples T Test.
 2. Move the continuous variable (e.g., Test Score) to the "Test
Variable(s)" box.

3. Move the categorical variable (e.g., Gender) to the

"Grouping Variable" box.

4. Define the groups (e.g., 1 = Male, 2 = Female).

5. Click OK to run the test.

o Output:
 A table showing the mean, standard deviation, and t-test
results (t-value, degrees of freedom, p-value).

o Interpretation:
 If p < 0.05, there is a significant difference between the
groups.

2. Paired Samples T-test:

o Purpose: Compare the means of two related groups (e.g., pre-
test and post-test scores).

o Example: Compare the average scores of students before and

after a training program.

o Steps:
1. Go to Analyze > Compare Means > Paired-Samples T
Test.

2. Select the two related variables (e.g., PreTest and

PostTest) and move them to the "Paired Variables" box.

3. Click OK to run the test.

o Output:
 A table showing the mean, standard deviation, and t-test
results (t-value, degrees of freedom, p-value).

o Interpretation:
 If p < 0.05, there is a significant difference between the
paired measurements.
ANOVA
1. One-Way ANOVA:
o Purpose: Compare the means of three or more independent
groups to determine if there are significant differences.

o Example: Compare the average test scores of students from

three different schools.

o Steps:
1. Go to Analyze > Compare Means > One-Way ANOVA.

2. Move the continuous variable (e.g., Test Score) to the

"Dependent List" box.

3. Move the categorical variable (e.g., School) to the "Factor"

box.

4. Click Post Hoc to select a post-hoc test (e.g., Tukey) if the

ANOVA is significant.

5. Click OK to run the test.

o Output:
 A table showing the F-value, degrees of freedom, and p-
value.

 Post-hoc test results (if applicable) showing pairwise

comparisons.

o Interpretation:
 If p < 0.05, there is a significant difference between at
least two groups.

 Use post-hoc tests to identify which specific groups differ.

Correlation
1. Pearson Correlation:
o Purpose: Measure the strength and direction of the linear
relationship between two continuous variables.

o Example: Examine the relationship between income and years

of education.

o Steps:
 1. Go to Analyze > Correlate > Bivariate.

2. Select the two continuous variables (e.g., Income and

Education) and move them to the "Variables" box.

3. Ensure Pearson is selected.

4. Click OK to run the test.

o Output:
 A table showing the correlation coefficient (r) and p-value.

o Interpretation:
 r ranges from -1 to 1:
 1: Perfect positive correlation.

 -1: Perfect negative correlation.

 0: No correlation.

 If p < 0.05, the correlation is statistically significant.

2. Spearman Correlation:
o Purpose: Measure the strength and direction of the monotonic
relationship between two ordinal or non-normally distributed
variables.

o Example: Examine the relationship between job satisfaction

(ordinal) and years of experience.

o Steps:
1. Go to Analyze > Correlate > Bivariate.

2. Select the two variables (e.g., JobSatisfaction and

Experience) and move them to the "Variables" box.

3. Select Spearman.

4. Click OK to run the test.

o Output:
 A table showing the correlation coefficient (rho) and p-
value.

o Interpretation:
  rho ranges from -1 to 1, similar to Pearson.

 If p < 0.05, the correlation is statistically significant.

Hands-On Exercise

Exercise: Basic Inferential Statistics

1. Independent Samples T-test:
o Compare the average income of males and females.

o Interpret the results (e.g., is there a significant difference?).

2. Paired Samples T-test:

o Compare the pre-test and post-test scores of students.

o Interpret the results (e.g., did the training program have a

significant effect?).

3. One-Way ANOVA:
o Compare the average test scores of students from three schools.

o Perform a post-hoc test if the ANOVA is significant.

o Interpret the results (e.g., which schools differ significantly?).

4. Pearson Correlation:
o Examine the relationship between income and years of
education.

o Interpret the correlation coefficient and significance.

5. Spearman Correlation:
o Examine the relationship between job satisfaction and years of
experience.

o Interpret the correlation coefficient and significance.

Key Takeaways

 T-tests: Compare means of two groups (independent or paired).

  ANOVA: Compare means of three or more groups.

 Correlation: Measure relationships between variables (Pearson for

continuous, Spearman for ordinal).

By the end of this section, students will be able to perform and interpret
basic inferential statistical tests, providing insights into group differences
and relationships in their data.

6. Reporting Results

Exporting Output
1. Exporting Tables and Charts:
o SPSS allows you to export output (tables, charts, and results) to
various formats for reporting.

o Steps:
1. In the Output Viewer, right-click on the table or chart you
want to export.
 2. Select Export.

3. Choose the format (e.g., Word, Excel, PDF).

4. Specify the file name and location.

5. Click OK to export.

o Tips:
 Use Word for detailed reports with text and visuals.

 Use Excel for further data manipulation or analysis.

 Use PDF for sharing finalized reports.

2. Exporting Entire Output:

o Export the entire Output Viewer content as a single file.

o Steps:
1. Go to File > Export.

2. Choose the format (e.g., Word, PDF).

3. Select the content to export (e.g., all objects, visible

objects).

4. Specify the file name and location.

5. Click OK to export.

Interpreting Results
1. Writing Clear and Concise Interpretations:
o Summarize the key findings in simple, non-technical language.

o Include:
 The purpose of the analysis.

 The main results (e.g., means, p-values, correlation

coefficients).

 The implications of the findings.

o Example:
  "The independent samples t-test revealed a significant
difference in average income between males (M
= 50,000,SD=50,000,SD=10,000) and females (M
= 45,000,SD=45,000,SD=9,000), t(98) = 2.5, p = 0.01.
This suggests that gender may influence income levels."

2. Avoiding Common Pitfalls:

o Do not overstate the findings (e.g., avoid claiming causation
from correlation).

o Clearly state any limitations or assumptions of the analysis.

Creating Reports
1. Combining Output, Interpretations, and Visualizations:
o Use a word processor (e.g., Microsoft Word) to create a
professional report.

o Structure:
1. Title Page: Include the title, author, and date.

2. Introduction: Briefly describe the purpose and context of

the analysis.

3. Methods: Explain the data source, variables, and

statistical techniques used.

4. Results:
 Present tables, charts, and statistical output.

 Include clear interpretations of the results.

5. Discussion: Discuss the implications, limitations, and

potential next steps.

6. Conclusion: Summarize the key findings and their

significance.

7. References: Cite any sources or literature used.

2. Formatting Tips:
o Use headings and subheadings to organize the report.

o Include captions for tables and charts.

 o Use consistent fonts, sizes, and styles.

o Add page numbers and a table of contents for longer reports.

3. Example Report Outline:

o Title: "Analysis of Income Differences by Gender and Education
Level"

o Introduction: "This report examines the relationship between

income, gender, and education level using data from a sample of
100 participants."

o Methods: "Data was analyzed using independent samples t-

tests, one-way ANOVA, and Pearson correlation in SPSS."

o Results:
 "The t-test showed a significant income difference between
males and females (p = 0.01)."

 "ANOVA revealed significant differences in income across

education levels (p < 0.05), with post-hoc tests indicating
higher income for college graduates."

 "Pearson correlation showed a positive relationship

between income and years of education (r = 0.6, p <
0.001)."

o Discussion: "The findings suggest that both gender and

education level influence income, with education having a
stronger effect."

o Conclusion: "This analysis highlights the importance of

education in determining income levels, with implications for
policy and workforce development."

Hands-On Exercise

Exercise: Reporting Results

1. Export Output:
o Export a frequency table and a bar chart to Word.

o Export a correlation table to Excel.

 2. Interpret Results:
o Write a brief interpretation of the t-test, ANOVA, and correlation
results.

3. Create a Report:
o Combine the exported output, interpretations, and visualizations
into a professional report.

o Follow the structure: Title, Introduction, Methods, Results,

Discussion, Conclusion.

Key Takeaways

 Exporting Output: Export tables, charts, and results to Word, Excel,

or PDF for reporting.

 Interpreting Results: Write clear and concise interpretations of

statistical findings.

 Creating Reports: Combine output, interpretations, and visualizations

into a professional report with a clear structure.

By the end of this section, students will be able to effectively communicate

their statistical findings through well-organized and professional reports.