Question Details

(solution) Frequency Distribution - Quantitative Maintenance lower


This is last question not attached to the other two excel sheets that I need help with. Thank you!


Frequency Distribution - Quantitative

 

Maintenance

 

lower 320

 

340

 

360

 

380

 

400

 

420

 

440

 

460

 

480

 

500

 

520

 

540

 

560 Histogram

 

20.0

 

Percent 18.0

 

16.0

 

14.0

 

12.0

 

10.0

 

8.0

 

6.0

 

4.0

 

2.0

 

0.0

 

Maintenance Descriptive statistics

 

Maintenance

 

count

 

80

 

mean

 

450.29

 

sample variance

 

2,882.18

 

sample standard deviation

 

53.69

 

minimum

 

329

 

maximum

 

570

 

range

 

241

 

1st quartile 420.00 upper <

 

<

 

<

 

<

 

<

 

<

 

<

 

<

 

<

 

<

 

<

 

<

 

< 340

 

360

 

380

 

400

 

420

 

440

 

460

 

480

 

500

 

520

 

540

 

560

 

580 midpoint width

 

330

 

20

 

350

 

20

 

370

 

20

 

390

 

20

 

410

 

20

 

430

 

20

 

450

 

20

 

470

 

20

 

490

 

20

 

510

 

20

 

530

 

20

 

550

 

20

 

570

 

20 frequency

 

3

 

3

 

1

 

8

 

5

 

12

 

12

 

15

 

7

 

8

 

1

 

3

 

2

 

80 median

 

3rd quartile

 

interquartile range

 

mode

 

low extremes

 

low outliers

 

high outliers

 

high extremes 456.00

 

489.75

 

69.75

 

329.00

 

0

 

0

 

0

 

0 Frequency Distribution - Quantitative

 

Maintenance

 

lower upper 300

 

350

 

400

 

450

 

500

 

550 <

 

<

 

<

 

<

 

<

 

< 350

 

400

 

450

 

500

 

550

 

600 midpoint width

 

325

 

50

 

375

 

50

 

425

 

50

 

475

 

50

 

525

 

50

 

575

 

50 frequency

 

3

 

12

 

22

 

29

 

11

 

3

 

80 midpoint width

 

343

 

35

 

378

 

35

 

413

 

35

 

448

 

35

 

483

 

35 frequency

 

6

 

8

 

12

 

20

 

20 Histogram Percent 40.0

 

35.0

 

30.0

 

25.0

 

20.0

 

15.0

 

10.0

 

5.0

 

0.0

 

Maintenance Frequency Distribution - Quantitative

 

Maintenance

 

lower 325

 

360

 

395

 

430

 

465 upper <

 

<

 

<

 

<

 

< 360

 

395

 

430

 

465

 

500 500

 

535

 

570 <

 

<

 

< 535

 

570

 

605 518

 

553

 

587 35

 

35

 

35 Histogram Percent 30.0

 

25.0

 

20.0

 

15.0

 

10.0

 

5.0

 

0.0

 

Maintenance Descriptive statistics

 

count

 

mean

 

sample variance

 

sample standard deviation

 

minimum

 

maximum

 

range

 

1st quartile

 

median

 

3rd quartile

 

interquartile range

 

mode Miles

 

80

 

827.53

 

1,188.20

 

34.47

 

741

 

908

 

167

 

806.00

 

827.00

 

851.50

 

45.50

 

815.00 low extremes

 

low outliers

 

high outliers

 

high extremes 0

 

0

 

0

 

0 BoxPlot

 

1/28/2010 16:03.39 (1) 600 650 700 750 Miles 800 850 900 950 9

 

4

 

1

 

80 BoxPlot 600 650 700 750 Miles 800 850 900 950 850 900 950 850 900 950 Descriptive statistics

 

count

 

mean

 

sample variance

 

sample standard deviation

 

minimum

 

maximum

 

range

 

1st quartile

 

median

 

3rd quartile

 

interquartile range

 

mode Miles

 

80

 

827.53

 

1,188.20

 

34.47

 

741

 

908

 

167

 

806.00

 

827.00

 

851.50

 

45.50

 

815.00 low extremes

 

low outliers

 

high outliers

 

high extremes 0

 

0

 

0

 

0 BoxPlot

 

1/28/2010 16:06.08 (1) 600 650 700 750 Miles 800 1/28/2010

 

DotPlot16:06.08 (1) 600 650 Descriptive statistics 700 750 Miles 800 Miles

 

80

 

830.11

 

1,779.85

 

42.19

 

741

 

1008

 

267 count

 

mean

 

sample variance

 

sample standard deviation

 

