Psychologists question the importance of biodiversity on the psychological health of humans in urban areas. Urban residents often visit green spaces such as parks within urban environments. Fuller et al., conducted a study on 15 different green spaces to determine the impacts of green space on people's psychological health. To assess how much people liked the green space, scientists had participants fill out a survey to determine their attachment to the green space. Scientists then then quantified the biodiversity of birds, plants, and butterflies at the different green spaces. Here is a link to a dataset relating biodiversity to residents' attachment to a location. 1. Which biodiversity measurement (butterfly species; bird species; plant species) variable is most strongly correlated with residents' "attachment"? o Calculate the correlation coefficients using the =correl() function in Excel. 2. What is the standard error of that correlation? o Calculate your answer using Excel and report your answer to four decimal places. 3. Which species exhibited the weakest correlation? 4. What is the correlation coefficient of the weakest relationship? o Calculate your answer using Excel and report your answer to four decimal places. 5. What is the value of t for the correlation of bird species? o Report your answer to four decimal places 6. What is thep value associated with the t value calculated in Question 5? o Use the excel formula =2*(1-(T.Dist(ABS(t,df,TRUE))) o This is a two-tailed t-test o degrees of freedom (df) = o We are using a cumulative probability function so we type TRUE o Report your answer to 4 decimal places n - 2 7. Based on this p value, should the authors reject or fail to reject the null hypothesis that bird species abundance is not correlated to attachment? Site ID Attachment Area (ha) Butterfly Species Bird Species Plant Species 4.4 23.8 12 5.1 B 4.5 16 14 18 5.5 4.7 6.9 6.4 4.5 2.3 10 17 4.7 4.3 5.7 5.3 3.8 1.2 4 4.6 4.4 1.4 4.5 Н 4.6 15 22 5.5 4.1 3.1 5.2 4.2 3.8 4 4.6 K 4.6 7.6 10 11 4.5 4.2 12.9 11 4.3 4 12 13 4.4 5.6 11 16 5.6 4.2 4.9 5.4 |Σzo