In: Statistics and Probability
you must calculate the deviations from the average, the manual correlation calculation and cross check it with Excel's correl function. Furthermore, you will generate the scatterplot graph, along with the trendline. Indicate whether there is a strong/weak/no correlation between the two variables.
Question:
The Swiss Hiking Federation is an organization that is known for promoting the same use of the hiking trail system throughout Switzerland. Suppose SHF would like to investigate the linear relationship between the amount of time to hike Wengen-Kleine trail in the Jungfrau region and the age of the hiker. A random sample of 7 hikers on this trail was selected and their age and hiking time is below.
AGE: 24 32 47 40 26 53 38
TIME: 2.7 4.2 5.0 3.8 2.2 2.9 3.0
Using XLS, calculate the correlation coefficient for this sample. Test to see if the population correlation coefficient is not equal to zero using a 90% CI. Here, you will use a two-tail test.