 What can averages, medians, and ranges reveal about a contest? Who will be the lucky winner of Mr. Mark's Math Adventures giveaway number one? Join me as we explore these questions in today's episode of Mr. Mark's Math Adventures. Hey math learners, it's Mr. Mark's here your friendly neighborhood math teacher remember it's not just about getting the right answers It's about learning and growing along the way before we dive into today's adventure Remember to hit that subscribe button and ring that bell to stay tuned for future episodes today's episode super special because today We're gonna use statistics to reveal the winner of Mr. Mark's Math Adventures giveaway number one now first things first I'd like to invite you to join me in congratulating the winner of our contest Melanie from California Congratulations, Melanie. You're the winner of a brand-new Mr. Mark's Math Let's see some celebratory remarks in the comments for Melanie All right now in today's adventure We're gonna use our giveaway's Participant entry data set as a vessel to dive into the world of mean range and mode and as we begin remember that mr. Mark's AI is Always just one click away offering instant personalized help in exploring the mathematical world of mr. Mark's math adventures It's perfect for learners of all ages and makes math fun and interactive and do consider using the companion worksheet It's a great free tool that you can use to follow along with each episode links to both are down in the description Let's start by setting up our data We've got a spreadsheet here with two columns name placeholder and number of entries taking the time to initially organize our data like this is key To any statistical exploration for our first quest We'll find the average or as mathematicians like to call it the mean number of entries per person Remember the average or mean is calculated by dividing the sum of all entries by the total count of Participants, let me show you how it's done step by step first We need the sum of all entries or the total of all entries when we add them all together We'll highlight every single entry in the number of entries column to see the sum with our data highlighted take a glance down in that Excel status bar at the bottom you see those numbers Excel's already calculating the sum value for us 1428 entries it's like having a mathematical assistant make sure you note down that sum of 1428 entries in an empty cell and now let's count how many participants we have We'll highlight every single entry in the name placeholder column and we'll get to see the count our data highlighted like this Take a glance at that Excel status bar one more time Excel again is already calculating the count for us a count of 136 math learning entrance. Let's make note of that as well in any empty cell now to find the average type to equal key and click The cell with our sum of 1428 type the divide key then click the cell with our count of 136 this division will reveal the average number of entries per person by dividing our sum by our count hit enter and there It is the mean the mean number of entries is ten point five or ten and a half entries All right now it's time to uncover our mode in our data. The mode is just the number that appears the most in our data Let's find which participant or participants obtain the most entries first type in equals mode M-O-D-E and then click and drag to select the whole range of cells in the number of entries column This tells the spreadsheet. Hi find me the most common number in this selection of cells after selecting the cells Close those parentheses and hit enter and just like that the spreadsheet does the heavy lifting and reveals the mode to be six The mode or the individual number of entries that occurred the most was six entries What do you think are there other easier ways to find the mode than this and next up on our math adventure? We're going to discover the range of our data think of the range as describing the distance from the smallest to the largest number of entries in Our collection of entry data. What do you say? We keep using our Excel skills to light the way first Let's click and drag again to highlight every number in our number of entries column and with our data highlighted Take a glance once more at that Excel status bar down in the bottom You see those numbers again Excel's already calculating the minimum and maximum values for us no down the minimum the smallest value in this case one Entry no down the maximum value in this case 28 entries in two empty cells. These are our data's boundaries We're gonna need them for our next step and in another empty cell What do you say we now calculate the range first type in equals and click that cell with our maximum number of 28 Type subtract and then click that cell with a minimum number of one This subtraction is going to reveal the full stretch of our collection of data now hit enter there The range turns out to be 27 It shows us how wide our data stretches each of these numbers and calculations tells us a part of the story of our data And it's up to us the math explorers to intentionally piece it all together Hey, could one of you have the top number of entries next time and maybe even win your very own mr. Mark's math mug What other statistics can we find under the hood comment your thoughts and stay tuned with your feedback We may just dive deeper into this data in a future episode. Hey props to you for taking some time out of your day To do some math with me. I hope you follow it along and if you made mistakes, that's all good Remember that every mistake is a step towards learning something new and hey mr. Mark's math adventures is holding giveaway Click the link down in the description below to see all the giveaway details and for your chance to win This is mr. Mark signing off. I'll catch you next time with another math problem. What did you think? Did you approach this problem differently? Let me know in the comments and if you enjoyed this problem Show your support by liking and sharing this video and don't forget to follow my page to stay up to date on more Math related content until next time You