Type and hit enter to Search
×

Analysis of Descriptive data using MS excel and IBM SPSS

  • 4.8(45,337 Rating)

Course Overview

Experience live, interactive learning from home with The Knowledge Academy’s Online Instructor-led IBM Training | SPSS Course in Dubai. Engage directly with expert instructors, mirroring the classroom schedule for a comprehensive learning journey. Enjoy the convenience of virtual learning without compromising on the quality of interaction.

What’s included in the SPSS Training Course?

  • World-Class Training Sessions from Experienced Instructors
  • SPSS Certificate
  • Digital Delegate Pack

Target Audiance

  • The meticulous analyst who seeks to refine their Excel skills for comprehensive data interpretation.
  • The eager novice, absorbing SPSS techniques to unlock the mysteries of descriptive data analysis.
  • The corporate executive, recognizing the power of data-driven decision-making and diving into Excel and SPSS with enthusiasm.
  • The inquisitive researcher, eager to master both Excel and SPSS for nuanced statistical exploration.

Schedule Dates

Analysis of Descriptive data using MS excel and IBM SPSS
16 September 2024 - 20 September 2024
Analysis of Descriptive data using MS excel and IBM SPSS
16 December 2024 - 20 December 2024
Analysis of Descriptive data using MS excel and IBM SPSS
17 March 2025 - 21 March 2025
Analysis of Descriptive data using MS excel and IBM SPSS
23 June 2025 - 27 June 2025

Course Content

  • Introduction to descriptive analysis
  • Basics of descriptive statistics
  • Types of variables
  • Data collection methods
  • Frequencies and percentages
  • Common statistical measures
  • Mean
  • Median
  • STDEV and variance
  • Range
  • Measures of associations
  • Applications using MS Excel
  • Applications using IBM SPSS

  • Frequency tables
  • Crosstabs
  • Complex crosstabs
  • Data summarization
  • Applications using MS Excel
  • Applications using IBM SPSS
  • Statistical measures for grouped data
  • Exercises

  • Multi-response and one-response data
  • Identify unusual data
  • Identify duplicated data
  • Merging data from multiple files
  • Compare datasets
  • Sort, split and select
  • Restructure data
  • Data aggregations
  • Recoding to same and different variables
  • Visual binning
  • Optimal binning
  • Statistical measures for grouped data
  • Applications using MS Excel
  • Applications using IBM SPSS
  • Exercises

  • Detecting missing data
  • Imputation for missing data
  • Single imputation
  • Multiple imputation
  • Outlier detection
  • Applications using MS Excel
  • Applications using IBM SPSS
  • Exercises

  • Building charts principals
  • Types of charts
  • Simple and complex charts
  • Applications using MS Excel
  • Applications using IBM SPSS
  • Review course objectives and suggestions

FAQs

Descriptive data analysis involves summarizing and interpreting data to describe the basic features of the dataset. It includes measures such as mean, median, mode, standard deviation, and frequency distributions.

Descriptive analysis provides valuable insights into the characteristics of the data, helping researchers and analysts understand the central tendency, variability, and distribution of the variables under study. It forms the foundation for further inferential analysis.

MS Excel offers a range of functions and tools for descriptive analysis, including formulas for calculating basic statistics, pivot tables for summarizing data, and charts for visualizing distributions and trends.

IBM SPSS is a powerful statistical software that provides advanced capabilities for descriptive analysis. It offers a user-friendly interface for generating descriptive statistics, creating frequency tables, and conducting exploratory data analysis.

Common descriptive statistics include measures of central tendency (mean, median, mode), measures of variability (standard deviation, variance), measures of distribution shape (skewness, kurtosis), and measures of association (correlation coefficients).

Start learning with 15.8k students around the world.
  • 3.3k
    Courses
  • 100+
    Certified Instructors
  • 99.9%
    Success Rate
Open chat
Hello
How Can We Help You?