Conrad says that some numbers are more popular than others - it's not completely random. I have 1000 results from the Roulette Gaming; How can I easily view which numbers are 'Hot' and which ones are 'Overdue? Follow along with Episode #1661 as Bill guides us through creating a Pivot Table and a Filter Scheme that will allow us a more Dynamic measure of the Data.
...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! Power Excel With MrExcel - 2017 Edition
"The Learn Excel from MrExcel Podcast Series"
Visit us: MrExcel.com for all of your Microsoft Excel Needs!
Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Learn Excel from MrExcel podcast, episode 1661.
Roulette Analysis.
All right! Conrad sends in today's question.
He says, you know, "Hey! With the Roulette tables, it's not completely random." That some numbers are more popular than others, can we take a look at the last 1,000 Roulette results and see which numbers are hot and which numbers are not hot.
So, we're going to have our list here.
We're going to insert a pivot table and I'm just going to put it here in C2, click [ ok ].
All right! And we have our pivot table field list over here.
I'm going to take the last 1,000 and put it in Row Labels, which gives me the numbers from 0 to 36.
And then I'm also going to take the last 1,000 and put it in Values.
I see but it wants to sum, and that's not what I want because I don't want to give 8 more credit than a 1.
Let's say, so I'm going to move the field list out of the way, and I'm going to choose here, click on field settings and said I want to do a Count, click [ ok ], alright! And to find the hot numbers.
The numbers that are coming up frequently will sort descending.
Alright, so 7, 17, 11, 21, 10 are the hot numbers.
Now, let's see if we can show just the top 5.
So, Value Filters, just down, out of your sight is something called Top 10 dot dot dot and I want to show the top 5.
Items based on a count of last 1000, so there are hot numbers.
Now, what if we were looking for the numbers that haven't come up in a long time?
The numbers, let's assume that it really is random, the numbers that are overdue.
Then we go back to Value Filters, Top 10 and we can ask for the bottom 5 items based on count of last 1000 and there are the numbers that have that kind of that are, let's say overdue.
They have not been coming up more frequently.
So, a simple little pivot table using a count of each number can show us, you know the trend of last 1000.
All right! I want to thank Conrad for sending that question in and I want to thank you for stopping by.
See you next time for another netcast from MrExcel.
Learn Excel from MrExcel podcast, episode 1661.
Roulette Analysis.
All right! Conrad sends in today's question.
He says, you know, "Hey! With the Roulette tables, it's not completely random." That some numbers are more popular than others, can we take a look at the last 1,000 Roulette results and see which numbers are hot and which numbers are not hot.
So, we're going to have our list here.
We're going to insert a pivot table and I'm just going to put it here in C2, click [ ok ].
All right! And we have our pivot table field list over here.
I'm going to take the last 1,000 and put it in Row Labels, which gives me the numbers from 0 to 36.
And then I'm also going to take the last 1,000 and put it in Values.
I see but it wants to sum, and that's not what I want because I don't want to give 8 more credit than a 1.
Let's say, so I'm going to move the field list out of the way, and I'm going to choose here, click on field settings and said I want to do a Count, click [ ok ], alright! And to find the hot numbers.
The numbers that are coming up frequently will sort descending.
Alright, so 7, 17, 11, 21, 10 are the hot numbers.
Now, let's see if we can show just the top 5.
So, Value Filters, just down, out of your sight is something called Top 10 dot dot dot and I want to show the top 5.
Items based on a count of last 1000, so there are hot numbers.
Now, what if we were looking for the numbers that haven't come up in a long time?
The numbers, let's assume that it really is random, the numbers that are overdue.
Then we go back to Value Filters, Top 10 and we can ask for the bottom 5 items based on count of last 1000 and there are the numbers that have that kind of that are, let's say overdue.
They have not been coming up more frequently.
So, a simple little pivot table using a count of each number can show us, you know the trend of last 1000.
All right! I want to thank Conrad for sending that question in and I want to thank you for stopping by.
See you next time for another netcast from MrExcel.
