Learn how to design ways to reduce risks of error creation. You need to know what can be the cause of errors.
- One of the most unfortunate problems that can often happen … when you're working with data … is you've gone through a process to make sure you have … good data hygiene and that your data is clean and not dirty, … but then after you do some analysis, … you somehow end up putting an error in the formula. … Maybe you're just not paying attention, … or you look away for a second … and something hits the keyboard, … or some other kind of mishap with your data occurs. … And the result is error creation. … This is something you need to be careful for … and control for, and it's something that I watch out for … every time I do data analysis. … Whenever I have a spreadsheet in Excel or Google Docs, … for example, I make sure that I have a mirrored set … of calculations so that when I'm actually doing the analysis … and the calculations and I come up with a number, … I have a secondary way and a way to test … if the two numbers are equal or not … in the mirrored calculations. … This is the same thing as …
Note: This course was created by Jason Schenker. We are pleased to host this training in our library.
Skill Level Beginner
Excel: Economic Analysis and Data Analyticswith Michael McDonald1h 37m Intermediate
Economics for Everyone: Understanding a Recessionwith Jason Schenker36m 31s Intermediate
Economics for Everyone: Job Markets and the Economywith Jason Schenker41m 42s Intermediate
2. Best Practices
3. Project Management
4. Evaluating Work
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.