How to use XLMiner Analysis ToolPak add-on for Google Sheets
Excel fans turned into Google Sheets users can rejoice. XLMiner ToolPak is another add-on that increases the power of Google Sheets. When Google first launched Sheets, it changed the game for many spreadsheet users, allowing for real-time collaboration from any device at any time. And as amazing as this new style of spreadsheets was, advanced Excel users were left out of the excitement. Google Sheets was pretty basic and did not have some of the advanced features that select users need to process and perform statistical analyses. However, Google Sheets and Excel have both changed a lot over the years. Excel has created a collaborative, online component. Google Sheets has become more advanced to keep up with the competition. They have improved their own features and introduced add-ons, a feature that allows 3rd party developers to create tools that boost the capabilities of Sheets.
Solver has created an add-on that solved one of those Google Sheets issues. It mimics the same tool used in Excel and allows users to perform essentially the exact same analyses. This is great for the many users who are making the switch from Excel to Google Sheets because it is free, cloud-based, and so easy to share and collaborate with using Google’s unique sharing permission. There are also many users, like myself, who work across both programs! The ease of being able to switch between programs without having to change the way you operate the features is invaluable for individuals and teams who need to create and share important data.
Who is Using XLMiner Analysis ToolPak?
Statistical analysis is performed by research scientists, analysists, government organizations, non-profits, and private companies. Being able to correctly understand data allows us to make better decisions in finance, investment, production, distribution, scheduling, and more. Users are using this add-on to predict flight delays and even optimize professional football scheduling. How will you use XLMiner Analysis ToolPak to change the world around you?
How to Access XLMiner Analysis ToolPak
It is really simple to get add-ons for Sheets.
- Open a spreadsheet
- Click the add-ons button in the navigation menu
- Click the Get add-ons button
- A window will pop up for you to browse
- Type “XLMiner Analysis ToolPak” in the search box.
- Click the Free button to get the add-on
You are ready to start using XLMiner Analysis ToolPak!
How to Use the Add-on
Starting the XLMiner Analysis Toolpak is easy. Simple click Add-ons → Manage add-ons → Start. Google Sheets will open the add-on, and a toolbar will appear on the right side of your spreadsheet. From this sidebar you can choose from twenty different options to perform statistical analyses on your data:
XLMiner Analysis Toolpak is intuitive to use and generally functions just like it’s Excel counterpart. Let’s go over a simple analysis so you can see the features of the add-on.
For this tutorial, we will run a correlation analysis. We are using a simple set of dummy data comprised of 3 columns containing various variables. Plug in the input data range into the Input Range box (A1:C12). For this demo, we will group our data by columns, and select the Labels in First Row option. Choose empty cell range for the data to output and enter it into the Output Range box. It’s that simple! Finally, click the OK button.
The add-on will run the statistical analysis for you, and populate output in your desired range, just like the image below!
We can repeat the same process to run a descriptive statistical analysis, and have the data output to the same sheet!
If you have been worried about switching to Google Sheets for fear of losing some of the advanced mathematical capabilities that Excel offers, Solver has created a great solution for you! Not only does it have nearly the same user experience and features that Excel offers, it also features an extra tool to sweeten the pie: Logistic Regression! It will be an easy transition for Excel users to get started using XLMiner Analysis ToolPak, and if you are new to statistical analysis, check out some of the great community resources available for free.