When you initially start the program, you may receive a startup window such as the one below. To begin using SPSS, launch the SPSS program. The data in Column A now appear as currency as can be seen in the following image. Because these data are salaries, let’s choose Currency and then click OK. You can activate the Number window by clicking on the arrow in the bottom right of the window you will receive a dialog box as in the following screen capture that will allow you to format the way you want the numerical data to appear in the cells. You should see the Number window in the top right-hand side of the Home ribbon in the preceding image. Then activate the Home ribbon by double-clicking on it (this has been done in the preceding image). To begin, highlight the data in Column A (see the preceding image). If I want the data to have a different appearance-for example, to indicate that it is currency-I can format the number type through the Home ribbon, Number window. You can see that I labeled the data Salary in the first cell and then entered the numerical data in a column below the heading. For example, in the following image, I’ve entered some annual salary data for a small business. We can enter data into Excel by simply entering the numbers in the cells. If the Data Analysis option is not visible at the top right of the ribbon, then the ToolPak was not installed properly (see previous instructions on installing the ToolPak). This option indicates that the ToolPak has been installed properly. When the Data ribbon is active, as in the preceding image, you can see the Data Analysis option at the upper right of the screen. The ToolPak can be accessed when the Data ribbon is active (see the following screen capture). In addition, we’ll be using the Data Analysis ToolPak for most of our analyses. We will be entering data into the cells for the analyses we’ll be conducting using Excel in subsequent modules. We typically refer to cells with the column letter first and the row number second (e.g., D5). Thus, cell A1 is highlighted in the preceding screen capture.
A cell is the point at which a column and row intersect. The columns are labeled with letters, and the rows with numbers.
#ADD ANALYSIS TOOLPAK EXCEL 2013 SERIES#
The spreadsheet has a series of columns and rows. You can see in the preceding worksheet where the File tab is, along with the Home, Data, and Worksheet tabs. Launching Excel When you open Excel, you will be presented with a spreadsheet. A dialog box in which Analysis ToolPak is the first option will appear. The very top option in the pop-up window should be Analysis ToolPak. On the left-hand side of the dialog box is a list of options click on Add-Ins to open a pop-up window. From here the process is similar to that for 2013. Next, click on Options toward the bottom of the drop-down menu. Begin by clicking on the File tab at the top left of the screen. The ToolPak should now be installed on your computer.įor Excel 2010, the process is similar. Click on this and then GO.Ī dialog box in which Analysis ToolPak is the first option will appear. At the bottom of the drop-down menu, select Options.Īfter clicking on Options, a dialog box of options will appear. For Excel 2013, this can be accomplished by launching Excel and then clicking on the File tab at the top left of the page.
#ADD ANALYSIS TOOLPAK EXCEL 2013 INSTALL#
Installing the Analysis ToolPak Before you begin to use Excel to analyze data, you may need to install the Data Analysis ToolPak. Getting Started with Excel, SPSS, and the TI-84 Calculator This worksheet also provides you the opportunity to interpret results in the context of specific problems, which assists you in critically evaluating current research in your field. Using these formulas and performing these calculations provides you with an understanding of how and why statistical formulas work and what they mean. This worksheet provides you with experience in calculating (by hand or using Excel®) formulas from the weekly readings. Descriptive and Inferential Statistics Worksheet
0 kommentar(er)
