[Back to Home]
Chapter 1 Technology Assignment.
Use Excel to generate random numbers.
Step 1: Make sure Excel has the Analysis Toolpak installed.
Open Microsoft Excel.
Type this formula into a cell: =randbetween(1,100) then press Enter.
If Excel gives an error like the one below, saying "#NAME?", it means you need to install the Analysis Toolpak. If not, you can skip to Step 2.
The instructions for Loading the Analysis Toolpak are on the Microsoft Web Site here.
For the older versions of Microsoft Excel (97-2003) here's a summary of those instructions:
On the Tools Menu, choose Add-Ins.
Check the box next to Analysis ToolPak, and click Okay.
For the newer versions of Microsoft Excel (2007 - 2008) follow the instructions as suggested in this image (you can also find a clearer version using your own help index):
Step 2: Create an Excel sheet with the random numbers
Type the formula into a cell (like randbetween(1,100) ), and hit Enter. The random number should now show up. Use Excel's Auto-Fill feature to repeat the formula for a bunch of cells. Select the cell with the random number, and move the mouse to the bottom-right of the cell, over the little black dot:
When you do this, the mouse will turn to a black plus sign.
To fill, just click & drag that little black dot over several cells. When you let go, the formula will be copied into those cells:
Step 3: Submit your work.
Complete all three sections of the assignment:
- Use the randbetween() function to generate 25 random numbers between 1 and 100.
- Use the randbetween() function to generate 25 random numbers between 20 and 57.
- Use the randbetween() function to generate 10 random numbers between 1 and 5. Compare to 1.2 #9 (page 18)
Near the top of the document, type your name, "Math 190 Chapter 1 Technology Assignment", and which section you are in (01/1:30 PM or 02/3:00 PM).
Save and send according to the instructions on the homepage.