Share
Explore BrainMass

Graphical display and box plot for hours of use for computer

Use of Excel or the drawing tools in Word are acceptable

Current Supplier Alternative 1 Supplier Alternative 2 Supplier
486 489 508
490 489 510
491 491 517
491 492 506
494 492 515
494 492 520
496 492 503
498 493 524
498 493 515
502 494 503
504 495 507
505 496 515
506 497 509
507 497 518
508 497 495
510 498 499
514 499 510
515 502 503
527 503 533
498 505 517

The above lists the hours of use for computer discs.

a) Make a graphical display of the three categories of data
b) Based on the data and your displays, which supplier would you recommend to your boss?
c) Find the mean, median, range and standard deviation for each supplier
d) Make a box plot for the Alternative 1 supplier.
e) Find the interquartile range for Alternative 1 supplier.

Solution Summary

A complete, neat and step-by-step solution is provided regarding the graphical display and box plot for hours of use for computer in the attached Excel file.

$2.19