Hi everyone, Joe for jasphyscasebreaks.com. Happy Wednesday, happy new release day. Happy Diamond Day. We got Diamond Kings coming at you from jasphyscasebreaks.com. This is 12 box inner case, random team number one. Let's see right here. No vet commons will ship. Everything else will. And there's an early bird special here too. So if you bought one of the first 20 spots, like these wonderful people did, then you've got a shot at that early bird spot. So let's get all the names here. Let's roll it. Let's randomize it. Snake eyes. Name on top. After two, we'll get an extra spot. One, two, easy. Matt Gomes, there you go. MG with the early bird spot. The early bird catches the worm. All right, so let's put his name here. Now in a new dice roll, let's figure out a random team assignments here. Let's roll it. Let's randomize it. Three and a three. Six the hard way. Your names first. One, two, three, four, five, and sixth and final time. After six, we've got Chris Miller all the way down to Ryan Harrell. Part six for the teams. Five and six. There you go. Six times, we've got the Texas Rangers down to the Tigers. Remember if you're watching live that groupbreakchecklist.com checklist is in the chat. All right, Chris with the Rangers. SKS with the Marlins. Ryan with the Rockies. Jackie got the Braves. Zach G with the A's. Brandon with the White Sox. Matt with the Diamondbacks. Matt Stubblefield last spot. Mojo, Blue Jays. Justin Larson, Pirates. Mary, you have the Phillies. Michael with the Cubs. Brandon with the Mariners. Colton with the Royals. Michael with the Giants. David with the Indians. And the Cardinals. Richard with the Nats. David Baker with the Rays. Jeremy with the Reds. Matt Gomes with the Brew Crew. SKS with the Red Sox. Colton with the Mets. Matt with your Early Bird Spot. The Yankees. Nice. Zach G with the Twins. Jeremy with the O's. Ryan with the Angels. Mark, you have the Astros. Joe with the Padres. Mary, you have my Dodgers. And Ryan, last but not least, Tigers. All right, so let's alphabetize by team here. Now, feel free to trade while you're trading. I'm going to pop open that case right over here. We're going to see which inner case we're going to do. I know it's kind of hard to see on that camera, but you can see L and R on the inner cases.  I'm going to select that one. Nice Dodger blue right there. We'll go 1, 2, 3 for the left side and 4, 5, 6 for the right side. The die is just off camera. And it's one. So we're going to do the left side right here. So let me go grab the left one. There you go. So the left side is the one we'll be doing. There you have it. All right, so I'm going to pause the video and allow for a little extra trading time. I know it's a brand new release, so people might want to get familiar with the team list and whatnot. So there you go. Trade away. We'll be right back. All right, welcome back, everybody. There are a lot of trade chatter, but at the end, no deals were done. All right, we've got a baseball draft coming up a little bit later tonight too, so that should be a lot of fun. All right, 12 box inner random team one on the 10th. Thanks, everyone, for joining us and making us part of your day. Appreciate it. So let's pop this guy open. Let's see what we got. Now the draft is only like what, a couple rounds this year? Or maybe five rounds? It's very short, as opposed to the dozens of rounds that I usually do. There'll be a lot of kids without jobs, but then they're also doing like, there's like a weird, undrafted free agent sort of thing, so there's been talk about teams trying to game the system a little bit where they kind of don't really make a big first round draft pick, you know? And they'll just draft an undrafted free agent and just kind of roll with that. So I get every organization will be different, but I guess that's some of the rumblings that I've been here and they think they might be able to get in for cheaper without signing bonuses and stuff, so we'll see. Two autographs or a memorabilia per box on average. There you go, that's the usual right here, the usual design that we've been used to. I can't tell who that is. It doesn't say on the box. Slippery packs there. Is that Sam using it on the box? That's right, Joe Floor, it's on average. They're all on average. I personally kind of like this. If you like all the Kings designs, you know what I mean? Diamond Kings, Quark Kings, Gridiron Kings are all related, they're all cousins.  Yeah, the canvas texture I really like too. Again, I think it's all the Kings products are definitely like that. Sort of an artsy look. A painting kind of look, that matte canvas finish. Something I've enjoyed over the years. We'll go a little bit slower on the first box just so we can get a good look at everything. Got those framed autos as well. Kind of a old, like I said, tobacco card design here, which I also dig. And there are the backs. Artist, palette, Javier Baez. Eloi. And our first hit is 21 out of 50. Ken Griffey Jr. Dual Relic for Cincinnati. Red Legs on the border early, Jeremy with the Reds. Reds on, oh, there he is, Sam Yuzo. I think some of these frames could be different colors and then they'll be serial numbered and all that. And we got Michael King. Two color Dual Relic and Autograph for the New York Mets. I think it's the Mets. Let me double check, that's why I have the checklist. No, Yankees. That blue makes it a little, usually they match the colors up nicely, but. All right, so that goes to Matt Gomes with the New York Yankees. It's the one bad thing about no logos. It looks like a bluish color. Usually you'll be able to tell by that. It was Ted Williams, DK Originals design. And there's one of the different colored frames right there, Jake Rogers, not numbered, but different parallel for the frame. And Ted Williams back there. All right, box one of the books. Not too bad. Let's pop open another one. Now we can speed up the break a tiny bit. Sure is, Patrick, I've got the TV tuned to MLB. Remember when you used to have to tune your TVs to a, but I've got it tuned to MLB network? Looks like it's gonna start, round one we'll start in about an hour and 40 minutes. It might be in the middle of our second Diamond Kings break by then. This should take about an hour. Might be on our second case and watch the first part of the draft. Anyone got any draft day news for us? Who's supposed to be projected number one? These are the guys we'll see in Bowman draft later this year. Although traditionally they usually are able to get these players into like single A or rookie ball or something like that, but I don't know if these players are gonna see any actual gameplay. Maybe Arizona Folly or it's Louis Thorpe. And we got a Juan Soto Jersey Kings relic for Richard, Richard Dunn with the Nets. Honest Wagner frame for the Pirates. And looks like we've got Zach Collins, dual relic and autograph for the White Sox. Nice, plays basketball and baseball. Zach Collins, White Sox, that'll be for Brandon Walker. It was Melot for the New York baseball giants. All right, next box. Patrick Goodwin saying Spencer Corkleson is projected to go number one in the draft. Looks like there's a new, the players saw that this morning, the players association proposed an 89 game schedule in a latest offer to the MLB. Hopefully they just get that deal done. Let's just get it done guys. Matt Harvey has received KBO and NPV, Korea and Japan Baseball League interest. It looks like the Pirates released a bunch of minor leaguers today. Next box, we've got Zach Gallin, two color relic and autograph for the Diamondbacks, Matt Gomes with the Snakes. I think the MLB Players Association, their latest plan, I think also includes an expanded playoff field. I haven't read the details on that, but it should be interesting. And Craig Bizio is your Jersey Kings for the Astros. Mark L with the Stroes. Joe Flores is saying, did you see NBA is thinking of putting NBA 2K fan noise on TV while games are being played? That's pretty cool. Sounds pretty realistic, doesn't it? Is that being pumped into the arenas as well? I think one interesting thing out of all this crazy, the pandemic craziness is the interesting things that live sports will bring. I wanna see, there was a Korean baseball game that I was watching that had stuffed animals in the seats behind home plate, like Pikachu's and Snorlax's and Power Rangers and all that sort of stuff. I thought that was kind of hilarious. I like the cardboard cutout ideas. I think they've talked about having maybe a select number of fans being video conferenced in to provide crowd noise or cheers and jeers. So there's been all sorts of ideas that I think are interesting. Not yet, Jennifer. We've got some solid stuff here, but nothing monstrous yet. This is just our first break of the day. Were there blow-up dolls too in the KBO? See, that'd be kind of funny. I think that'd be sort of hilarious. Oh, and that team got a massive fine. Well, hey, KBO, no fun league. There's Travis Demerit, dual relic and autograph, Tigers, Ryan Harold. I think we got our, did we get our two? Oh no, that was from the previous box. I think that'd be one more relic in here. One more. It's Jordan Yamamoto. And we've got a Shohei Otani quad relic. Nice, there's Domingo Leyva. Oh, and you mean in the soccer league? FC Sol, Sol would be the soccer team that's there. That's funny though. I'm looking forward to that. I'm looking forward to creative ways to kind of fill like the background for TV at least, you know? All right, so MLB Draft. I got some info here. We'll take place in an unusual fashion this year according to mlbtraderumors.com. This year's 2020 rule four amateur selection show will launch at five Eastern, but it'll be held remotely and end after only five rounds. Well shy of the typical 40 round affair. Bonus is capped as usual, but they won't be paid up front. Players can only receive 100K on the outset with the rest deferred to the 2021-22 season. Three days from now, draft eligible players that went unselected will be eligible to sign. None can sign for more than $20,000, which is kind of crazy because we looked this up the other day or a few weeks ago, I think. I think like if you get picked like in the fifth, sixth, seventh round, you know, you can still be eligible for bonuses upwards of $500,000, if not more. They're Strasburg dual rally. So the fact that teams can sign players for $20,000, that's significant savings for the big business. But not good for the players. There's Strasburg, Richard with the Nets.  If you're thinking of going right out of high school or whatever and you're like, hey, I'm projected sixth, seventh round, you know, bang, I could get a few hundred thousand dollars right out of the gate and then nope, 20. Nine out of 99, you got Hall of Famer Barry Larkin. Another red for Jeremy Agno. DK Originals autograph. Nice, he's got a good looking auto. There's the Kino frame. Are there any card price guides you would recommend? Yes. I would recommend ebay.com and search under sold items and that will give you your price guides. All right, next box. Yeah, actually an easier, that's a good point, David. The easier way to look at ebay sold sales, go to 130point.com, 130point.com. I think Rory Wagner maybe told me about that website a few years ago but the user interface was kind of terrible but I think they changed it within the last like six, eight months. So the website interface is a lot easier to use and it searches completed items, sold items and buy it now prices, which usually doesn't appear on ebay but you can find buy it now prices as well or best offer prices. So 130point.com, it's a good resource. Any card collector worth their salt should have that bookmarked. That and cardboardconnection.com and groupratechecklist.com.  No right or wrong way to collect. There's Peter Lonzo frame and we got Jordon Alvarez, 17 out of 25. Three color dual relic, going to Mark L. Nick Solak dual relic and autograph. That's for the Rangers. That's gonna be for Chris Miller and the Rangers. Nice Rory, what's going on? All right, next, good luck. Continuing on the draft, the atypical circumstances only increase the potential for wild outcomes. It might feel like normal at the top of the MLB draft where the scuttlebutt is that the Tigers will kick things off by taking ASU first base from Spencer Porkelson but things would get weird quickly thereafter. There have been some chatter that team could even punt the draft. Perhaps even one that has a fairly lofty draft position for RJ Anderson of CBS Sports. Baseball America's JJ Cooper exam that possibility concluding that it likely doesn't make much sense for a team to pursue. I don't know but we'll find out. Jennifer, if you rewind the chat a little bit you can rewind the video a little bit. You can see it's 130point.com. All right, next box, Tony Gonsolin frame. And we got Paul Molliter of Bat Kings. Goes to Matt Gones, piece of Paul Molliter's lumber. And we've got a Trent Grisham Padres dual relic and autograph who's got the fries. Joe Flores on the board. There's Nick Solak again for the Rangers. All right, next box. Any other fun draft related news? These are the guys we'll see in Bowman Draft. So the tires are taking Spencer Porkelson according to most mock drafts from Arizona State. The Orioles, possibly Austin Martin center fielder from Vanderbilt. Miami Marlins, Aisa Lacey. Royals, Zac Veen. Blue Jays, Max Meyer. That's the top five right there. The Wade Boggs, Bat Kings. Red Sox edition going to SKS. Piece of old Boggsie's lumber. The Cubs have taken nobody in the draft. Rex, they're the 16th pick and the draft starts about an hour and 19 minutes and 30 seconds, according to MLB Network. Sean Murphy, A's dual relic and autograph. Zac Gwynne. But according to fangraphs.com, they've projected Patrick Bailey, a catcher out of North Carolina State as a possible pick. Yeah, the tobacco cards are nice. Are they specifically off the T206 or is it just a generic tobacco card vibe? I don't know, either way, I like it. Initially, when they first did the mock-ups for it, I was just like, eh. But the final design seems pretty good. Oh, they call it 206 on the group? Okay, yeah, they look nice. That'd be a fun set to build. All the players on that T206 list. Who does fangrass have the Dodgers taking? Tanner Witt, a right-handed pitcher out of Episcopal High School in Texas. You guys know if there's a case-hit situation in Diamond Kings? I forget from last year. There's Garrett Cole, quad relic, Yankees. That will be for Matt. And we've got AJ Puck, dual relic and autograph. A's, Zac, next box. Now for the baseball draft, folks, it's the first two picks should be interesting for us hobby-wise. The number one pick has traditionally been featured, Bowman draft pretty heavily. And then the number two pick usually gets held and saved for Bowman baseball to follow in spring. So in this case, we saw, I think Adley Rushman was the key one. He was the number one pick last year. So he was featured a lot in Bowman's draft. And then you see Bobby Witt Jr. and a lot of the number two picks in a lot of our Bowman baseball stuff, which we have some of it still available on Jaspie's case break stop. Diamond Icons has a dual patch auto for Nolan Ryan Rangers edition and Astros edition. That's good multiple ways to get the Ryan Express. We have 39 out of 99, Ronald Bolanos. For the Padres, that's gonna go to Joe Flores and the Friars. There are those 206 cards. Domingo Leyba, I don't know why you were flipped around. Maybe a variation. Ghost of Matt Gomes. All the frames were flipped around. There's Roostar Greater All. And Mel Ott, he's having flipped around for some reason. And we've got a Pete Alonzo autograph, eight out of 50 in that tobacco card format, the T206 design. That is slick. That goes to Colton Carver in the New York Mets. Yeah, not bad at all. Man, it'd be hashtag good for the hobby. If Pete Alonzo, what if he wins the MVP this year? Would that be hashtag good for the hobby? Oh, this must be a case hit from downtown. Bryce Harper, or at least a super short print. Love those downtown cards. Phillies, Mary with the fight in Phills. That's exactly what downtown Philadelphia looks like, ladies and gentlemen. Declaration of Independence is there. Ben Franklin hangs around there. We got colonial, colonial-ly dressed guys and horses running around. So that's exactly what downtown Philadelphia looks like. In case you've never been there, that's a spinning image right there. Now you don't need to go to Philadelphia anymore. There it is, you saw it. But those downtown cards have been a nice introduction into these various sets. I dig it. Roy says Yellich MVP 2020, but does that help us with the hobby? How much does that add to Yellich's rookie cards? I feel like Pete Alonzo could be a big uptick in price. Oh, that's right, Sean. We are talking polar bear conservation efforts. There's Aaron Judge, dual relic. See, I feel like you win a rookie of the year. You win an MVP the following year. There's Matt with the Yankees. Be a nice boost in value. Hashtag good for the hobby. And we've got Danny Mendic, dual relic and autograph for the White Sox. That's gonna be for Brandon in Chicago, the South Siders. Last box coming up. No, we're keeping Rex, we're keeping him in check. So he's not drunk with his newfound power. All right, final box. Random team one, our first inner case of the day. The second inner case where it's gonna happen right after this. And then we'll go through some more orders and see what's coming up next. I saw Rex that was early saying, the only thing about Bowman-Draffy don't like takes three to five years. See, their picks get their starts. That's, see, that's the, it's a long game. That's the thing, that's the beauty of baseball. Especially when those early releases, it's the long game. But if you pick the right player, and there could be, there could be huge return on investments in baseball. Not true, Rex, the hats are already massive. Jersey Kings, White Sox, Brandon. And we've got Dylan Cease, dual relic and autograph for the White Sox. It's for Brandon. And looks like that is that. Do I have to give away anything in this break or anything like that? I don't think so. Just the early bird spot in this break. Very nice break, ladies and gentlemen. Random team one in the books. Brand new 2020 Diamond Kings baseball. Thanks for joining us. Thanks for watching. I'm Joe. We'll see you next time. Should we do a recap? We might as well. Kind of a longer video. So here's a quick. Those downtown cards look pretty sharp. I'm a fan of those in any set. It's a little more, a little more refractory in that, in this Diamond Kings edition. That Peter Lanzo autograph back there was nice too. So some pretty strong hits popping ladies and gentlemen. Thanks for watching. Thanks for breaking with us once again. Joe for jaskyscasebreaks.com. I'll see you next time.


