In Google Sheets, complete the following: Generate a random number between 1 and 1694 (use =RANDBETWEEN(1,1694)). Drag the formula down till you have 2372 numbers. Each of these numbers will represent a person in a trial, where the numbers 1 - 3 represent people that developed ear infections. With the first column highlighted, drag the formula to the right till you have 20 columns (T is the 20th letter). Each column represents its own trial. Your spreadsheet represents 20 separate trials. Copy all of the generated numbers, and "Paste Values," so the numbers don't keep regenerating. Under the A column (in a cell below your data) count how many people have developed ear infections by using the command =COUNTIF(A1:A2372,"<=3") Highlight the cell with your COUNTIF statement and drag it over to the T column so that you can count the ailments in each trial. Save the Google Sheets file as an .xlsx (File >> Download >> Microsoft Excel)