Excel HW10

# Excel HW10 - Excel HW #10 In the Excel Manual, read page 60...

This preview shows pages 1–2. Sign up to view the full content.

Excel HW #10 In the Excel Manual, read page 60 (only the top half of the page). While you read the Excel Manual, use your computer to try out and experiment with each new step, using the same data-set that is used in the Manual. Column A contains the values of the X-variable from Textbook Example 4.29 (on page 272 of the Textbook); Column B contains the corresponding probabilities, from the same Example. Just type these numbers directly into Columns A & B of your Excel spreadsheet. In Column C, the formula =A2*B2 must be typed directly into cell C2. Notice that when you drag that formula down through cells C3, C4, C5, etc., it *automatically* adjusts itself to multiply the corresponding row entries: In cell C3 the formula becomes =A3*B3, etc. [Even after the numerical answer appears in a cell, you can still see the underlying formula by clicking on the cell to activate it, and then looking up at the Formula Bar near the top of the screen. For example, click on cell C4 (numerical value "0.375") to see the formula =A4*B4.] After

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 12/02/2008 for the course STOR 155 taught by Professor Andrewb.nobel during the Fall '08 term at UNC.

### Page1 / 2

Excel HW10 - Excel HW #10 In the Excel Manual, read page 60...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online