SRMP_Statistics.pdf

# K e y t o p i c s using excel spreadsheets regression

This preview shows pages 20–23. Sign up to view the full content.

K E Y T O P I C S Using Excel spreadsheets Regression Analysis Creating Graphs T I M E F R A M E 1 hour, 45 minutes C L A S S O U T L I N E T I M E 15 minutes 1 hour 15 minutes 15 minutes T O P I C Lecture - How to use Excel Field Collecting Lecture - Regression Analysis Regression Analysis and Graph D E S C R I P T I O N An introduction to using spreadsheets. Students work in pairs to collect specimens. Explain regression analysis. Students discuss the significance of their results using regression analysis. Students will design clear graphs. using calculators and lab notebooks. M A T E R I A L S Worksheets, Lab notebooks, Laptops with Excel P R O C E D U R E Distribute the worksheets. Students will be shown how to enter data (column versus rows), use the function keys and create graphs. Students will calculate the mean and standard deviation directly in Excel. After they have performed these calculations, students can begin creating graphs. A mini-lecture on regression analysis will explain a statistical test used in biology. After running this statistical test on their data, students may discuss with the class which results are significant and which are not.

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

View Full Document
Science Research Mentoring Program STATISTICS © 2013 American Museum of Natural History. All Rights Reserved. 21 Session Four: Statistical Analysis: WORKSHEET Statistical Analysis I N T R O D U C T I O N Upon completion of this lab, you should be able to: 1. Use Excel to calculate average, standard deviation, and regression analysis 2. Create different types of graphs, and evaluate what makes a good graph S T A T I S T I C A L A N A L Y S I S Statistical analysis takes the guessing out of data interpretation. Analysis of the data can determine the degree of variability in the numbers and determine whether the differences observed are real. We began this last week by calculating the mean, mode, median, variance, and standard deviation by hand; now let’s move into using Excel to look for relationships. E X E R C I S E 1 : B A S I C S T A T I S T I C S I N E X C E L A N D G R A P H M A K I N G Upon completion of this lab, you should be able to 1. Enter your field data into an Excel spreadsheet. 2. Calculate the mean and standard deviation. Are you getting the same results as yesterday? 3. Start graphing your data in Excel. Do those graphs differ from the hand-drawn graphs? How and why?
Science Research Mentoring Program STATISTICS © 2013 American Museum of Natural History. All Rights Reserved. 22 WORKSHEET: Statistical Analysis (continued) R E G R E S S I O N A N D C O R R E L A T I O N Investigators can use many different kinds of statistical analyses. We will use a statistical test called a regression analysis to analyze your specimens’ measurements. This type of analysis looks for cause-effect relationships between the A variable and Y variable by determining the degree of association between the two variables. The regression is determined by a mathematical procedure that evaluates how the observed data plotted on the graph can be explained by a straight line.

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern