Tracking chores in Excel - Microsoft Excel Tutorial

(upbeat music) - When I was a kid, my father had us do chores. Me and my sisters and brothers rotating every week through the kitchen, the hallway, the living room, the bedrooms, the bathroom. I hated it. And part of why I hated it was because somebody would do a bad job on something and we'd all get in trouble. If I come home tonight and the kitchen is looking bad, no TV for anybody for the rest of the week. No, and we knew that there was somebody who was always doing the kitchen bad. There was no win in there. How could we win with data? Check it out. Let's look at the charts and what the data is telling us. You've got 12 weeks of data, three kids, Terrance, Dorothy, and Gray. And they rotate through three chores, kitchen, bathroom, living room/hallway. They're scored one through five. Also, each is scored on their own bedroom each week, one through five. So by stacking that data up, we can do some analysis. Now look, here are all the scores up through week 12. And check this out…