Researchers are interested in whether Study Method A (Sample A) and Study Method B (Sample B) result in different test scores. The researchers drew two separate random samples of students and required Sample A to study using Study Method A and required Sample B to study using Study Method B. After one month of studying, both samples took the same test. Use Excel to perform an independent sample t-test to determine if the mean test scores from Sample A and B significantly differ. Assume unequal variance. Sample A Sample B 73 87 82 100 67 88 66 80 95 99 90 97 89 92 90 70 75 98 78 100 69 79 87 91 90 90 82 89
Inverse Normal Distribution
The method used for finding the corresponding z-critical value in a normal distribution using the known probability is said to be an inverse normal distribution. The inverse normal distribution is a continuous probability distribution with a family of two parameters.
Mean, Median, Mode
It is a descriptive summary of a data set. It can be defined by using some of the measures. The central tendencies do not provide information regarding individual data from the dataset. However, they give a summary of the data set. The central tendency or measure of central tendency is a central or typical value for a probability distribution.
Z-Scores
A z-score is a unit of measurement used in statistics to describe the position of a raw score in terms of its distance from the mean, measured with reference to standard deviation from the mean. Z-scores are useful in statistics because they allow comparison between two scores that belong to different normal distributions.
- Researchers are interested in whether Study Method A (Sample A) and Study Method B (Sample B) result in different test scores. The researchers drew two separate random samples of students and required Sample A to study using Study Method A and required Sample B to study using Study Method B. After one month of studying, both samples took the same test.
Use Excel to perform an independent sample t-test to determine if the mean test scores from Sample A and B significantly differ. Assume unequal variance.
|
Sample A |
Sample B |
|
73 |
87 |
|
82 |
100 |
|
67 |
88 |
|
66 |
80 |
|
95 |
99 |
|
90 |
97 |
|
89 |
92 |
|
90 |
70 |
|
75 |
98 |
|
78 |
100 |
|
69 |
79 |
|
87 |
91 |
|
90 |
90 |
|
82 |
89 |
Hypotheses for the test is given below:
Step by step
Solved in 2 steps with 1 images
