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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!