statistics and excel bell curve batting average comparison part number two get ready taking a deep breath holding it in for 10 seconds looking forward to a smooth soothing excel your first a word from our sponsor yeah actually we're sponsoring ourselves on this one because apparently the merchandisers they don't want to be seen with us but but that's okay whatever because our merchandise is is better than their stupid stuff anyways like our crunching numbers is my cardio product line now I'm not saying that subscribing to this channel crunching numbers with us will make you thin fit and healthy or anything however it does seem like it works for her just saying so you know subscribe hit the bell thing and buy some merchandise so you can make the world a better place by sharing your accounting instruction exercise routine if you would like a commercial free experience consider subscribing to our website at accounting instruction dot com or accounting instruction dot think of it dot com we are in excel if you don't have access to this workbook that's okay because we basically built this from a blank worksheet but we started in a prior presentation so if you're starting from a blank worksheet you may want to begin back there however if you do have access to this workbook there's six tabs currently down below the two example tabs in essence answer keys the two practice tabs having pre-formatted cells so you can get to the heart of the practice problem the two blank tabs is where we started with a blank worksheet and are continuing at this point in time quick recap of what we did last time we went online to find some resources for baseball statistics we downloaded them in a CSV or comma deliminated type of format and then we put them into our blank data so that we can sort the information populated in a table filter it pick up what we need and then copy it over to our blank tab looking at just basically the batting averages we converted the batting averages to a decimal format so that we have whole numbers with them now so now we have the 60 representing basically the 60 percent here for 2000 or 1920 and 2022 so we have the two years so that we can compare the two we did our standard data calculations the mean standard deviation median mode for 1920 and 2022 looking at the differences between the two we noted that the mean is similar to the median and mode for both years which would indicate that we could have a bell shaped curve which might help us with our comparisons so now we are constructing our bell shaped curve starting with the 1920 data we plotted from negative five which is unusual you might say why would we have an X of negative five the batting averages would need to be between one and 100 but four standard deviations goes down to negative five here and so we want to have all of the data that we could on the bell curve so we have a nice smooth bell curve and we can kind of double check that our data adds up to 100 as we did here when we did our norm dot dist calculation this set of data basically adds up to 100 percent now and that is useful to be able to see that and in part it's doable because we converted the stats which were in percent or decimal format to you know whole numbers okay so now let's also do our z-score which is a nice thing to be able to look at especially when we're comparing two different years because when we're talking about people's batting averages we might say well look at the things were a lot different in 1920 than 2022 but we can see where they were relative to the field at that point in time relative to the mean and that's going to give the z-score how far away from that middle point so I can go to the home tab font group let's make this black white let's center it and do the z-score so the z-score is going to be equal to brackets I'm going to take the x value which is a negative five in this case minus the mean the distance from the mean for 1920 data closed up the brackets and divide that by the standard deviation so there we have it and enter now I want to copy that down so I'm going to double click on it anything that's not in the current field I'm working in then I want to make absolute that's going to be these two and column J so the J2 I'll put my cursor in there F4 and the keyboard dollar sign before the J and the two put my cursor on J3 F4 on the keyboard or dollar sign before the J and the three enter back on it double click in the fill handle to bring it on down so there we have it so if we're looking at a like a a 32% batting average then that's 3.08 likelihood for that exact area and it's 1.06 on the z-score or 1.06 away from the middle point the middle point being right here at around 24 to 25 that's where the z-score hits zero because of course that is the mean for the 1920 data so then we can also take a look and and try to compare this to our actual data so what I'm going to do now is pick up our actual data to compare to the actual data we could take these percentages and multiply them times the count over here let's calculate the count the count equals count and then I'll take my data for 1920 so it's just going to count all of the data and enter so there's 629 count over here this is going to be equal to the count and we'll count this data and here we have 822 so I could multiply these percentages times the 629 and get whole and get numbers that we would think would basically represent if I had that sample using like the bell curve data or I could try to convert my data into percentages so I can compare and that's probably the better way to go here so what I'm going to do is call this the frequency so this is going to be the frequency and I'm gonna say let's make that home tab let's say actual actual data frequency and let's wrap the text home tab alignment wrap the text center it and make it black and white and so there we go that should work I'll check the spelling hopefully later and the frequency we're going to see how many times in this data set do we get a count of x so x being in this case above five and less than or equal to four or four if I was talking down here which would be more common for batting average right it would be up to one up to an including one from zero zero to one that's what the frequency is going to give us it's our buckets so I'm going to say this equals the frequency which is a spill array the data set I'm going to pick over the data which is over here and say boom there's our data and then comma and now we want the bins array which is going to be this information control shift down and control backspace there we have in it cloning close up the table and enter and it spills it on down so there we have our accounts it's going a little far here so I'd like to remove that last one or actually it has a number in it so maybe I should make this go down one more go down to 55 just so we can include that last number and so okay so there we have it and then I'm going to total this and and then sum it up over here so if I sum this up by the way I should get alt equal that should be a hundred or one home tab no numbers percentify and this one over here if I say alt equals we're going to get to the 629 which should be our account right there's the 629 that's a check a double check that we've kind of got all of our information now instead of multiplying these percentages times 629 so I can compare to the frequency I'm going to take the percent percent of total the percent of the total so that we can convert this into percentages which I can compare to these numbers then on the actual data so actual let's say actual actual percent of total home tab alignment center rapid black white and then we'll put our cursor here this is going to be equal to this divided by I'm going to put my cursor in the data so I can say control shift down taking me to the bottom picking up the 629 I'm going to say f4 on the keyboard to make it absolute so there we have it so we're going to take each one of these divided by the total enter and let's make that into a percent home tab number percentify add some decimals putting our cursor on the fill handle double clicking it taking it on down so now we've got our percentage use comparisons so this compared to this now this compared to this this is our bell curve this is the actual percent of total data let's look at our differences then we could say that well it's the difference between the actual and our percent data home tab no font group black white alignment center and let's say this is going to be equal to the p of x minus the actual percent of total making that a percent home tab number percentify adding some decimals double-click in the fill handle to take it on down so we can see the differences there so it looks like it lines up pretty good pretty good now we could actually plot this information we can plot these two basically on top of each other to see how closely they line up the bell curve and the actual percent of total so we'll pick up control shift down and then shift up so I don't pick up the total control backspace so I get back to the top and then insert charts we're gonna put a bar graph and boom so there's our actual data looks very bell ish bellish shaped and let's say this is for 1920 comparison and then I'm gonna pick up the actual in data so let's put our cursor here let's go to the chart and let's add the data I need to first pick up my proper X's so these X's aren't right I need to pick them up over here so I'm gonna edit and then select this one and go into our X's like we do every time control shift down and shift back so I don't pick up the total enter okay so it looks like it's got the correct X's so I'm gonna say okay got the correct X's because we went to Texas and found all of my X's that's a song sorry that's a song I got distracted all of my X's are in Texas anyway we're gonna I don't know why that song just would you would you delete that stew Phil would you delete that cuz that shouldn't be in there select that's my editor we're gonna then go into here and and we're gonna say now we'll then take this and say we want to select the data and we want to say that we have add let's add the next data set which is gonna be named the actual percent of total and then we'll take our column over here and pick that one up and say percent boom looks good okay and okay so now we've got the two on the same so you can see that that let's add a legend let's add a legend I thought it was gonna put a picture of me right in there cuz I'm a legend I thought it was just gonna put my portrait on the side whatever anyways you can see that the that the actual data is pretty close you know so you could see to the to the bell shaped curve which means that the bell shaped curve should give us some predictive power over what we're doing here so let's pull that on down now we could of course make an area type of graph as well but let's what I want to do now is do the same kind of thing for for the next year let's put let's put something above this so that we can show that it's 1920 data so I'm gonna select all of this information and right click and then insert and shift it down shift it down okay and then this is gonna be 1920 and let's make that number format and let's just make it a general and then I'm gonna select that and I'm gonna I'm gonna copy it across I'm not gonna some people might merge I don't like to merge so I'd rather right click and then format the cells so and then go into the alignment and then I want it to be horizontal center across the selection so that'll put it in the middle without combining so they're still separate cells but it's like in the middle and then I can go into the home tab and let's make it a different color like a blue maybe let's make it blue and white so that's the 2020 stuff all right let's now do the stuff for for 2022 so I might be able to hide some data first let's make a skinny T it's like mr. T got skinny because he stopped working out it's a skinny T and then we're gonna right click and then hide no one knows who mr. T is anymore whatever everybody knows mr. T man he's on the A team and so this one is blank because I hid the data all right let's do it again up top and then let's do this for 2022 so now we're on I'll put this up top 2022 formatting that home tab number let's make it general format I'll make this one green let's say so I'm gonna hit the home font group let's make it dark green and then white okay so we have the same starting point we have X's we've got the P of X P of X and then we're gonna have let's select those two I should have kept it unhidden so I can black white I'm gonna make the X a little smaller we should probably center it alignment center and then I should probably just copy the X's from what we did before but I'll recreate them well actually let's unhide and copy the exact same X's so I'm gonna I'm gonna unhide putting my cursor from L to U Lou and then right click and unhide and let's just pick up the exact same X's to make sure that we have them lined up this equals this five putting my cursor on it double clicking the fill handle it won't let me do that so I got to drag it down for crying out loud Phil why is the handle not working why is Phil's handle not working so I'm gonna scroll up we don't need the decimals decimals would you number group kindly depart so that we can get down to business over here then I'm gonna hide from M to S so miss is gonna we're gonna hide miss and then hide she's distracting people the miss okay so now we're gonna say this is gonna be equal to norm dot dist and so now we're gonna pick up the X which is now 2022 data so so I'm sorry it's gonna be that X the five comma the mean is that 22.2 for the 2022 data I want to F for it because I want to copy it down dollar sign before the K and the two so that 22.2 don't move down comma standard D that's gonna be the 6.12 F4 in other words make it absolute dollar sign before the K and the three comma cumulative no false or zero closing it up enter putting my cursor on it percentifying the cell home tab number group percentify so we can recognize and then we're gonna put our cursor on the fill handle and double-click it on down there we have it and now it adds up to 100% if I go to the total down here and we say alt equal 1 or 100 home tab number percentify decimal eyes and recognize all right so then we're gonna say the Z we can do our Z score which is important for our comparison purposes home tab font group black white let's center it let's make it a little smaller and the Z is going to be equal to brackets the five minus the X minus the mean 22.2 in this case close the brackets dividing by the standard D standard deviation 6.14 there's our Z I want to copy it down so anything that's outside of my data over here that's outside of the table I'm working in I need to make absolute that's anything in column K so that's gonna be this K2 F4 dollar sign before the K and the 2 K3 F4 dollar sign before the K and the three enter putting my cursor on the Z score double-click in it down and we can see that it gets to that zero point around 22 and 23 because that's the mean and that makes sense so we can compare the Zs for years 2022 and 1920 now let's do the actual frequency you're a frequency frequency I don't know font group black white did you just call me a freak I would know it's the freak the frequency I said I said frequency we're gonna say this is gonna be the frequency which is which is how many times it's gonna fall into the buckets for example this one being above zero up to and including one so we'll do our frequency equals frequency tab data array it's gonna be over here control shift down control backspace to get back up comma and then the bends array which are our X's which all live in Texas we try to stay out of Texas therefore I because you there's that's where the X's are and so it's not a pleasant place a lot of times that's a song okay get the song out of your head no song references no one even knows what you're talking about man no one even knows what you're talking about okay sorry but this cut there's still two down here so let's actually pull this down and bring this down to one more I'll pull these two down so that we get that last two in there and this should be 56 and then there we have it so now I can total this up this is gonna be alt equals alt equals 822 so that 822 should be the total to that so that looks good that's our check number now and now what I'd like to do I could multiply all these numbers by the 822 so I can compare it to the frequency but I'd rather make these into percentages so now I'm gonna say this is going to be the actual actual percent of total and then we're gonna go home tab font group black white wrap it center it and then we'll say this is gonna be equal to that zero divided by I'm gonna go into my data so I can go control shift down just so I can find that bottom number f4 on the keyboard dollar sign before the X and the 65 so I can copy it down not having the total move down when I do so percent to find the cell before we copy it down home tab number group percentify to recognize add some decimals fill handle double-click in it and fill fill does the calculations and there we have it so I can say alt equals that should be a hundred percent right there home tab number group percentify to recognize and so there we have now I can say the difference the difference between the actual data and the P of X data home tab font black white center is equal to P of X stuff minus actual percent of total percentify home tab number group percentify decimals double-click and fill handle to bring it on down there we have it all right so let's let's put a I have a 2000 I thought I put a 2000 oh there it is let's center this 2022 thing now selecting this whole bit up top right clicking formatting the cells and I will do this by going to the alignment group horizontal center across selection and okay you can't see it because it's in the middle now and it's white there so home tab font group bucket drop down make it green and there we have it the hiccups okay so that looks good so so now I could say that that we we do a P of X calculation so I could say well let's look what the P of X looks like control shift down and shift up to not pick up the total control backspace to get back to the top and then I'm gonna say insert charts let's put this in place with a bar chart boom and so there's our our actual data this is for 2022 comparison let's say and then I'm gonna put my actual data on top of it well first let's fix the X's the X's down here they need to be fixed something needs to be done about these X's we're gonna go to the chart design we're gonna go to select and then edit this on the left and then add our X's I'll be selecting my X's okay I'll be so you don't just give me random X's I'm the one that picks them so there they are and then we're gonna say okay and then now let's put the actual data on top of it to compare it so we're gonna go to the chart design data select and then we're gonna add more data and I'm gonna call it actual percent of total and then we're gonna say boom and let's pick up our actual data and okay okay and so now you can see this one's a little bit kind of weirder because well let's add the legend hit the plus button we're gonna add a legend and it's gonna show a picture of me oh man I'm I thought when you look it up in the dictionary legend then I thought there's a picture of me when that when you do that but no they put the legend here so then now this one you know it's a little bit more walkie but it still kind of conforms to so you think the bell curve would still give us some predictive power so we're gonna say alright let's put that down here in our collection of pictures I'll put this over here I have a lot of pictures on your phone of your family and stuff no they're of charts their chart pictures they're really important to me I have to keep them safe over there okay so now we're gonna say that we want the difference so we can call this let's put it up top differences let's say let's make that orange home tab font group drop down making it let's say dark orange or something and white and then let's put the differences for the X's and in the P of X's maybe and then we can say the differences between the actual percent of total that we can do differences on selecting these items home tab font group making it black white centered wrapping it I need to unhide my 2019-20 data which is both between L and T putting my cursor on the drop-down or on the column L to you Lou we're going to Lou and right click skip to the Lou my darling and we want to unhide where's your darling she's skipped off to the Lou skip into the Lou my darling that's a song nobody knows what you're talking about that song is ancient for crying out no need what's a Lou and okay whatever skip into the Lou man so let's just do this actually let's just pull over the X's so the X's are just gonna be this and then I'm gonna copy it down and we're gonna copy it down to here and then let's go to the home tab numbers and remove some of the decimals okay we can make this a little bit smaller possibly alright and then the P of X's I'm gonna say is equal to the difference between the 1920 P of X data so this minus then this data so you can say boom there's that and I can make it a percent possibly home tab number percentify adding some decimals double clicking to take it on down so now we're looking at the difference between 1920 and and 2022 I could do that for let's do that let's insert a cell here right click insert for the Z's as well so for the Z's I could say this equals the Z here minus the Z there so and then I don't want to make that a percent let's format this one home tab font group format paint it and so there's our difference and then I'll just double click to bring that on down we can take the differences in the actual percent of the total so this equals the actual data for to 1920 minus 2022 boom making that into a percent home tab number percent adding some decimals double clicking it on down so there's some some comparison data and then of course we could make some other graphs and try to graph these things on top of each other if we wanted to such as the 1920 P of X and the 2022 just to see them overlapping each other to see what that would look like so let's take the P of X here I'm going to say control shift down and then shift up and control backspace back to the top insert charts and let's insert a bar chart so now we have now we have P of X 2000 or 1920 verse P of X 2022 something like that and then I'll pull this on over here and let's also pull in the 2022 I need the X's so I'm going to pick up the X's too so we're going to say don't pick up the X's it's not a good idea it's not a good we have to we have to do it we're going to go in here we need our own X's it's better than just having random X's be given say that we pick them up or we get random X's okay so there we have it and then so now we're going to select the data and go into chart design select the data and I can put on top of it I'm going to add another data set and say this is going to be the second P of X or let's call it this one let's just name it P of X 2022 and then I'm going to pick this data is going to be this range P of X 2022 boom and okay so now you can see the two if we if we approximate a bell curve on the two you can see they're slightly you know this this they're slightly skewed the shape of the bell curve let's let's add a legend here legend hold on I thought I changed the name this orange one oh my data so this one let's edit this and this is 1920 so let's just call it 1920 okay so the legend and then this one let's call it edit let's make that one 2022 and okay okay so now we can see that the shapes of these on top of each other and see that it's kind of skewed and then this one obviously more peaked in 2022 and we can see the differences over here in our mean is 24 versus 22 so those middle points you would think would be 24 versus the 22 so we can see kind of the the relative data here now when we look at the z scores remember we're thinking about the z scores are relative to the middle point of of their of their distribution which we have these two different kind of bell curves based on the two different time frames so we have that and then we could do a comparison of like the percent of of the total versus the percent of the total over here but let's let's keep it at that for now and and just note then when you do some of these comparisons then sometimes the z score becomes relevant because when you're trying to compare one year versus another year you might be saying well you know if I if I if I looked at something down here and we had we had a player that had like a 30 a 30% right a batting average in 1920 and we looked at their z score which is this column and so it's at it's at 0.79 up above that average point and if I go over here the 30% if we look at the z score is 1.27 above and so if I just look at those two numbers you can say well they're both at that 30 but but if I compare it to what was happening relative this one over here in 2022 is a lot higher up you know it's so it's further away from that middle point the average of the times so you would expect you know that would that would be a differentiating factor possibly even though you're looking at the same percentages remember that the general idea of the statistics oftentimes is that I can't look at just how many at bats they have or how many times they got on base because they're going to have different at bats that's why we make the percent so so the percent already kind of evens things out a bit but it's still not going to be give us we might want to have more questions about who's the better player and what time frame and whatnot and the argument of course is going to be yeah but and the things were a lot different and in 1920 than 2022 so let's see how well that percentage was compared to the the middle point the average the z score right and that would be another another factor that you can kind of put into play let's go ahead and add some formatting here so I'm going to select all of my data here up top I'm just going to make it blue home tab font group bucket if you don't have that blue it's in the more colors there it is the blue and I like to put some borders around it if I may I'm going to do that here too you may no one's going to stop you home tab font group border blue border blue at least I don't think anyone's going to stop you I won't stop you you can make it a different color if you want I won't stop you from doing that either it's a free it's a free country man it's a free country well at least it used to be border blue I wouldn't be surprised if someone stops you now the king of England probably come in here and try to tell you what color you should make your chart home tab font group border blue and then we'll say this one home tab font group border blue and then this one uno vase moss one more time control shift down home tab font group border blue I'll make my table however I want to make my table it has only two legs on it and falls over every time I put something on it that's how I want it that's how I made it that's how it's going to be okay that's how it's going to be this is going to be center across let's make it home tab font group and orange and let's pull our graphs over here so we have all our pictures so we can see them we need to have our it's not enough just to have your pictures your special pictures you have to have them ready so that people can look at them you can show them off when at like parties and stuff so then so there they are let's go into the review and I'm not oh now it's gonna I can't spell check it because it has all the names let's try to highlight all of this stuff and just spell check it over here see if I misspelled fixing my spelling spell check frequency I knew it that wasn't actual okay we can make some skinnies let's these can be skinnier mr. T you're still not skinny enough I know you lost some weight but still all right that looks pretty good looks pretty good


Also, now I'm going to talk about the data sets, what is new for that assets and for that sets as indicators. So now the indicators are being calculated on the fly. So let me then go a bit to the to the web application. So if I'm going to maintenance, and I'm going to that asset to report the files. Okay, not here, but I just want to show the, the, the sections. Okay, and then I'll care. So now if I, if I scroll down, I see that there are two indicators that are linked to that particular section. Okay, that's important because if you want to have in your application, like for a particular that said, you want to have to visualize some indicators you need to, you need to remember that you need to assign link those indicators to a particular section otherwise they're not going to show up. Okay. So, let's see how this looks like in, in, in Android so I'm going to open my reproductive health data set in this case I only have one data value set for April 2021. Okay, and I have all these numbers there to for an attack visits. And this is a total 12. Okay, he's calculating on the fly. So if I am selecting here instead of a tool, let me just put here five. So the value of this should be like 15. Okay, so then you see how this is being calculated on the, on the fly as well.


Everybody forced you are ripping a box of 2022 immaculate baseball hobby for a Keem. D Thanks to Keem and good luck. It's probably this week Rory. I don't know for sure Okay hard not to notice this thing What Sleeve logo one-of-one patch Lars Newt bar. Oh my god Cardinals fans. What is that patch?  That is something else right there. That's pretty me too a one-of-one printing plate dual bat relic of Heimigro and Ernie Lombardi Back-to-back one-of-one's Ernie grow and Or no, a Heine grow and Ernie Lombardi Okay That's what's up to a rookie patch auto Curtis Terry 29 to 49 a Coal wind signatures for of 99 RPA of auto Lopez 10 of 72 Yeah, Heine grow is a pretty cool name and a Dale Murphy auto numbered 8 of 25 Well, that was a pretty cool box. That was good stuff a Keem Appreciate the order we will get Scards out to you in a bit


What's the one challenge that UNESCO wants to experience in this area? Let's start with your industry, just. Basically, getting into the main platforms, you know, the main challenge for the female artist, but we are getting the squeeze, see the question which is what you make it, internet, and those other platforms, so, in any kiputeki dog? Na, squeeze producer wana kwa ambia wacheka kitu na see pesa, wana pulizia ile kitu, ama wama changam kani lise. But it's important because I've met a couple of artists who have been, to say kupusana to Kond, they went and paid upfront because, you know, they wanted to do everything, coding day, lafu producer tuna kujana ames. Na kuku wasidia tena anaitisha vitu. Ya, wana juapia ina dipe na ule producer wana fanya kazinei. On my side, so far, so good. Akuna producer mi ni sumbo. Actually mi mi na wasumbwa angasana. Juki lasa ni ko, I need the beat. Twanya evi, twanya evi so na wasumbwa angasana, so to say mi na wasumbwa. I like that, I like yo kusumbwa. Walk us through the video. Wana ule ichoz kutipa eleka. Sijiwe ini wapi? Ah, that's Kibra. Yuritoi? Ya, that's Toy Matu in Kibra. Ah ya, nan metokatu kuj... We are making it look so beautiful. Mazi, how? What did you do in post-production? Ama ni steama tu? Ama ni wewa wana fanya ika ebizuri. I don't know, King's Day. Why does it look so good? Kazi safi. King's Day, it's been smart today. Why did you choose Kibra? Ok, nili kwa na other options, but Kibra, to say mi, nili feel ita kwa ma ideal place. Yusiku nili kwa na Sunday. We kwa na aputu ni omilineza pata exactly what I'm looking for. What were you looking for? Every content that you see in that video, like getting those women kwa nge kwa video, actually it was not an easy thing.  Ya, aku na amtantuka kwa nge kwa video kwa. So, but na appreciate wali kwa bali. Nani na feel kwa bit challenging. Umes mama we have so many people looking at you na shanga, umes chana na fanya ni ini. Was awan na ume, for example. It was crazy, but na shukurili happened. Ya.  Ati iku make it pekit haija kufanya wakwa kwa kwa.  Ati iku make it pekit haija kufanya wakwa kwa. I like that about you. That's why I tell you, kitu aso hengene, wuku je tu, wukamu na toa 3 p.m. wuku je 4 p.m. This is my home. Yes, literally. Literally, ya. What would you like to tell your fans out there? Sana-sana boychart. Una taka boychart na jwe ni iku suku treat gachat. Just treat them right. Mama, muna kwa na ya, kwa tufanya kenyo na ruku na penda. But respect women. That's the most important thing. Joa tami sezi kwa na mtu mene and you respect, so you should respect women. And women should start respecting yourself. Ya, na pia women you respect men. Na joa wezi ni respect and then I'm not respecting you but it's a two-way traffic. They make it sound like an empowered woman is very rude all the time. For example, say, jo mimi na jijua kamaval now me and kins, they cannot atiwak the way we're supposed to because ntataka kukompet, which is not true. I know my place. He is the lion of the house, are we together and lembe ni place then, mini gavan kai na umat, tendele atu na life but that's how it is. I came to terms with it, I've made my peace with it and we're not together. So let's not fight We're not together. We're not together. We're not together. Where can we find you on social media? Ah, Instagram wavinya underscore williams Facebook wavinya williams basically everywhere. We're not together. Actually, we're not together. We're not together. We're not together. Actually, my mum tells me Jacca Mark if lost. This is who I am. It's been a pleasure mammy. Thank you so much. Thank you so much. I can you will find out best. She is going to do some more performing and telling me about stance over wuma but since the midnight and remember please do not forget there is a roshro happening. It happened inside from Embu means Mr. and Miss Meru University So we're going to the front Miku na sisi Kwa gala Na sisi tu taku wa kwa yo gala Yes, what he said Uta pata present as water Una penda details water Una penda Fana kaki tucheza kawwe Una senda kwa itishaya macho please Just because you've seen them on TV Okay, selfie na weze Amma ukore di kutua pake


The iPhone 11 Pro Max is an interesting device. Now I have spent the last 30 days getting myself acquainted with iOS, but Apple has to offer with this new device. They are some good, there's some bad, but I have to say that Apple at least has impressed me this year. Now you guys know I'm an Android user, I usually use Galaxy devices, but this time I said look, let me spend some time to use the iPhone. First off the bat, it still feels like an iPhone, I'm not the biggest iOS fan, and I think iOS still has a long way to go, at least for me. People like it, that's fine, and this is not an OS discussion. But what does the iPhone 11 bring, especially my use case for 30 days? Now the one thing I'll say off the bat that I really like is the battery life. For me iPhones have had terrible battery life, and the increase of the battery size to 3900, 3969 milliamps is done wonders. I think it's probably the longest lasting battery I've used this year. I like that the iPhone battery is something that you can depend on, so to me that is a huge plus. Now day to day using the iPhone has been good, it's been solid, and one of the other things that of course we do on a regular basis is take photos. And the camera on the iPhone has really stepped up this year. Now we know they've always been good at video, and video has gone taking the last step again this year, 4K 60 stabilization is really good, and it's something that I think everyone has to take a look at, especially other manufacturers to see what is Apple doing here in the video department. Now in terms of photos, they've also stepped up their game as well. So we now have little life photography, it's easy to use. Some people like the fact that night mode is automatic, I like that too, but I also want to be able to turn it on. Now yes I know iOS users are not cute to that kind of stuff, but on the 11 Pro Max it's called the Pro for a reason, I want to have pro features. Now the camera app is improved, and there are a lot of things that you do well, but still Apple, simply I just want to change my video resolution or photo resolution, I can just do it right there in the app, I have to go out. There are little things like that in iOS that kind of annoy me, especially when it comes to using applications, where the back buttons are the top left down corner, I have big hands I can get to it, but it's just dumb. So those are the kind of things in iOS that really irked me, but like I said, don't get me wrong, the iPhone really impressed me this year. Now as you know I do a lot of gaming on the channel, and I've got to say one of the things that I was very skeptical about was Apple Arcade, I'm like come on Apple, you're just trying to like gouge money from people, you know, that was my mindset. Little did I know that look, they actually have a good selection of games, I will fully recommend Apple Arcade to anyone who is a gamer who loves to game, loves to play different types of games, it's definitely worth it, it's $4.99 a month, I signed up and I haven't cancelled my subscription, I had the opportunity too, but I didn't do it because Apple has filled Apple Arcade with a lot of very good games, you know, just to name a few here for you. Now besides the big stellar stuff, like look, we'll talk about you know hardcore gaming on mobile phones in a second, but you've got things like Cat Quest 2, yes, if you like cats, but if you like also adventure style games, it's a really good game, this Punch Planet, which is kind of like a fighting game, you do have Towaga, which is a really cool game that uses lights and dual joysticks there, you've also got a game called Stella, which is kind of like an adventure game, very creepy, dark motif, what you notice here is the different graphical styles, again pushing on the iPhone with that, you know, 813 processor and also like ballistic baseball, again, different games that fit different types of people, and of course you can still play your hardcore games like, you know, Fortnite, Call of Duty Mobile, which run really well on the iPhone 11 Pro Max, I play Call of Duty Mobile quite a bit, and you probably noticed a Razer case on this device, now the reason this case is here is because Razer has a case that does a lot of cooling on your device, and I have to say it is necessary if you game on the iPhone, the iPhone tends to run very hard, always has, Apple has no special cooling like other Android manufacturers do, it's just something they just don't do, so the iPhone runs really hard, you get temperatures up to like 102 degrees or so, with the Razer case, the way it's built, it's got some special cooling pads and things like that, I've noticed it drops at least the temperatures down by six degrees, so if you run 102, it goes up to like 96, then you're in power with everybody else, I like that, that's why I like using this case, granted the case is a bit bulky, bulky than my regular standards, but I do like what the case brings, you know, to the table. Now, in terms of other aspects of things that you can do with the iPhone that I've tried to use over the last 30 days, Siri was one of them, I stopped just again, something they need to improve, but the hardware itself has been really good, you know, you've got wireless charging, you've got fast charging now at 18 watts, you can also use a 30 watt charger to get a faster charger rate as well, so that's something to take note of, there are many chargers, there are anchor chargers, I'll put a list for you guys down below to allow you to get a faster charger without actually spending a lot of money on, you know, one of the Apple chargers out there. There's also a protective, screen protector from Spigen, which I do like, I know I mentioned a couple of things, but these are just the things I use on the iPhone here, it's super easy to use, Danny Wingett had a video about it, and I'll have a link for you guys down below to check it out, it's cheap, it's effective, and trust me, if you buy a device like this, it's definitely worth it. Now, in terms of the colors, I do like, you know, that midnight green, I think Apple's done a really good job with their color schemes this year, you know, I'm glad they've gone away from the, you know, gold every year, a different type of gold, I like to see stuff like this, I want to see a design change, I think the iPhone line is getting stale, I'm not a big fan of the design in general, I don't like this, you know, fidget spinner design for the camera layout, and I think it's just, it's been, I think it was just more of a logistic thing because they have the molds, it's cheaper, that's how I look at things from Apple anyway, and the notch, yeah, if you're an iOS user or an Apple user, you're used to it, but it's things like this to take away from screen real estate, don't like it, especially when you're gaming, to me it's just stupid, but hey, it is what it is, I think overall though, besides some of the negatives you've heard in this video, like I said, I've been quite impressed with the iPhone this year, especially hitting the things that it didn't do well, you know, when I said covering battery life and having probably the best battery life this year for any smartphone, at least with that battery size, things like the ROG phone, yes, some of you have mentioned that, yes, it's got a 6,000 mAh battery, it will beat any phone out there, as long as you know, even when you're gaming, it should probably still work, and then you've also got improved cameras, and you've seen some of the images we've put up here, they've done a good job improving that, please next year include night mode on the wide angle lens, but overall the camera's been really good, the video's really solid on here, and I think Apple has taken the right approach on these aspects here, I'd like to see more additives to a device like this, it's priced at $1,000 or $1,000 plus, and it comes with 64GB of storage to read, which is absolutely crazy, that's one thing at least Samsung does well, where if you're going to pay that much, give enough storage, and I know that everybody wants to move people to cloud storage, but still you're looking at something where, you know, you shouldn't be milking your users constantly for things like this, that being said though, those are my thoughts on the iPhone 11 Pro Max, I think it's a solid device, I think Apple has done a fantastic job on improving what they haven't done well, there's still a few things I'd like to see, but I am happy with it so far, anyway guys, if you have any questions or any comments about this video, if you own an 11 Pro Max and you think everything I said is completely wrong, leave your thoughts down below, if you agree with me as well, hey sure, I would love to hear your thoughts as well, otherwise guys don't forget to like, share, subscribe and always enjoy entertainment.


