Hey guys! Here are a few sample problems to help you get used to formatting documents for MSExcel or for SPSS.
sample problems:- A study was done to examine the relationship between shoe size and height in men. The data is in tab-delimited text format.
Use excel to import the data and run an ANOVA to see if the height classes have different mean shoe sizes. Then run a t-test to see if there is a difference between shoe sizes
for the tallest group and the shortest group of men measured.
You can find the answer here.
- A study was done to determine the effectiveness of three different chemotherapies on reduction of tumor size. The tab-delimited data represent
percent reduction in tumor size for each treatment. Use SPSS to run an ANOVA on these data. You can find the answer here.
- A study was conducted to determine the relationship between sprint speed, mass, and ambient temperature in wolf spiders. The data were saved
as an excel file. Import the data into excel, and run an ANOVA for sprint speed. Then, export the data into a tab-delimited text document which can be opened with
SPSS. Run a bivariate correlation between Mass and Sprint Speed. Create a scatterplot showing the relationship between sprint speed and
mass. On this scatterplot, be sure to separate out the groups and fit a
line to each group. You can find the answer here.
- We collected spiders from several field sites in order to determine the amount of intraspecific variation in reproductive structures between populations.
We measured two angles of key importance on the reproductive structures. The other numbers in the data set are ID numbers for the individuals. The data are saved as an excel file. Use excel to run an ANOVA to
see if there are any significant differences between populations for angle 1. Export the data to SPSS and run an ANOVA to see if the same effect exists
for angle 2. Run some normality tests in SPSS to make sure your data are normally distributed. You can check your answer here.
