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

  Economics assignment

This document contains various important questions and their appropriate answers in the subject field of Economics.

  Demand and supply curves

Economics is the study of the principles governing the allocation of scarce means among competing ends when the objective of the allocation is to maximize the attainment of the ends.

  Long-run perfectly competitive equilibrium for the firm

Evaluate Government intervene and correct this situation?(a) Explain the concept of a concentration ratio. A rise in the price of magarine Explain the impact of external costs and external benefits on resource allocation long-run perfectly c..

  Supply and demand diagrams

Explain each of the following using supply and demand diagrams,  With the use of a graph, explain how these two programs affect cigarette consumption and the price of cigarettes.

  Case study: fisher-price toys

The case study of the Fisher-Price Toys, Inc., a popular case in basic economics and management from the prestigious Harvard Business School.

  Draw the production possibility curve

Draw the production possibility curve and a. Define consumer surplus and producer surplus.

  Tax revenue

The Australian government administers two programs that affect the market for cigarettes

  Maximize total welfare

How many tickets to sell to maximize total welfare.

  Difference between the cv and the ev

The change in consumer surplus (?CS) is not "theoretically" justifiable like the CV and EV but it continues to be the most widely used measure of consumer welfare change. Explain how this can be reconciled

  Depict von neumann-morgenstern utility index u in a diagram

Depict the von Neumann-Morgenstern utility index u in a diagram

  What is the market solution

What is the market solution (market price and quantity) and What is the total surplus of the society under the market solution

  Calculate gross national product and net national product

Calculate gross national product and net national product

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: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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