Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

X 1 X 2 X 3 X 4 X 5 X 6 X 7 Bus Number Maintenance Age Miles Type Bus-Mfg Passengers 135 329 7

X1 X2 X3 X4 X5 X6 X7

Bus Number

Maintenance

Age

Miles

Type

Bus-Mfg

Passengers

135

329

7

853

Diesel

Bluebird

55

120

503

10

883

Diesel

Keiser

42

200

505

10

822

Diesel

Bluebird

55

40

466

10

865

Gasoline

Bluebird

55

427

359

7

751

Gasoline

Keiser

55

759

546

8

870

Diesel

Keiser

55

10

427

5

780

Gasoline

Keiser

14

880

474

9

857

Gasoline

Keiser

55

481

382

3

818

Gasoline

Keiser

6

387

422

8

869

Gasoline

Bluebird

55

326

433

9

848

Diesel

Bluebird

55

861

474

10

845

Gasoline

Bluebird

55

122

558

10

885

Gasoline

Bluebird

55

156

561

12

838

Diesel

Thompson

55

887

357

8

760

Diesel

Bluebird

6

686

329

3

741

Diesel

Bluebird

55

490

497

10

859

Gasoline

Bluebird

55

370

459

8

826

Gasoline

Keiser

55

464

355

3

806

Gasoline

Bluebird

55

875

489

9

858

Diesel

Bluebird

55

883

436

2

785

Gasoline

Bluebird

55

57

455

7

828

Diesel

Bluebird

55

482

514

11

980

Gasoline

Bluebird

55

704

503

8

857

Diesel

Bluebird

55

989

380

9

803

Diesel

Keiser

55

731

432

6

819

Diesel

Bluebird

42

75

478

6

821

Diesel

Bluebird

55

162

406

3

798

Gasoline

Keiser

55

732

471

9

815

Diesel

Keiser

42

751

444

2

757

Diesel

Keiser

14

600

493

10

1008

Diesel

Bluebird

55

948

452

9

831

Diesel

Keiser

42

358

461

6

849

Diesel

Bluebird

55

833

496

8

839

Diesel

Thompson

55

692

469

8

812

Diesel

Bluebird

55

61

442

9

809

Diesel

Keiser

55

9

414

4

864

Gasoline

Keiser

55

314

459

11

859

Diesel

Thompson

6

396

457

2

815

Diesel

Thompson

55

365

462

6

799

Diesel

Keiser

55

398

570

9

844

Diesel

Thompson

14

43

439

9

832

Gasoline

Bluebird

55

500

369

5

842

Gasoline

Bluebird

55

279

390

2

792

Diesel

Bluebird

55

693

469

9

775

Gasoline

Keiser

55

884

381

9

882

Diesel

Bluebird

55

977

501

7

874

Diesel

Bluebird

55

38

432

6

837

Gasoline

Keiser

14

725

392

5

774

Diesel

Bluebird

55

982

441

1

823

Diesel

Bluebird

55

724

448

8

790

Diesel

Keiser

42

603

468

4

800

Diesel

Keiser

14

168

467

7

827

Gasoline

Thompson

55

45

478

6

830

Diesel

Keiser

55

754

515

14

895

Diesel

Keiser

14

39

411

6

804

Gasoline

Bluebird

55

671

504

8

866

Gasoline

Thompson

55

418

504

9

842

Diesel

Bluebird

55

984

392

8

851

Diesel

Bluebird

55

953

423

10

835

Diesel

Bluebird

55

507

410

7

866

Diesel

Bluebird

55

540

529

4

846

Gasoline

Bluebird

55

695

477

2

802

Diesel

Bluebird

55

193

540

11

847

Diesel

Thompson

55

321

450

6

856

Diesel

Bluebird

6

918

390

5

799

Diesel

Bluebird

55

101

424

4

827

Diesel

Bluebird

55

714

433

7

817

Diesel

Bluebird

42

678

428

7

842

Diesel

Keiser

55

768

494

7

815

Diesel

Bluebird

42

29

396

6

784

Gasoline

Bluebird

55

554

458

4

817

Diesel

Bluebird

14

767

493

6

816

Diesel

Keiser

55

699

475

9

816

Gasoline

Bluebird

55

954

476

10

827

Diesel

Bluebird

42

705

403

4

806

Diesel

Keiser

42

660

337

6

819

Gasoline

Bluebird

55

520

492

10

836

Diesel

Bluebird

55

814

426

4

757

Diesel

Bluebird

55

353

449

4

817

Gasoline

Keiser

55

  1. Sort the data by type of Bus Manufacturer and calculate the Average Cost and Standard Deviation of Maintenance for each Manufacturer
  2. Sort the data by Fuel Type and calculate the cost of Maintenance and the Average Mileage and Standard deviation of mileage by each fuel type of fuel
  3. Present your results in a table. Cut and paste your chart and table into MS-Word and attach your results.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing Information Systems

Authors: Mario Piattini

1st Edition

1878289756, 9781878289759

More Books

Students also viewed these Accounting questions