User Account

All Pages

Make a chart to compare diesel and gasoline

Assignment Help Business Economics
Reference no: EM133082355

Need help with the Hypothesis and Regression formula;

The consultants at Hayward Management Consulting Group are discussing the factors that explain the cost of maintenance for a fleet of Buses at the Buena School District.

You have data on Cost of Maintenance (Y - Dependent Variable) and Age in Years of a vehicle (X - Independent Variable) and Mileage Driven (M)

Using the data in MS-Excel (Attached)

Calculate the Average Number of miles comparing Diesel and Gasoline Buses and make a chart to compare Diesel and Gasoline and,

Conduct a Test of Hypothesis at 2½ Level of Significance comparing the Average cost of Maintenance of Diesel and Gasoline buses.

Conduct a Test of Hypothesis at 2½ Level of Significance comparing the Average number of Miles driven for Diesel and Gasoline buses.

Use Regression Analysis to identify

the Fixed Charge and

the cost for each additional mile of transportation

What is the Coefficient of Determination?

What is the estimated cost of maintenance for a bus that is driven for:

670 Miles

750 Miles

850 Miles

Using Regression Analysis, test whether the Total Cost of Maintenance is significantly affected by the Total Mileage driven of any bus.

Data Set 3 --Buena School District Bus Data

 

Bus Number

Maintenance

Age

Miles

Type

TYPECODE

135

329

7

853

Diesel

1

200

505

10

822

Diesel

1

326

433

9

848

Diesel

1

887

357

8

760

Diesel

1

686

329

3

741

Diesel

1

875

489

9

858

Diesel

1

57

455

7

828

Diesel

1

704

503

8

857

Diesel

1

731

432

6

819

Diesel

1

75

478

6

821

Diesel

1

600

493

10

1008

Diesel

1

358

461

6

849

Diesel

1

692

469

8

812

Diesel

1

279

390

2

792

Diesel

1

884

381

9

882

Diesel

1

977

501

7

874

Diesel

1

725

392

5

774

Diesel

1

982

441

1

823

Diesel

1

418

504

9

842

Diesel

1

984

392

8

851

Diesel

1

953

423

10

835

Diesel

1

507

410

7

866

Diesel

1

695

477

2

802

Diesel

1

321

450

6

856

Diesel

1

918

390

5

799

Diesel

1

101

424

4

827

Diesel

1

714

433

7

817

Diesel

1

768

494

7

815

Diesel

1

554

458

4

817

Diesel

1

954

476

10

827

Diesel

1

520

492

10

836

Diesel

1

814

426

4

757

Diesel

1

120

503

10

883

Diesel

1

759

546

8

870

Diesel

1

989

380

9

803

Diesel

1

732

471

9

815

Diesel

1

751

444

2

757

Diesel

1

948

452

9

831

Diesel

1

61

442

9

809

Diesel

1

365

462

6

799

Diesel

1

724

448

8

790

Diesel

1

603

468

4

800

Diesel

1

45

478

6

830

Diesel

1

754

515

14

895

Diesel

1

678

428

7

842

Diesel

1

767

493

6

816

Diesel

1

705

403

4

806

Diesel

1

156

561

12

838

Diesel

1

833

496

8

839

Diesel

1

314

459

11

859

Diesel

1

396

457

2

815

Diesel

1

398

570

9

844

Diesel

1

193

540

11

847

Diesel

1

Data Set 3 --Buena School District Bus Data

 

Bus Number

Maintenance

Age

Miles

Type

TYPECODE

40

466

10

865

Gasoline

2

387

422

8

869

Gasoline

2

861

474

10

845

Gasoline

2

122

558

10

885

Gasoline

2

490

497

10

859

Gasoline

2

464

355

3

806

Gasoline

2

883

436

2

785

Gasoline

2

482

514

11

980

Gasoline

2

43

439

9

832

Gasoline

2

500

369

5

842

Gasoline

2

39

411

6

804

Gasoline

2

540

