Z01_REEC5174_09_IE_APPA

Z01_REEC5174_09_IE_APPA - Appendix A An Introduction to...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Appendix A An Introduction to Data Analysis and Graphing for a PC This appendix provides a quick introduction to the use of some of the data analysis and graphing capabilities of one of the more commonly used computer programs, Excel. This and other similar software systems make it much easier to graph and analyze large data sets. 1. TO SET UP EXCEL FOR DATA ANALYSIS AND GRAPHING Open Excel and activate the “Data Analysis” tool. o Under the “Tools” pull-down menu, look for “Data Analysis.” o If you don’t see “Data Analysis,” look for “Add-Ins.” Click on “Data Analysis” or “Add-Ins” and select “Analysis ToolPack”; then click “OK.” o If you did a custom install instead of a complete install of Excel, you may not find “Analysis ToolPack” under “Add-Ins.” If this is the case, go to your original installation CD to add this feature. Enter the data to be analyzed or graphed in columns on the Excel spreadsheet. o If you want to graph height versus arm length, enter the data in two columns with the data you want to appear on the y-axis (independent variable) of a graph in the right-hand column. o The data to appear on the x-axis (dependent variable) should be in the adjacent left-hand column. o An example is on the next page. Note: If you are using Excel 2007 to find and activate Add-ins: Click on the “Office” button in the upper left-hand corner. Then click on the “Excel options” button at the bottom of the pop-up window. Select “Add-ins” from the left-hand column. Select/highlight “Analysis ToolPak” in the list of Inactive Application Add-ins, then click “Go.” Check the box in front of “Analysis Tool Pak” in the window that appears and click “OK.” Now click on the “Data” tab at the top of the screen. You should see a new “Data Analysis” pull- down menu at the right top of the screen. A B C 1 Gender Arm Length (cm) Height (cm) 2 3 f 73.7 170.2 4 m 76.7 177.8 5 m 71.1 170.2 Reece_IG App A-1
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6 f 66 165.1 7 f 68.6 172.7 8 m 76.7 172.7 9 m 78.7 177.8 10 m 81.3182.9 2. TO SORT THE DATA In the upper left-hand corner of the Excel spreadsheet, click the box between Row 1 and Column A. The whole table should be highlighted when you do this. Pull down the “Data” menu at the top of the screen and click “Sort.” If you have headers or titles on your columns, click the ° in front of “Header row.” Select the column you want to sort by (e.g., Gender). Select either “Ascending” if you want the sort to go from low to high (or A to Z) or “Descending”
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

Z01_REEC5174_09_IE_APPA - Appendix A An Introduction to...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online