Technology Assignment/ Probabilities
USE THE TEMPLATE ATTACHED TO THIS POST RATHER THAN THE TEMPLATE IN ALEKS. THE TEMPLATE INCLUDES INSTRUCTIONS FOR COMPLETING THE DQ.
For this DQ, youâ€™ll complete a modified version of Technology Assignment, for which youâ€™ll look at the empirical vs. theoretical probabilities of rolling a given number on a multi-sided die.
Download the attached template (â€œT5 DQ1 – Nameâ€) and follow the instructions in the text box to complete the Excel. Here is a video taking you through the steps: https://youtu.be/JLkSrTZtyR8
Here are some additional hints for completing the DQ:
Hint #1: The RANDBETWEEN() function used will be invoked each time you make a change in the Excel sheet, so your Frequency and Empirical Probability column entries will keep updating as you change the worksheet. This is normal.
Hint #2: Formulas
Â· Empirical Probability = Frequency/Total number of rolls
Â· Theoretical Probability = 1/Number of sides of the die
Â· Use the =AVERAGE() function in Excel.
Hint #3: For your response comparing the empirical probability with 1,000 rolls against the empirical probability with 4,000 rolls, what you should do is compare each average of differences. Which group of empirical probabilities is, on average, closer to the theoretical probabilities? (How would you be able to quantify â€œcloserâ€ in this case?) How might the number of rolls be contributing to this result?
I hope this helps; feel free to let me know if you have any questions.