Z02_REEC5174_09_IE_APPB

Z02_REEC5174_09_IE_APPB - Appendix B An Introduction to...

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

View Full Document Right Arrow Icon
Appendix B An Introduction to Data Analysis and Graphing for a Mac 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 For example: 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 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.3 182.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. Reece_IG App B-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
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” for high to low (or Z to A). Click “OK.” 3. TO GET DESCRIPTIVE/SUMMARY STATISTICS FOR THE DATA a. Pull down the “Tools” menu at the top of the Excel spreadsheet and click on “Data Analysis.” b. Click on “Descriptive Statistics” and then “OK.” In the window that appears, for input range click on the icon to the right of the “Input Range:” box. Highlight (select) the data in the Excel spreadsheet that you want analyzed. For example, select all
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.

This note was uploaded on 02/08/2012 for the course BIOLOGY 101 taught by Professor Hayes during the Spring '09 term at Harvard.

Page1 / 5

Z02_REEC5174_09_IE_APPB - Appendix B 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