Data Analysis
Introduction to excel
• Basic function in excel
• Short-cut keys in excel
Data formatting
• Conditional formats
• Aggregate functions and number functions
Lookup functions
• Lookup and hookup functions
• Index and match
Data handling
• Data validation
• Duplicates and Transpose
• Paste special functions
Data visualization
• Charts and diagrams
• Data summery, report and dashboard
Creating, importing and exporting data in SPSS
• Designing A Good Questionnaire and Codebook For SPSS
• Getting Familiar With SPSS
• File Options in SPSS
• Importing Data From Other Softwares Into SPSS
• SPSS Shortcuts
Creating, managing and manipulating SPSS variables
• Types of Variables
• Levels of Measurements in SPSS
• Creating Variables in SPSS
• How To Compute Variables in SPSS
Creating and interpreting SPSS output
• Frequency distribution and cross tabulation
• How To Create and Interpret The Result of A Histogram
• Creating Bar Graphs in SPSS
• Pie Charts in SPSS
• Inferential statistics
Assignments
Project