 blue, more colors, standard, there's the blue, boom, and then font group and center it. We could also make these thinner. So if I select the whole thing again, make them a little bit thinner, because I only have one number in there. And then I could wrap the text so the headers still fit just to practice that. So I'll select the entire header field and go to the home tab alignment and wrap the text. So now you've got the header. Now wrapping the text, notice that that makes this whole row wider. So if I had anything to the right, it could kind of be kind of an issue because it makes everything on this whole row wide, but that's the pros and cons to wrapping the text. So then if I say the total heads on each flip, we'll do our account if. So if it's a number one, it represents heads. Number two represents tails. Let's see what our results are. How many heads did we get out of, I only did 74 flips instead of 75. Okay, out of 74 flips. So equals count if brackets. I'm gonna put my cursor on this cell. I'm gonna do it with my keystrokes this time, holding control shift up, but then I wanna make sure I don't pick up the header. So I'm gonna say hold shift down and that picks up the whole range. I can still see the formula up here. And so I'm just gonna hit enter. And I'm sorry, I didn't finish the formula. I have to say comma. And the next criteria is if it's a one, number one. And then I can close it. To see it down here, it's count if the whole range comma criteria one. And then tails is gonna be the same equals count if brackets shift nine. I'm gonna do it just with the keyboard now. Up, up, holding shift and control up, holding just shift down. So I don't include the header. Looking at the formula bar, adding the comma to put the condition, the second criteria number two and enter. If I double click on it down here, you could see the whole function. And then if I put my total, it should come out to 74 using the trustee sum function equals the SUM of these two. So I'll put an underline here, home tab font group underline. And then I can say the percent heads. Percent heads is gonna be equal to the total heads, 34 heads divided by the number of flips 75. And then that shows up as just a number because I don't have it as a percent formatting home tab number group percentifying it. I like to call it the percentify. Some people that annoy some people, but I think it's fun. And then I'm gonna, I'll just keep it at that percents we'll round it. And then percent tails. And we're gonna say this equals 41 over 75. So that should be percentified 55. So the percent total should be a hundred percent, right? So we're gonna say percent total is gonna be equal to the SUM of the 45 and the 55, which is one. And if I go to the home tab, number group percentify it comes out to a hundred, which I can't see. So I'll widen the sell out a bit. And so there it is. So then I'm gonna put an underline here, home tab font group underline. And there we have it. Now I can copy this all the way across. And I can see for this first test 34 heads, 41 tails. That's a breakout of 45, 55. We would expect it to be 50, 50. But of course we only flipped it 74 times out of the total population, which is infinite times. So it's not gonna be exact, right? Let's say we did that though a hundred times. So I'm gonna copy this all the way across, selecting them, copy with the fill handle all the way across. Now notice that I can't see, whenever you see these hash taggy things, that means usually the cell is not large enough. So I'm gonna select all of the headers all the way across to try to get them to be the same size, selecting all of them to here. And I need them to be about this wide. So I'm gonna put my cursor between ES and ET and make them wide enough to see that 100%. So there we have it. So if we look at all of these, we can say if let's just look at the heads side, which we would expect to be 50%, right? So we got 45, 53, 56, 56, 53. 60, 49, right? So some are higher, some are lower, but they're kind of hovering around the 50. So let's select this whole thing. I'm gonna put this in my calculation formatting, which I'll make another color to make it stand out as not part of the center of the table. Home tab, font group, and I usually make that dark blue or I have been at least lately, and then white on the text. So we can see the text, font, and put some brackets around it. Now, I might wanna then say, okay, let's see if I can take these results. Let's just take a look at the heads and see if I can analyze that a little bit more. And maybe I'd like to do that with a vertical analysis. So I'd like to take this in a horizontal row and transpose it to see it vertically. So what I can do there is I can copy this whole thing, and it's kind of a two-step process. I'm gonna copy this whole thing and say I would like to make that into a column, control C or copy. I'm gonna go up here, up top, and I'm gonna first paste it just the numbers only. I don't want the formulas just the numbers. I'm gonna right-click, paste it one, two, three. And then I'm gonna copy that whole thing again, control C, and paste it here, but transpose. Right-click and paste special and transpose, meaning I want you to reverse the X and the Ys, so now it's in a column format. Then I'm gonna delete all of this stuff from IR all the way out. I'm deleting the whole column, so you can just delete the numbers. You don't really need to, but right-click and delete. And so there we have our data. So I could enter a table here if I want into this data. So I could say, let's go to the Insert tab and make a table and say, okay, so there's our table. And then I could say this is the expected value. Notice when I put something on the second line of the table and hit Enter before I do that. I'm gonna undo that. I'm gonna select this whole data, make it a percent, Home tab, numbers, percent to find it. And then, and you could add some more decimals, maybe you want it more exact over here, but let's keep the decimals off. And then I'm gonna put the expected value here. Expected, and notice when I hit Enter, it adds another table. Now the expected amount is just 0.5 or 50%. It's already in a percent format. And then I can say this is the difference. I'm gonna make another column, difference. And when I hit Enter, it makes the whole column, this is gonna be equal the 45 minus the 50, there's the difference. I'm gonna copy this down too, just double-clicking on that fill handle. And so now you can see the difference is above and some below on the table. So that looks good, I'm gonna, I have an extra column, so I'm gonna delete this column over here, right-click and delete, let's do that. Now if I wanna add a total line to a table, I could do that by going to the Table tab. So I'm on the table, in the Table tab, I could add a total column, which is in the Table style options group, and then down here, it,