Practical Example - Hypothesis Testing

The numbers and formulas used in comparison to the video, lecture, and solution are all different. It's a bit confusing... For example, the population variance in the lecture uses VARP to calculate the formula but the solution uses VAR.S. Also, when comparing the "Test (Part 2)" tab between video lecture to excel lecture, the numbers are different... It's not enough to change the outcome of the test but consistency or an explanation of why one or the other would be great.

In the video, the instructor gets the sample variance, while the Excel we download for the lesson gets the population variance. Still, this confuses me too. My belief is that the Excel file is not correct because, whether we are working with the male or female groups, these are samples of the whole population.

Any feedback from an instructor would be very valuable, though.

Julián

Hi People

I have seen the same problem. Why in the Excel file is showed "Population variance" and we are calculating "T-score". In this case, I believe must be "Sample variance", once T-score is to sample sampling.

So, would the correct calculation to p-value be two-tailed?

This exercise is doing many doubts.

We waiting for some help.

Best regards,

Emerson