minimum

 

maximum

 

range

 

1st quartile

 

median

 

3rd quartile

 

interquartile range

 

mode 806.00

 

827.00

 

851.50

 

45.50

 

815.00 low extremes

 

low outliers

 

high outliers

 

high extremes 0

 

0

 

1

 

1 BoxPlot

 

1/28/2010 16:08.20 (1) 600 650 700 750 800

 

850

 

Miles 900 950 1000 1050 950 1000 1050 1/28/2010

 

DotPlot16:08.20 (1) 600 650 700 750 800

 

850

 

Miles 900 Correlation Matrix

 

Maintenance

 

Age

 

Miles Maintenance

 

1.000

 

.465

 

.450 Age Miles 1.000

 

.522 1.000 80 sample size

 

± .220 critical value .05 (two-tail) ± .286 critical value .01 (two-tail) percent

 

3.8

 

3.8

 

1.3

 

10.0

 

6.3

 

15.0

 

15.0

 

18.8

 

8.8

 

10.0

 

1.3

 

3.8

 

2.5

 

100.0 cumulative

 

frequency percent

 

3

 

3.8

 

6

 

7.5

 

7

 

8.8

 

15

 

18.8

 

20

 

25.0

 

32

 

40.0

 

44

 

55.0

 

59

 

73.8

 

66

 

82.5

 

74

 

92.5

 

75

 

93.8

 

78

 

97.5

 

80

 

100.0 percent

 

3.8

 

15.0

 

27.5

 

36.3

 

13.8

 

3.8

 

100.0 percent

 

7.5

 

10.0

 

15.0

 

25.0

 

25.0 cumulative

 

frequency percent

 

3

 

3.8

 

15

 

18.8

 

37

 

46.3

 

66

 

82.5

 

77

 

96.3

 

80

 

100.0 cumulative

 

frequency percent

 

6

 

7.5

 

14

 

17.5

 

26

 

32.5

 

46

 

57.5

 

66

 

82.5 11.3

 

5.0

 

1.3

 

100.0 75

 

79

 

80 93.8

 

98.8

 

100.0 Data Set 3 --Buena School District Bus Data

 

Bus Number

 

X1 Maintenance

 

X2 Age

 

X3 Miles

 

X4 Type

 

X5 Bus-Mfg

 

X6 Passenger

 

X7 135

 

120

 

200

 

40

 

427

 

759

 

10

 

880

 

481

 

387

 

326

 

861

 

122

 

156

 

887

 

686

 

490

 

370

 

464

 

875

 

883

 

57

 

482

 

704

 

989

 

731

 

75

 

162

 

732

 

751

 

600

 

948

 

358

 

833

 

692

 

61

 

9

 

314 329

 

503

 

505

 

466

 

359

 

546

 

427

 

474

 

382

 

422

 

433

 

474

 

558

 

561

 

357

 

329

 

497

 

459

 

355

 

489

 

436

 

455

 

514

 

503

 

380

 

432

 

478

 

406

 

471

 

444

 

493

 

452

 

461

 

496

 

469

 

442

 

414

 

459 7

 

10

 

10

 

10

 

7

 

8

 

5

 

9

 

3

 

8

 

9

 

10

 

10

 

12

 

8

 

3

 

10

 

8

 

3

 

9

 

2

 

7

 

11

 

8

 

9

 

6

 

6

 

3

 

9

 

2

 

10

 

9

 

6

 

8

 

8

 

9

 

4

 

11 853

 

883

 

822

 

865

 

751

 

870

 

780

 

857

 

818

 

869

 

848

 

845

 

885

 

838

 

760

 

741

 

859

 

826

 

806

 

858

 

785

 

828

 

980

 

857

 

803

 

819

 

821

 

798

 

815

 

757

 

1008

 

831

 

849

 

839

 

812

 

809

 

864

 

859 Diesel

 

Diesel

 

Diesel

 

Gasoline

 

Gasoline

 

Diesel

 

Gasoline

 

Gasoline

 

Gasoline

 

Gasoline

 

Diesel

 

Gasoline

 

Gasoline

 

Diesel

 

Diesel

 

Diesel

 

Gasoline

 

Gasoline

 

Gasoline

 

Diesel

 

Gasoline

 

Diesel

 

Gasoline

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Gasoline

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Gasoline

 

Diesel Bluebird

 

Keiser

 

Bluebird

 

Bluebird

 

Keiser

 

Keiser

 

Keiser

 

Keiser

 

Keiser

 

Bluebird

 

Bluebird

 

Bluebird

 

Bluebird

 

Thompson

 

Bluebird

 

Bluebird

 

Bluebird

 

