-----------------------------------------------------------------------------------------------------------------------------------------
During the lesson the learner will:
1: Download and review the lesson instructions.
2: Read Caldwell, Chapter 8, Hypothesis Testing – T tests.
3: Watch the video: T-tests, Independent means (7:32 minutes). Notes are provided.
4: Watch the video: Hypothesis Testing: Two Independent Samples Using Excel … (3:50).
5: Watch the video: Related Samples T-test (6:07 minutes). Notes are provided.
6: Watch the video: Hypothesis Testing: Two Related Samples Using Excel …(4:42).
7: Watch the video: Using Excel to Solve Fishing Example (5:55 minutes).
8: Download the “t-test calculator” Excel file.
9: Watch the video: Bounds t-test calculator (3:45).
10: Download and review the study questions that are provided. Download the data in the Excel spreadsheet to be used with the study questions. These do not have to be submitted to the instructor but should be answered for your review. Video answers are provided to the study questions.
11: Review the answers to the study questions by viewing the video solutions.
-------------------------------------------------------------------------------------------------------------------------
Read Chapter 8 of the textbook
-------------------------------------------------------------------------------------------------------------------------Caldwell, S. (2010). Statistics Unplugged. (3rd ed.) Thomson Wadsworth: Belmont, California.
-------------------------------------------------------------------------------------------------------------------------
In this video Dr. Bounds will give an overview of hypothesis testing involving two independent means .
Click on the television or use this link to view this episode of the Lecture Series
Click here to download the video notes that accompany this video
-------------------------------------------------------------------------------------------------------------------------
In this video Dr. Bounds will give a demonstration of how to use Excel Data Analysis to compute the t statistic when testing a hypothesis involving two independent means .
Click on the television or use this link to view this episode of the Lecture Series
-------------------------------------------------------------------------------------------------------------------------
In this video Dr. Bounds will give an overview of hypothesis testing involving two related sample means. Related samples involve a two sets of data such as a pre-test and post-test.
Click on the television or use this link to view this episode of the Lecture Series
Click here to download the notes that accompany this video
-------------------------------------------------------------------------------------------------------------------------
In this video Dr. Bounds will give a demonstration of how to use Excel Data Analysis to compute the t statistic when comparing the means of two related samples.
Click on the television or use this link to view this episode of the Lecture Series
-------------------------------------------------------------------------------------------------------------------------
In this video Dr. Bounds will give an example of solving a test of significance involving two independent sample means. Smith and Jones argue over who is the best fisherman based on the average number of fish caught over a period of time. Using the t-test for independent means the two are able to determine if there is a statistically significant difference in the average number of fish caught.
Click on the television or use this link to view this episode of the Lecture Series
-------------------------------------------------------------------------------------------------------------------------
This Excel program should work on a PC or a Mac. Determine which t-test you want to perform - independent samples or related samples (see tabs at bottom of the spreadsheet to switch between the two). Enter the data in the appropriate columns and the program computes the t value. To delete the data, simply highlight it and delete it with the Delete key on your keyboard. DO NOT DELETE entire rows or columns since doing so will mess up the calculator.
-------------------------------------------------------------------------------------------------------------------------
In this video Dr. Bounds demonstrates how to use his instructor-created Excel program to solve t-test questions and will demonstrate how to use it to solve the Smith and Jones argument over who is the best fisherman based on the average number of fish caught over a period of time. Using the t-test for independent means the two are able to determine if there is a statistically significant difference in the average number of fish caught.
Click on the television or use this link to view this episode of the Lecture Series
-------------------------------------------------------------------------------------------------------------------------
The Study Questions are for review only. They do not have to be completed and submitted as an assignment. Answers to selected questions may be given. NOTE: Data for the study questions are also attached.
Click here to download Study Questions
Click here to download Study Questions Data
-------------------------------------------------------------------------------------------------------------------------
Click on the question to view the video solution to the study question.
Question 1 (4:30 minutes)
Question 2 (3:43)
Question 3 (3:57)
Question 4 (3:56)
Question 5 (3:23)
Question 6 (3:59)
Question 7 (3:34)
Question 8 (3:46)
Question 9 (3:27)
Question 10 (3:32)
-------------------------------------------------------------------------------------------------------------------------