Digital is a transformation sweeping through every industry. When we looked at four industries, we found that roughly 20 trillion dollars was at stake. If you extrapolate it out to all of the other industries, it could be well worth over a hundred trillion dollars. That number should give actually policymaker and industry a sense of the tremendous opportunity of different sectors getting connected and online. Nine out of ten of our clients believe that digital and all this change is going to be very disruptive, but only one in ten has a roadmap and understands what they need to do about it. There's no doubt that there will be winners and losers in this change. The question is, will there be more losers than there will be winners? How can big companies stay ahead of disruptions? Small companies can be fast and can be nimble. Big companies, they can deploy a lot of capital. Not all is lost for incumbents. They still do have many capabilities at play, and now is the time for them to use those and enhance the way in which they're currently offering products. We need to keep taking the productivity curve forward, and the way to do that is innovation. The automated haul trucks, they are safer and more productive. My biggest worry as Chief Innovation Officer in my company is the ability of a huge company like ourselves to understand all the challenges that we are facing with all these new technologies. It's the innovator's dilemma. How are companies going to cannibalize themselves and innovate to make sure they're relevant going forward? It's actually pretty difficult because what you're trying to do is to fundamentally change what you believe in. One of the hardest things to do for most companies is letting go of control. Make sure that you're aware of potential changes in consumption behavior. Carefully monitor what consumers on the fringes are doing. These fringe behaviors could potentially become mainstream. The key thing is to be able to fail fast, listen to the market and fine tune fast. It's about listening to how your process is working, how your technology is working, how your business model is working and going through a cycle, a continuous cycle of that. To be successful, companies need to think about ecosystems and the way they interact and partner with other companies. Interconnectivity also means connection between different business models. The power industry is also a retail business, but it's also a communication business. The idea of outcomes becomes very important. What outcomes can you satisfy for a customer with Michel and the tire company, providing an outcome of more efficient vehicle utilization rather than selling tires? A great example of thinking about business models in a very different way is going from selling a patient monitor, which is a computer that sits at a patient's bedside, into selling monitoring as a service. You need to start thinking about how do you share resources? How do you rent resources? Enable an ecosystem that can drive you a business model.


