spreadsheet case study below:

Case Study 3. Salamanders Open the spreadsheet Case Study 03 Salamanders. As a weekend project, you decide to study if salamanders are more likely to inhabit forest floor areas with higher leaf litter. In your local forest, you sample twenty equal sized quadrats. For each quadrat, you enumerate how many salamanders and fallen leaves there are. Research interest do salamander counts rise with increased in leaf litter? Q.23. Which is the X-variable? o Sample o Number of leaves o Salamanders Q.24. What variable-type is the X-variable? Grouping - nominal o Grouping - ordinal Numeric - discrete Numeric - continuous Q.25. Which is the Y-variable? Sample Number of leaves o Salamanders Q.26. What variable-type is the Y-variable? o Grouping - nominal o Grouping - ordinal Numeric - discrete Numeric - continuous Q.27. Write in full your null hypothesis. Q.28. Which statistical test should you use to test the null hypothesis? T-test o Correlation o Chi-square Q.29. Run your analysis. What is the value of your test-statistic? Nb. Record your value to 3 decimal places. If the 4* decimal place is 5 or higher, round the 3r decimal place up. If the 4* decimal place is less than 5, round the 3 decimal place down. For example, a value of 3.4568 becomes 3.457; a value of 3.4564 becomes 3.456. Q.30. What is your p-value? o > 0.05 o 50.05 and > 0.01 o 30.01 and > 0.001 o 50.001 Q.31. Which type of graph is most appropriate for this analysis? o Bar chart o Means & whiskers o XY graph Mosaic plot Q.32. Referring to the Page 1 instructions, save a copy of your graph. Edit as needed to include axis labels. You will need upload the graph into Brightspace in Part III. Q.33. How do you interpret the results relative to the research goal? Write up to a one paragraph response. Salamanders and leaf litter Sample Number of leaves Salamanders 1 12 3 2 12 4 3 32 14 4 20 6 5 20 12 6 27 5 7 23 4 19 7 9 23 2 10 26 8 11 21 6 3 0 13 8 2 14 35 6 15 2 1 16 5 8 1 18 25 15 19 33 4 20 35 10 12 19 17