How to Prepare Your Data for Analysis – Sample


Course Description

You have a perfectly clean dataset, but your favourite stats program isn’t happy – it needs your data in a different format. This course is about teaching you how to transform your data from what you have into what you need to get your analyses done. In this course you’ll learn how to make calculations on your data, create composite variables and convert numerical data to categories. You’ll also learn how to code your data to make it easier to work with in stats programs, and determine the data type of each of your variables, helping you to decide which analyses are appropriate.


At the end of this course you will receive a certificate of completion. Post it to Facebook, your LinkedIn page or print it out and stick it on your wall. Just don’t throw darts at it, ok…

Learning Outcomes

  • Over 1.5 hours of video content!
  • Learn how to make calculations with your data
  • Learn how to create composite variables
  • Learn how to convert numerical data to categories
  • Learn how to code your data
  • Learn how to round your data
  • Learn how to determine the correct data type of each variable
  • Excel is used as a learning tool, but the lessons learned are transferable to other media
  • Data files are provided for the student to practice with
  • Practical learning experience with real data

Course Content

Total learning: 4 lessons Time: 107 minutes


Admin bar avatar

Lee Baker is an award-winning software creator that lives behind a keyboard in a darkened room. Illuminated only by the light from his monitor, he aspires to finding the light switch. With decades of experience in science, statistics and artificial intelligence, he has a passion for telling stories with data, yet despite explaining it a dozen times, his mother still doesn’t understand what he does for a living. Insisting that data analysis is much simpler than we think it is, he creates friendly, easy-to-understand video courses that teach the fundamentals of data analysis and statistics. As the CEO of Chi-Squared Innovations, one day he’d like to retire to do something simpler, like crocodile wrestling.



  • Over 1.5 hours on-demand video
  • Language: English
  • Certificate of Completion
Do NOT follow this link or you will be banned from the site!