so it's not negative 50 and it's not negative 30 it's 15 degrees and it feels so good it's like summertime over here welcome to the midwest winter whoo also this snow is packed i mean i don't know if you can see that but this entire bridge is probably good one to two feet of snow covering it crazy saw someone with a snowmobile and i was like i have to get it i have to get it so i tried running up here really quick but he flew by the bridge so fast that i couldn't get i couldn't get his attention crap that have been so awesome that have been epic b-roll ah there's a guy on the bike in 15 degree weather i don't know what his story is but just like him and just like you and me we all have a unique story right okay so i was setting up this shot for like the longest time but my stupid droby tripod wouldn't actually hold and so i'm like a frick and then i finally get it stable and i hear this and i'm like we have to go get it so i just ran across the snow got all snowing wet just to get that little bit of footage oh that was so epic okay where were we i'm not even gonna try to set the tripod the plan was to set the tripod up watch the camera just do my spiel not doing that again better yet we're gonna hang with this guy whoa what is this hello thanks wow that was a treat well i was gonna say something deep about something and something deep this deep that but press that off your person there but you know what i feel like so many people are already saying this and it's just repetition of of all this good feeling oh hold on you know you can do this you can do that and yes you can do all those things keep pursuing them keep working hard i'm also gonna make this quick because it's cold and i don't like being in the cold my shoes and my feet are wet this has really taken a whole different approach i was gonna do a whole thing a whole video on this but what i'm saying is this it'll i'll make it very brief we all have a unique story to tell and it's the way we tell it that really mattered i will say this for those who are struggling to create something to create their story and make it onto social media whether it be instagram facebook youtube whatever it might be i challenge you with this make your story unique to you i know that's like dull like it's my story but but but hear me out the way you tell your story it's far more important than the actual content okay you could have the the best story the most compelling story to tell or you could have that champion story but if you don't tell it in the way it's supposed to be told if you don't tell your story the way you are or the characteristics that you bring to the table that story won't hold its weight as much as it could and it all counts it's all important but the way you tell that story is far more important so i guess you know are you telling your story the best way you can are you working hard enough to get better at your craft to tell your story because ultimately if you're starting a business if you're starting a youtube channel if you want to grow on social media heck if you want to start a website and monetize on that you got to tell your story you got to build your brand the way you would build it there's so many techniques out there's so many how to business 101 marketing 101 but it all comes down to the original content you have which is your story you got to build your story based off your brand and your brand is your story so i think that's what i want to say today again i was going to go into uh this video is going to be about how to buy a camera if you're on a budget i mean that was the whole point of this of this video but then i saw a snowmobile then i was like what's that guy's story on the bicycle and then i was just thinking man i've got a cool story i hope i can tell that uniquely on social media and then this came out so it's not what i intended but that's that's the beauty of this you can just make it what you want and that's literally that's the story i love it i think i just got i just got pumped for those snowmobiles because i think i trash can because i think i just want to be on a snowmobile well i want some adventure and i'm going to go get it so say bye to my friend here we're going to peace out have a good weekend hope this kind of this kind of helped you in your journey a little bit i don't know it was such a such a random thing to do but yet again your story matters and it's unique don't wait on anyone else to tell you how to tell it start doing it start working today start grinding tell your story even if it's not perfect start making those little perfections every single time you create content make those little perfections and then go from there so that being said i'm a peace out hope that helped see you guys next time on the johnny q channel peace that guy incredible balance


