SOCIO-ECONIMIC
DATA PROCESSING
USING EXCEL /
SPSS
TEAM MEMBERS:
1. VINAYKUMAR CHAN DAM
2. ARCHANA C
3. ARUNIMA KT
4. TANIA VIJU
INTRODUCTION TO DATA PROCESSING
Socio-economic data
- Data about humans
- Human activities and the space
structure used to conduct human activities
Data processing
- conversion of raw data to machine readable
- change of information in any manner detectable by an
observer
Socio-
COLLECTED DATA USABLE INFORMATION economic
Data
processing
using
Excel/SPSS
INTRODUCTION TO DATA PROCESSING
DATA PROCESSING SYSTEM
DATA PROCESSING
1. Conversion
2. Validation
3. Sorting
4. Summarization
5. Aggregation
Socio-
6. Analysis economic
Data
7. Reporting processing
using
[Link] Excel/SPSS
IMPORTANTS OF SOCIO-ECONOMIC DATA PROCESSING/ANALYSIS
Improve targeting in welfare schemes
Provide better education
SamuhyaPatanamuri
at
Mananthavady
Bring greater accountability in public services Socio-
economic
Provide better health conditions Data
processing
using
By giving transportation facilities Excel/SPSS
Give social cohesion
IMPORTANTS OF SOCIO-ECONOMIC DATA PROCESSING/ANALYSIS
Make better decisions in poverty, employment and
unemployment
By increasing productivity in small scale industries
Enhance ease of living for citizens
Bringing efficient waste management systems
Canal
Rejuvenation by
Participatory
Sanitation Socio-
Planning at economic
Alappuzha Data
processing
using
Excel/SPSS
Provide better infrastructure to place
SOCIO-ECONIMIC DATA PROCESSING USING EXCEL
• Developed by Microsoft
• Features calculation, graphing
tools & pivot tables,
• Programming language - VBA
Data Processing with Excel features
• List in Excel
-To create drop down list
• Sorting and filtering lists Socio-
- ex: sort by date economic
- Isolate key components Data
processing
• Building formulas, including the using
use of Excel built-in functions Excel/SPSS
- sum, average, count…etc
SOCIO-ECONIMIC DATA PROCESSING USING EXCEL
Data Processing with Excel features
• Paste Special
• The IF function
- Popular function
used for comparison
• Linking worksheets
- To add a cell or cell
range from another
worksheet
Socio-
• Cell references, relative economic
and absolute references Data
processing
using
Excel/SPSS
SOCIO-ECONIMIC DATA PROCESSING USING EXCEL
Data Processing with Excel features
• Subtotal
-To summarise a data
- Note: need sorted data
• Excel charts
- to create graphical
representation of data
- Column Chart.
- Line Chart.
- Pie Chart. Socio-
- Doughnut Chart. economic
- Bar Chart. Data
- Area Chart. processing
- XY (Scatter) Chart. using
-Bubble Chart Excel/SPSS
SOCIO-ECONIMIC DATA PROCESSING USING EXCEL
Data Processing with Excel features
Steps to create a chart
1. Select the data range.
2. On the Insert tab, in
the Charts group, click
the chart type
needed ,ex: line chart.
3. Select line chart type
from 2-d line or 3-d
line.
Features of chart
Socio-
• Change Chart economic
Type Data
• Switch processing
Row/Column using
• Legend Position Excel/SPSS
• Data Labels
SOCIO-ECONIMIC DATA PROCESSING USING EXCEL
Data Processing with Excel features
• Using Pivot Tables to summarise data
-flexible table
-gives you summarised data
Note: shouldn’t have any blank
column or blank record
Steps to create a pivot table
1. Insert -> pivot table
2. Select table or range
3. New worksheet /
Socio-
existing worksheet
economic
Data
processing
Pivot field table using
Excel/SPSS
SOCIO-ECONIMIC DATA PROCESSING USING EXCEL
Data Processing with Excel features
EXAMPLE OF PIVOT TABLE
GIVEN DATA : FIXED TABLE
Socio-
economic
Data
processing
using
Excel/SPSS
SOCIO-ECONIMIC DATA PROCESSING USING EXCEL
Data Processing with Excel features
EXAMPLE OF PIVOT TABLE
OUTPUT : PIVOT TABLE
Socio-
economic
Data
processing
using
Excel/SPSS
SOCIO-ECONOMIC DATA PROCESSING USING SPSS
STATISTICAL PACKAGE FOR THE
SOCIAL SCIENCE
• Statistical analysis of data
• Effective data management
• Ensure high accuracy and
quality decision making
• Wide range of options
•Excellent reporting, plotting and data presentation features.
•Open source integration
3 Basic ways of processing & analysis of data:
Socio-
Descriptive statistics economic
Examine relationships between variables (Regression, factor Data
processing
analysis, etc.)
using
Compare groups to determine significant differences (ANOVA, Excel/SPSS
T- tests, etc.)
SOCIO-ECONOMIC DATA PROCESSING USING SPSS
DATA EDITOR -Data View and variable view
Socio-
economic
Data
processing
using
Excel/SPSS
SOCIO-ECONOMIC DATA PROCESSING USING SPSS
DESCRIPTIVE STATISTICS
Socio-
economic
Data
processing
using
Excel/SPSS
SOCIO-ECONOMIC DATA PROCESSING USING SPSS
GRAPHS
Socio-
economic
Data
processing
using
Excel/SPSS
SOCIO-ECONOMIC DATA PROCESSING USING SPSS
FUNCTIONALITIES OF SPSS
• Data Examination • Data Transformations
• General Linear Model • Descriptive statistics
• Correlation • Reliability tests
• ANOVA • T-tests
• Regressions • MANOVA
• Cluster analysis • Factor analysis
• Time series • Profit analysis Socio-
economic
• Graphics and graphical • Survival analysis Data
processing
interface using
Excel/SPSS
Let us know your feedback…
Socio-
economic
Data
processing
THANKYOU using
Excel/SPSS