Name:________________________
Begin the exposition of your work on this page. If more room is needed, continue on sheets of paper of exactly the same size (8.5 x 11 inches), lined or not as you wish, but not torn from a spiral notebook. You should do your initial work and calculations on a separate sheet of paper before you write up the results to hand in.
Output from Excel must have your name and the homework number in cell A1. Staple all sheets together. No unstapled papers will be accepted.
1. Do all of problem 2.12 on page 46 by hand. For part (a), construct the histogram by hand. Use graph paper, a ruler and label the axes and the class endpoints.
2. In this problem you will use Excel to produce the same histogram. As this will serve as your introduction to Excel, I will give you step by step instructions for how to do it. If you have had no prior experience using Excel, it will probably take you at least four times as long to produce the histogram as it took you to do it by hand. Do not be discouraged. After a few hours with Excel you will begin to appreciate the help a computer can give you in doing data analysis.
a). Go to a computer that has Excel on it. For example, all the computers in the Artsci Computer Lab in the basement of Cupples I have Excel.
b). Locate the Excel icon on the screen (if the screen is dark, nudge the mouse. If you don't know what the mouse is, get help fast). Double-click on the Excel icon.
c). When the spreadsheet grid appears, in cell A1 type your name (first and last) followed by a comma and then HW1. In subsequent homeworks, change HW1 to the actual homework number.
d). Enter the data for problem 2.12 which appears on page 47 of the text. There are a number of ways to do this. You have this data on a diskette which came with your text book (if you purchased a new copy). In a later lesson you will learn how to take the data for this problem from the diskette and load it into an Excel spreadsheet. If you already know how to do that, go ahead and do it. Otherwise, here are the instructions for entering data by hand. Starting at cell A2, type in the numbers in five rows, just as they appear in problem 2.12. Your last entry, an 11, will go into cell J6. Note: this is not the only way to enter the data. In later situations you'll find that you need to enter such data into a single column.
e). When you did part (b) of problem 2.12, you found the endpoints of the classes. Put them in ascending order, discard the first and the last, and enter the remaining ones in column K, beginning at cell K2 and ending at cell K4, since there are six class endpoints and you have discarded two of them.
f). On the top menu bar, click on Tools, go to the bottom of the dropped down list and click on Data Analysis (if Data Analysis doesn't appear, see Note below), on its dropped down list click on Histogram and then click on the OK box. Let's agree that from now on I will write such a sequence of clickings as:
Note: If Data Analysis doesn't appear on the Tools drop down list, click on Add-Ins instead. On the list of Add-Ins Available, click to put a check in the box preceding Analysis ToolPak and then click OK. Now go back to Tools and follow the above instructions.
g). At this point you should have the Histogram form on the screen waiting for you to fill in the blanks. Namely,
h). Everything should be done now. Fiddle a bit with what you have to edit the labels on the histogram or to move it to the bottom of the page. As you move the cursor around on the histogram, you will see such instructions appear near the bottom left of the screen. For example, click on any place on the histogram box and you can drag it to anywhere else on the page. Move the cursor to a corner of the histogram box and the cursor will change into a double arrow. Click and hold and you can stretch the histogram box sideways and down to make it as large as you like.
i). Print the sheet you are on by clicking File/PrintPreview, to see on the screen what it will look like printed. If you are satisfied with it, then click print. If not, go back and work on it some more.
j). When you are satisfied with what you have, and you have printed it, click on File/SaveAs and then save it to the floppy disk you should carry with you to save all your Math 320 computer work on. It will ask you to assign a name to the file. Something like a:HW1 will work for saving it to your floppy as file HW1. It will automatically add the appropriate three-letter extension for Excel files.
k). Suppose you goofed and it's not what you want. If it's just the histogram that needs to be redone, do that and give the same cell as before for the Output Range. The old histogram will be erased and replaced by the new one. If something more has to be changed, you can go to a new sheet. Notice the file tabs at the bottom of the spreadsheet screen. You have been working on sheet one. Click on sheet two, and you get a fresh spreadsheet. If for some reason you wanted to copy the data to the new sheet, you do this by clicking the copy icon at the top, but just below the menu bar. Let the cursor rest on each of these icons and a label will appear telling you what it is. After clicking the copy icon, highlight the block of cells you wish to copy from Sheet 1. For example, hold down the left mouse button on cell A2 and drag it to cell J6. The block of data is now outlined. Click on Sheet 2, click on cell A2 (you've written your name and HW1 in A1) and then click on the paste icon. That is how you move stuff. Even the graphs can be moved in a similar fashion. When you are done, don't forget to save. It will be the same file, but now with Sheets 1 and 2. Print Sheet 2 by clicking on the Sheet 2 tab and then clicking on File/Print.
One advantage to using new sheets is that all your work on HW1 will be in a single file. Old mistakes can sometimes be instructive. Save everything.