2. Make sure you have installed the Excel Data Analysis ToolPak
3. Watch Dr. Curren’s video tutorial at (Dr. Curren walks you through some of the Excel steps needed for the studies you will conduct this semester.This video tutorial uses slightly different methods, but you will get similar results. Note that the data in the Excel sheet you downloaded has been altered therefore your calculations will be different than the video)
4. Use the Excel sheet to complete the exercises below ….
5. Using a t-test, determine if there is a significant difference in height above the ground between galls that were preyed upon by beetles and those that were not
Answer:
6. Calculate the average diameter (with standard deviation) for all the galls
Answer:
7. Use a t-test to determine if the diameter of the galls is significantly different between galls that have and have not been parasitized by and wasps
Answer:
8. Enter the results of your calculations on the assignment and answer the questions there
Answer:
0 comments