Questions:

a$)$ Using MS Excel, create a scatter plot with cholesterol saturation index values $($CSI$)$ on

the x $-$axis and nucleation times $($NT$)$ on the y $-$axis. $(1$ Point$)$

b$)$ Summarize the plot. $(1$ Points$)$

c$)$ Calculate the mean value for the CSI$($x$)($round to $2$ decimal place$).$ Show your work. $(1$

Points$)$

d$)$ Calculate the mean value for NT $($y$)($round to $2$ decimal place$).$ Show your work. $(1$

Points$)$

e$)$ Complete the table above and compute the following:

I. Calculate the sum of xy $($round to $2$ decimal place$).(1$ point$)$

II$.$ Calculate the Sum of x$^(2)($round to $2$ decimal place$).(1$ point$)$

III. Calculate the sum of y$^(2)($round to $2$ decimal place$).(1$ point$)$

f$)$ Calculate the correlation coefficient $($round to $3$ decimal place$).$ Show your work. $(3$

Points$)$

g$)$ Summarize the strength of the relationship between CSI and NT$.(1$ Point$)$

h$)$ State the null and alternative hypothesis. $(1$ Point$)$

i$)$ Calculate t$-$test statistic for the correlation $($round to $3$ decimal place$).$ Show your work.

$(2$ Points$)$

j$)$ Find the degrees of freedom. Show your work. $(1$ point$)$

k$)$ Let alpha $=0\mathrm{.}05,$ find the critical value $($round to $3$ decimal place$)$ and state your

conclusion. $(1$ Point$)$

I$)$ Let alpha $=0\mathrm{.}05,$ find the p$-$value $($round to $3$ decimal place$)$ and state your conclusion.

$(1$ Point$)$