Documents Found!
As seen in
Less Work, Better Grades
Join
Course Hero
Access
best resources
Ace
your classes
Ace your courses with Course Hero!
|
|
|
Study Smarter, Score Higher
Here are the top 5 related documents
...Math 251, Test 2 Wednesday, May 19, 2004 Name: Hints and Answers
Instructions. Complete each of the following 9 problems. Please show all appropriate details in your solutions. Good Luck. 1. (15 pts) (a) Find the mean and standard deviation for the ...
...Math 251, Test 3, 21 November 2003 Name. 1. (20 pts) (a) Let x be a random variable from any population with mean and standard deviation . What type of distribution will the distribution for x from samples of size n with n large approximate? Answe...
...Normal Approximation to Binomial Distribution
Consider the binomial distribution with n trials, and probability of success is p This distribution is approximately normal if np > 5 and nq > 5. In this case it is approximated by a normal distribut...
...Z Score
The z value or z score tells the number of standard deviations the original measurement is from the mean. The z value is in standard units.
Copyright (C) 2002 Houghton Mifflin Company. All rights reserved.
1
Formula for z score
x- z=
C...
Document Content (unformatted)
Course Hero has millions of student submitted documents similar to the one
below including study guides, homework solutions, papers, exam answer keys and textbook solutions.
1 Problem 702,000 430,100 1,532,000 175,000 1,500,600 400,000 295,000 646,800 62,000 648,500 175,000 328,400 403,400 432,400 381,600 425,000 101,800 440,000 1,501,100 429,000 182,000 283,500 2,626,100 400,600 175,000 132,000 429,600 400,600 1,643,600 1,200,600 175,000 400,600 257,000 699,600 175,000 189,000 934,600 431,500 62,000 4,250,000 122,600 1,575,300 900,600 335,000 259,900 5,175,000 192,000 2,678,000 250,000 Math 251: Excel Assignment 1 The data in cells A1 to A972 represent total pay for NFL players in US dollars for the year 2000. The total pay includes salary and bonuses. Problem 1. a) Highlight column A and copy it column c. Use click and paste options as in Word. b) Sort the data in column c) in ascending order. Do this by highlighting column c, then click on Data and choose the sort option. Make sure that ascending order is selected and then click ok. c) What is the lowest total pay? d) As in a) and b) copy the data in column a) to column e), but this time sort in descedning order. e) What is the highest total pay in the list? f) How many players had total pay more than 1,000,000? To do this enter =countif(a1:a972, ">1000000") in a cell below, or manually check it from one of sorted lists. g) How many players had salaries between 1,000,000 and 2,000,000 inclusive? To do this enter =countif(a1:a359,"<2000001") - countif(a1:a359, "<1000000") in a cell below, or manually check it on one of your ordered lists. h) How many players had total pay between 500,000 and 1,000,000 inclusive? Click on Problem 2 for your second question. Page 1 Problem 1 423,000 2,700,000 429,600 203,000 Page 2 Problem 1 250,000 880,000 325,000 5,000,000 250,800 263,900 2,898,600 269,500 3,400,600 62,000 872,800 3,425,000 1,300,000 175,000 1,603,400 1,623,100 865,400 1,323,900 331,600 2,402,000 803,400 1,423,400 219,000 2,300,400 979,800 342,600 416,500 578,500 925,000 326,000 62,000 62,000 175,000 250,000 343,900 1,381,000 477,500 365,600 620,000 426,500 62,000 175,000 502,900 1,013,300 189,000 525,000 853,000 603,800 250,000 Page 3 Problem 1 2,000,000 428,700 109,000 652,700 179,100 370,000 266,800 288,000 375,000 253,600 325,000 1,503,000 276,300 453,000 365,600 62,000 2,800,000 655,900 260,000 1,634,000 3,849,000 3,250,000 267,500 1,300,000 253,600 609,100 207,200 328,300 207,000 317,000 1,128,200 310,000 148,000 3,126,900 192,600 477,500 934,000 62,000 259,000 3,200,300 328,400 470,000 196,000 936,700 1,862,000 400,000 2,503,100 703,400 803,400 Page 4 Problem 1 1,338,200 578,600 425,000 262,000 175,000 702,200 438,300 400,000 175,000 394,400 62,000 62,000 267,400 412,200 346,300 953,300 1,046,000 743,300 338,200 2,203,400 135,600 180,000 608,500 1,403,400 328,400 402,200 208,000 175,000 551,500 2,003,300 500,000 341,000 320,000 325,000 937,300 62,000 2,053,500 628,200 600,000 5,153,300 208,000 839,000 4,175,000 1,100,000 62,000 2,876,000 1,261,000 550,000 112,000 Page 5 Problem 1 250,000 2,593,000 250,000 325,000 121,000 429,000 3,517,000 175,000 577,000 2,877,000 1,033,000 1,503,000 3,251,000 62,000 2,125,000 333,000 402,000 1,401,000 285,000 917,000 1,000,000 826,000 451,000 921,000 510,000 476,000 627,000 433,000 62,000 327,000 175,000 400,000 175,000 490,000 430,000 658,000 651,000 265,000 177,000 410,000 62,000 1,053,000 750,000 270,000 577,000 651,000 350,000 583,000 327,000 Page 6 Problem 1 595,000 825,000 400,000 196,000 1,519,000 414,000 62,000 667,000 502,000 351,000 600,000 350,000 6,667,300 175,000 1,932,200 861,800 175,000 62,100 325,000 144,200 449,500 498,000 325,000 985,000 1,301,600 175,000 60,000 402,800 62,100 431,800 327,800 375,000 287,800 176,000 400,000 1,093,200 327,200 2,178,900 1,115,100 869,500 175,000 252,800 814,500 2,338,200 183,000 327,800 237,600 942,800 588,200 Page 7 Problem 1 526,700 62,100 327,800 62,100 400,000 334,500 400,000 175,000 291,700 178,500 255,000 416,700 62,100 681,200 327,800 212,800 6,200,000 2,783,700 2,610,800 127,500 400,000 1,101,400 552,000 250,000 124,800 177,000 750,000 417,500 62,100 602,800 1,836,900 2,923,200 231,000 502,100 1,570,100 426,300 461,300 254,100 254,100 1,628,100 401,700 400,000 400,000 256,000 976,000 359,200 1,320,000 1,476,300 511,500 Page 8 Problem 1 62,000 317,000 175,000 2,189,800 1,002,300 62,000 601,600 838,000 811,600 400,000 795,200 700,000 400,000 262,000 250,000 600,200 1,568,000 328,400 328,600 429,200 192,000 3,497,600 1,251,000 251,400 178,500 1,108,800 3,450,400 184,000 527,100 345,500 450,800 250,000 824,100 505,700 1,525,600 621,400 396,700 179,500 700,300 2,639,500 669,500 859,300 325,000 62,000 478,000 432,100 253,300 175,000 62,000 Page 9 Problem 1 62,000 350,000 2,072,200 400,000 339,300 254,200 169,500 175,000 162,000 575,700 280,200 231,000 3,451,800 2,672,700 3,000,700 3,300,700 185,000 860,000 6,249,000 175,000 62,000 1,068,900 325,000 62,000 253,400 175,000 953,000 1,105,700 281,000 62,000 400,000 62,000 1,807,000 2,901,000 350,800 378,200 250,000 175,000 272,600 935,400 290,000 851,100 179,000 178,200 141,000 201,000 961,900 360,000 613,900 Page 10 Problem 1 484,600 336,900 175,000 626,100 986,900 470,000 351,500 479,600 1,750,700 425,000 1,201,000 1,651,000 62,000 783,000 500,000 250,000 253,500 375,000 485,000 268,000 325,000 834,300 3,810,000 1,877,000 1,260,000 250,000 400,000 1,270,000 2,133,000 62,000 971,200 400,000 400,000 1,112,900 329,000 1,500,000 325,000 1,025,000 1,130,000 400,000 252,000 175,000 62,000 400,000 517,000 400,000 250,000 1,400,000 3,145,000 Page 11 Problem 1 400,000 175,000 400,000 429,000 1,247,000 175,000 800,000 400,000 3,817,000 3,479,000 175,000 791,000 189,000 2,275,000 62,000 2,248,000 1,491,000 343,400 117,000 874,000 625,000 429,000 354,000 62,000 537,600 254,000 432,400 328,400 1,212,000 433,000 328,400 272,400 476,300 62,000 105,000 456,400 175,000 600,000 593,000 537,000 459,000 402,100 250,000 1,405,000 432,400 2,647,500 1,062,000 175,000 440,000 Page 12 Problem 1 2,290,000 325,200 250,000 175,000 1,793,000 328,400 1,250,000 175,000 5,600,000 633,000 892,000 753,400 101,000 104,400 2,693,000 733,200 700,000 1,420,400 1,586,400 185,000 287,200 335,000 799,200 175,000 3,437,000 595,000 62,000 431,800 432,400 2,083,000 415,000 108,000 62,000 175,200 610,000 606,400 175,000 1,787,000 338,200 175,000 253,400 1,438,000 250,000 1,900,000 410,200 392,800 2,328,800 645,600 260,000 Page 13 Problem 1 400,000 793,000 1,234,100 308,000 344,200 175,000 1,653,600 259,300 865,500 936,800 431,800 329,200 62,000 433,200 359,200 1,670,200 1,503,900 184,000 934,700 1,846,000 2,550,000 1,334,000 433,100 468,000 1,608,800 472,500 62,000 177,000 401,300 416,100 325,000 664,100 465,000 406,200 280,500 937,900 105,300 328,400 359,100 950,000 448,800 206,000 325,000 475,800 2,926,000 2,851,100 62,000 1,865,400 4,277,200 Page 14 Problem 1 175,000 62,000 1,152,400 1,205,900 189,000 149,000 179,200 1,528,300 1,694,400 254,500 1,002,900 176,000 743,100 62,000 401,100 175,000 325,000 233,000 323,000 1,200,000 175,000 498,200 181,000 2,519,300 500,000 329,000 450,000 175,000 3,200,900 1,902,900 517,000 175,000 2,295,500 551,500 1,053,400 350,000 2,025,000 550,000 475,000 325,000 2,128,600 62,000 194,000 430,000 1,044,000 1,789,000 430,300 238,000 436,200 Page 15 Problem 1 1,466,000 283,800 250,000 372,200 176,000 253,600 1,688,000 175,000 2,308,000 62,000 3,751,300 676,900 1,480,000 2,902,500 358,600 953,500 350,000 5,101,200 328,400 175,000 186,000 266,000 1,375,000 327,000 250,000 62,000 325,000 267,500 131,000 325,000 62,000 1,742,000 600,000 350,000 450,000 437,200 1,533,000 1,075,000 182,000 250,000 525,000 650,000 271,600 420,000 250,000 700,000 337,800 1,450,000 205,000 Page 16 Problem 1 206,000 480,000 175,000 400,000 62,000 175,000 177,800 250,000 1,385,000 757,000 675,000 325,000 432,000 550,000 1,427,000 289,000 282,600 1,449,000 157,000 450,000 250,800 350,000 260,000 3,090,000 250,000 325,000 324,000 175,000 176,000 400,000 1,042,000 164,000 62,000 62,000 1,600,000 550,000 725,000 625,000 175,000 2,000,000 1,400,000 2,556,000 5,850,000 177,000 1,366,000 353,700 192,000 62,000 511,000 Page 17 Problem 1 2,925,000 800,000 375,000 1,862,200 328,400 285,000 950,000 523,000 62,000 62,000 1,410,400 4,309,000 737,000 260,200 101,000 232,000 3,128,300 432,400 338,300 250,000 176,000 600,000 1,696,000 400,000 198,400 175,000 398,400 1,850,000 178,000 400,000 1,250,000 62,000 250,700 3,377,000 1,575,000 593,000 552,500 432,200 62,000 375,000 335,000 2,313,000 178,000 1,500,000 401,200 62,000 206,000 731,000 350,000 Page 18 Problem 1 3,502,500 402,300 650,400 753,900 175,000 600,400 432,300 339,800 400,000 1,868,000 462,000 257,900 2,481,400 1,583,000 2,516,600 1,147,000 463,600 429,000 1,201,400 272,200 1,052,000 62,000 454,000 431,500 62,000 978,600 3,523,100 328,600 62,000 379,800 1,399,700 3,751,100 554,200 308,000 622,700 3,469,400 353,200 400,000 259,000 603,900 1,112,800 557,100 450,000 1,991,100 1,761,200 400,000 182,000 1,074,000 207,000 Page 19 Problem 1 175,000 478,600 350,000 701,100 2,900,800 62,000 937,900 254,200 715,600 391,200 327,500 400,000 6,230,600 389,500 254,500 620,000 350,000 334,400 539,800 903,900 602,500 328,400 378,100 533,500 352,500 1,632,000 333,500 1,513,700 894,500 261,500 504,500 400,000 675,000 1,010,300 400,100 252,200 1,002,500 937,900 253,900 62,000 937,900 288,500 400,000 603,000 400,000 2,268,200 254,500 600,000 386,600 Page 20 Problem 1 522,000 479,500 3,902,800 2,950,000 587,000 329,500 1,159,500 325,000 400,000 62,000 425,000 1,603,400 375,000 62,000 675,800 1,503,600 654,500 356,500 273,200 1,125,000 453,400 472,500 131,000 62,000 436,900 451,100 2,576,900 325,000 62,000 175,000 329,500 452,800 694,600 379,500 453,100 2,904,500 2,017,000 Page 21 Problem 2 702,000 430,100 1,532,000 175,000 1,500,600 400,000 295,000 646,800 62,000 648,500 175,000 328,400 403,400 432,400 381,600 425,000 101,800 440,000 1,501,100 429,000 182,000 283,500 2,626,100 400,600 175,000 132,000 429,600 400,600 1,643,600 1,200,600 175,000 400,600 257,000 699,600 175,000 189,000 934,600 431,500 62,000 4,250,000 122,600 1,575,300 900,600 335,000 259,900 5,175,000 192,000 2,678,000 250,000 423,000 2,700,000 429,600 203,000 Problem 2. Make a histogram of the data in Column A whose first class has lower limit of 0 and upper limit of 499,999. Use the class boundaries for the bin numbers. This is the same data as in problem 1. To do this: Click on Tools Select Data Analysis Select Histogram The "Input Range" is A1:A972 (the cells containing the data) The Bin Range is the cells in which you wrote the class boundaries. Select the box by Chart Output and Excel will include the graph. Click on OK and Excel will create the Histogram Excel will put the Histogram on a new sheet by default. Click on the graph and grab a corner and re size it so it looks good to you. Page 22 Problem 2 250,000 880,000 325,000 5,000,000 250,800 263,900 2,898,600 269,500 3,400,600 62,000 872,800 3,425,000 1,300,000 175,000 1,603,400 1,623,100 865,400 1,323,900 331,600 2,402,000 803,400 1,423,400 219,000 2,300,400 979,800 342,600 416,500 578,500 925,000 326,000 62,000 62,000 175,000 250,000 343,900 1,381,000 477,500 365,600 620,000 426,500 62,000 175,000 502,900 1,013,300 189,000 525,000 853,000 603,800 250,000 2,000,000 428,700 109,000 652,700 Page 23 Problem 2 179,100 370,000 266,800 288,000 375,000 253,600 325,000 1,503,000 276,300 453,000 365,600 62,000 2,800,000 655,900 260,000 1,634,000 3,849,000 3,250,000 267,500 1,300,000 253,600 609,100 207,200 328,300 207,000 317,000 1,128,200 310,000 148,000 3,126,900 192,600 477,500 934,000 62,000 259,000 3,200,300 328,400 470,000 196,000 936,700 1,862,000 400,000 2,503,100 703,400 803,400 1,338,200 578,600 425,000 262,000 175,000 702,200 438,300 400,000 Page 24 Problem 2 175,000 394,400 62,000 62,000 267,400 412,200 346,300 953,300 1,046,000 743,300 338,200 2,203,400 135,600 180,000 608,500 1,403,400 328,400 402,200 208,000 175,000 551,500 2,003,300 500,000 341,000 320,000 325,000 937,300 62,000 2,053,500 628,200 600,000 5,153,300 208,000 839,000 4,175,000 1,100,000 62,000 2,876,000 1,261,000 550,000 112,000 250,000 2,593,000 250,000 325,000 121,000 429,000 3,517,000 175,000 577,000 2,877,000 1,033,000 1,503,000 Page 25 Problem 2 3,251,000 62,000 2,125,000 333,000 402,000 1,401,000 285,000 917,000 1,000,000 826,000 451,000 921,000 510,000 476,000 627,000 433,000 62,000 327,000 175,000 400,000 175,000 490,000 430,000 658,000 651,000 265,000 177,000 410,000 62,000 1,053,000 750,000 270,000 577,000 651,000 350,000 583,000 327,000 595,000 825,000 400,000 196,000 1,519,000 414,000 62,000 667,000 502,000 351,000 600,000 350,000 6,667,300 175,000 1,932,200 861,800 Page 26 Problem 2 175,000 62,100 325,000 144,200 449,500 498,000 325,000 985,000 1,301,600 175,000 60,000 402,800 62,100 431,800 327,800 375,000 287,800 176,000 400,000 1,093,200 327,200 2,178,900 1,115,100 869,500 175,000 252,800 814,500 2,338,200 183,000 327,800 237,600 942,800 588,200 526,700 62,100 327,800 62,100 400,000 334,500 400,000 175,000 291,700 178,500 255,000 416,700 62,100 681,200 327,800 212,800 6,200,000 2,783,700 2,610,800 127,500 Page 27 Problem 2 400,000 1,101,400 552,000 250,000 124,800 177,000 750,000 417,500 62,100 602,800 1,836,900 2,923,200 231,000 502,100 1,570,100 426,300 461,300 254,100 254,100 1,628,100 401,700 400,000 400,000 256,000 976,000 359,200 1,320,000 1,476,300 511,500 62,000 317,000 175,000 2,189,800 1,002,300 62,000 601,600 838,000 811,600 400,000 795,200 700,000 400,000 262,000 250,000 600,200 1,568,000 328,400 328,600 429,200 192,000 3,497,600 1,251,000 251,400 Page 28 Problem 2 178,500 1,108,800 3,450,400 184,000 527,100 345,500 450,800 250,000 824,100 505,700 1,525,600 621,400 396,700 179,500 700,300 2,639,500 669,500 859,300 325,000 62,000 478,000 432,100 253,300 175,000 62,000 62,000 350,000 2,072,200 400,000 339,300 254,200 169,500 175,000 162,000 575,700 280,200 231,000 3,451,800 2,672,700 3,000,700 3,300,700 185,000 860,000 6,249,000 175,000 62,000 1,068,900 325,000 62,000 253,400 175,000 953,000 1,105,700 Page 29 Problem 2 281,000 62,000 400,000 62,000 1,807,000 2,901,000 350,800 378,200 250,000 175,000 272,600 935,400 290,000 851,100 179,000 178,200 141,000 201,000 961,900 360,000 613,900 484,600 336,900 175,000 626,100 986,900 470,000 351,500 479,600 1,750,700 425,000 1,201,000 1,651,000 62,000 783,000 500,000 250,000 253,500 375,000 485,000 268,000 325,000 834,300 3,810,000 1,877,000 1,260,000 250,000 400,000 1,270,000 2,133,000 62,000 971,200 400,000 Page 30 Problem 2 400,000 1,112,900 329,000 1,500,000 325,000 1,025,000 1,130,000 400,000 252,000 175,000 62,000 400,000 517,000 400,000 250,000 1,400,000 3,145,000 400,000 175,000 400,000 429,000 1,247,000 175,000 800,000 400,000 3,817,000 3,479,000 175,000 791,000 189,000 2,275,000 62,000 2,248,000 1,491,000 343,400 117,000 874,000 625,000 429,000 354,000 62,000 537,600 254,000 432,400 328,400 1,212,000 433,000 328,400 272,400 476,300 62,000 105,000 456,400 Page 31 Problem 2 175,000 600,000 593,000 537,000 459,000 402,100 250,000 1,405,000 432,400 2,647,500 1,062,000 175,000 440,000 2,290,000 325,200 250,000 175,000 1,793,000 328,400 1,250,000 175,000 5,600,000 633,000 892,000 753,400 101,000 104,400 2,693,000 733,200 700,000 1,420,400 1,586,400 185,000 287,200 335,000 799,200 175,000 3,437,000 595,000 62,000 431,800 432,400 2,083,000 415,000 108,000 62,000 175,200 610,000 606,400 175,000 1,787,000 338,200 175,000 Page 32 Problem 2 253,400 1,438,000 250,000 1,900,000 410,200 392,800 2,328,800 645,600 260,000 400,000 793,000 1,234,100 308,000 344,200 175,000 1,653,600 259,300 865,500 936,800 431,800 329,200 62,000 433,200 359,200 1,670,200 1,503,900 184,000 934,700 1,846,000 2,550,000 1,334,000 433,100 468,000 1,608,800 472,500 62,000 177,000 401,300 416,100 325,000 664,100 465,000 406,200 280,500 937,900 105,300 328,400 359,100 950,000 448,800 206,000 325,000 475,800 Page 33 Problem 2 2,926,000 2,851,100 62,000 1,865,400 4,277,200 175,000 62,000 1,152,400 1,205,900 189,000 149,000 179,200 1,528,300 1,694,400 254,500 1,002,900 176,000 743,100 62,000 401,100 175,000 325,000 233,000 323,000 1,200,000 175,000 498,200 181,000 2,519,300 500,000 329,000 450,000 175,000 3,200,900 1,902,900 517,000 175,000 2,295,500 551,500 1,053,400 350,000 2,025,000 550,000 475,000 325,000 2,128,600 62,000 194,000 430,000 1,044,000 1,789,000 430,300 238,000 Page 34 Problem 2 436,200 1,466,000 283,800 250,000 372,200 176,000 253,600 1,688,000 175,000 2,308,000 62,000 3,751,300 676,900 1,480,000 2,902,500 358,600 953,500 350,000 5,101,200 328,400 175,000 186,000 266,000 1,375,000 327,000 250,000 62,000 325,000 267,500 131,000 325,000 62,000 1,742,000 600,000 350,000 450,000 437,200 1,533,000 1,075,000 182,000 250,000 525,000 650,000 271,600 420,000 250,000 700,000 337,800 1,450,000 205,000 206,000 480,000 175,000 Page 35 Problem 2 400,000 62,000 175,000 177,800 250,000 1,385,000 757,000 675,000 325,000 432,000 550,000 1,427,000 289,000 282,600 1,449,000 157,000 450,000 250,800 350,000 260,000 3,090,000 250,000 325,000 324,000 175,000 176,000 400,000 1,042,000 164,000 62,000 62,000 1,600,000 550,000 725,000 625,000 175,000 2,000,000 1,400,000 2,556,000 5,850,000 177,000 1,366,000 353,700 192,000 62,000 511,000 2,925,000 800,000 375,000 1,862,200 328,400 285,000 950,000 Page 36 Problem 2 523,000 62,000 62,000 1,410,400 4,309,000 737,000 260,200 101,000 232,000 3,128,300 432,400 338,300 250,000 176,000 600,000 1,696,000 400,000 198,400 175,000 398,400 1,850,000 178,000 400,000 1,250,000 62,000 250,700 3,377,000 1,575,000 593,000 552,500 432,200 62,000 375,000 335,000 2,313,000 178,000 1,500,000 401,200 62,000 206,000 731,000 350,000 3,502,500 402,300 650,400 753,900 175,000 600,400 432,300 339,800 400,000 1,868,000 462,000 Page 37 Problem 2 257,900 2,481,400 1,583,000 2,516,600 1,147,000 463,600 429,000 1,201,400 272,200 1,052,000 62,000 454,000 431,500 62,000 978,600 3,523,100 328,600 62,000 379,800 1,399,700 3,751,100 554,200 308,000 622,700 3,469,400 353,200 400,000 259,000 603,900 1,112,800 557,100 450,000 1,991,100 1,761,200 400,000 182,000 1,074,000 207,000 175,000 478,600 350,000 701,100 2,900,800 62,000 937,900 254,200 715,600 391,200 327,500 400,000 6,230,600 389,500 254,500 Page 38 Problem 2 620,000 350,000 334,400 539,800 903,900 602,500 328,400 378,100 533,500 352,500 1,632,000 333,500 1,513,700 894,500 261,500 504,500 400,000 675,000 1,010,300 400,100 252,200 1,002,500 937,900 253,900 62,000 937,900 288,500 400,000 603,000 400,000 2,268,200 254,500 600,000 386,600 522,000 479,500 3,902,800 2,950,000 587,000 329,500 1,159,500 325,000 400,000 62,000 425,000 1,603,400 375,000 675,800 62,000 1,503,600 654,500 356,500 273,200 Page 39 Problem 2 1,125,000 453,400 472,500 131,000 62,000 436,900 451,100 2,576,900 325,000 62,000 175,000 329,500 452,800 694,600 379,500 453,100 2,904,500 2,017,000 Page 40
Find millions of documents here - Study Guides, Homework Solutions, Papers, Exam Answer Keys and more.
Course Hero has millions of course related materials that will enable you to learn better,
faster and get an A in all your courses.
Below is a small sample set of documents:
Below is a small sample set of documents:
La Sierra >> M >> 251 (Fall, 2009)
FormulasandBasicArithmetic: Usethesymbols+*/foraddition,subtraction,multiplicationanddivision. Useparentheses()likeyouwouldusethemfororderofoperationinalgebra. Startingacellwith=andthenenteringaformulawilltellexceltodothe desiredcomputation. Example:...
Charleston Law >> MA >> 200 (Fall, 2009)
MA250 Final Exam summary Time: Monday, April 27 , 2009, (6:30-8:30 p.m.) Place: AC (Athletic Complex) All answers require full justification. There will be proofs. The test covers Sections 1-5, 7-12, 14, 17-20, 23-25 from the texbook, plus the Le...
Charleston Law >> MA >> 200 (Fall, 2009)
...
Charleston Law >> MA >> 200 (Fall, 2009)
...
Washington >> FIN >> 502 (Fall, 2008)
1 of 1 Time Beginning balance on this date [E of row prior] House Payment on this date Interest inflow over NEXT year .10(B-C) Columns PV of B plus D House minus Payment Column C B+D-C PV of Interest Inflow Overall NPV of All Cash Flows F+G No...
Washington >> FIN >> 502 (Fall, 2008)
Rice Due November 17 Homework #F4 Fin 502 Fall 2003 I. (B&M) Ch. 8, #5,7 (Recommended 6, 3 but getting 3(c) precisely is difficult) Ch. 7, #10,12 (Recommended 11) II. Consider three firms each paying a dividend of $1 per share a year from today and...
Washington >> FIN >> 502 (Fall, 2008)
2 Spring 1990 Rice Fin 502 FINAL EXAM INSTRUCTIONS: Answer all questions. It is essential that you explain the reasoning behind your answers rather than just give the answers themselves. Be as brief, but as rigorous, as possible. Use graphical expla...
Washington >> FIN >> 502 (Fall, 2008)
FIN 502 FISHER DIAGRAM HANDOUT Graph Page 3 RICE C1 C1* C* ARICOS T(I*) PP* CMCOS C0 C0* W0-I* W0 W0+NPV ...
Washington >> FIN >> 502 (Fall, 2008)
Rice Illustration of Effects of Leverage on Beta Fin 502 Suppose rF=10%, VU=100, #Shares=10, U=1. Also suppose there are only two dates, and three possible equally likely outcomes at time 1: good, OK, and bad. Then consider the following example G...
Washington >> BA >> 580 (Fall, 2009)
UNIVERSITY OF WASHINGTON Graduate School of Business Administration BE 579 Office: Mackenzie 338, 543-4480 Edward M. Rice email: erice Summer 2002 (*) Office Hours: by Appointment Course Outline This course is designed to teach some microeconomic in...
Washington >> MSIS >> 512 (Fall, 2009)
MSIS: Managerial Economics and Finance Edward Rice Offices: Mackenzie 338 Emails: erice @u.washington.edu Spring 2003 Phone: (206)-543-4480 This course has several purposes. First, it teaches the student the fundamental principles of microeconomics,...
Washington >> MSIS >> 512 (Fall, 2009)
Rice Handout #1 MSIS 512 Assume a Competitive, Price Taking firm in the Short Run facing a Price of 20 and a cost curve of TC (Q) = Q 3 5Q 2 + 12Q + 9 Q 0 1 2 2.5 3 4 5 6 7 P 20 20 20 20 20 20 20 20 20 TR 0 20 40 50 60 80 100 120 140 TC 9 17 21 23...
Washington >> MSIS >> 512 (Fall, 2009)
Rice Handout #2 MSIS 512 Assume a Monopolist facing an industry demand curve of P = 77 14.25 * Q And a cost curve of TC (Q) = Q 3 5Q 2 + 12Q + 9, Q 0 1 2 2.5 3 4 5 P 77 62.75 48.5 41.375 34.25 20 5.75 TR 0 62.75 97 103.4 102.75 80 28.75 TC 9 17 ...
Washington >> MSIS >> 512 (Fall, 2009)
Rice 500 MIDTERM AND FINAL EXAMS BE INSTRUCTIONS: Answer all questions. It is essential that you explain the reasoning behind your answers rather than just give the answers themselves. Be as brief, but as rigorous, as possible. Be sure to use graph...
Washington >> MSIS >> 512 (Fall, 2009)
Rice Due April 26 Homework 1: The Basics of Discounting MSIS Econ-Finance Spring 2003 I. Derive the present value of a N-payment annuity of $A beginning at time 0, instead of time 1. (With this annuity, $A are paid on dates 0 thru N-1.) Assume that...
Washington >> MSIS >> 512 (Fall, 2009)
Rice Due April 30 Homework #2: Should We Do the Project? MSIS Econ-Finance Spring 2003 I. A widget manufacturer currently produces 200,000 units per year. It buys widget lids from an outside supplier at a price of $2 a lid. The plant manager believ...
Washington >> MSIS >> 512 (Fall, 2009)
Rice Due May 10 Homework #3: Stock and Cash Flow Values MSIS Econ-Finance Spring 2003 I. Mr. T. Thumb is the president of Microtechnology, Inc., a very small private company. He expects revenues in the forthcoming year of $20 million and costs (inc...
Washington >> MSIS >> 512 (Fall, 2009)
Rice Due June 4 Homework #4: Demand and Supply in Competition MSIS Econ-Finance Spring 2003 Suppose the market for books is perfectly competitive. In addition, suppose that there are two groups of booksellers Internet (I) booksellers and Brick and...
Washington >> MSIS >> 512 (Fall, 2009)
Rice Due June 7 Homework #5: Monopoly Pricing MSIS Econ-Finance Spring 2003 I. You run a convenience store near the University District facing a demand curve for Healthies, its unique vegetable drinking product, q = 125 - 25p, where q is the quanti...
Washington >> MSIS >> 512 (Fall, 2009)
Rice Due May 17 Discussion Question #1: Drugs and Street Crime MSIS Econ-Finance Spring 2003 There has been much recent discussion about what to do about the drug problem in the United States (and the world). People are concerned about the number o...
Washington >> MSIS >> 512 (Fall, 2009)
Rice Due June 7 MSIS Econ-Finance Spring 2003 Discussion Question #2: Internet Firms, Monopoly, and Losses During the late 1990s, the valuations of Internet companies were very high by almost any historical standard. One potential explanation of th...
Washington >> MSIS >> 512 (Fall, 2009)
1 of 1 Time Beginning balance on this date [E of row prior] House Payment on this date Interest inflow over NEXT year .10(B-C) Columns PV of B plus D House minus Payment Column C B+D-C PV of Interest Inflow Overall NPV of All Cash Flows F+G No...
Washington >> MSIS >> 512 (Fall, 2009)
Rice Rules for Taking the Final Exam MSIS Econ-Finance Spring 2003 While the final exam will be a take-home, this will not be your typical take-home exam. My strong preference generally is to give an in-class exam, because I believe most student le...
Washington >> MSIS >> 512 (Fall, 2009)
Rice MSIS Econ-Finance Spring 2003 Rules for Submission of Final Exam and Cheat Sheet Exam Possibilities: 1. Electronic submission: Email exams to liwei23@u.washington.edu by 5pm on Friday, June 13th. (Writing up all answers to exam questions, incl...
Washington >> BE >> 500 (Fall, 2009)
Rice Due November 10 Homework #3: Supply and Surplus Consider a firm, B, with a short run cost curve of TC1(q) = q2 + q + 9 Assume the firm can produce fractional, as well as integer, outputs. I. A) What are firm B\'s fixed costs? BE 500 Fall 2003 B...
Washington >> BE >> 500 (Fall, 2009)
Rice Handout #1 BE 500 Assume a Competitive, Price Taking firm in the Short Run facing a Price of 20 and a cost curve of TC (Q) = Q 3 5Q 2 + 12Q + 9 Q 0 1 2 2.5 3 4 5 6 7 P 20 20 20 20 20 20 20 20 20 TR 0 20 40 50 60 80 100 120 140 TC 9 17 21 23.4...
Washington >> BE >> 500 (Fall, 2009)
Rice Handout #2 BE 500 Assume a Monopolist facing an industry demand curve of P = 77 14.25 * Q And a cost curve of TC (Q) = Q 3 - 5Q 2 + 12Q + 9, Q 0 1 2 2.5 3 4 5 P 77 62.75 48.5 41.375 34.25 20 5.75 TR 0 62.75 97 103.4 102.75 80 28.75 TC 9 17 2...
Washington >> BE >> 500 (Fall, 2009)
Rice BE 500 Handout #6 Three Statements of the Coase Theorem If there are no transaction costs and no information costs, and if there are also well-defined property rights, then 1. resources will be directed to their highest valued uses. 2. the allo...
Washington >> FINANCE >> 555 (Fall, 2009)
Finance 555: Financing Decisions, Payout Policy and Corporate Control Edward M. Rice Office: Mackenzie 338, 543-4480 Email: erice@u.washington.edu Spring 2003 Office Hours: T 3:30-4, Th 6-7 and by appointment This course provides a general economic ...
Washington >> FINANCE >> 555 (Fall, 2009)
Rice Fin 555 States of the World Pricing State preference theory provides an alternative way to view the pricing of securities. The model is quite general; the CAPM, arbitrage, and option pricing models are all special cases of it. The key concept to...
Washington >> FINANCE >> 555 (Fall, 2009)
Rice Fin 555 Example of DeAngelo-Masulis Decreasing Effective Tax Shield Debt Policy State Cash Flow Non-Cash Tax Shields CF to Debt Taxable Income* Tax Expense* CF to Equity Total Cash Flow to Security Owners (Debt + Equity) No Debt s1 130 30 0 10...
Washington >> FINANCE >> 555 (Fall, 2009)
Rice Fin 555 Illustration of Effects of Leverage on Beta Suppose rF=10%, VU=100, #Shares=10, U=1. Also suppose there are only two dates, and three possible equally likely outcomes at time 1: good, OK, and bad. Then consider the following example Good...
Washington >> FINANCE >> 555 (Fall, 2009)
Rice Illustration of Effects of Leverage on Value Under MM Assumptions Fin 555 This example grows out of the handout \"Illustration of Effects of Leverage on Beta.\" It solves explicitly for the values of equity and debt assumed in that handout, usin...
Washington >> FINANCE >> 555 (Fall, 2009)
Rice 555 Fin Fall 2001 FINAL EXAM INSTRUCTIONS: Answer all questions. It is essential that you explain the reasoning behind your answers rather than just give the answers themselves. Be as brief, but as rigorous, as possible. The exam has a total o...
Washington >> FINANCE >> 555 (Fall, 2009)
Rice 555 Fin Winter 2002 MIDTERM EXAM INSTRUCTIONS: Answer all questions. It is essential that you explain the reasoning behind your answers rather than just give the answers themselves. Be as brief, but as rigorous, as possible. The exam has a tot...
Washington >> FINANCE >> 555 (Fall, 2009)
Due April 24 Case Study Questions and Write-Up American Home Products Spring 2003 Finance 555 You should assume the role of a Financial Consultant writing a recommendation to AHP\'s Chief Financial Officer (CFO) about an appropriate capital structur...
Washington >> FINANCE >> 555 (Fall, 2009)
OBS 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 CALDT 31-Jan-72 29-Feb-72 30-Mar-72 28-Apr-72 31-May-72 30-Jun-72 31-Jul-72 31-Aug-72 29-Sep-72 31-Oc...
Washington >> BA >> 580 (Fall, 2009)
vti_encoding:SR|utf8-nl vti_author:SR|erice vti_modifiedby:SR|erice vti_timecreated:TR|22 May 2002 20:17:46 -0000 vti_timelastmodified:TR|22 May 2002 20:17:46 -0000 vti_filesize:IR|25600 vti_title:SR|579 Course Outline vti_extenderversion:SR|4.0.2.40...
Laurentian >> MGT >> 200303 (Fall, 2009)
Bearspread or Bear Call Spread A bearspread is the reverse of a bullspread The maximum profit occurs with falling prices The investor buys the option with the higher striking price and writes the option with the lower striking price Profit from t...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter Two Basic Principles of Options Answers to Problems and Questions 1. 2. Up False. The owner of an option has the right to do something, while the writer has an obligation to perform if the option owner exercises. The term wasting asset refer...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter 6 The Black-Scholes Option Pricing Model 1 2002 South-Western Publishing Introduction The Black-Scholes option pricing model (BSOPM) has been one of the most important developments in finance in the last 30 years basic valuation model...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter Six The Black-Scholes Option Pricing Model Answers to Problems and Questions 1. Interest rates may have changed, the expected amount of the next dividend may have changed, or the market may anticipate a different future level of volatility in...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter 8 Fundamentals of the Futures Market 1 2002 South-Western Publishing Outline A. The concept of futures contracts B. Market mechanics C. Market participants D. The clearing process E. Principles of futures contract pricing F. Hedging G. S...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter 11 Fundamentals of Interest Rate Futures 1 2002 South-Western Publishing Outline Interest rate futures Treasury bills, Eurodollars, and their futures contracts Speculating & Hedging with T-bill futures Hedging with Eurodollar Futures...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter Twelve Futures Contracts and Portfolio Management Answers to Problems and Questions 1. Immunization refers to the situation in which the effects of interest rate risk and reinvestment rate risk largely cancel. 2. Bullet immunization seeks to ...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter Fourteen Swap Pricing Answers to Problems and Questions 1. If the options are European style you can use the put/call parity model with C P = 0, meaning K = S (1+R)T. Here we have K = 28.55 x (1.055)0.5 = 29.32 If the options are American st...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter 2 Basic Principles of Stock Options 1 2002 South-Western Publishing Outline What options are and where they come from Why options are a good idea Where and how options trade Components of the option premium Where profits and losse...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter 2 Review Basic Puts and Calls 1 2002 South-Western Publishing Buying a Call Option (cont\'d) Breakeven = $87 0 Maximum loss = $7 20 40 60 80 100 2 Buying A Call Option A bullish strategy Consider possible actions if: stock d...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter Three Basic Option Strategies: Covered Calls and Protective Puts Answers to Problems and Questions 1. Covering a call means either 1) buying back a call that you previously wrote, or 2) adding a stock or long option position so that a short c...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter 4 Option Combinations and Spreads 1 2002 South-Western Publishing Rolling Trading Strategies Rolling down/out/up - possible action as part of re-evaluating ones option position Rolling down - closing your position and reestablishing a ...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter Four Option Combinations and Spreads Answers to Problems and Questions 1. A straddle involves a higher maximum profit if the stock remains near the option striking price. A strangle has a lower maximum profit, but it occurs over a wider range...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter Five Option Pricing Answers to Problems and Questions 1. Arbitrage is the existence of a riskless profit, especially when you do not have to commit funds to earn the profit. 2. Market prices move continually, and frequently move slightly away...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter Eleven Fundamentals of Interest Rate Futures Answers to Problems and Questions 1. Unlike shares in a particular common stock or bushels of inspected soybeans, not all Treasury bonds are identical. Differences in coupon rate and in maturity ar...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter Thirteen Swaps and Interest Rate Options Answers to Problems and Questions 1. In an interest rate swap, the swap seller is the party paying the floating rate. 2. The swap tenor is the length (in time) of the swap arrangement. The swap price i...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter 13 Swaps and Interest Rate Options 1 2002 South-Western Publishing Outline Interest rate swaps Foreign currency swaps Circus swap Interest rate options 2 Introduction Both swaps and interest rate options are relatively new, but...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter 14 Swap Pricing 1 2002 South-Western Publishing Outline Swap pricing Solving for the swap price Valuing an off-market swap Hedging the swap Pricing a currency swap 2 Swap Pricing Swaps as a pair of bonds Swaps as a series of f...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter 1 Introduction 1 2002 South-Western Publishing Outline Introduction Types of derivatives Participants in the derivatives world Uses of derivatives Effective study of derivatives 2 Introduction (cont\'d) How many have heard of the ...
Laurentian >> MGT >> 200303 (Fall, 2009)
Chapter 12 Futures Contracts and Portfolio Management 1 2002 South-Western Publishing The Concept of Immunization Introduction Bond risks Duration matching Bullet Immunization Bank immunization Duration shifting 2 The Concept of Immuniza...
Laurentian >> MGT >> 200303 (Fall, 2009)
University of Lethbridge Mgt 4451 Derivative Securities Markets End of Chapter Problems Chapter 3 Problems 18. Stock: 400 x ($74 79 7/16) = -$2,175 Options: 2 x 100 x (5 7/8 6) = - $25 Total = $2,200 loss 20. 21 9/16 90 79 7/32 158 7/16 24. 7/1...
Laurentian >> MGT >> 200303 (Fall, 2009)
Mgt 4451 Y Derivative Securities Markets Fall Semester 2003 Project 25 marks Part 1 General Electric With a notional US $100,000 purchase in board lots General Electric shares on close Oct 1/03 A. Investment situation generate income(covered call)...
Delaware >> FREC >> 682 (Fall, 2009)
%!PS-Adobe-3.0 %Creator: groff version 1.08 %DocumentNeededResources: font Times-Bold %+ font Times-Italic %+ font Times-Roman %+ font Symbol %DocumentSuppliedResources: procset grops 1.08 0 %+ font Symbol-Slanted %Pages: 349 %PageOrder: Ascend %Orie...
Delaware >> FREC >> 682 (Fall, 2009)
%!PS-Adobe-2.0 %CreationDate: Wed Feb 17 09:58:59 1993 %Title: troff output %Creator: user mccarthy using opost (NeWSprint) %DocumentFonts: (atend) %Pages: (atend) %EndComments % @(#)opost.ps 1.5 10/15/90 % % Prologue file included by opost /M{3 mul ...
Delaware >> FREC >> 682 (Fall, 2009)
%!PS-Adobe /wpdict 120 dict def wpdict begin /bdef {bind def} bind def { /bflg false def /Bfont 0 def /bon false def f /psz /_S /_t 0 def /show load def { {0 rmoveto} bdef /_pixelsnap {transform .25 sub round .25 add exch .25 sub round .25 add exch ...
Delaware >> FREC >> 480 (Fall, 2008)
GEO_ID 05000US01001 05000US01003 05000US01005 05000US01007 05000US01009 05000US01011 05000US01013 05000US01015 05000US01017 05000US01019 05000US01021 05000US01023 05000US01025 05000US01027 05000US01029 05000US01031 05000US01033 05000US01035 05000US01...
Delaware >> FREC >> 424 (Spring, 2008)
Table 3: Mean SAT Reasoning Test Critical Reading, Mathematics and Writing Scores by State The College Board strongly discourages the comparison or ranking of states on the basis of SAT scores alone. (SAT scores from: http:/professionals.collegeboard...
Delaware >> FREC >> 424 (Spring, 2008)
Murder Rates, Cops, Incarceration, Death Penalty, Etc., by State STATE VIOCRIM06 MURDER06 Alabama 425 8.3 Alaska 688 5.4 Arizona 501 7.5 Arkansas 552 7.3 California 533 6.8 Colorado 392 3.3 Connecticut 281 3.1 Delaware 682 4.9 Florida 712 6.2 Georgia...
Washington >> CSS >> 450 (Fall, 2009)
Creating Dialog Based Applications with MFC 7 By Jason Pursell, University of Washington, Bothell (2000-2003) jpursell@u.washington.edu Introduction This tutorial demonstrates how to create a simple dialog based application with MFC 7 and Visual Stu...
Georgia Tech >> CS >> 1050 (Fall, 2008)
More Number Theory Proofs Rosen 3.1 Prove or Disprove If m and n are even integers, then mn is divisible by 4. The sum of two odd integers is odd. The sum of two odd integers is even. If n is a positive integer, then n is even iff 3n2+8 is even....
Georgia Tech >> CS >> 1050 (Fall, 2008)
Rosen 1.4, 1.5 Basic Definitions Set - Collection of objects, usually denoted by capital letter Member, element - Object in a set, usually denoted by lower case letter Set Membership - a A denotes that a is an element of set A Cardinality of a ...
Georgia Tech >> CS >> 1050 (Fall, 2008)
More Set Definitions and Proofs 1.4,1.5 Ordered n-tuple The ordered n-tuple (a1,a2,.an) is the ordered collection that has a1 as its first element, a2 as its second element . . . And an as its nth element. 2-tuples are called ordered pairs. Cartesi...
What are you waiting for?