Miles Recorded by 120 Salesman 403 423 435 444 452 462 474 490 415 416 418 419 420 421 421 407 424 435 444 453 462 474 493 430 431 432 432 433 433 434 407 424 436 445 453 462 475 494 439 440 440 441 442 442 443 408 425 436 446 453 463 476 495 449 450 450 451 451 451 452 410 426 436 447 454 464 477 497 457 457 458 459 459 460 460 1) Use Excel to create a frequency distribution 2) Use an appropriate graph to display the data visually 412 428 438 447 455 465 478 498 468 469 470 471 471 472 473 413 430 438 447 455 466 479 498 482 482 483 485 486 488 489 413 430 438 448 456 468 481 500 502 502 505 508 509 511 515 The survey of 110 voters in the Uk has produced the following results Voter 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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 Prefered party Conservative Conservative Conservative Labour Conservative Democrat Labour Labour Labour Labour Conservative Conservative Conservative Labour Conservative Conservative Labour Conservative Labour Conservative Labour Labour Labour Democrat Green Conservative Labour Conservative Labour Conservative Other Labour Green Conservative Conservative Democrat Conservative Labour Labour Labour Green Labour Labour Labour Conservative Democrat Conservative Conservative Labour Labour Green Conservative Conservative Labour Conservative Democrat Labour Labour Labour Conservative Labour Other Conservative Conservative Labour Labour Conservative Democrat Labour Conservative Green Democrat Conservative Labour Conservative Labour Labour Labour 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 Conservative Labour Labour Labour Conservative Labour Labour Labour Conservative Conservative Democrat Labour Labour Labour Other Conservative Labour Labour Labour Conservative Conservative Labour Other Other Other Labour Conservative Conservative Labour Labour Labour Conservative 1) Use an appropriate graph to display the data visually You have received the following information on the budget allocated per employee in your company Name Department Month Department Budget (euro's) PAUL MARKETING Apr 2345 PAUL MARKETING May 2345 PAUL MARKETING Jun 2345 ALAN MARKETING Apr 1500 ALAN MARKETING May 1500 ALAN MARKETING Jun 1700 JANE MARKETING Apr 3201 JANE MARKETING May 3201 JANE MARKETING Jun 3201 KIM ADVERTISING Apr 5500 KIM ADVERTISING May 5500 KIM ADVERTISING Jun 5500 PETRA ADVERTISING Apr 2987 PETRA ADVERTISING May 2987 PETRA ADVERTISING Jun 2987 TONY ADVERTISING Apr 1300 TONY ADVERTISING May 1300 TONY ADVERTISING Jun 1345 BRIAN ADVERTISING Apr 2590 BRIAN ADVERTISING May 2590 BRIAN ADVERTISING Jun 2590 JULIA SALES Apr 1600 JULIA SALES May 1600 JULIA SALES Jun 1800 NOREEN SALES Apr 5000 NOREEN SALES May 5600 NOREEN SALES Jun 5600 KAREN SALES Apr 4500 KAREN SALES May 4500 KAREN SALES Jun 3400 1) Create a crosstabulation of the budget allocated per department on a monthly bases (i.e. for the months Apr, May, Jun) 2) Use an appropriate graph to display the data visually You have received the following information on oil production by employees Employee number 1 2 3 Old production, X 47 71 64 % raise in production, Y 4.2 8.1 6.8 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 35 43 60 38 59 67 56 67 57 69 38 54 76 53 40 47 23 4.3 5.0 7.5 4.7 5.9 6.9 5.7 5.7 5.4 7.5 3.8 5.9 6.3 5.7 4.0 5.2 2.2 1) Use an appropriate graph to display visually the relationship between initial oil production and productuon increase