In early November of 2010, Episode #1278 should have been broadcast. That particular Podcast was showing the use of the LINEST Function with NFL statistics to predict who would win the next super bowl! Unfortunately, this formula worked well, but...
Transcript of the video:
Hey welcome back to MrExcel podcast sponsored by Easy-XL.
Learn Excel from MrExcel podcast. Episode 1268.
Predict the Super Ball Hey, welcome back. I'm Bill Jelen from MrExcel.
You know we got an email the other day someone said. Hey, there's a podcast 1267 and there's a podcast 1269, what happened to 1268? and Scott and I were talking about that Scott in my office and we don't know what happened to 1268 and was a real mystery. I'm out here in Seattle.
I'm in Mike Garvin's office and Mike has this awesome awesome bookshelf.
This is like a museum of the best spreadsheet books ever. There's books there are at Wizzy count and books there're on lotus and some MrExcel books and some J-walk books and all these books over here and I was poking around the bookshelf and I found. I found episode 1268 up on that bookshelf.
And it would have been an awesome thing because it was this amazing formula that would let you predict the outcome of the Super Ball.
All right so here's here's all these statistics I'm going to use =LINEST. LINEST that's another way to do it. Here's the known Ys comma then the known X's Green Bay Packers, isn't that incredible?
If I would have just broadcast that when I should have everyone could have bet and would have won millions on the Super Ball.
But here, it's too late. It's already after the fact.
Isn't that while the LINEST Function gets any NFL statistics, predict the winner of the next super cool.
Hey i want to thank you for stopping by. Will see you next time for another netcast from MrExcel.
Learn Excel from MrExcel podcast. Episode 1268.
Predict the Super Ball Hey, welcome back. I'm Bill Jelen from MrExcel.
You know we got an email the other day someone said. Hey, there's a podcast 1267 and there's a podcast 1269, what happened to 1268? and Scott and I were talking about that Scott in my office and we don't know what happened to 1268 and was a real mystery. I'm out here in Seattle.
I'm in Mike Garvin's office and Mike has this awesome awesome bookshelf.
This is like a museum of the best spreadsheet books ever. There's books there are at Wizzy count and books there're on lotus and some MrExcel books and some J-walk books and all these books over here and I was poking around the bookshelf and I found. I found episode 1268 up on that bookshelf.
And it would have been an awesome thing because it was this amazing formula that would let you predict the outcome of the Super Ball.
All right so here's here's all these statistics I'm going to use =LINEST. LINEST that's another way to do it. Here's the known Ys comma then the known X's Green Bay Packers, isn't that incredible?
If I would have just broadcast that when I should have everyone could have bet and would have won millions on the Super Ball.
But here, it's too late. It's already after the fact.
Isn't that while the LINEST Function gets any NFL statistics, predict the winner of the next super cool.
Hey i want to thank you for stopping by. Will see you next time for another netcast from MrExcel.
