You are a teacher and have administered a reading test to 3rd graders. You want to analyze the test scores in the experiment. There are 3 groups: 1-the control group (using current teaching method) 2-the CBT group (using a computer based training method) 3-the hybrid group (using a combination of the current and CBT methods)
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.
I am using excel and need help filling out the chart and answering the questions below
| CONTEXT - You are a teacher and have administered a reading test to 3rd graders. You want to analyze the test scores | |||||||||
| in the experiment. There are 3 groups: | |||||||||
| 1-the control group (using current teaching method) | |||||||||
| 2-the CBT group (using a computer based training method) | |||||||||
| 3-the hybrid group (using a combination of the current and CBT methods) | |||||||||
| Answer the questions below the data. | |||||||||
| Control | CBT Only | Hybrid | General Stats | Control | CBT Only | Hybrid | |||
| 15 | 14 | 16 | Average | ||||||
| 11 | 12 | 14 | |||||||
| 12 | 13 | 13 | |||||||
| 14 | 11 | 17 | High | ||||||
| 15 | 15 | 15 | Low | ||||||
| 14 | 16 | 16 | Variance | ||||||
| 12 | 11 | 11 | Standard Deviation | ||||||
| 10 | 10 | 17 | |||||||
| 12 | 9 | 14 | |||||||
| 9 | 14 | 15 | Total number of students passing with 15 or higher | ||||||
| 14 | 13 | 12 | Total number of students failing with 14 or lower | ||||||
| 13 | 13 | 15 | Average passing grade for Hybrid Group | ||||||
| 13 | 11 | 11 | Average failing grade for the CBT group | ||||||
| 10 | 13 | 14 | |||||||
| 12 | 13 | 14 | |||||||
| 13 | 12 | 13 | |||||||
| 10 | 16 | 11 | |||||||
| 11 | 15 | 12 | |||||||
| 9 | 12 | 18 | |||||||
| 11 | 10 | 13 | |||||||
| 8 | 12 | 11 | |||||||
| 15 | 11 | 11 | |||||||
| 13 | 10 | 12 | |||||||
| 12 | 10 | 14 | |||||||
| Questions | |||||||||
| 1-Calculate the items in the general stats column (use .S descriptor for Variance and St Dev) | |||||||||
| 2-Based on the data provided, which method do you feel is the most effective? | |||||||||
| 3-Why do you think this method is most effective? | |||||||||
| 4-Which of the options provides results closest to the mean? | |||||||||
| 5-QUESTIONS about the above results: | |||||||||
| a-What does variance mean? | |||||||||
| b-What does standard deviation mean? | |||||||||
| c-What does a low standard deviation imply? What about a high standard deviation? | |||||||||
| WEBSITE for more info on Standard deviation and variance: | |||||||||
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