529

4

846

Gasoline

2

29

396

6

784

Gasoline

2

699

475

9

816

Gasoline

2

660

337

6

819

Gasoline

2

427

359

7

751

Gasoline

2

10

427

5

780

Gasoline

2

880

474

9

857

Gasoline

2

481

382

3

818

Gasoline

2

370

459

8

826

Gasoline

2

162

406

3

798

Gasoline

2

9

414

4

864

Gasoline

2

693

469

9

775

Gasoline

2

38

432

6

837

Gasoline

2

353

449

4

817

Gasoline

2

168

467

7

827

Gasoline

2

671

504

8

866

Gasoline

2

Reference no: EM133082355

Questions Cloud

What is the relative price of apples before trade : Assume the Ricardian model where the marginal product of labor in the home country is 3 in the apple industry and 2 in the beer industry.
Why are professional athletes paid so much : Why are professional athletes paid so much? Discuss. Include economic concepts/terminology (marginal revenue product?) in your posting.?
What is the percentage increase in high school student : What is the percentage increase in high school student passing rates when they are bribed to get good grades?
How do taxes affect businesses and consumers : How do taxes affect businesses and consumers? Short answer please.
Make a chart to compare diesel and gasoline : The consultants at Hayward Management Consulting Group are discussing the factors that explain the cost of maintenance for a fleet of Buses at the Buena School
Model of interconnection between land and labor markets : Consider a monoeentrie city that establishes a maximum building height for business structures. The maximum height is the height of buildings one kilometer from
Distinctions between the three nations : What are at least two other distinctions between the three nations that affect the standard of living besides the ones listed on the table?
Sustainable business and economic development : Is sustainable business and economic development the answer to the globalization controversy?
What is the maximum willing to buy : What is the Maximum Willing to Buy (Quantity at Price = 0)?

Reviews

Write a Review

Business Economics Questions & Answers

  Describes the short-run time production period

Which of the following describes the short-run time production period?Firms can vary only one of the inputs in the production process. Firms can vary all inputs into the production process. Firms cannot vary any of the inputs into the production proc..

  Terms of their rates of return and risk

Suppose you are an investor with a choice between three securities that are identical in every way except in terms of their rates of return and risk.

  Are all good samples random

Are all good samples random? This is an opportunity to bring up opinion polling, which typically tries to obtain views from particular groups

  About paine resulting from the surgery

A surgeon performs a surgery on john smith. smith later complains to his surgeon about paine resulting from the surgery. his surgeon dismisses his complaints as not credible and eventually withdraws from the case. Describe the theories that could sup..

  What is the value of the monetary base

Money Definitions. To answer the following questions, refer to the money definitions and relationships 1: Total currency = (currency in circulation) + (vault cash) 2. Total reserves = (vault cash) + (reserve deposits). Suppose that banks have a total..

  Diesel engine will have guaranteed residual value

A12-cylinder heavy-duty diesel engine will have a guaranteed residual value of  $ 1000 in 5 years. Today (year 0) the equivalent worth of this engine is how much if the interest rate is 9% per year?

  Screen capture of the successful execution

Support your experimentation with a screen capture of the code and a screen capture of the successful execution of the new code.

  Imports-exports and domestic spending

Accounting for trade in goods and services Suppose the following transactions occur during the current year: A U.S. company sells 200 transistors to a Spanish company at $15.00 per transistor. Sam, a U.S. citizen, pays $1,500 for a laptop he orders f..

  What is the value that is below or less than µ

Two values will be required to complete the following equation:

  About economists assessment of protectionism

Which of the following statements about economists' assessment of protectionism is true?

  About fat content and other ingredients on food packages

In December 1992, the federal government began requiring that all foods display information about fat content and other ingredients on food packages. The displays had to be verified by independent laboratories. The price of an evaluation of a food pr..

  Evaluate regression results

The Dodge City Bank is planning its loans for the next several years, and is using the model of loan demand developed from past experience. Fred Smith

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd