Amazing video!! ✌😉 BonusV(9an) spreadsheet, 6-month Moving Ave., single cell formula in cel AF6: =LET(a,AE6:AE36,nm,6,s,SCAN(0,SEQUENCE(ROWS(a)),LAMBDA(v,i,AVERAGE(INDEX(a,SEQUENCE(nm,,i))))),FILTER(s,NOT(ISERR(s))))
Beautiful : ) : ) Thanks Teammate ExcelLambda AND the thanks for the polite and convenient reference to the worksheet you used ; ) I have added it to the download. Go Team!!!!
I had to put this formula on the BonusV(9an) worksheet in cell AP6: =LET(a,AE6:AE36,nm,6,s,SCAN(0,SEQUENCE(ROWS(a)),LAMBDA(v,i,AVERAGE(INDEX(a,SEQUENCE(nm,,i))))),FILTER(s,NOT(ISERR(s)))) which is off to the side. Go Team!!!!!
It took me about 20 minutes to understand it. I had to make this formula to remind myself what each variable meant: =LET(sales,AE6:AE36,num_months,6,scan,SCAN(0,SEQUENCE(ROWS(sales)),LAMBDA(a,r,AVERAGE(INDEX(sales,SEQUENCE(num_months,,r))))),FILTER(scan,NOT(ISERR(scan)))) lol But, man!!!! Thanks for teaching me cool new stuff ExcelLambda. I love hanging out on the Team with you : ) : ) I have the gift of a new idea from you today of: Create some numbers, SEQUENCE(ROWS(sales)), then always get the current row and the five below inside AVERAGE, INDEX(sales,SEQUENCE(num_months,,r))!!!!!! : )
Excellent as usual Mike. I wish you and your family a good and healthy 2022! Of course as usual one tip: please pay attention to the 0 values (in your example of Test and Quiz). It is relevant to know the difference. Empty cells are ignored by AVERAGE. I am looking forward to your explanation of testing...Greetings Bart
Thanks for that tip, Bart!!! The tail end of this class and hypothesis testing and regression won't be for about 5 months... Happy Holiday to you and your family!!!
Like n°158, comment n° 32: 😵Holy Moly! 😵 the whole family of summarized metrics: Mean, Median, Mode, Moving Average, Skew & More! Buckling up for this trip captain 🚀!
Another epic and awesome lesson! Saved it for the weekend, so I could walk through the examples. Much fun and learning in this one. Many thanks and thumbs up!!
It is so cool that you save up time, then go through it slow, for fun, and do all the examples!!! That is why I post the videos and files : ) Many You ARe Welcomes, Wayne : )
At about 5 minutes, you’re off by one row on where the 75th percentile is. It’s 84.5, but you said that it corresponded to the space between row 22 and 23. 84.5 > 84.
Yes, but you can NEVER count on me to get things spelled correctly... Somewhere over the first decade of teaching I made the joke of Mu being Mew, and then over the second decade of teaching I just sort of forgot it was a joke... lol
I have some linear regression videos in this class (#44-52): ruclips.net/user/playlist?app=desktop&list=PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ Nothing on kruskal, friedman
Amazing video!! ✌😉
BonusV(9an) spreadsheet, 6-month Moving Ave., single cell formula in cel AF6:
=LET(a,AE6:AE36,nm,6,s,SCAN(0,SEQUENCE(ROWS(a)),LAMBDA(v,i,AVERAGE(INDEX(a,SEQUENCE(nm,,i))))),FILTER(s,NOT(ISERR(s))))
Beautiful : ) : ) Thanks Teammate ExcelLambda AND the thanks for the polite and convenient reference to the worksheet you used ; ) I have added it to the download. Go Team!!!!
I had to put this formula on the BonusV(9an) worksheet in cell AP6: =LET(a,AE6:AE36,nm,6,s,SCAN(0,SEQUENCE(ROWS(a)),LAMBDA(v,i,AVERAGE(INDEX(a,SEQUENCE(nm,,i))))),FILTER(s,NOT(ISERR(s))))
which is off to the side. Go Team!!!!!
It took me about 20 minutes to understand it. I had to make this formula to remind myself what each variable meant: =LET(sales,AE6:AE36,num_months,6,scan,SCAN(0,SEQUENCE(ROWS(sales)),LAMBDA(a,r,AVERAGE(INDEX(sales,SEQUENCE(num_months,,r))))),FILTER(scan,NOT(ISERR(scan)))) lol
But, man!!!! Thanks for teaching me cool new stuff ExcelLambda. I love hanging out on the Team with you : ) : ) I have the gift of a new idea from you today of: Create some numbers, SEQUENCE(ROWS(sales)), then always get the current row and the five below inside AVERAGE, INDEX(sales,SEQUENCE(num_months,,r))!!!!!! : )
@@excelisfun Like always, you are too kind!! Always a pleasure!! You are guilty of making Excel so much fun !! 🙏✌😉
@@Excelambda Yes!!!!!! : ) : ) : ) : ) : )
out of context, but that cat picture is adorable!
So glad you like the Mew (Population Mean) Kitten picture at 06:06 - You gotta have fun with statistics, right?
Excellent as usual Mike. I wish you and your family a good and healthy 2022! Of course as usual one tip: please pay attention to the 0 values (in your example of Test and Quiz). It is relevant to know the difference. Empty cells are ignored by AVERAGE. I am looking forward to your explanation of testing...Greetings Bart
Thanks for that tip, Bart!!! The tail end of this class and hypothesis testing and regression won't be for about 5 months... Happy Holiday to you and your family!!!
Good refresher video on stats, thanks Mike!
You are welcome, Chris H : ) : ) : ) : )
Magic Mike, Happy New Year. Thank you for sharing all your secrets with us. Today I was able to learn a few new tricks.
Thanks, Paulo!!! Happy New Year to you and glad you could pick up a few new tricks : )
Thanks Mike. Skew and Moving Average!!! Awesome!!!!
I've learned a lot from your videos; thank you so much!
You are welcome! If you need to learn statistics in Excel, you came to the right channel : )
Thank you once again Mike! Happy New Year!
You are welcome and Happy New Year, Gareth!!!!
Like n°158, comment n° 32:
😵Holy Moly! 😵 the whole family of summarized metrics: Mean, Median, Mode, Moving Average, Skew & More!
Buckling up for this trip captain 🚀!
Buckle up on the rocket trip through all of this that you already know, but there might be a tid bit here or there ; )
@@excelisfun Captain, I have a long way to catch up! ... but I KNOW it will be enjoyable! hopefully tonite! #GoTeam!
@@spilledgraphics All Night Party!!!!!!!!!!!! Go Re Calc!!!!!!!!
Thank you.😊
You are welcome! Wait trill you get to the Standard Deviation video - then the Mean means ever more ; )
I've had a lot of bosses in my time, and the one I have now is definitely MEAN.
Too funny!!!! Those average bosses are so mean ; )
Another epic and awesome lesson! Saved it for the weekend, so I could walk through the examples. Much fun and learning in this one. Many thanks and thumbs up!!
It is so cool that you save up time, then go through it slow, for fun, and do all the examples!!! That is why I post the videos and files : ) Many You ARe Welcomes, Wayne : )
Yet another EXCELlent video from amazing Mike. Thank you so much for the share.
You are welcome for the central location fun, Fellow Teacher : ) : ) : )
❤🎉😅
@@excelisfun0:07
👍as usual very easy understood lecture. Well done Mike.
Thanks, Roger : )
Great video as usal ❤️🤗...Eager to see next videos in this series😊
Me too... I can't wait!!!!
Boom!Super Fun Refresher Class...Thank You Mike :)
You are welcome, darryl!!!
At about 5 minutes, you’re off by one row on where the 75th percentile is. It’s 84.5, but you said that it corresponded to the space between row 22 and 23. 84.5 > 84.
It's a very good video. Love it. Thank you Mike. Kitten is cute 😺
Kitten and Ghosts make Excel better ; )
I can’t wait to see the other videos of the series!
What about the last rows of the Tables, is the formula of the moving average would be correct?
Nope: last rows are not correct. That is one reason we did not plot them.
Immersive experience.
Useful! ❤️
Glad it is useful, Ai Ja!!!!
Any Excercises?
🤩
: ) : ) : )
Cute kitty, but isn't is "mu", the greek letter? :)
Yes, but you can NEVER count on me to get things spelled correctly... Somewhere over the first decade of teaching I made the joke of Mu being Mew, and then over the second decade of teaching I just sort of forgot it was a joke... lol
@@excelisfun That's hilarious! :) Mew it is!
@@jamesepace No, no, we must keep the Greek heritage, but always make the joke!
1st comment
1st Place Trophy for you, Syed Hassan!!!!
can you do about liner regression, kruskal, friedman test also
I have some linear regression videos in this class (#44-52): ruclips.net/user/playlist?app=desktop&list=PLrRPvpgDmw0mSJCZaqQPFj0eto4qnzkCZ
Nothing on kruskal, friedman
@@excelisfun thank you, sir
@@Mei-oe6sg You are welcome! P.S. That is a cool user name, it's like red^2 ; )