Are you trying to use the Analysis ToolPak dialog box?
There is a better version, for free, from Frontline Systems.
Running into a bug? Microsoft knows about the problem.
George Mount's book: Advancing into Analytics: From Excel to Python and R 1, Mount, George - Amazon.com
Dan Fylstra's XLMiner info: XLMiner Analysis ToolPak
There is a better version, for free, from Frontline Systems.
Running into a bug? Microsoft knows about the problem.
George Mount's book: Advancing into Analytics: From Excel to Python and R 1, Mount, George - Amazon.com
Dan Fylstra's XLMiner info: XLMiner Analysis ToolPak
Transcript of the video:
Learn Excel for MrExcel Podcast episode 2409.
There's an amazing replacement for the Analysis ToolPak.
Hey, welcome back to MrExcel netcast.
I am Bill Jelen.
Analysis ToolPak?? You are saying “wasn't that replaced?” Hey, in the old days, the Analysis Toolpak had 89 functions.
And sure those became part of Excel in 2007.
But it also had this other thing.
This Data Analysis dialog box with 19 different tools.
And if you turn on the Analysis Toolpak on the data tab, far right hand side.
Those tools are still there.
There ancient.
They're clunky.
But they're the only way to do some of these things.
This is a crazy winding story with a lot of connections in it.
Last Tuesday.
Someone reports a bug with XL2BB.
This is our add-in that lets you take an Excel workbook and post it to the MrExcel message board in a way that people can copy it to their own workbook.
And some people who were on the Insiders Beta said, hey, we're getting a bug.
And we trace it down to Application.GoTo not working in VBA.
Now the good news is Microsoft is aware of this bug and a fix is coming.
A couple of days later a friend of mine is working through George Mount’s new book, Advancing Into Analytics.
I know George from his Facebook posts.
He posts a lot about Excel.
You've probably seen his posts.
His new book is out.
And George is talking about the Analysis Toolpak Descriptive Statistics.
The person reading the book tries to use it won't work.
I try it.
It won't work.
And I say, hey, “I bet that the Analysis ToolPak is using Application.Goto as well”.
All right now.
Dan Fylstra.
Spreadsheet Legend.
Author of Solver.
Me: Bill Jelen.
Getting too old and losing a few brain cells in my head.
I mixed up Solver and the Analysis ToolPak.
I know Dan.
I met him in a couple of conferences.
I have his email.
I reached out and I said, hey Dan, do you think there's any chance that the Analysis Toolpak is using Application.GoTo?
Dan was very nice.
He didn't say.
“Bill, you've mixed up Solver and Analysis ToolPak”.
He says well, you know I don't have the source code for the Analysis Toolpak, but it seems likely that they might be using it.
It's a good theory.
But.
Here at Frontline Solvers we've rewritten the Analysis Toolpak just based on what we think it was doing.
And our version is free.
It works with Excel and Excel Online.
The old Analysis Tool Pack, using VBA, of course won't.
And I'll add my two cents.
It is a cleaner interface than the old one.
So here's what you do.
On the Insert tab.
Go to Get Addons.
Search for XL (two letters) Miner.
Like that.
And there it is.
The XLMiner Analysis ToolPak.
You click Add, I agree, then Continue.
And over here on the right hand side are the 19 items that the old Analysis ToolPak offered us.
And let's just try the Descriptive Statistics, so we'll click on Descriptive Statistics.
It opens up.
The input range is here.
I don't have labels in the first row.
For the output range, I'll just choose a cell over here.
Click OK and very quickly it provides all of the information that the old Analysis ToolPak would have done.
OK, now most people don't even know the Analysis ToolPak is there and that these 19 tools are there.
But for anyone who's trying to use it and you're just frustrated, because it doesn't work in Excel Online, or maybe it's affected by this bug before Microsoft squashes the bug.
Or, you're just looking for a cleaner interface.
This is a beautiful, beautiful set of tools.
From Dan Fylstra.
Just go out to the Insert tab.
Dan, of course, has a lot of great premium versions of Solvers at Frontline Systems, so he knows all about Excel and writing add-ins for Excel.
Including these new add-ins that work in Excel online.
Alright.
So, for any of you have George Mounts’ book and you're struck by this weird bug in the Insiders Fast Beta or you're just looking for a better version of the Analysis Toolpak, check out XLMiner from Dan Fylstra.
Well, this is where I always promte a book.
Why don't you go out and check out George Mounts’ book, Advancing into Analytics - from Excel to Python And R. It sounds awesome.
If you like these videos, please, down below, Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments down in the YouTube comments below.
I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
So this is crazy.
I got this green circle behind me.
I know it doesn't cover the whole screen.
But I think it helps improve the lighting.
My problem: behind me, there are 308 little glass block windows.
And if I'm recording at night or early in the morning you can see me.
But, the perpetual problem is if I do anything in the afternoon or in the evening when that is backlit, I'm so dark you can't see what's going on.
So I got this little thing on Amazon.
It's either blue or green.
Slips on the back of your chair.
And I think by putting that there, it fools the camera into lighting me instead of lighting those windows back there.
But I look like a dork with just around circle around me.
I don't know what do you think?
There's an amazing replacement for the Analysis ToolPak.
Hey, welcome back to MrExcel netcast.
I am Bill Jelen.
Analysis ToolPak?? You are saying “wasn't that replaced?” Hey, in the old days, the Analysis Toolpak had 89 functions.
And sure those became part of Excel in 2007.
But it also had this other thing.
This Data Analysis dialog box with 19 different tools.
And if you turn on the Analysis Toolpak on the data tab, far right hand side.
Those tools are still there.
There ancient.
They're clunky.
But they're the only way to do some of these things.
This is a crazy winding story with a lot of connections in it.
Last Tuesday.
Someone reports a bug with XL2BB.
This is our add-in that lets you take an Excel workbook and post it to the MrExcel message board in a way that people can copy it to their own workbook.
And some people who were on the Insiders Beta said, hey, we're getting a bug.
And we trace it down to Application.GoTo not working in VBA.
Now the good news is Microsoft is aware of this bug and a fix is coming.
A couple of days later a friend of mine is working through George Mount’s new book, Advancing Into Analytics.
I know George from his Facebook posts.
He posts a lot about Excel.
You've probably seen his posts.
His new book is out.
And George is talking about the Analysis Toolpak Descriptive Statistics.
The person reading the book tries to use it won't work.
I try it.
It won't work.
And I say, hey, “I bet that the Analysis ToolPak is using Application.Goto as well”.
All right now.
Dan Fylstra.
Spreadsheet Legend.
Author of Solver.
Me: Bill Jelen.
Getting too old and losing a few brain cells in my head.
I mixed up Solver and the Analysis ToolPak.
I know Dan.
I met him in a couple of conferences.
I have his email.
I reached out and I said, hey Dan, do you think there's any chance that the Analysis Toolpak is using Application.GoTo?
Dan was very nice.
He didn't say.
“Bill, you've mixed up Solver and Analysis ToolPak”.
He says well, you know I don't have the source code for the Analysis Toolpak, but it seems likely that they might be using it.
It's a good theory.
But.
Here at Frontline Solvers we've rewritten the Analysis Toolpak just based on what we think it was doing.
And our version is free.
It works with Excel and Excel Online.
The old Analysis Tool Pack, using VBA, of course won't.
And I'll add my two cents.
It is a cleaner interface than the old one.
So here's what you do.
On the Insert tab.
Go to Get Addons.
Search for XL (two letters) Miner.
Like that.
And there it is.
The XLMiner Analysis ToolPak.
You click Add, I agree, then Continue.
And over here on the right hand side are the 19 items that the old Analysis ToolPak offered us.
And let's just try the Descriptive Statistics, so we'll click on Descriptive Statistics.
It opens up.
The input range is here.
I don't have labels in the first row.
For the output range, I'll just choose a cell over here.
Click OK and very quickly it provides all of the information that the old Analysis ToolPak would have done.
OK, now most people don't even know the Analysis ToolPak is there and that these 19 tools are there.
But for anyone who's trying to use it and you're just frustrated, because it doesn't work in Excel Online, or maybe it's affected by this bug before Microsoft squashes the bug.
Or, you're just looking for a cleaner interface.
This is a beautiful, beautiful set of tools.
From Dan Fylstra.
Just go out to the Insert tab.
Dan, of course, has a lot of great premium versions of Solvers at Frontline Systems, so he knows all about Excel and writing add-ins for Excel.
Including these new add-ins that work in Excel online.
Alright.
So, for any of you have George Mounts’ book and you're struck by this weird bug in the Insiders Fast Beta or you're just looking for a better version of the Analysis Toolpak, check out XLMiner from Dan Fylstra.
Well, this is where I always promte a book.
Why don't you go out and check out George Mounts’ book, Advancing into Analytics - from Excel to Python And R. It sounds awesome.
If you like these videos, please, down below, Like, Subscribe and Ring the Bell.
Feel free to post any questions or comments down in the YouTube comments below.
I want to thank you for stopping by.
We’ll see you next time for another netcast from MrExcel.
So this is crazy.
I got this green circle behind me.
I know it doesn't cover the whole screen.
But I think it helps improve the lighting.
My problem: behind me, there are 308 little glass block windows.
And if I'm recording at night or early in the morning you can see me.
But, the perpetual problem is if I do anything in the afternoon or in the evening when that is backlit, I'm so dark you can't see what's going on.
So I got this little thing on Amazon.
It's either blue or green.
Slips on the back of your chair.
And I think by putting that there, it fools the camera into lighting me instead of lighting those windows back there.
But I look like a dork with just around circle around me.
I don't know what do you think?
