Question: Watch the Lab 3 video entitled Assessing Statistical Independence for a Dice Sim- ulation in Microsoft@ Excel@. The data set labeled Dice Simulation reports the

Watch the Lab 3 video entitled "Assessing Statistical Independence for a Dice Sim- ulation in Microsoft@ Excel@". The data set labeled "Dice Simulation" reports the outcome of a computer simulation in which two five-sided dice (numbered from 1-5) are rolled repeatedly (N = 5,000 trials). (a) For each of the pairwise events defined in Question 1 (A-B, A-C, B-C), use Mi- crosoft@ Excel to complete the following steps 1 - 3. 1. Create a cross-tabulation table. 2. Fix the marginal counts and predict the expected cross-tabulation table under statistical independence. 3. Compute the test statistic: T = > (Observed; - Expected;)2 Expected (b) Report the test statistic (T) for the pair-wise comparison (A - B). Round your answer to one decimal place. (c) Report the test statistic (T) for the pair-wise comparison (A - C). Round your an- swer to one decimal place
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
