Statistical Analysis with Excel For Dummies. Joseph Schmuller

Чтение книги онлайн.

Читать онлайн книгу Statistical Analysis with Excel For Dummies - Joseph Schmuller страница 26

Statistical Analysis with Excel For Dummies - Joseph Schmuller

Скачать книгу

href="#fb3_img_img_fdfe8538-054e-5f30-abc8-5c70bf36ad70.png" alt="Snapshot of the output of the Descriptive Statistics tool."/>

      FIGURE 2-28: The output of the Descriptive Statistics tool.

      Additional data analysis tool packages

      Two other data analysis tool packages are available for Excel. The good news is that both work on Windows, Mac, and iPad.

      One is called the XLMiner Analysis ToolPak (from Frontline Systems) and it does everything the original Toolpak does, plus an analysis called Logistic Regression. Rather than take you through this package in every chapter, I leave it until Chapter 21 when I cover Logistic Regression — and the XLMiner Analysis ToolPak provides the best way to get the job done.

      I use the iPad as an opportunity to explore the other package, StatPlus (from AnalystSoft). This way, you get a deep dive into another toolset, and I don’t have to cover every combination of every platform (Windows, Mac, iPad) with every tool package (Analysis Toolpak, XLMiner ToolPak, StatPlus) in every chapter!

      It turns out that the free version of StatPlus — the one I work with in this book — has some of the tools the Toolpak provides and also has some goodies the Toolpak lacks. That makes it very much worth having. Luckily for you, this add-in is easy to set up and to work with. All you have to do to add it to Excel on your iPad is tap Insert | Add-Ins | See All. In the Office Add-Ins box that appears, scroll down to StatPlus and tap Add.

      1 Enter your data into an array.It’s a good idea to name the tab of the worksheet that contains the array.

      2 Tap Insert | Add-ins | StatPlus to open the Add-ins box.If you’ve used StatPlus recently, its icon appears immediately under Recently Used Add-ins. If it doesn’t, find it in My Add-Ins. Tapping StatPlus opens the StatPlus pane on the right side of the screen.

      3 In the StatPlus panel, tap New Analysis to open the Commands box.

      4 Hunt down the analysis tool you want.The Commands box is organized into categories, so you might have to tap a couple of categories before you find the tool you’re looking for.

      5 Tap the name of the tool.

      6 Enter the values into the boxes on the StatPlus panel.From the drop-down menu for the Columns For box, select the tab where your data lives. If your spreadsheet is open to that tab, its name already appears in the Columns For box.In the Headers box, you can choose either Name in the first row or no headers.For the next few steps, keep in mind that the tool you use determines the number of Variables boxes you work with.

      7 To add an array to a Variables box, select it on the spreadsheet and then tap the little three-cells-and-a-plus-sign icon for the appropriate Variables box.This step opens the Variables pane.

      8 Tap Add in that pane to return to the previous pane.The selected range is in the Variables box.

      9 Tap Run.StatPlus opens a new worksheet with the results.

Snapshot of the StatPlus pane, with entered values for a Descriptive Statistics analysis.

      FIGURE 2-29: The StatPlus pane, with entered values for a Descriptive Statistics analysis.

Snapshot of the results of the Descriptive Statistics analysis ’ compare with the results shown in Figure 2-28.

      Need quick access to a few commonly used statistical functions? You can get to AVERAGE, MIN (minimum value in a selected cell range) and MAX (maximum value in a selected range) by clicking the down arrow next to the AutoSum button on the left side of the Formulas tab. Clicking this down arrow also gets you to the Mathematical functions SUM and COUNT NUMBERS (counts the numerical values in a cell range).

Snapshot of the Home Σ button and the menu that clicking its down arrow opens.

      FIGURE 2-31: The Home ∑ button and the menu that clicking its down arrow opens.

      By the way, if you just click the ∑ button and not the down arrow, you get SUM.

      The last selection on that menu is yet another way to open the Insert Function dialog box.

      

One nice thing about using the ∑ menu: It eliminates a step. When you select a function, you don’t have to select a cell for the result — just select the cell range, and the function inserts the value in a cell immediately after the range.

      The pane offers a number of suggestions, including charts (Excel’s name for graphs) to visualize the data as well as a possible correlation between data in two of the columns (the years 1990 and 2001). I have more to say about charts in Chapter 3. (Correlation? What’s that? Chapter 15 tells you all about it.)

Snapshot of the Analyze Data tool at work.

      FIGURE 2-32: The Analyze Data tool at work.

      This new feature is for non-Windows

Скачать книгу