Keiser

 

Bluebird

 

Bluebird

 

Bluebird

 

Bluebird

 

Bluebird

 

Bluebird

 

Keiser

 

Bluebird

 

Bluebird

 

Keiser

 

Keiser

 

Keiser

 

Bluebird

 

Keiser

 

Bluebird

 

Thompson

 

Bluebird

 

Keiser

 

Keiser

 

Thompson 55 Passenger

 

42 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

14 Passenger

 

55 Passenger

 

6 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

6 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

42 Passenger

 

55 Passenger

 

55 Passenger

 

42 Passenger

 

14 Passenger

 

55 Passenger

 

42 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

6 Passenger 396

 

365

 

398

 

43

 

500

 

279

 

693

 

884

 

977

 

38

 

725

 

982

 

724

 

603

 

168

 

45

 

754

 

39

 

671

 

418

 

984

 

953

 

507

 

540

 

695

 

193

 

321

 

918

 

101

 

714

 

678

 

768

 

29

 

554

 

767

 

699

 

954

 

705

 

660

 

520

 

814

 

353 457

 

462

 

570

 

439

 

369

 

390

 

469

 

381

 

501

 

432

 

392

 

441

 

448

 

468

 

467

 

478

 

515

 

411

 

504

 

504

 

392

 

423

 

410

 

529

 

477

 

540

 

450

 

390

 

424

 

433

 

428

 

494

 

396

 

458

 

493

 

475

 

476

 

403

 

337

 

492

 

426

 

449 2

 

6

 

9

 

9

 

5

 

2

 

9

 

9

 

7

 

6

 

5

 

1

 

8

 

4

 

7

 

6

 

14

 

6

 

8

 

9

 

8

 

10

 

7

 

4

 

2

 

11

 

6

 

5

 

4

 

7

 

7

 

7

 

6

 

4

 

6

 

9

 

10

 

4

 

6

 

10

 

4

 

4 815

 

799

 

844

 

832

 

842

 

792

 

775

 

882

 

874

 

837

 

774

 

823

 

790

 

800

 

827

 

830

 

895

 

804

 

866

 

842

 

851

 

835

 

866

 

846

 

802

 

847

 

856

 

799

 

827

 

817

 

842

 

815

 

784

 

817

 

816

 

816

 

827

 

806

 

819

 

836

 

757

 

817 Diesel

 

Diesel

 

Diesel

 

Gasoline

 

Gasoline

 

Diesel

 

Gasoline

 

Diesel

 

Diesel

 

Gasoline

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Gasoline

 

Diesel

 

Diesel

 

Gasoline

 

Gasoline

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Gasoline

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Diesel

 

Gasoline

 

Diesel

 

Diesel

 

Gasoline

 

Diesel

 

Diesel

 

Gasoline

 

Diesel

 

Diesel

 

Gasoline Thompson

 

Keiser

 

Thompson

 

Bluebird

 

Bluebird

 

Bluebird

 

Keiser

 

Bluebird

 

Bluebird

 

Keiser

 

Bluebird

 

Bluebird

 

Keiser

 

Keiser

 

Thompson

 

Keiser

 

Keiser

 

Bluebird

 

Thompson

 

Bluebird

 

Bluebird

 

Bluebird

 

Bluebird

 

Bluebird

 

Bluebird

 

Thompson

 

Bluebird

 

Bluebird

 

Bluebird

 

Bluebird

 

Keiser

 

Bluebird

 

Bluebird

 

Bluebird

 

Keiser

 

Bluebird

 

Bluebird

 

Keiser

 

Bluebird

 

Bluebird

 

Bluebird

 

Keiser 55 Passenger

 

55 Passenger

 

14 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

14 Passenger

 

55 Passenger

 

55 Passenger

 

42 Passenger

 

14 Passenger

 

55 Passenger

 

55 Passenger

 

14 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

6 Passenger

 

55 Passenger

 

55 Passenger

 

42 Passenger

 

55 Passenger

 

42 Passenger

 

55 Passenger

 

14 Passenger

 

55 Passenger

 

55 Passenger

 

42 Passenger

 

42 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger

 

55 Passenger 52. Refer to the Buena School District bus data.

 

a. Select the variable for the number of miles traveled last month. Conduct a test of

 

hypothesis to determine whether the mean number of miles traveled is equal to 840.

 

Use the .01 significance level. Find the p-value and explain what it means.

 

b. Using the maintenance cost variable, conduct a test of hypothesis to determine whether

 

the mean maintenance cost is less than $500 at the .05 significance level. Determine the

 

p-value and interpret the result.

 


Solution details:

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 13, 2020

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now