The Excel function =RANDBETWEEN(a,b) generates a random integer value between a and b. Open Excel. Copy and paste the Excel function into 30 cells (rows) starting at Column A at A1. Create 30 random values between 0 and 7 to simulate the response to the question, "How many times have you dined out in the past week?"Note: Once you have your 30 random values in Column A, select all values, copy the values, and use "Paste Special - Values" to Column B starting at B1. This will keep the spreadsheet from recalculating and changing your results.