Hi everyone, happy Saturday.  I'm Monica Wahee and I'm just starting this live stream a little early uh so everybody can connect and say hi to each other and say hi to me and I can say hi to you. Hi everyone, just connecting now. All right and see it's working. I can update you in this period of time before we start the live stream on a research study I participated in for the application that I'm using to stream which is called restream. Restream is an application that is for people like oh hi we have somebody from Somalia on. Hello from Boston to Somalia, thank you. So I've been in a study where restream that's put on by restream and just to be clear what this software does is it helps people like me who are not very good at engineering. It helps like if you want to do something simple like I'm doing I'm streaming to YouTube and streaming to LinkedIn from my you know my little home on my laptop and my desktop but what I learned actually from participating in the study it's over now um is that uh restream can do a lot of different things it can actually you know do more like let's say you had like a dance recital and you had um a big uh something oh hello everybody let's see here hi from India yay oh um hi Matthew how are you I haven't seen you in a long time I hope you're doing well thank you for showing up to my live stream I was just talking a little about this before I started I'm going to officially start in a couple minutes um about how I was participating in the study um for oh is that here is here hi is that here I'm glad you were able to show up I didn't even advertise this very much I'm so glad you're here um I was I I found out the software I'm using can do all kinds of stuff not that I'm trying to do all kinds of stuff but also this is another thing you know how I've been having trouble with the chat like right now I I have this counter on here that says nobody's watching well obviously you're here because you're chatting so that counter's wrong and then also I've had live streams where I'm like nobody's here nobody's chatting and after I get off the live stream people email me and they're like Monica I was chatting and so this was coming up also in the participation among the participants because it's a qualitative study so we were discussing stuff and so hopefully um what we'll have is some improved restream is really taking off a lot of people are using it now and it's really improving fast but another thing that I sort of got out of discussing this with other people is streaming actually is a lot of work like I maybe didn't realize that because I like to watch people who are having fun streaming like walking around Las Vegas or going to a resort or fishing or whatever but even those people they look like they're having fun but it's a lot of work for them to set up their streams and do everything and I you know I'm starting to appreciate that more now and so give them more likes and thanks and you know because now I'm starting to be a little more empathetic and appreciate that and my live streams are a lot easier and still I'm like wow it's kind of like holding an event you know like um like a lecture or something you know all right well now it's one o'clock eastern time time to start the um official stream thanks to everybody shown up I'm Monica and I'm doing the stream today uh I'll give you a little backstory what I've been trying to do my goal for this year is to increase my youtube subscribers so if you're watching this live or you're watching this recorded and you like it that would be awesome that you liked it in fact what I would like you to do is check out my other stuff I have a lot of diverse stuff and um if you like that then I'd like you to subscribe because um I'm going to try to do more live streams so I can talk to you in real time um of course they're spontaneous I also make videos that are not so spontaneous so I can plan things and do a good demonstration but it's night I have a whole bunch of different things so that's what I was trying to do is you know I hardly had any subscribers like 3 000 subscribers and I have like like over 100 videos you know lectures and all kinds of stuff so I was like I gotta I gotta improve this so if you follow my blog you'll you'll know that and also I'm a LinkedIn learning author so of course I turned the LinkedIn learning you know but I don't know how to do something that's the first place I turn so I took a course and um learned some tricks about expanding um your youtube audience and one of them was just live streaming like this so uh so today uh I'm gonna demonstrate something oh one of the things that I also learned from that class um that course which is actually sort of obvious but you know how sometimes things are obvious but you need to be taught them I needed to be taught this the description to youtube videos is really important and I'm telling this to you guys and you're probably consumers of youtube and so you probably already know this but if you happen to make any videos like for example I have a lot of learners who are doing portfolio projects in data science and I tell them make a video show showcase how you could communicate about your data and about your project well if you do make a video and you put it on youtube it's really important you make the description like nice what do I mean by nice first of all make sure it actually describes the video and put words in it like if you have a transcript or anything um that you know what words you said you know put a lot of words in it there's five thousand characters in the description on youtube put words in it that you say in there because one of the things that was said in the course is there's really no tags there's no word description for the SEO to grab on to so you want to put the description another thing that I just think is nice and now it's easy to do is to put timestamp links so and when you have long videos and you'll see I'm definitely going to do that with this one after it's recorded is is go back and listen to it and then put in timestamp links for um so people can jump around in the video because I think it just makes it easier to learn especially if you're studying or you're like I'm going to demonstrate stuff and if you're like oh trying to do it you want to go back and look at it those are really nice so in the process of doing that if you're going to do that to your videos what do you have to do you have to watch them again so I was watching I have a playlist called essentials of statistics which has I guess really good videos I mean I forgot how good they were I was enjoying watching them um you know I'd sort of forgotten making them I made them in 2015 but they're really good I think they're really good and but they're they're good for people learning statistics um in an applied way they're not theoretical they're a hundred percent applied and I think that's why a lot of people like them because most statisticians teach like theory and I don't I get the theory but it doesn't fascinate me I'm not into math well I think it's so cool about statistics is when you can apply it when you can do stuff with it like actually predict something so uh I I created the videos for my nursing class I used to teach in undergrad and they loved it these nurses loved it and it was all by hand but I found as time went on data scientists loved it and I'm like you're already doing artificial intelligence why you care about standard deviation how to calculate by hand and I realize now when I'm right watching it is like yeah this is a good review for a data scientist because I talk a lot about how the statistical software we're not using in the class would do this and how we're going to do it instead you know because I would always give them like five x y pairs to make a correlation out of because who's going to sit there and you know calculate that forever but anyway I guess this is my long introduction way of saying as I was going through that I realized how much I use excel the random number functions in excel for just like basic research administration not for like fitting regressions or anything like that or imputing data just for like basic managing of research and when I thought of that I thought back to the last few weeks when I meet with my customers and I work with them and I realized I'm always doing this with my customers so I thought well why don't I just hold a little tutorial just show people how to do it because none of my customers have ever known how to do it and everybody seems to know excel so let me uh then just show you uh some tricks okay so I'm going to share my screen here and we're going to start with actually first I'm going to show you um uh where I'm getting the data that I'm going to use to demonstrate and that is I'm getting it from ahd.com American hospital directory.com and the reason why it's important for you to know that is because this is a really awesome website um it says here free hospital profiles but let's say you go here it's got all this data these are the hospital statistics by state here's all the states and here the here's the columns about it you know number of hospitals staff beds total discharges patient days and this is uh I think these are annually they're either annually or quarterly because Medicare which is the federal public insurance for elders mainly for elders there's some other groups in it that requires each of our hospitals to report quarterly data to it and what ahd.com does you see you can log in here they get this data which I think it's free or you can buy like you just have to pay for the media that they give it to you on like it's a lot of data and what they do is they load it in this interface and you can pay them and log in and do a bunch of analysis but the reason why I haven't done that is it's more for economics these are more it's more for economic um forecasting I've logged into it before I think they gave me a free account to show show me something um but this is available um publicly to just look at the data and I find it really helpful to when I'm teaching about healthcare now these are all the states in the United States I live in Massachusetts so when I taught my undergraduate course in nursing in statistics I use this a lot for demonstration because it was just like it's kind of nice because you get like this first of all it's public data you get this hospital name and actually if you're curious you can click on each hospital and it'll bring you to a record I'm not a robot I'm just demonstrating this here um and see this isn't and again this is public information but this is about Brock and hospital here's the website and I like using this to just teach you know to um just show when people are learning about hospitals and healthcare in the U.S. to just hear you know read about this hospital you know compare the patient revenue and all that um so let's see here it was okay but the data set that I am going to demonstrate with is this one and so I just want to go over the columns here says hospital name um the city and then um like so Massachusetts is not a very big state there are a few big cities in it and the rest are kind of suburbs and it's sort of rural area but not very rural um but there are places where you would have to drive a long time to get to a hospital so that's one thing to keep in mind um like for example you know Worcester is a really big city if you lived in Worcester you wouldn't have to go very far to get to a hospital there's multiple hospitals in Worcester but and and Gloucester is not a huge city but it's a pretty big city and yeah you actually pronounce it Gloucester like somebody had to teach me that but like a city like Pittsfield or Greenfield they're very kind of small and they're actually kind of lucky to have um a hospital and as you can see see here 89 beds it's not very big and so um so I just wanted to point that out that that's the the background like I grew up in Minnesota if we were looking at the list of Minnesota I'd be telling you different things because that's different geography here so what this is staff beds for those of you who don't know just to let you know um you can have beds in a hospital there are not staffed because there's not enough staff that's a problem right now in the U.S. because of the pandemic so this just says which beds are in operation that you can support with your staffing and these are how many people were discharged so this is inpatient all the hospitals offer outpatient services but this is just about inpatient and this is how many inpatient days like if everybody just had one day then the discharges would equal this but some people have more so and you can tell you know the closer these are to each other how many what kind of a hospital is it is it one more people stay a long time or not and then this is the gross patient revenue and don't get me started on that if you want to know about that watch my lecture on financing and reimbursement in the U.S. healthcare system that's in my other playlist not my statistics one all right so I took all these and I put it on in excel and what I want you to do is pretend that this isn't public data you know pretend this is more like private pretend these are participants in a clinical trial and you have done the the beginning stuff with them so what's the beginning stuff is you've let me stop you've already done the beginning stuff which is you first had inclusion exclusion criteria and so you went out and you said well you have to have a blood pressure between here and here and you have to be this age or whatever and you figured out that they were eligible then you sat down with them and you went through a consent process where you showed them consent form you told them everything they're gonna have to do in the clinical trial and they were like yeah yeah yeah I guess so and let's say that you felt convinced that they understood what they were talking about and what you were talking about you're going to get them in this clinical trial and they signed the consent form they say okay here I am then you go okay I'm going to measure your baseline data so you measure the baseline and then you've got the spreadsheet of data I guess that was it the spreadsheet of data and then now is time for you to do something with it so if you're doing an observational study you might have gathered a bunch of data from these people obviously for the observational study you don't have to put them in any groups but you have to create a study ID for them so maybe they have a unique ID like a medical records number or a social security number that's private and you don't want to use it you don't want to use any of those numbers and also I just found when I worked at the army I found people would have duplicate social security numbers that's not supposed to happen but people have a typo or there's some issues duplicates happen when they're not supposed to happen that's just life and data science okay so the best thing to do in the study is assign everyone a study ID and I mean that even if you're not saying people if you're saying animals or you're studying hospitals or whatever assign everybody a study ID now you can do that just by you know sequentially numbering them as they consent but if you just have a spreadsheet of data like we do with these hospitals you know how do you assign a study ID so I'm going to start by um sharing my screen here and we're going to go over to the to my data okay so what did I do here so so this is all I did was I copied the data and I changed these to like names of columns that look like here let me make sure this looks good here yeah um names of columns that like you would have like pat days instead of patient days okay I also added this column actually let me show you how I did it how I added this column this is what started out is I just put this up there and I put um I highlighted this and I right click I like to right click and I put insert because if you highlight something and then you right click and put insert it'll do that like if you do that with a row and then insert it'll insert a row but now I'm going to do controls because I want it okay so I just put the word order because this is the order that they came in at and this is alphabetical order so let's say this was like a class or something everybody already knows that every with last name of a b whatever's at the top and the z's are at the bottom and so it's like everybody knows the order but maybe I just want to create the order so I type one two three then I highlight these three okay now in excel I want you to notice the cursor okay see how it's uh hopefully you can see this this is an arrow okay now when I go down here see this fat plus it's like a fat plus now I'm going to go on this corner okay as I go down see that plus with the barbs on it like I call them barbs they're arrows right but if I go over here on the correct the barbs disappear see how it's a plus with like no arrows and it's not fat that's how you do what I call draggy draggy you can drag it down we created this pattern and now we're going to drag it down and you can kind of see see that 10 it's like filling them in okay draggy draggy oh okay okay we get 72 so we have 72 let me save this and by the way how I got this could be up here like if if you're this is all see home here let's view where's this view yeah view see this freeze panes I'm going to go here and put on freeze panes and what like if you do that see how when I scroll down to 42 like you can't see anything okay if I go back here and I go up and I click on the one I click below the pane I want frozen I can go up here and do freeze panes and then when I go down it'll stay which I like okay so I added that the other thing I added was this column over here called metro now this is like not real data I just made this up I made it up because I wanted to show you a demonstration with something where there was a binary field so I just made this up by metro I meant remember I was saying Worcester is metro and I'm in Boston that's Metro but some of these places like Greenfield is in the middle of nowhere I think so maybe you live in Greenfield you don't agree but in any case I just made up this field and kind of flag things the way I wanted to just so I could demonstrate this certain thing okay so everybody follow me so far so what you would do is like let's say that I got this hospital and actually I've studied these hospitals they have some IDs like they have organizational IDs and stuff but I just added this order I just added this ID to them but let's say I can't use that ID because we know they're in alphabetical order and if somebody say ID is like 37 they know they're in the middle whatever we have to do a random ID okay so this is now we're thinking observational study Monica is going to give them a random ID okay so how would I do that well this is the steps I do first I create a new column here right click uh insert and I call it random and random okay and I click into the first cell up here and I type equals rand open parentheses and close parentheses and that gives me this random number between zero and one okay now I'm going to go back up here and I'm just going to hit enter see that that didn't update if I go over here see I click on it remember it was 0.77 before let me do it again see now it's 0.70 so that it likes to update a lot well I want this random number in all of them so remember what the trick I taught you I click on this see it's a fat plus now here's skinny now I'm just going to drag it down it's just going to copy everything it's going to copy that ran number 72 so there's 72 in here see these random numbers and they're just going to keep updating every time I do something like update something else they're going to change okay now I'm going to but that's fine just it's there you just leave it now I'm going to insert a new column insert and I'm going to call this see how it updated I'm going to call this study ID okay so this is where I'm going to assign them this ID and nobody's really going to know what order they were in first so what am I going to do before I do that well I'm going to highlight the whole thing that's what you can do up here I'm going to go to over to data here I'm going to do sort and guess what I'm going to sort by I'm going to sort by random right and I don't really care what it says I'm just going to sort it okay now that I'm done you'll see it's even out of order already like five nine oh two you know it just changes all the time but our original order you see the four twenty ten sixteen so this work now I'm going to put it on the study ID and the study ID is going to be like one two three see how it keeps updating then I highlight and do my right where I write this down okay okay so this is how I assign a random study ID to this group of hospitals which are pretending our patients now if I want to get back the original order I can highlight up here okay I can sort by order and get back the original order okay so for example this might be somebody's social security number in your or your medical record number right and you put this in here and then you did this random thing and you sorted them by the random and you had the study ID and now so Brockton hospital now is going to be known in your study as 39 and ad care is going to 62 and Edison Gilbert 19 and there and then you can use so let's say these were real people and I said okay thanks for being in our study I'm going to send you through email a bunch of anonymous surveys like three anonymous surveys like they went through consent right and when you go to fill those out you're going to have a link just go to the link and enter your study ID as the first question well when you think about that that's a very secure way of getting research data because even though they consented if somebody hacks that data like you're using survey monkey or something someone hacks that data and they find out oh you know this person here study ID 39 has HIV or has vital cancer or something they they they only know what study ID 39 they don't know it's medical record number whatever right and so that's why it's kind of good to do this like in general so let me go back and see if anybody's got any questions now nobody has any questions okay so this first part let me just unshare for a second so the first thing I did what I did right there was I just showed you how to put a study ID on um I I put a study ID that just said one two three four five let's say you have different sites like an A and B site and you want to use like a study ID you want to do a one a two a three and the b one b two you excel will do that they it does this incrementing thing just you know work with it and that's how I get a study ID now the problem with the study ID is this so I want you to imagine I'm the statistician and we're doing like a clinical trial and I haven't really gotten to the randomization but let's say fast forward we did a randomization and there's two groups and the people have been placed in those groups and it's double blind okay so how so how I've seen a double blind study done is they take people with high blood pressure and they have two drugs they have like the usual drug that a lot of people take in this new experimental drug and what they'll do is the the experimental drug they'll make it so you can't really tell it from the usual drug and then people who are administrative what they'll do is package up the drug to give to the participant in these packages that all look the same but they'll put a study ID on it so whatever study ID you get that's your package it's kind of like a gift whatever random your raffle gift but that means that the statistician me is going to actually randomize the study ID is on a spreadsheet and say okay hand these out and whatever study ID this person gets says what package it because that way it can be double blind right so the the clinician can be like oh I I get I just pulled up the chart where I'm recording all the random all the patients that are enrolled and the next study ID is 60 I guess I'm giving that to you and here's a bunch of drugs but no one knows the patient or the participant in the clinician they don't they don't know what drug it is whether it's a or b so I I've been sort of behind the scenes when they're trying to set that up and so but one of the things that they have to do first is realize that if somebody gets sick and goes to the emergency room we're gonna have to unblind them so we're gonna have to figure out what they're taking and of course I mean we have to know for the statistics what ID 60 took but we're gonna also have to know for the emergency room so I need to keep track of who is ID 60 in case I get we used to have pagers you know we'll get a page in the middle of the night I gotta go do a unblinding get up and go pull up the spreadsheet and figure out who is assigned to 60 so how do you do that how do you arrange all that I'm going to show you that right now is what you'd make is what's called a crosswalk um it's called so we're going to go back here and so we're going to pretend that order that hospital name is like the person's name and order is like their original number and study ID is their new number so the first thing I'm going to do is I'm going to copy this whole page and just do this in control C and then I'm going to go over here in haste okay here let's make it a little bigger okay so and I'll call this um study ID crosswalk okay this is a random thing keeps updating so I can get rid of this just right click and delete and I'm going to pretend this is the person's name so we could figure out like we could figure out who to call who emergency room call whatever and I'm going to just erase all this other data okay okay there we go this is the study ID crosswalk okay so right here we can sort this by anything let's sort it by study ID here my data has headers and okay see it's all kitty wumpas here but the study ID so let's say somebody calls me and says uh oh it's terrible this person this hospital went to the emergency room that doesn't make sense this hospital went to the emergency room and it's hospital study ID five monica go figure out um uh who it is right and it would be um the va boss but it's not really who who it is what I'd be figuring out is there'd be like a column here that would say or somewhere it would say I I think I would put it in this I'm trying to remember what I used to do because this this spreadsheet I'm making with this crosswalk uh that was so locked out almost nobody should get at it and so I I think I put the treatment assignment in here so I would then look up the treatment assignment I'd say okay study ID five what did we say was assigned to placebo or was assigned oh we were doing blood pressure study so it was assigned to drug a or drug b and so um so this is so but this is what I also use when I'm just de-identifying like if I was going to do that thing and say okay thank you hospital for consenting to be in my study we're going to send you three surveys over the next three weeks and here's your study ID and I want you to enter it and fill out our surveys and then fast forward my data analyst comes and says um you know somebody didn't you know they filled out goofy stuff and I'll say who filled out goofy stuff maybe we can ask them I'll call them and see why they filled out goofy stuff and they said five I'd look it up and say it was the VA boss I don't know why I picked out the VA I used to have a friend who worked there all right actually I still do have a friend who works there maybe she's on here are you on here Heather hi I don't think I even invite her I should invite her these things she's really smart too she's good after me all right so so far what I've done is I've shown you how to how to just number the rows automatically in excel I showed you how to make a random number that just keeps updating I showed you how to make a study ID and you know how to sort by the random number make a study ID I showed you how to make a study ID crosswalk um now uh let me go before we go on let me see if I have any questions no I don't have any questions um now we're gonna move to um um what if we wanted um to randomize okay these uh these um hospitals like in the treatment groups like we're carrying on with the thing so um I'm gonna go over here and talk about what like actually we could just do it here um there oh there's one thing I wanted to tell you about and that is rand between so let me just show you why I don't use rand between so I'm gonna copy this over here to just show you why I don't use rand between okay so um well I won't leave it on here I'll just demonstrate it so I'm gonna erase these two because this is what we started with is um just where I had order okay now we'll notice that there were 72 hospitals now when I was young and naive I thought that maybe I could just insert a column and put like a new order right and just do rand between right so how how does rand between work you do equals rand between and it's going to give you a random number in between two numbers you see this down here this top bottom top so if I said rand between five comma ten see we see five now I'm going to go enter let's see here break it down a few see five so that's what it does okay so I mistakenly thought I could do rand between like one and 72 and just get a new study ID for them okay like that but you probably have already figured out the first problem with that and the first problem with that is that every time I did something like if I go high enter the number change okay but you can you can solve that like if you if you ever needed a bunch of random numbers between one and 72 you could do this then you just copy this I'm going to put copy then I'm going to go over here and I'm going to go over home pay special and choose values because then now if I click here this says 24 whereas this says rand between whatever so you can just get a bunch of values and that's how I do it I I do this and I copy it it's like I make a little random number machine and then I just get rid of it once I get my random list but the problem is um actually let's do that let's say you know so I said okay this keeps updating we'll solve it by going copy and then just pasting it and doing paste special values and then it's stuck it's like there okay so then I got rid of this random one and I said okay yay I've got this new order I'll sort by that so I sorted by it um but as you can immediately see I got duplicates and so that's why you can't really do that um because you'll you need to have a uh a unique ID and you just won't get one that way so that's something that I wanted to show you is the reason why I do it my way to create this random or the study ID that's random you know like it's randomly assigned is this other way instead of using this random so now I'm gonna get rid of this um although I do want to say um let me just say this here I want to say that um rand between is really useful okay um I find it kind of useful for making fake data like if you want to create a fake column um and you want it to be between one and three you can say rand between one to three like if there's three different sites you're doing um but if you do that again you've got a copy and then paste values because this random number will just keep updating um so okay so that's rand between now what I'm going to talk to you about is how you do a randomization so remember in observational studies you know you'll just have you'll have a study ID and you often will have a hypothesis right like I I think that um um for instance I think that taking this kind of pain medication is associated with lower heart attack risk or something like that you could have that as a hypothesis for an observational study but what you wouldn't be doing is assigning anybody to take the pain medication you just be studying people who are already taking it or not taking it like there's people with arthritis often take pain medication so you could get people with arthritis who are not taking it and taking it and then follow them through time and when you got them in your study and it was time to make a study ID you could use my method to just give them a study ID okay but now let's turn the tables let's say that you're going to study arthritis medication you want to assign what medication they're taking okay like whether it's placebo or this pain medication whatever if you want to assign it and you want to do a double blind and all that the I I want to remind you about what actually is happening in a clinical trial because it's kind of weird imagine there are two women let's call them um Sarah and Jenny okay let's say these two women are named Sarah and Jenny okay and they're both going to be in the study form I don't know like I guess birth control pills or something let's say that we enroll Sarah she qualifies and we put her in group A then we enrolled Jenny and she qualifies and we put her in group B we are not saying that Sarah and Jenny are different people what we are saying is Jenny is the counterfactual of Sarah so we're saying Sarah let's say we give Sarah placebo Sarah is the example of Sarah not taking any drug and we give Jenny the drug then we'll say Jenny is the example of Sarah if if there was this time when Sarah split into two people she could be Sarah without drug Sarah with drug this is the time and and Jenny's just representing Sarah with the drug okay so you're probably like that's creepy right because if you knew my friends Sarah and Jenny they're really different like I can't even imagine one representing the other in a clinical trial but if you think about it if you design your inclusion and exclusion criteria for your clinical trial such that you get a very narrow range of people like for example let's say that you are staying Alzheimer's and you enroll people with a certain level of function just a certain level you're getting a very homogenous group and so if you put one in one group one in the other you're hoping they're kind of a mirror image of each other because they're so alike so that's what we're doing now is we're randomizing we're saying okay who's going to be the counterfactual of who right so let's go back and um and so remember why do we randomize okay well we you know I talked about Sarah and Jenny but randomization is really about groups it's really about let's say I just take a hundred people from Boston they're going to be all like diverse some will smoke some will some will be a B some will be and whatever my outcome is is going to probably be influenced by some of those factors and we often adjust for them and you know analyses like adjust for obesity or whatever you know risk obesity gave or whatever but when you randomize when you just roll the dice and you randomly put a hundred people in two different groups you'll be surprised at how similar those groups are so if I took a hundred people from Boston and I randomly put them in two groups and I looked at the mean age it probably wouldn't be that different now if I took a hundred people in Boston who are age 20 to 30 and looked at them in randomize and looked at the mean age it would probably be exact exactly the same but if I took a broader range you know but then if I expand that to a thousand people or a million people eventually when you split it it's the same and that's a whole idea behind machine learning and artificial intelligence which we're not doing today all right and so what I'm going to do so so the thing with machine learning and artificial intelligence is they've got boatloads of numbers they say okay here are all the visa transactions let's split them and then we're going to study these and apply the model of these right well we don't really have the luxury of a million transactions if we're studying arthritics and giving them some you know pain medication right like I'm remembering a real life study you can read about it it's one of my publications with my friend Bob where there were 30 people in the study we only had 30 people we're studying pathology trainees and that's all that there were and we had to randomize them into two groups because they were going to get two different educational things and we really wanted them to be like comparable you know because some trainees took a long longer time than others and the problem was we had so few people some of our randomization wasn't very random so like I've been helping I have a Chinese Chinese customer and she's making some with some materials in Chinese and I can't read Chinese and one of them she made was an online quiz and I was just testing the quiz you know see if it worked and one of the times I tested the quiz I got 100% I can't even read it and so that's kind of what that that illustrates is that when you do randomization with just a few people sometimes you can end up with all of a certain group in one spot you know like if there is men and women in that 30 I might end up with all the women in one of the groups if there weren't as many women you know what I mean and so sometimes you have to randomize and throw away a randomization it's like you have to re-roll the dice a few times until you see something you don't have to do this with big numbers just the small ones so I'm going to just kind of show you how to randomize into two groups and then I got a special treat for you is I'm going to show you how to do a blocked randomization and why you would do that all right so let's go back to our fake data actually it's real data about fake participants okay so let's go back to our data here so let's pretend that so we have the study ID here let me just sort by study ID okay so we've got we've got all these participants we have 72 participants okay we're having fantasy uh we started a clinical trial and we said you have to meet this inclusion exclusion criteria and um and the 72 participants did and now we want to randomize them okay so uh what what should we do let's go uh copy this and I'll put it up there and the first thing I'm going to do is just copy it I just copied that up here okay well we already have this random thing that keeps updating now I can get complicated on you but let's just say we're randomizing them into two groups okay um what I could so I already know that there's 72 of them so if I were to make the groups half and half what is that that's 36 in each group I'm so bad at math so I want to put 36 in one group and 36 in the other so let's just um let's just sort this again by a random number right because we can get back the original order we can get back to study ID let's sort by random again and and let's make a new um let's make a new field we'll call it actually let me put it over here by house we'll say we'll call it treatment okay and I'm gonna make it be one for meaning they're going on treatment or zero meaning they're not getting a treatment okay so uh I want like the 36 of them to be on treatment so I could just go here like one two three four I'm just going to drag this down to 36 and you can kind of see it oh that went too far like I literally do this 26 okay here's 36 okay so these are the first 36 rows so I'm going to just give them the treatment right because and this keeps updating just ignore it ignore it okay so they get the treatment okay and everybody else does that yep everybody else doesn't so the everybody else gets a zero I'm just copying the zero and putting it okay and then I can just erase this I just did that to make sure I got the right one okay so now let's go back and sort by study ID again okay so now what do we have let me see this we've got we still have this random that I just keep living there we have this order um which we the original like their medical record number whatever their names so we know who they are and we have their treatment assignment and I guess this is maybe the best time for me to do like this copy this go over to our study ID crosswalk and then go there that's probably what I do I can get rid of those here so this is what I would use then to unblind is I'd have this treatment assignment in there all right so this is um randomized okay and so what what I did with my friend let me um so what I did with my friend is I just took 72 things and randomized them and I didn't really look at them if let's one of the things that I noticed when I went through and I flagged them as rule or I didn't say rule I'm metro or not later I kind of looked at and I said you know there's a lot of metro areas in Massachusetts there's not as many non metro ones well let's say I did this randomization I looked at it and then all the non metro ones ended up in one group and none of them in the other you'd be like well Monica you should have predicted that because you're the one who did the sampling lecture that says when you do simple random sampling which is what we're doing uh you can get imbalances like that so that's the problem with simple random sampling now if you only have uh like like one thing I could do is just throw away the randomization right and just like I could just sort it again and look at what I got and so like um so that's an option just throw away the randomization get another one um and that's what I did with my friend like you know if all the women that ended up in one group you know we only have 30 I just did the randomization again whatever you do don't pick don't do anything picky like don't use your hat just use the randomization you know like what kind of I'll tell you this funny story um the same friend Bob one day brought he's a pathologist he brought me um a an excel sheet that was had 40 rows on it and each one of them had was a tumor and had some information about it and he said Monica let's write a paper with my friend I forgot the friend's name the the friend who had given it to him and he and I said this is great and he said but I'm having a problem is the before the friend met me he wrote an abstract and published it and he got a mean from one of these variables and I can't get that mean and I'm like yeah I don't know I mean he just took 40 people with tumors right he's like yeah so we met with a friend and I said okay would I take the mean I get all this but maybe you did a mean of a group like because they had diagnostic groups and the friend I still remember the friend said no I just picked out what values to put in the me and we're like just pick them out like you pick flowers or you pick up fruit at the grocery I mean how do you pick them and he's like well this guy was high on this and low on this he was looking at lab values pathologists so I picked him but this other guy wasn't I don't know I just I didn't think we measured it very well I didn't pick him I'm like you can't do that you have to use the statistics you always have to be guided by numbers you know even when you're getting rid of people and you're a data set so whatever but so what I'm gonna do now is demonstrate what you can do if you've got this problem that I could have with this data set we're not we're I'm taking a simple random sample like I just showed you but the there's this characteristic which I'll show you here we'll look at what I'm talking about there's this characteristic this is it this metro here and actually let me just sort by metro and I'll show you and again this is not really a real I just kind of made this up so you can see here here all the zeros see there's only about 27 of these 72 that are in the non-metro area so um so I could end up with a bad situation with my randomization so um what I'm gonna do I don't know where to put this so I'm gonna show you how to do a blocked randomization it's probably easier for me to just show you than um to explain what I'm doing first we'll just sort this by study idea right okay now I'm gonna do this thing where I make two lists I make a list of the metro in the non-metro so first I'm gonna call this metro I'm gonna call this non-metro okay just to remind myself what I'm doing then over here I'm gonna copy this I'm gonna just remove this treatment because we're gonna make a new one um and I'm also gonna copy this over here I'm just copying the whole thing I'm just getting rid of the random order thing okay or maybe I want to keep it yeah let me keep it let me keep the random order thing never know when you're gonna need that okay so so that's what I did first okay so that's just a copy now my goal is to remove the non-metro ones from the metro one so I'm gonna go sort this by metro and see these are the non-metro ones so I'm gonna go and remove them all the zeros and then right click and delete then this one over here I'm gonna sort this by metro and then remove the opposite remove the metro ones okay so I split the list so that's the first thing you do okay so the list is split now now metro is separate from non-metro there's no copies okay now I'm gonna create a sheet called blocks and I'm just gonna format a little bit here because otherwise it's totally annoying um we'll just do that text here and I'm gonna call this block block num for block number okay then I'm gonna call this metro id and non-metro id okay now how many blocks are we gonna have I don't know how many um let's I'm gonna just make 10 for you six seven eight nine ten and you're probably like what are you been doing so I'll show you okay so the goal is to fully make pairs of metro id and non-metro id but we don't want them to be obvious so let's go and sort by um again the random id that's why I decided to keep it so we're I'm sorting both of the metro and the non-metro by the random id just once so I can put them in the random order okay so here we have in the metro the first study id we have is 70 so I'm gonna put that 70 and in the non-metro the first study id we have is 44 okay so now we created a block let's create a few more blocks um so the third one this is going to be 21 and 37 so 21 37 okay and then this one it's 62 and 60 kind of close 62 and okay now let's say we filled this in all the way down here now remember my problem was that I was getting all for example the non-metros in one group if I pretend these are filled in if I do a random number here and see remember rand that if I do this and I'm just gonna drag it down here okay I've got 10 units of course I would really have at least 30 but I'm just showing you this first I start by random and then now I can do the treatment right and let's say I do five and then five see how if these were really filled in it would be forced to have equal metro and non-metro and if this were filled in here the placebo group or whatever it was the control group would be forced to have equal numbers it would have five metros and five non- metros and it would be totally random like they wouldn't even know that that happened so that's what's called a blocked randomization and that's why you do it is to make sure that you have an evenness of something of a characteristic that it's coming out uneven when you do it the other way all right so let me stop here okay well I didn't get any questions or if you're asking questions it's because the chat doesn't work and I don't know about you asking questions but anyway I just thought I'd hold this little live stream to show you these tricks with Rand and Rand between although I didn't really show you much good to do with Rand between with this effort so don't bother with Rand between for doing this but Rand between is a good function you can use it for other things but Rand I definitely use Rand and you see I spend a lot of time sorting things and creating um orders and creating columns um and that and I do that in Excel now I use R I use SAS and obviously if we were dealing with a list of transactions you know I couldn't be doing this in Excel what's nice to do in Excel though is you can take some of those transactions you take like 100 and just play with it in Excel and decide how you want to de-identify or how you want to identify things or how you want to do a black randomization you can like I always think of Excel as kind of like a little sandbox where I can figure out how I want to do something before I go to SAS or R so whatever I program I you know I don't go oh maybe I should put a random color maybe I should throw this away or maybe I should pair this up you know that that process I did where I looked up the block I was making the block I looked at the first one I looked at the second you could do that so easily automated in um a uh statistical software oh I got a comment here thanks Monica I had to randomize something on the fly just now and ran between is a great function to know awesome I'm so glad I'm definitely applied not theoretical okay awesome I'm so glad you're already like I'm selling random and I even sold a ran between today makes me feel good um all right so yeah so as you can see the um things that I'm doing in Excel or that you could do in SAS and R these things they're not statistics okay it's not math it's research administration and that's often the thing that makes or breaks your study it's like do you remember a treatment group you would sign these people to do you know who these study IDs are do you know what's going on so if you suddenly feel like your heart's in your throat you don't know what's going on I suggest you take my data curation course that's course bubbled up from all the stuff I was like you guys should have kept track of this um and you're like okay I'll keep track of that how do you keep track of it right like those spreadsheets I just made they come naturally to me they don't come naturally to everybody so if you want to learn more about things like that like how how do you even keep track of this how do you even plan this I just did this demonstration but there's a lot of things I know how to keep track of I've done a lot of research administration because I think you know when you're an epidemiologist you're just kind of stuck with it it's kind of like I have a friend who's a musician maybe he's on here um and when you're a musician you're stuck dealing with sound you're just stuck with it you've got to deal with sound you've got to protect sound or whatever and you know when when you're an epidemiologist not a laboratory statistician or laboratory technician or something but an epidemiologist like you're always going to the IRB you're always writing protocol um you know excel is so much your friend word is your friend you're not making beautiful stuff you're making stuff like what I just showed you you're doing research administration which is really important that's that's how you make sure you're doing ethics that's how you make sure you're the right answer and a lot of people just don't really teach it or they don't really know how to do it so I'm trying to fill in the blanks with those all right well thank you to everybody who showed up today and um made with in my audience because I always feel better when there's more people in my audience um if you liked what you heard either you showed up today or you um are listening to this afterwards and you like what you heard please like hit the like button I don't know how to talk because I just talked for an hour and also you know please subscribe because that's actually what I'm trying to do this year is get more subscribers on my youtube channel it's been around for a long time it's kind of like I'd like to think of it as like you know when you have a there's a vacation place nobody's seen before but it's so beautiful but then when everybody gets there it's not going to be so beautiful anywhere so it's still beautiful it's still pristine my my um channel is still like only 3000 subscribers so now is the time to get in there and start making comments and uh and be a star and really support me all right well thanks so much for showing up it's a Saturday so and it's beautiful weather today in Boston so hopefully you'll get out and do something fun um thanks very much and I look forward to seeing you in the chat on my next


