Using the data on sheet P1, solve the following questions.

A) What is the total order amount for Salesperson Adongo?

B) What is the minimum order amount for Salesperson Santino?

C) What is the average order amount for USA?

D) What is the maximum order amount for Spain?

E) What is the standard deviation of order amount for Ghana?

F) What is the total order amount for Quarter 1 of 2005?

G) What is the total order amount for Quarter 2 of 2005?

H) What is the total order amount for Quarter 3 of 2006?

I) What is the total order amount for Salesperson McDonald in Quarter 1 of the year 2005?

J) All salespeople receive 10% of profit as bonus, but you'd like to award 15% of profit as bonus if they exceed $1,000 in orders per quarter in a given year. What is the total bonus amount?

the excel spreadsheet for this problem is attached. thanks

SalespersonOrder Amount Expenses Adongo 2633 2239 Adongo 750 638 Adongo 63 54 Adongo 216 184 Adongo 270 230 Adongo 1087 924 Adongo 279 238 Adongo 1140 969 Adongo 1031 877 Adongo 945 804 Adongo 1674 1423 Adongo 756 643 Adongo 864 735 Adongo 207 176 Buchanan 86 74 Buchanan 2328 1979 Buchanan 97 83 Buchanan 53 46 Buchanan 135 115 Buchanan 1868 1588 Buchanan 1114 947 Buchanan 900 765 Buchanan 1168 993 Buchanan 521 443 Buchanan 2250 1913 Buchanan 547 465 Buchanan 118 101 Buchanan 562 478 Buchanan 600 510 Costa 594 505 Costa 636 541 Costa 119 102 Costa 540 459 Costa 349 297 Costa 390 332 Costa 5130 4361 Costa 135 115 Costa 3078 2617 Costa 360 306 Costa 63 54 Costa 3465 2946 Costa 774 658 Costa 239 204 Costa 316 269 Costa 3264 2775 Profit 394 112 9 32 40 163 41 171 154 141 251 113 129 31 12 349 14 7 20 280 167 135 175 78 337 82 17 84 90 89 95 17 81 52 58 769 20 461 54 9 519 116 35 47 489 Product BaseBall Golf Tennis Golf Golf Golf Tennis Tennis Golf Golf Tennis BaseBall Golf Tennis Golf Golf Tennis Golf BaseBall BaseBall BaseBall Golf Tennis Tennis Tennis Tennis BaseBall BaseBall BaseBall BaseBall BaseBall BaseBall Tennis Tennis Tennis Golf Golf Golf Golf Golf BaseBall Tennis BaseBall Golf Golf Date 1/8/2005 2/2/2005 3/3/2005 5/5/2005 6/7/2005 7/7/2005 8/9/2005 8/9/2005 9/10/2005 10/11/2005 11/12/2005 12/13/2005 12/14/2005 1/14/2006 2/15/2006 2/15/2006 3/17/2006 4/18/2006 5/19/2006 6/20/2006 7/21/2006 7/22/2006 8/23/2006 9/22/2006 10/25/2006 11/26/2006 11/26/2006 12/27/2006 12/27/2006 1/1/2005 1/1/2005 2/2/2005 3/4/2005 4/5/2005 4/5/2005 5/5/2005 5/5/2005 6/7/2005 7/7/2005 7/8/2005 7/8/2005 7/8/2005 8/8/2005 10/12/2005 11/5/2005 Country GHANA GHANA GHANA GHANA GHANA GHANA GHANA GHANA GHANA GHANA GHANA GHANA GHANA GHANA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA Costa Costa Costa Costa Costa Costa Costa Costa Costa Costa Costa Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Davolio Dodsworth Dodsworth Dodsworth Dodsworth 102 135 222 72 360 437 146 432 133 390 390 375 60 47 67 94 137 81 30 38 302 30 202 468 94 54 285 47 72 68 54 32 109 203 68 22 86 42 36 90 166 23 302 960 744 137 87 115 189 62 306 372 125 368 114 332 332 319 51 40 57 80 117 69 26 33 257 26 172 398 80 46 243 40 62 58 46 28 93 173 58 19 74 36 31 77 142 20 257 816 633 117 15 20 33 10 54 65 21 64 19 58 58 56 9 7 10 14 20 12 4 5 45 4 30 70 14 8 42 7 10 10 8 4 16 30 10 3 12 6 5 13 24 3 45 144 111 20 Golf Tennis Golf BaseBall Tennis Golf BaseBall BaseBall BaseBall Tennis Tennis Tennis BaseBall Tennis BaseBall Tennis BaseBall Golf Golf Golf Tennis BaseBall BaseBall Tennis BaseBall Tennis Golf Tennis Tennis BaseBall Golf BaseBall BaseBall Golf Golf Tennis Golf Tennis BaseBall Golf Tennis BaseBall BaseBall Golf Tennis BaseBall 12/13/2005 1/24/2006 2/15/2006 3/17/2006 4/17/2006 6/21/2006 8/23/2006 9/23/2006 10/25/2006 11/25/2006 12/27/2006 1/3/2005 2/3/2005 3/5/2005 4/4/2005 5/5/2005 6/5/2005 7/6/2005 8/12/2005 9/13/2005 10/13/2005 11/16/2005 12/14/2005 1/14/2006 2/16/2006 3/17/2006 3/17/2006 4/18/2006 5/19/2006 5/20/2006 6/17/2006 7/18/2006 8/22/2006 8/22/2006 8/22/2006 8/22/2006 9/24/2006 9/24/2006 10/25/2006 10/25/2006 11/23/2006 12/27/2006 1/2/2005 2/2/2005 2/2/2005 3/3/2005 USA USA USA USA USA USA USA USA USA USA USA UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Dodsworth Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock 1080 1166 1140 1872 347 600 1688 600 360 315 27 523 540 405 1823 698 731 733 570 3162 2242 93 150 11858 840 57 1580 844 450 2340 225 192 4125 1785 2063 129 180 857 245 596 706 786 3300 224 60 465 918 992 969 1592 295 510 1435 510 306 268 23 445 459 345 1550 594 622 624 485 2688 1906 80 128 10080 714 49 1343 718 383 1989 192 164 3507 1518 1754 110 153 729 209 507 601 669 2805 191 51 396 162 174 171 280 52 90 253 90 54 47 4 78 81 60 273 104 109 109 85 474 336 13 22 1778 126 8 237 126 67 351 33 28 618 267 309 19 27 128 36 89 105 117 495 33 9 69 Golf Golf Golf Tennis Tennis Golf Tennis BaseBall Tennis Tennis BaseBall Tennis Golf BaseBall BaseBall Tennis Golf Tennis Golf Golf Golf Tennis Tennis Golf Tennis Tennis Golf Golf Tennis BaseBall Tennis Tennis BaseBall Golf BaseBall Tennis Tennis Golf Golf BaseBall Golf BaseBall BaseBall BaseBall Tennis Tennis 3/4/2005 4/4/2005 5/5/2005 5/6/2005 6/6/2005 7/7/2005 8/9/2005 8/9/2005 9/10/2005 10/11/2005 11/12/2005 12/14/2005 1/14/2006 2/17/2006 3/17/2006 4/18/2006 5/16/2006 6/17/2006 7/23/2006 8/13/2006 9/24/2006 10/24/2006 11/26/2006 12/27/2006 1/1/2005 2/2/2005 3/3/2005 3/4/2005 4/4/2005 5/8/2005 6/6/2005 7/8/2005 8/9/2005 9/10/2005 10/12/2005 11/9/2005 12/14/2005 1/15/2006 1/15/2006 2/15/2006 3/17/2006 3/17/2006 4/17/2006 5/19/2006 5/19/2006 6/20/2006 UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Hancock Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Jonson Leverling Leverling Leverling Leverling Leverling Leverling Leverling 379 1109 788 638 690 1170 47 1035 349 2751 78 30 61 41 86 108 100 540 58 123 162 93 130 43 77 318 346 222 44 557 65 61 144 67 224 34 51 32 21 252 2970 264 175 396 108 450 323 943 670 543 587 995 40 880 297 2339 67 26 52 35 74 92 85 459 50 105 138 80 111 37 66 271 295 189 38 474 56 52 123 57 191 29 44 28 18 215 2525 225 149 337 92 383 56 166 118 95 103 175 7 155 52 412 11 4 9 6 12 16 15 81 8 18 24 13 19 6 11 47 51 33 6 83 9 9 21 10 33 5 7 4 3 37 445 39 26 59 16 67 Golf Golf Golf BaseBall Tennis Tennis Tennis Golf Tennis BaseBall BaseBall BaseBall BaseBall Tennis Tennis Tennis Golf Golf BaseBall BaseBall Golf Tennis Tennis Tennis Tennis BaseBall Golf Golf BaseBall BaseBall Tennis Tennis BaseBall BaseBall Golf Tennis Tennis Tennis Tennis BaseBall BaseBall Golf Tennis BaseBall BaseBall Golf 7/21/2006 8/21/2006 9/23/2006 10/25/2006 11/26/2006 11/26/2006 11/26/2006 12/26/2006 12/26/2006 12/27/2006 1/2/2005 2/2/2005 2/2/2005 3/3/2005 4/4/2005 4/5/2005 5/5/2005 5/5/2005 5/6/2005 6/6/2005 7/8/2005 8/10/2005 9/10/2005 10/11/2005 11/12/2005 12/12/2005 1/15/2006 2/15/2006 2/16/2006 4/17/2006 5/21/2006 6/20/2006 7/21/2006 8/22/2006 9/25/2006 10/26/2006 11/26/2006 11/26/2006 12/27/2006 1/2/2005 2/2/2005 2/2/2005 3/3/2005 3/3/2005 3/4/2005 4/4/2005 UK UK UK UK UK UK UK UK UK UK USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling Leverling McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald 334 750 720 735 2951 785 468 203 177 375 690 347 90 60 2700 432 843 570 1536 56 777 54 5700 228 1260 2625 750 2394 1163 480 467 197 315 1590 591 591 585 391 968 969 971 972 974 510 1071 2394 284 638 612 625 2509 668 398 173 151 319 587 295 77 51 2295 368 717 485 1306 48 661 46 4845 194 1071 2232 638 2035 989 408 397 168 268 1352 503 503 498 333 823 824 826 827 828 434 911 2035 50 112 108 110 442 117 70 30 26 56 103 52 13 9 405 64 126 85 230 8 116 8 855 34 189 393 112 359 174 72 70 29 47 238 88 88 87 58 145 145 145 145 146 76 160 359 Tennis Tennis Tennis Golf BaseBall Tennis Tennis Tennis BaseBall Golf Tennis Tennis BaseBall Golf Golf Golf BaseBall Golf Golf Golf Golf BaseBall Tennis Tennis Tennis Golf Tennis BaseBall Tennis Golf Tennis Tennis Golf BaseBall Golf Golf BaseBall BaseBall Tennis BaseBall BaseBall BaseBall BaseBall Golf Golf Golf 4/5/2005 4/5/2005 5/5/2005 5/5/2005 5/6/2005 5/6/2005 6/6/2005 6/7/2005 7/8/2005 8/8/2005 8/9/2005 9/10/2005 10/9/2005 11/12/2005 12/9/2005 1/14/2006 1/15/2006 1/15/2006 2/15/2006 3/15/2006 4/18/2006 4/18/2006 5/19/2006 6/20/2006 6/20/2006 7/20/2006 8/22/2006 8/23/2006 9/23/2006 10/24/2006 11/20/2006 12/20/2006 1/1/2005 1/1/2005 2/2/2005 3/2/2005 4/5/2005 5/6/2005 6/6/2005 7/7/2005 8/8/2005 9/9/2005 6/10/2005 10/12/2005 11/13/2005 12/13/2005 USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald McDonald Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller 63 222 2226 231 428 677 2063 1317 252 585 387 452 540 186 1043 52 594 150 144 399 1980 174 187 480 189 140 690 288 1193 492 146 895 75 252 383 825 641 988 2958 252 638 319 169 2958 239 93 54 189 1893 197 364 576 1754 1120 215 498 329 385 459 159 887 45 505 128 123 340 1683 148 159 408 161 119 587 245 1015 419 125 761 64 215 326 702 545 840 2515 215 543 272 144 2515 204 80 9 33 333 34 64 101 309 197 37 87 58 67 81 27 156 7 89 22 21 59 297 26 28 72 28 21 103 43 178 73 21 134 11 37 57 123 96 148 443 37 95 47 25 443 35 13 BaseBall Golf BaseBall Tennis Tennis Tennis BaseBall Golf Tennis BaseBall Tennis Tennis Tennis Golf Tennis Tennis BaseBall Golf Tennis BaseBall BaseBall Tennis Tennis Golf Golf Tennis Tennis Tennis BaseBall BaseBall Tennis Tennis Golf Tennis Golf BaseBall Golf Golf Golf Tennis Golf Golf Tennis Golf BaseBall Tennis 12/14/2005 1/14/2006 1/15/2006 2/16/2006 3/16/2006 4/18/2006 5/19/2006 6/20/2006 7/21/2006 8/22/2006 8/22/2006 8/23/2006 8/23/2006 9/23/2006 9/24/2006 10/24/2006 11/25/2006 12/27/2006 12/27/2006 1/1/2005 1/1/2005 1/1/2005 2/2/2005 2/2/2005 3/3/2005 3/3/2005 8/3/2005 4/5/2005 5/6/2005 5/6/2005 6/7/2005 6/7/2005 7/8/2005 9/10/2005 10/11/2005 10/11/2005 10/11/2005 10/11/2005 10/12/2005 11/12/2005 12/13/2005 12/13/2005 1/14/2006 2/12/2006 3/17/2006 3/17/2006 CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Miller Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock Peacock 540 30 378 748 615 414 120 87 707 300 660 328 4941 42 645 636 912 540 135 3162 142 684 116 3510 465 810 285 656 900 1485 608 56 234 1440 1251 710 324 171 210 1104 1125 30 1485 314 432 54 459 26 322 636 523 352 102 74 601 255 561 279 4200 36 549 541 776 459 115 2688 121 582 99 2984 396 689 243 558 765 1263 517 48 199 1224 1064 604 276 146 179 939 957 26 1263 267 368 46 81 4 56 112 92 62 18 13 106 45 99 49 741 6 96 95 136 81 20 474 21 102 17 526 69 121 42 98 135 222 91 8 35 216 187 106 48 25 31 165 168 4 222 47 64 8 Golf Golf Golf Golf BaseBall Tennis Golf Tennis BaseBall Tennis BaseBall Golf Golf BaseBall Tennis BaseBall Golf Golf BaseBall Golf BaseBall Tennis Tennis Golf Tennis Golf Golf Golf Golf BaseBall BaseBall Golf BaseBall Tennis Tennis BaseBall Golf Golf Golf Tennis Tennis Golf BaseBall Tennis BaseBall Golf 3/17/2006 4/18/2006 4/18/2006 4/18/2006 5/19/2006 5/19/2006 7/21/2006 8/23/2006 9/23/2006 10/25/2006 10/25/2006 10/25/2006 10/25/2006 11/25/2006 12/26/2006 12/27/2006 1/1/2005 2/2/2005 3/2/2005 4/5/2005 4/5/2005 5/5/2005 6/6/2005 7/8/2005 8/9/2005 9/10/2005 9/11/2005 10/11/2005 10/11/2005 10/12/2005 12/13/2005 1/16/2006 2/16/2006 2/16/2006 3/16/2006 3/17/2006 3/17/2006 3/17/2006 3/17/2006 5/19/2006 5/19/2006 6/20/2006 6/20/2006 6/21/2006 7/21/2006 8/22/2006 CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA CHINA UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK UK Peacock Peacock Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Santino Suyama Suyama Suyama Suyama Suyama Suyama Suyama Suyama Suyama Suyama 630 1260 483 432 600 819 684 540 102 109 87 239 788 2160 998 1737 2160 1890 450 1069 834 90 43 1193 428 375 2088 720 1224 2063 379 342 2385 398 351 68 120 79 462 105 1300 189 1200 285 600 450 536 1071 411 368 510 697 582 459 87 93 74 204 670 1836 849 1477 1836 1607 383 909 709 77 37 1015 364 319 1775 612 1041 1754 323 291 2028 339 299 58 102 68 393 90 1105 161 1020 243 510 383 94 189 72 64 90 122 102 81 15 16 13 35 118 324 149 260 324 283 67 160 125 13 6 178 64 56 313 108 183 309 56 51 357 59 52 10 18 11 69 15 195 28 180 42 90 67 Tennis Tennis Tennis Tennis Tennis BaseBall BaseBall Tennis Golf Tennis Tennis BaseBall Tennis Golf Golf Tennis Tennis Golf Golf Golf Tennis Tennis Golf BaseBall Tennis Golf Tennis Tennis Golf BaseBall Golf Tennis BaseBall BaseBall BaseBall Tennis BaseBall Tennis Golf Tennis BaseBall BaseBall Golf Golf Golf Golf 8/23/2006 11/26/2006 1/1/2005 1/1/2005 2/3/2005 3/3/2005 3/3/2005 4/4/2005 5/6/2005 5/6/2005 6/6/2005 7/7/2005 8/8/2005 9/10/2005 9/10/2005 9/10/2005 10/11/2005 11/12/2005 12/13/2005 12/13/2005 12/13/2005 12/13/2005 12/13/2005 12/13/2005 1/15/2006 3/17/2006 3/17/2006 3/17/2006 4/18/2006 5/19/2006 5/19/2006 5/20/2006 6/20/2006 8/22/2006 9/24/2006 11/26/2006 2/2/2005 4/5/2005 4/5/2005 4/5/2005 5/6/2005 5/6/2005 6/6/2005 6/6/2005 8/8/2005 11/13/2005 UK UK SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN Suyama Suyama Suyama Suyama Suyama Suyama Suyama Suyama 180 72 35 76 938 417 1170 1276 153 62 30 65 798 355 995 1085 27 10 5 11 140 62 175 191 Golf Tennis Tennis BaseBall Tennis Tennis Tennis BaseBall 12/13/2005 12/14/2005 12/14/2005 7/21/2006 8/22/2006 11/25/2006 11/26/2006 12/26/2006 SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN SPAIN