课程: Excel: Tracking Data Easily and Efficiently

今天就学习课程吧！

今天就开通帐号，24,600 门业界名师课程任您挑！

Times: Checking data quality

Times: Checking data quality - Microsoft Excel教程

课程: Excel: Tracking Data Easily and Efficiently

开始一个月试用 购买团队方案

Times: Checking data quality

“

- [Narrator] Here, we have data from Wednesday and the people who did work and the activity codes, their start and end times. There's a lot that we might want to do with this data. Maybe we want to do some analysis on how much time is being spent on each activity. Maybe we want to look at how much overall time people are spending. But before we can do that, we have to check the data quality, especially if somebody handed you paper and then you typed it in, or you handed somebody paper and they typed it in. And now we're going to do the analysis. Let's check the quality. Let's look at Cristiano's time where he was on activity D17. The paper says he started at noon and ended at 1:19 AM. So one assumption we're making is that these times don't go over into the next day. So there is something wrong. Did Cristiano work from 1:19 AM to noon? Maybe they're reversed. But anyway, that's the kind of thing we need to look…

内容