Hi everybody. Happy Sunday. Joe for jaspyscasefrakes.com here with 2021-22 Panini Revolution Basketball Eight-Box Intercase. Pick your team number seven. All card ship, a lot of fun stuff, a lot of fun parallels here. And an intercase from a fresh master case. So thanks everyone for joining us and spending a bit of your Sunday with us. I'll show you the list of people in Pick your team seven in just a second. Select the intercase first. So we're going to select that die right there. We'll go one, two, three for the left side, four, five, six for the right side. And it's three left side. This is four, five, six. So this we will save for next time. Pick your team number eight, which is on the site right now with the same discount for those of you watching live. And thanks everybody who picked their teams on a Sunday, first of the month. Kind of weird not having like three basketball playoff games in the late afternoon or evening. The two playoff games already sorted out today. So in the early game Milwaukee in Boston beat the Celtics 101-89. Who does everyone have in that series? We're talking a little bit of just off camera. I think before we start this recording, I think it's going to be a good series. I hope it goes like six or seven games. I think we were talking earlier, Adam was suggesting earlier that listen, Celtics had a little bit of a longer layoff. So slow start. Tatum and Brown aren't going to play as poorly as they did today. And eventually the loss of Chris Middleton is going to have to catch up with the buck sooner or rather sooner or later. See, Burge, what's going on? I got a Mahom select rookie from a break the other day. It was graded by PSA, graded as just RC 103 looked at, and it's a silver prism, but it makes no note on the label. Sometimes they don't. I think PSA often goes by how the submitter provides the text. They may have just forgotten. As long as it's clear from the card, it will still hold the value as if it was silver. It's Paul George, Groove Parallel, and that's a Porzingis autograph. Kind of looks like Pony, right? Pony autograph. Kevin with the Wizards. And we've got a out of 149 impact parallel for the Pelicans. Dong Hyun with that one. 40 out of 149. And Revolution also I think is one of the first products that has the mid-season trades. They have them in their current uniforms. It's Aaron Wigginsgroove, Aaron Gordon Astro, and a Tyler Hero Summers 12 out of 60. Nice one for the Miami Heat. Brian with the Heat. Got Philly's ad-mets on in the background. There's Austin Reeves, Astro, and then Evan Mobley. Cleveland! This is for you! See, Burge. Last bomb, Mojo. Box two. I feel like the crowd noises mixed a little high on this. Mixed a little too loud. ESPN. Alright, next box. We got Yannis with 24 points a day, 13 rebounds, 12 assists. Bobby Portis 15 points, 11 rebounds. Drew Holiday 25 points, 9 rebounds, 5 assists, and a few steals too. Grayson Allen 3 for 6 from 3. Celtics, Tatum 21 points, 6 rebounds, 6 assists, couple steals. Al Horford 12 points, 10 rebounds, a few assists. Jalen Brown 12 points, 4 assists, and a couple steals, 9 rebounds. Milwaukee did what they needed to do. They won that game on the road. What did everyone think about the Warriors Grizzlies game? I think that one was a little more exciting. A lot of back and forth in this game. Warriors ended up winning 1-17, 1-16. They are another road team. Taking one away from the home team. Steph Curry, Grew, Sano Obi, Jericho Sims, Rookie Astro.   Looks pretty cool. That's for Dallas. That's going to go to Dung Hyun. And we've got another Tyler Hero Sunburst, 11 out of 60. That's a cool pattern. Another one for Brian and the Miami Heat. And a Jalen Green Supernova insert. For Houston that will be for Aime. Next box. Steph Curry 24 points, 5-12 from 3. Pretty good day for him. Andrew Wiggins, 17 points. Clay Thompson 15 points. Gary Payton playing some meaningful minutes. Jordan Poole 31 points, 8 rebounds, 9 assists. A couple blocks in the mix as well. A plus-10 on the plus-minus. Team leading plus-10. Grizzlies, they had a pretty good game too. John Moran 34 points, 10 assists, 9 rebounds, almost triple-doubling. A few steals. Jaren Jackson Jr. 33 points, 10 rebounds and an assist. If they got, Brian and Clark had almost a double-double. D'Anthony Melton at 14 points. They got a little bit more from Dylan Brooks, Xavier Tillman, Desmond Bay, and that could be a W for them. That should be a good series. I'm hoping for seven games. We've got a Sam Jones, old Celtics auto. That's going to go to Aime in the Boston Celtics. Fractal parallel, 14 out of 100. And we've got an impact. There's a Luc Adanche. It's all cardship. You'll get that, Dallas. 62 out of 149. Julius Randall. New York Knicks, Stacy with the New York Knicks.  John Collins for Aime and Atlanta. Yeah, Ryan, that NFL mixer's pretty close. Think just a handful of spots and a filler. 51 out of 75. Clint Capella. Love the 75th anniversary look. Kind of a cool background there. 51 out of 75 for Aime and Atlanta. And there's a Scotty Barnes vortex insert for Toronto. That'll be for Aime. All right, next box. Anyone have any thoughts on tomorrow's games? What's the schedule tomorrow? I'll be breaking tomorrow on Monday. We've got two game ones. Philadelphia at Miami. They're both TNT games. Philadelphia at Miami. Dallas at Phoenix. Everyone's thoughts on those games. Philadelphia, that's going to be a rough go for them. No Joe L&B'd. I think they said that he's got some sort of orbital, some eye fracture or something like that. But they're going to say he's going to try to make it to game three or four. That's going to be a rough early few games for Philadelphia, I think. They're missing, I mean, I guess James Harden. Tyrese Maxie, guys like that really have to step up. To make up for the loss of Joe L&B'd. What's the line on that? Philadelphia plus seven and a half. Interesting. Bryce Harper just homeworked. There's a Jalen Green rookie revolution insert. And we got it. Ooh, nice. Josh Giddy impact. 143 out of 149. He definitely made a nice impact on the OKC Thunder. Johnny and the Thunder. Nice. Matt DeLeo, what's up? Matt's like, hey, not so fast Joe. Take a look at that Miami injury list. That's true. You're right. A lot of day-to-days. PJ Tucker, Jimmy Butler, Marquise Morris, Kayla Martin, Tyler Hero. A lot of day-to-days there. I think Jimmy Butler should be fine. But yeah, if they missed some of those other guys, that might be an issue. So Matt, are you telling me, and are you telling me that we're leaning sixers plus seven and a half? It's Jonathan Kaminga. Groove parallel for the Warriors. That's for Dan. Oh, are those all COVID protocol? Shockwave, Scotty Barnes insert for AIM and the Raptors. Julius Randall Fractal. Maybe I am taking Philadelphia plus seven and a half. There's Jalen Green base rookie for Houston. That is for AIM. There's another Jalen Green supernova. There's Josh Giddy right there. Interesting. No COVID. Oh, they're just sick. Just illness. Interesting. That might slow them down a little bit, especially if the sixers come out firing them. Matt's taking the sixers. Don't be surprised if they take one or two. Right, if they can steal a game in Miami and then just grind it out until Joel and Bied comes back, then we've got a series. I lost both of my picks today. I had laid the points with Boston and I had laid the points with Golden State. Golden State one by one. I think I had the minus one and a half or two and a half or something like that. I wasn't close with Boston. I'll have to think about that game. All right, Matt. Good call. Good call. What about Dallas at Phoenix? Who does everyone have there? Dallas at Phoenix. I think the injury report looks pretty clean for both teams. At least as of now, according to ESPN, there's nobody on the injured list. No designations. Behind Lugans Dort is a Celtic, another Sam Jones autograph. Steve Burch has Dallas. Winning the whole thing or winning game one. Davion Mitchell going for Dong Hyun. And Kyrie, 146 out of 149. And that's what we'll have to retool a little bit for next year as well, Brian. Just like, just like my Lakers. Kind of a similar situation. Kessler Edwards, Groove, another Josh Giddy. And RJ Barrett Astro. Steve Burch has Dallas for game one. Base Josh Giddy. There's a Franz Wagner for Orlando. And a cubic Aaron Gordon, 22 out of 50. If Denver gets, if they get a healthy Jamal Murray and Michael Porter Jr., it could be a very good team next year. There's Kaminga Astro Parallel. And we've got a die cut back here. That is LeBron James.  Dallas is a, Dallas is plus five and a half road dogs. We'll, we'll be watching both of those games tomorrow. So, you know, a two screen day like most days. Keep a screen on for the sports. Keep a screen on for Jaspies. And we can chat about the game while we hang out, hang out together, chat about the game group break at the same time. So, all of these series are two, two, one, one, one, right? Yeah, that's what it looks like. Sons have the first two home games, and the Mavs have the next two home games, and they switch as one, one, one, if necessary, five, six, seven. Does it change in the finals? Does it go two, three, two in the finals? I forget, every year I forget.  And we've got a Fox in the Box, the Iron Fox, 1960 sunburst. Almost like, like guitars from the 60s, man, that sunburst pattern popularized there. Sacramento Kings, Dong Hyun with that one. There's Michael Porter Jr. right here. We've got a Vortex, Evan Mobley for Cleveland. Bones Highland. I don't know if the Nuggets have a full-string squad. I don't know how many minutes Bones Highland is going to get, but it looked pretty good during the playoffs. There's a base Evan Mobley. All right, two more boxes to go.  Discount automatically applied at checkout. Discount subject to be canceled at any time. Go back to full price at any time. I think I might be tempted to take the Mavs, plus five and a half. Take the two Road Dogs tomorrow. I'll have my official picks tomorrow for entertainment purposes only. My baseball picks still rocked. I gotta keep working, dig myself out of that hole. Second to last box, Norman Powell Astro. Got a shockwave, Cade Cunningham. Descent to Murray. Anna Johns and Kaminga Fractal Autograph. Nice one for Dan and the Warriors. 26 out of 100. Did he get any minutes today? He did. 15 minutes, six points and 15 minutes. 6.6 rebounds and assist and a steal. Nice. Got a Kevin Durant. 38 out of 149. Impact for Brian and the Nets. James Harden Supernova. He may have to go Supernova. It's for the first few games while Joel and Vita's out. Final box coming up. Good luck, ladies and gentlemen. Thanks everybody for joining the break. Thanks everybody for spending a bit of your Sunday with me. I appreciate that. More breaks to do on jaskyscasebreaks.com. If you want to get into the action with us. Thank you. We have not seen the Galactic Parallel yet. I don't know if that short print is one per intercase or is it one per master case. I forget. Someone let me know if you know in the chat. We have not seen that yet. I don't even know if they're guaranteed. But none yet. Evan Mobley and other bass. And we've got a Jared Butler Jazz 47 out of 99 Cosmic Parallel in Utah. Rick with the Jazz. There's Evan Mobley here. Aaron Johnson. Aaron Gordon Astro. Evan Mobley Rookie Revolution.  Zac Levine. Fractal. Balanchunus. And a Josh Christopher Astro Parallel. And there's Bones Highland on the back there. There you go, gang. Jeremy Harder saying usually one per master case. So we did not see the galactic on this side. Hopefully it's on the other side, which is available right now on jazzy's casebreaks.com. Thanks for watching. Thanks for breaking with us. I'm Joe and I'll see you next time for the next basketball break. Bye-bye.