Hypothesis test (t-test) for a mean in Excel - statistics help

Dr Nic shows how to use Excel to perform a hypothesis test for mean using Excel. She also shows the overall hypothesis testing process, linked in with her other stats videos. 0:00 Introduction 0:26 Example: mean weights of apples 0:53 Null hypothesis and alternative hypothesis 1:06 One-tailed test or two-tailed test 1:24 Steps for hypothesis testing 1:50 Using Excel 2:50 Interpreting the p-value 3:12 Using the Data analysis ToolPak 4:18 T distribution 4:25 P-value This video gives a good illustration of the meaning and derivation of a p-value. If you would like more about where the p-value comes from, take a look at "Understanding where the p-value comes from": https://youtu.be/0-fEKHSeRR0 For a step-by-step description of how to use a p-value in a hypothesis test, see our video Hypothesis Testing: https://youtu.be/0zZYBALbZgg See https://creativemaths.net/videos/ for all of Dr Nic's videos organised by topic. #DrNicStats #Statistics #Excel