#What if analysis excel for mac software#

You sell a certain for the highest price of 50 and a certain for the lower price of 20. Assume you own a book store and have 100 books in storage. The following example helps you master what-if analysis quickly and easily. Click here for information on activating Data Analysis in Excel for Windows. What-If Analysis in Excel allows you to try out different values (scenarios) for formulas. Lastly, the steps are different if you are using Windows. If you would like to see a different guide on, please email me at Thanks for reading! She created the pictures for this guide and provided an overview of the instructions. Now, let’s see if it worked! Click on the “Data” tab at the top:ĭo you see a “Data Analysis” button? If so, great! You can now perform statistics in Excel! If not, look back through the prior steps and see where you went wrong.Ī very special thanks goes to my former MBA student, Misty Bussie. Do you see a sub-tab labeled “Analysis” or “Data Analysis”? If not, then perform the following steps:Īs seen below, click on the “Tools” menu:Ĭlick the checkbox beside “Analysis Toolpak”:

To determine whether your Data Analysis tab is activated, open a blank Excel workbook. For some reason, Excel defaults the Data Analysis tab as inactive, although it is completely free and pre-installed.

#What if analysis excel for mac software#

Have you ever wanted to calculate a simple statistic in Excel, but couldn’t find the correct tab to do so? If so, it is possible that you did not have the “Data Analysis” tab activated. Easily take your statistical data from Excel into JMP software from SAS, then transform it to easy-to-understand dynamic graphics and explore what-if.