Hello, welcome back on my YouTube channel. In my last video, I've demonstrated how to create wedge buffers using pictures taken with merging maps in the field. This can, however, also be done on the fly and also in such a way that you can see the wedge buffers in merging maps on the mobile phone app. I'll demonstrate that in this video. Let's first install the merging plugin from the Plugins Manager. After installing the plugin, you can find it in the browser panel. Click right and choose configure. There enter the credentials of your account. Click test connection to see if your credentials are okay. You can also save the credentials to your QGIS password manager. After logging in, I have access to the projects on the merging maps cloud. Under explore, I can find the public projects and the developers of merging maps have a very nice example project for reading exit data from cameras that we need in our project. So click right and choose clone to add this to my own account and then I can find this project in the browser panel under my projects. Then I can choose download to use it locally and I can open the project. I'm going to use the app in a different area on our modern island in the Netherlands called Ameland where I'm going tomorrow. So I'm using the locator bar to locate Ameland and I find it here and I'm going to use the extent of the island of the map canvas for our project in the app. So go to the project menu and in the project properties, first you can check the settings under merging maps and adjust it to your needs. You can enable here selective sync. You can change the quality of the photos that are stored in the project or snapping options. Here I keep everything as default. Under view settings, you can set the extent of the project that will be taken over by the app. I choose here the map canvas extent, but I noticed that my project is still in EPSG 3857 while I prefer to have my project in the Dutch projection. So I'm going to change the projection of the project. I use 28992 and I set the on the fly reprojection to Amersfoort new. Just to be sure I'm going to set the extent to these new coordinates in the project projection. Note that the coordinates taken with the merging maps app are in a latitude longitude geographic coordinate system, but when we load the project it will be on the fly reprojected to the projection of this project. The cloned project comes with a backdrop of OpenStreetMap, but I would also like to demonstrate how to add another backdrop and I'm going to use here the PDOC services plugin, which is a plugin to access Dutch GIS layers and it adds this button and there I can find an actual aerial photograph or the photo with 8 centimeter resolution in WMS format. So I'm adding this to the project and let's zoom in so you can see the details. So in the field I have an internet connection so I can use this layer. Let's change the order of the layers and I'm going to make map themes, presets of layers that I want to show. So I'm going to add a theme where I just have the survey layer which is called data and the aerial photograph layer and I call this map theme aerial photograph. They create another map theme with the survey layer and OpenStreetMap and I call that one OpenStreetMap. Now you'll see later that merging maps on the mobile phone will take over these map themes so we can switch between the two easily. You can also do that in your QGIS project as I demonstrate here. So let's now check the attribute table to see which fields come in this clone project. We see that this has FID, the picture path and some of this EXIF data that we need. To see how this works we have to look at the layer properties attribute forms and there we can see how this has been set up. In the form layout there's the FID field, there's the photo field and let's change it to an image viewer so we can also see an example of the image in the attribute table form view later. There's direction, you see it's a range widget type with a slider and it uses here a function to read the EXIF direction data from the picture. The same is for latitude and longitude coordinates, they also use these functions to read the coordinates from the picture, from the EXIF information, the metadata of the picture and there are similar fields to get direction, latitude and longitude and the date from the GPS. I'm going to demonstrate if you want to add another field for example to take some notes with the picture. So I toggle to editing mode and I add a new field, I call it notes and I change it to text type and to give the amount of characters let's change it to 100 and the toggle of editing and save the new field then I go back to the layer properties and I'm going to add the notes field to the form layout by dragging it there and I can put it in the position where I want it but I want it at the bottom and I choose a multiline text widget so we can take enough notes if necessary and I can give an alias for the fields so I can call the FID the observation number. The app will show the alias. Now we need to create a nice style for these data survey points so I toggle on the layer styling panel and what we're going to do is create a symbol, an SVG marker for the camera and to use the rotation and a wedge buffer by using a geometry generator. So let's first choose the SVG marker and when we want to use SVG markers in merchant maps we need to store the SVG in the project folder. So I'm going to browse to the folder of these SVG files that come with QGIS and there's one called camera.svg and I'm going to copy this one and paste it in the folder of this project so it will be later synchronized with the cloud therefore it's important that you really have the SVG file in the folder. Let's make it a bit bigger, you can later tweak it. Now let's change the color of the SVG marker and let's use this color and I would like to have the symbol rotated with the direction field. I'm going to use here the numeric direction field. I'm going to add an extra style layer and then move it to the bottom then I'm going to use a geometry generator for that layer and that is what our polygon with the wedge buffer will be and I'm going to write an expression. I'm going to search for wedge buffer which is a function and here in the right panel you can find an explanation it needs center azimuth width outer radius so let's formulate our expression center should be equal to the geometry so the the point you see an example then azimuth that's the angle for the middle of the wedge to the point and I'm going to use there the direction then there's the width make that 45 degrees and set the outer radius to 0.0008 degrees click okay and now I'm going to change the simple fill here to a shape burst fill and I'm going to use two colors with some opacity so can we still see what's below and from that reddish kind of color to white which is completely transparent change to set distance and modify the blur strength we can play with this when we see the results so I'm going to just add a point to see how it's now going to look like and there I can use the direction slider to set the direction there I see the rotated camera and the wetroom buffer that looks already quite nice so you can play with the variables to change the looks so toggle off editing and choose this card to remove also our example point we'll save the project and click synchronize and then it shows me the changes and obviously our online layers are not synchronized but they're just loaded on the mobile phone so here I go to the mobile phone to merge in maps and under projects I find their amulant and I synchronize and then I go to the home screen and I can load the project there I can see it and let's first test those map themes so I can choose here between the aerial photograph and open street map and when I zoom in it shows me all the details from the online layer now I'm going to add a point of course this is demonstration just from inside and this how the field form looks like I want to take a picture here just of my screen click okay and you see it fills in all this active data I can make some notes here it warns me that I still need to fill in something and that is this observation number auto generate does not work here so I need to fill in a number otherwise it doesn't accept it and here on the fly it shows me the direction of the picture of course not very accurate because I'm inside but this is exactly what I wanted to achieve so I can now synchronize it back with the cloud so we can also see this observation in QGIS QGIS I click on the synchronize button it shows me the differences and it will download the observation point now I'll find it in the attribute table so I go to the form view I can see there the field form with also the preview of the picture but I need to tweak a little bit the widgets I see here the file name that's not so nice to see and all this active data is also not so interesting and let's have a look here at the point on how it looks like in QGIS this point move the selection and I zoom in I see there the watch buffer so I'm gonna remove a few of the fields that I don't want to show to the user in the form it will be stored in attribute table but not as a form view let's have a look at our form and I would still like to tweak it I'm going to add a new field because I also want to have the date in a readable form stored I can also choose date and time with here I'll choose only date and I would like to get rid of the file name so I go here after saving and I add the date by dragging it to the position where I want it so after the picture and for the picture I don't want to show the path I'm going to uncheck this box for the date I see it's already in the day month year format so I keep it like that and for the default I use $ now to show the current date and every time observation is updated it will also update the current date I give an alias date and I'm giving here the aliases in the same capital first character and I'm going to change here in the layer settings the display so that will control how we will see a preview in the app so what I would like to see is the observation number and date and a preview of the picture so I can control that with an expression I add here a string observation number and I concatenate that with the field fid then I concatenate it with new line then on the second line I would like to see the date so I use a string date and I concatenate that with the date field and then to create that picture I need to create an expression here if you use hash image it knows it has to show the image and then you need to tell where the image is stored and it starts with a file, column and tree slashes and then it needs to know the folder and that's a variable so I can click here on expression and then under variables I can find their project folder and I can click insert to add it there to the file name and to complete the path I also need the name of the file of the image which is stored in the image field so their fields and values I can find there the photo field which has the path of the picture as you can see there in the example and I also insert this expression so we now have the path to the folder in the file name of the picture I can save the project and synchronize it and here on the mobile phone app I can also synchronize and I'll add a new point it warns that the gps accuracy is low but it's just to demonstrate point number two take a picture and it shows the direction coordinates and it can take notes and it hides all the other fields and there I see the watch buffer now to show what this preview does when I click on it it shows the picture but we have added a few fields so I can better choose the new point and there you see observation number and the date and the little picture let's synchronize and see how this looks like in QGIS we synchronize it there and there's our second point in the attribute table I can see there all the fields you see for the new point that it also shows the observation number and date expression now I'm going to remove the two points because those were examples I save it attribute tables empty and I synchronize and then tomorrow I can use it on my mobile phone to map pictures that it take in Ambulant and after the weekend I can see the results here


