Answer:
b. T.DIST
Step-by-step explanation:
Previous concepts
The t distribution (Student’s t-distribution) is a "probability distribution that is used to estimate population parameters when the sample size is small (n<30) or when the population variance is unknown".
The shape of the t distribution is determined by its degrees of freedom and when the degrees of freedom increase the t distirbution becomes a normal distribution approximately.
The degrees of freedom represent "the number of independent observations in a set of data. For example if we estimate a mean score from a single sample, the number of independent observations would be equal to the sample size minus one."
Solution to the problem
a. RAND
False, since this function is to generate a random number between 0 and 1. And is not used to calculate p values
b. T.DIST
Correct, since th population deviation is unknown and if we find the degrees of freedom we can calculate the p value with this function.
c. NORM.S.DIST
False, because this is in order to calculate the p value when the population deviation is given
d. Not enough information is given to answer this question.
False we have enough info to conclude this.