Title: Mini Project 2 Non jamovi Version
Course: PSYC 301 Statistical Methods in Psychol

This is for folks who do NOT have jamovi on the computer they have access to. If you have jamovi on your computer, click here to do the assignment.

Here are the instructions that you had earlier.

For Mini Project 2, we will be testing a hypothetical situation of determining if a company makes fair dice. The specific kind of dice we are talking about are 20 sided dice, numbered 1 to 20, commonly used in role-playing games like Dungeons & Dragons. In most of these games getting higher numbers on a roll leads to a better outcome for the player.

Imagine you are a person who runs game conventions and you want to give each attendee a 20-sided die in their goodie bag. Of course, if you are like me, you care that they are good dice and you locate a nicely-priced supplier of bulk dice in a variety of festive colors. They arrive by the Postal Service in boxes of 50 dice each. You want to do a basic test of them to make sure they are fair. A fair die will deliver higher numbers (from 11 through 20) as often as lower numbers (from 1 through 10).  You take one box, unopened to a suitably large room with a flat open floor and dump the dice out from a couple of feet in the air. They tumble out wildly bouncing and skittering across the floor. You don't touch them except to pick up each die after writing down the number on a piece of paper, then tossing it back into the box. By the end of this you have confirmed you did indeed get 50 dice and you have the numbers recorded for each .

If you do not have jamovi, follow these steps:

1. Download the .csv (comma separated values) file.
2. Open the file using Excel or other spreadsheet program (Excel is preferred due to it being part of your browser based email in Office 365).
  1. In Office 365 (browser email) select Excel in the 'waffle menu'.
  2. Then, select 'Upload and open...'
  3. That will bring up your file selection options for your computer. Find and select the dice.csv file, wherever on your computer that you saved it.
  4. It will then open in Excel in a browser window. You should convert it to an editable format if it asks to do that.
3. Scroll down to line 52 and click in the B column for line 52. That is, select cell B52.
4. Copy and paste the following that is in red into that cell: =countif(B2:B51,"=H")
  - This Excel command 'counts if' each time over a range it satisfies the criteria, in this case equalling H.
  - Other spreadsheets such as Google Sheets, Apple Numbers, etc. all have the same or similar command.
5. If you didn't press your enter/return key, do so.
6. A number will appear there. That number is the total number of the die rolls that classify as 'high', meaning die rolls between 11 and 20.
7. go to this website: https://www.graphpad.com/quickcalcs/binomial1/
8. You should see this:
9. You will fill in the blanks in the web page:
  1. For number of successes, put in the value from that Countif command
  2. For the number of trials, put in 50 because that's the total number of dice that were rolled.
  3. For the probability, leave it at .50, because our null hypothesis is that half the rolls are 11 and above, and half are 10 and below.
10. You will get an answer page next. It will confirm the information you supplied and provide two probabilities. One is for a one-tailed test, but we want the one for the two-tailed test.
11. That number that is next to the P is the probability of our observing our data if in fact the data was distributed as .50 probability, if the die was fair.
12. If that probability is 0.05 or less, then we can reject the null hypothesis that the dice are as likely to roll high as low. But, if that probability is greater than 0.05, then we retain the null hypothesis.
13. Write down that probability.

At this point, click here return to the assignment to find the questions you need to answer.