Live from Austin, Texas, it's theCUBE. Covering Dell EMC World 2016, brought to you by Dell EMC. Now, here are your hosts, Dave Vellante and Stu Miniman. Welcome back to Austin, everybody. This is theCUBE, the worldwide leader and worldwide tech coverage and live tech coverage. Excuse me, Ashley Gorwakparwala is here. He's the president of the service solutions division at Dell EMC. Ashley, good to see you again. Congratulations on the new appointment. Oh, thank you. Welcome. Thanks for having me. How's it going? I mean, wow. Big news, big day. How's it feel? Feels pretty good. So, we got to add another number one to the big board in just calendar Q2, IDC Gartner, so on. Said we are now number one globally in server shipments. So, you know, Michael's fond of saying we're number one in everything in one place. And so, we've kind of been consistent with that. And so, right before we closed, we had number one, which is a huge milestone for Dell servers now 21 years old. And the first time in history, we've hit the number one mark, so. So that's a milestone, units. Of course, the next milestone will be dollars, I presume, is that? The next milestone will be revenue and there's a few past that as well. Revenue is a little bit harder to measure. I'm not so sure it's accurate out there what everyone's reporting, but units is pretty fair way to at least look at it, so. But yeah, it's just a milestone on the journey, so. So, we were talking off camera. You guys have had a long relationship with EMC prior to the acquisition slash merger. And we learned earlier, I mean, not a super surprise, but you guys had started sort of reinvigorating your relationship, in part anyway, with by selling servers to EMC. They're a big consumer of servers, and you guys start aligning that. So now you've got this sort of other captive business that you can sell into. Talk about why that's important and how it affected sort of the groove swing, if you will. Yeah, if you think about the market, today you have to have and be relevant in the area at convergent infrastructure, hyper-convergent infrastructure. EMC is the classic version of their company, very, very storage-centric. And for V-blocks, for instance, had brought in VCE where they had done just a complete kind of OEM of Cisco gear for that V-block, very successful in that, but they were not a server company. And so, in order to make sure they had the right converged, hyper-converged portfolio, they needed the compute side. So they were already in the process bringing in compute partners. We were the preeminent compute partner out there. And so we had already begun working. So on day one, we could hit the ground running because their teams had already been engaged in, how do you take the best of our compute technology, high-performance compute, reliable, dense, and merge it into what they had in terms of software assets around VX, VxRail, VxRack, scale-ready nodes, things like that. So, you know, there's almost an instant on switch, although to your point, there's a lot of movement before that switch turned on. So. Stu, when you were at EMC, you were a server company for about a nanosecond when you bought TG, and then they killed it, but there's a real difference between server mentality and storage mentality.  They were like, yeah, shut the lights off when you're done there, because I think, from day one, EMC knew when they bought data general that it was all about the clarion, not the avion. But I mean, the long partnership that EMC had with Dell, and it was interesting, even in the EMC solution portfolio, they push a lot of x86 out there, not just in the storage architecture, but all the software products that they sell, many of them go in appliances. And then of course, every customer, if they're buying a sand or a NAS, you know, are putting a lot of those solutions together. So it was always, you know, server and storage always went well together. So it was interesting. I always thought EMC always had, you know, from a field standpoint, good knowledge of that server sale. I think they were instrumental in helping Cisco grow the UCS business. So, you know, what do you see as kind of the power of the combined go-to-market of, you know, the power of two now that you're together is what that'll mean to your business. Yeah, it's great for me and for Tom Burns in networking as well in that we already were putting together converged infrastructure in Dell Classic and Dell Legacy, if you will. Now you put the number one compute platform with the number one storage platform and you have the assets around software, management, orchestration, virtualization layer. You basically have everything you need to build an engineered solution. You don't have to partner for it. You can build internally. You can optimize it, support it, and then be very confident all the way through the process of owning it, managing it, deploying it, updating it and so on that you have one company that can backstop the entire solution for you. That's pretty unusual in this industry. Actually, in the keynote this morning we heard a lot about basically the Dell PowerEdge inside all of these various solutions. I think one of the big highlights they're talking about from the storage side is the hyperkinner to the VxRail. Maybe can you give us a little bit of a just kind of quick run through as to where all of your servers are living inside of these new solutions? Sure, and we're certainly not done yet. So what we've been able to do very quickly is VxRail now on PowerEdge and that really has changed the nature of how they can operate because they can go up market because we have much more high performance capability. They can go down market with some of the capability for us to offer that performance at a value that they just couldn't operate at and really the density allows them to get into where they needed many more minimum for a cluster. Now they can get down to just three units basically for a minimum and still operate at 200 VMs. If you look at VxRack, again, if you're going to scale out on these type of architectures, don't start with a three unit, start with a hundred units and then VxRack offers you those opportunities with different software stacks. And these are now built on PowerEdge combined with the EMC capability. And just to clarify, I understand that's like a ready node which is more like a reference architecture, kind of not a fully put together solution. Now these can be fully put together systems as well. And then scale IO really, really is taking off and has enormous momentum in the marketplace as fairly much a software application on top of a hardware infrastructure that is somewhat agnostic of. Put it together though with PowerEdge and you have the ability to have a reference architecture to really say, this is pre-validated, we stand behind it, we know it, you don't have to do the work behind it. It comes together, scale ready nodes if you will, not PowerEdge. I was getting my VxRail flex and scale IO ready nodes which are same software, similar configuration. Which are part of it, yes. You know, in that continuum as Chad always talks about. That's right. That's one of the keys is if you want to build your infrastructure and about 80% of customers still want to build their infrastructure, they've invested, they know how, they know their business better than most and they want to be able to build out exactly for what they have, what they need, what they already have from an acquisition, whatever the reason. And so as you go through that somebody then wants, I have to know it works at least, help me out, give me a starting point, reference architecture. I'd rather just buy this piece, put together for me, give me an engineered solution. Give me something that's already been pre-tested, pre-validated. You know what? I'm going to turn my infrastructure over to a turnkey approach, back the truck up, put the thing down. I don't really want to know how to update it or optimize it. I want to run the application. And so who else can offer from that build to buy continuum? Every click stop, we have the best of the capabilities of this combined infrastructure company coming together. So actually the business still drives the need for applications, which drives the need for compute. And that leads to a discussion of workloads. And historically you'd look at workloads as you had OLTP, you got decision support and data warehouse, you got web, maybe you got some file and print, HPC. How have workloads changed? Are we just renaming those names? I mean there are some differences. You got analytics and transactions coming together. You got HPC and big data are sort of coming together. You've got this Hadoop thing that came in and sort of changed the whole discussion around data from an asset or from a liability to an asset. How are workloads changing and how does that affect how you deliver solutions to the marketplace? Yeah, you named quite a few. So it's really hard to look at an HPC workload and what's underneath the infrastructure and say that also would apply to big data and data analytics today. And not be saying the same thing. To your point, the workloads especially around big data, BI are really advancing in the enterprise. We're fond of asking people how much data do you think you have? They always under call it. How much data do you think you use? They always under call it. Then God forbid if you get to the question of how much of your data that you actually know you have that you're using, do you make a decision on in real time? And it's so small that that is really where the growth is because if you can get there faster and quicker, we've seen the digital disruption where people can do this, you're probably going to beat your competition in your peer set in your segment. So everyone wants to get there. And I think that's really been a focus that's changed. So perhaps a unified communications and collaboration workload maybe just isn't the important thing for the IT department anymore. That's something they can offload into a buy mentality whether it's a SaaS cloud, infrastructure that's turnkey because you're just worried about the application and they're putting their sophistication on BI, on data analytics, on search. These are really becoming the more interesting ones. Software defined storage, software defined infrastructure, software defined data centers, still incredibly important because it's somewhat independent of the workload where you can lay down a very flexible infrastructure and you don't have to think about workload first, you can think about infrastructure, then workload and not be suboptimal in that. You can still deliver each of those workloads on the infrastructure, scale it out. So just pick those to stop there and think about the infrastructure underneath. Well, if you're going to be in any of these infrastructures, you better have responsiveness at the node. So our investment R&D is going into driving in VME faster, tiers of storage class memory faster than anyone else can get there because you've got to have responsiveness next to the application, next to the CPU. You've got to be able to have connectivity. So you've seen us come out, be first to mark with 25 gig eCopper, we'll be right there with 32 gig fiber channel and so on down and already working on some newer fabrics that can live in the rack. And we want to be there because you can't scale out if you can't connect these nodes together. It just doesn't work. Modular, if you don't have a modular infrastructure, it can either be nodes that are modular or within the node modular that you can then optimize. But once you do, you want to build them out very quickly for each workload. You've got to have a little bit of locality. It still matters. I hope when I'm in a autonomous driving car one day that it doesn't have to go over the network to a data center to say, should I break and then come back? Because that's not the latency I think I want to afford. So that locality of compute and capability is going to matter a lot to people. Not everything's at one end and the other end. Sensors in a data center. And then I think one of more exciting workloads you didn't mention, heterogeneous computing, GPUs, FPGAs converted in. Think of it as standard processor with optimized processing capability around it, acceleration and machine learning, machine to machine learning, AI, AR, VR, all these aspects are really moving it forward. And the connection point between those nodes is Ethernet? Is that what I'm hearing? Or is it Ethernet and Infiniband or? From node to node, a lot of people have lost a lot of money betting against Ethernet over the years. So I think Ethernet still has a ways to go from node to node. But Photonics will be there one day and there's a crossover point where it will get there.  There's a future way that we've got to get to the point where we can share capability. So just a bunch of- Some of the Gen Z stuff and things like that, yeah. Gen Z is the one we're supporting today. One of my architects is the president of Gen Z, the first president, we want to drive that forward. It's a great, I think, way to build a physical layer. The protocol may be different for different people and how they use it. And so that's one that we really think is important. Ashley, two biggest growth areas, we had Matt Eastwood on yesterday, said the two biggest areas, hyperscale in China, give us the update as to the Delta position there. I agree, yeah, I agree with Matt. I think Intel just had their earnings yesterday and if you read through some of the public information they had cloud for them in a data center sense, growing at 32%. But their data center group grew at about nine, which is under what they had called beginning of the year. So that means the rest of the enterprises did not grow.  One, it doesn't have the same level perhaps profitability for our business as others on a per unit basis, but it's a very big business. Second, if you wander around here, you can see some really interesting things. So we're showing off a miniature modular data center off to the side and we're really the leaders of modular data centers and that's come from our work with the hyperscale. If we had come up from kind of the enterprise and said I wonder if we can get to hyperscale now and we can take some of our solutions and just slightly tweak them to be hyperscale ready, never were to work. And we would have never gotten into MDCs and now be able to help many other customers, financial services companies, research on and on with kind of coming to the realization that maybe a modular data center is the way to approach it today. Why not optimize the entire environment? So we're going to keep pushing into hyperscale. We love the customer engagement we have there. On China, we've done very well in China. China is a great market for us. We have a great field team, great relationships with customers there. It's a very different dynamic though than the rest of the world because you have a different set of server and infrastructure competitors there and we love to compete. So we have no problem being in that different competitive environment. As a matter of fact, a lot of the products we sell globally do quite well in China. We also will do some things for China specific to that marketplace. But I think that's the way that everyone's going to have to approach that marketplace. And one of your big hyperscale customers is Microsoft. Companies like that, they buy a little bit lumpier.  Do you think you keep that number one position? I don't know. Because like you said, the server market's pretty lumpy and a arbitrary 13 week period during the year is not the great measurement. As a matter of fact, as a private entity, I could kind of care less about a 13 week arbitrary period. We still have numbers and we still have plans and we want to hit them on a measured basis. But we're really about the long term. So that's why for us, we've never seen number one as a destination but just a milestone on the journey. We'll soon be number one with a lot of separation and won't be an issue. But if you look through the last couple of years, we've taken so much share out of, for instance, HP Enterprise that it was just a matter of time to get to the crosspoint. Next quarter or the quarter after that, who knows? So last question I have for you. Microsoft actually was Dell customer for years, tried ODM and came back as kind of my understanding. We looked at the VMware on Amazon announcement there. It's going to be new bare metal, be a new configuration. Is there any reason why Dell couldn't be, I'm sure you guys must have a configuration at a price point and can customize to fit something like that is my... Yeah, without, we need to bring you on for our strategy sessions, Stu. You know, without getting into specific customers, what we do for our hyperscale customers can apply across the set of hyperscale customers, social media, search, infrastructure as a service. We think you are the best technology to offer. And so someone like AWS who now has announced a new deal with VMware, one of the Dell technology companies, they'd be a perfect customer of ours. But there was no deal made that you were involved with. There was no deal made that I was involved in, that's true. All right, we have to go. But I'll give you the last word, private company, but what should we be looking for in terms of progress points, milestones, areas of success actually that you're focused on with your group? If you don't see us next year, being able to deliver on the promise of that continuum of however you want to consume your IT, whatever workloads you're trying to optimize, what's your business problems? If we're not bringing the best of our IT, our compute, our storage, our networking together with the software assets that we have today, then shame on us, because we've got all the assets, guys, we've got everything. Now it's a matter of, it's almost kiddin' a candy store sometimes, you get sugared up and you need to know and focus. So I think our biggest challenge, and if you want to watch us for progress, is are we, do we have the right priorities or are we bringing out to the marketplace the type of solutions first that matter to people? Because we've got almost a matrix of unlimited capability today to offer our customers. All right, best of breed, the way you want it, Ashley, thanks very much for coming to theCUBE. Good to see you again. Good to see you again. You're welcome. Great to see you guys. All right, keep it right there, everybody. Stu and I will be back with our next guest. We're live from Dell EMC World 2016 in Austin. Right back.