Questions
A new fuel injection system has been engineered for pickup trucks. The new system and the...

A new fuel injection system has been engineered for pickup trucks. The new system and the old system both produce about the same average miles per gallon. However, engineers question which system (old or new) will give better consistency in fuel consumption (miles per gallon) under a variety of driving conditions. A random sample of 41 trucks were fitted with the new fuel injection system and driven under different conditions. For these trucks, the sample variance of gasoline consumption was 53.6. Another random sample of 24trucks were fitted with the old fuel injection system and driven under a variety of different conditions. For these trucks, the sample variance of gasoline consumption was 39.7. Test the claim that there is a difference in population variance of gasoline consumption for the two injection systems. Use a 5% level of significance. How could your test conclusion relate to the question regarding the consistency of fuel consumption for the two fuel injection systems?

(a) What is the level of significance?
  

State the null and alternate hypotheses.

Ho: σ12 = σ22; H1: σ12 > σ22Ho: σ12 > σ22; H1: σ12 = σ22    Ho: σ22 = σ12; H1: σ22 > σ12Ho: σ12 = σ22; H1: σ12σ22



(b) Find the value of the sample F statistic. (Round your answer to two decimal places.)
  

What are the degrees of freedom?

dfN
dfD


What assumptions are you making about the original distribution?

The populations follow independent normal distributions.The populations follow independent normal distributions. We have random samples from each population.    The populations follow dependent normal distributions. We have random samples from each population.The populations follow independent chi-square distributions. We have random samples from each population.


(c) Find or estimate the P-value of the sample test statistic.

P-value > 0.2000.100 < P-value < 0.200    0.050 < P-value < 0.1000.020 < P-value < 0.0500.002 < P-value < 0.020P-value < 0.002


(d) Based on your answers in parts (a) to (c), will you reject or fail to reject the null hypothesis?

At the α = 0.05 level, we reject the null hypothesis and conclude the data are not statistically significant.At the α = 0.05 level, we reject the null hypothesis and conclude the data are statistically significant.    At the α = 0.05 level, we fail to reject the null hypothesis and conclude the data are not statistically significant.At the α = 0.05 level, we fail to reject the null hypothesis and conclude the data are statistically significant.\


(e) Interpret your conclusion in the context of the application.

Fail to reject the null hypothesis, there is sufficient evidence that the variance in consumption of gasoline is greater in the new fuel injection systems.

Reject the null hypothesis, there is insufficient evidence that the variance in consumption of gasoline is greater in the new fuel injection systems.   

Reject the null hypothesis, there is sufficient evidence that the variance in consumption of gasoline is different in both fuel injection systems.

Fail to reject the null hypothesis, there is insufficient evidence that the variance in consumption of gasoline is different in both fuel injection systems.

In: Statistics and Probability

Linton Company purchased a delivery truck for $29,000 on January 1, 2017. The truck has an...

Linton Company purchased a delivery truck for $29,000 on January 1, 2017. The truck has an expected salvage value of $2,100, and is expected to be driven 106,000 miles over its estimated useful life of 10 years. Actual miles driven were 15,300 in 2017 and 13,400 in 2018. Correct answer. Your answer is correct. Calculate depreciation expense per mile under units-of-activity method. (Round answer to 2 decimal places, e.g. 0.52.) Depreciation expense $Entry field with correct answer .25 per mile SHOW LIST OF ACCOUNTS SHOW SOLUTION SHOW ANSWER LINK TO TEXT Correct answer. Your answer is correct. Compute depreciation expense for 2017 and 2018 using (1) the straight-line method, (2) the units-of-activity method, and (3) the double-declining-balance method. (Round depreciation cost per unit to 2 decimal places, e.g. 0.50 and depreciation rate to 0 decimal places, e.g. 15%. Round final answers to 0 decimal places, e.g. 2,125.) Depreciation Expense 2017 2018 (1) Straight-line method $Entry field with correct answer 2690 $Entry field with correct answer 2690 (2) Units-of-activity method $Entry field with correct answer 3825 $Entry field with correct answer 3350 (3) Double-declining-balance method $Entry field with correct answer 5800 $Entry field with correct answer 4640 SHOW LIST OF ACCOUNTS SHOW SOLUTION SHOW ANSWER LINK TO TEXT Partially correct answer. Your answer is partially correct. Try again. Assume that Linton uses the straight-line method. Prepare the journal entry to record 2017 depreciation. (Credit account titles are automatically indented when amount is entered. Do not indent manually. If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Round answers to 0 decimal places, e.g. 2,125.) Account Titles and Explanation Debit Credit Entry field with correct answer Depreciation Expense Entry field with correct answer 2690 Entry field with correct answer Entry field with incorrect answer now contains modified data Accumulated Depreciation-Equipment Entry field with correct answer Entry field with correct answer 2690 SHOW LIST OF ACCOUNTS LINK TO TEXT Partially correct answer. Your answer is partially correct. Try again. Assume that Linton uses the straight-line method. Show how the truck would be reported in the December 31, 2017, balance sheet. (Round answers to 0 decimal places, e.g. 2,125.) LINTON COMPANY Partial Balance Sheet Entry field with correct answer Entry field with incorrect answer now contains modified data $Entry field with incorrect answer now contains modified data 29000 Entry field with correct answer: Entry field with incorrect answer now contains modified data Accumulated Depreciation-Equipment Entry field with incorrect answer now contains modified data 2690 $Entry field with incorrect answer now contains modified data 26310

In: Accounting

A new fuel injection system has been engineered for pickup trucks. The new system and the...

A new fuel injection system has been engineered for pickup trucks. The new system and the old system both produce about the same average miles per gallon. However, engineers question which system (old or new) will give better consistency in fuel consumption (miles per gallon) under a variety of driving conditions. A random sample of 31 trucks were fitted with the new fuel injection system and driven under different conditions. For these trucks, the sample variance of gasoline consumption was 52.7. Another random sample of 24 trucks were fitted with the old fuel injection system and driven under a variety of different conditions. For these trucks, the sample variance of gasoline consumption was 38.5. Test the claim that there is a difference in population variance of gasoline consumption for the two injection systems. Use a 5% level of significance. How could your test conclusion relate to the question regarding the consistency of fuel consumption for the two fuel injection systems?

(a) What is the level of significance?


State the null and alternate hypotheses.

Ho: σ12 = σ22; H1: σ12 > σ22Ho: σ12 > σ22; H1: σ12 = σ22    Ho: σ22 = σ12; H1: σ22 > σ12Ho: σ12 = σ22; H1: σ12σ22



(b) Find the value of the sample F statistic. (Round your answer to two decimal places.)


What are the degrees of freedom?

dfN
dfD


What assumptions are you making about the original distribution?

The populations follow dependent normal distributions. We have random samples from each population.The populations follow independent chi-square distributions. We have random samples from each population.    The populations follow independent normal distributions. We have random samples from each population.The populations follow independent normal distributions.


(c) Find or estimate the P-value of the sample test statistic.

P-value > 0.2000.100 < P-value < 0.200    0.050 < P-value < 0.1000.020 < P-value < 0.0500.002 < P-value < 0.020P-value < 0.002


(d) Based on your answers in parts (a) to (c), will you reject or fail to reject the null hypothesis?

At the α = 0.05 level, we reject the null hypothesis and conclude the data are not statistically significant.At the α = 0.05 level, we reject the null hypothesis and conclude the data are statistically significant.    At the α = 0.05 level, we fail to reject the null hypothesis and conclude the data are not statistically significant.At the α = 0.05 level, we fail to reject the null hypothesis and conclude the data are statistically significant.


(e) Interpret your conclusion in the context of the application.

Fail to reject the null hypothesis, there is sufficient evidence that the variance in consumption of gasoline is greater in the new fuel injection systems.Reject the null hypothesis, there is insufficient evidence that the variance in consumption of gasoline is greater in the new fuel injection systems.    Reject the null hypothesis, there is sufficient evidence that the variance in consumption of gasoline is different in both fuel injection systems.Fail to reject the null hypothesis, there is insufficient evidence that the variance in consumption of gasoline is different in both fuel injection systems.

In: Math

A new fuel injection system has been engineered for pickup trucks. The new system and the...

A new fuel injection system has been engineered for pickup trucks. The new system and the old system both produce about the same average miles per gallon. However, engineers question which system (old or new) will give better consistency in fuel consumption (miles per gallon) under a variety of driving conditions. A random sample of 41 trucks were fitted with the new fuel injection system and driven under different conditions. For these trucks, the sample variance of gasoline consumption was 53. Another random sample of 21 trucks were fitted with the old fuel injection system and driven under a variety of different conditions. For these trucks, the sample variance of gasoline consumption was 33.1. Test the claim that there is a difference in population variance of gasoline consumption for the two injection systems. Use a 5% level of significance. How could your test conclusion relate to the question regarding the consistency of fuel consumption for the two fuel injection systems?

(a) What is the level of significance?


State the null and alternate hypotheses.

Ho: σ12 = σ22; H1: σ12 > σ22Ho: σ12 > σ22; H1: σ12 = σ22    Ho: σ22 = σ12; H1: σ22 > σ12Ho: σ12 = σ22; H1: σ12σ22



(b) Find the value of the sample F statistic. (Round your answer to two decimal places.)


What are the degrees of freedom?

dfN
dfD


What assumptions are you making about the original distribution?

The populations follow independent normal distributions. We have random samples from each population.The populations follow dependent normal distributions. We have random samples from each population.    The populations follow independent normal distributions.The populations follow independent chi-square distributions. We have random samples from each population.


(c) Find or estimate the P-value of the sample test statistic.

P-value > 0.2000.100 < P-value < 0.200    0.050 < P-value < 0.1000.020 < P-value < 0.0500.002 < P-value < 0.020P-value < 0.002


(d) Based on your answers in parts (a) to (c), will you reject or fail to reject the null hypothesis?

At the α = 0.05 level, we reject the null hypothesis and conclude the data are not statistically significant.At the α = 0.05 level, we reject the null hypothesis and conclude the data are statistically significant.    At the α = 0.05 level, we fail to reject the null hypothesis and conclude the data are not statistically significant.At the α = 0.05 level, we fail to reject the null hypothesis and conclude the data are statistically significant.


(e) Interpret your conclusion in the context of the application.

Fail to reject the null hypothesis, there is sufficient evidence that the variance in consumption of gasoline is greater in the new fuel injection systems.Reject the null hypothesis, there is insufficient evidence that the variance in consumption of gasoline is greater in the new fuel injection systems.    Reject the null hypothesis, there is sufficient evidence that the variance in consumption of gasoline is different in both fuel injection systems.Fail to reject the null hypothesis, there is insufficient evidence that the variance in consumption of gasoline is different in both fuel injection systems.

In: Math

Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services,...

Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services, the company has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $22.10 per hundred square feet. However, there is some question about whether the company is actually making any money on jobs for some customers—particularly those located on remote ranches that require considerable travel time. The owner’s daughter, home for the summer from college, has suggested investigating this question using activity-based costing. After some discussion, she designed a simple system consisting of four activity cost pools. The activity cost pools and their activity measures appear below:

Activity Cost Pool Activity Measure Activity for the Year
Cleaning carpets Square feet cleaned (00s) 7,000 hundred square feet
Travel to jobs Miles driven 180,500 miles
Job support Number of jobs 2,000 jobs
Other (organization-sustaining costs and idle capacity costs) None Not applicable

The total cost of operating the company for the year is $352,000 which includes the following costs:

Wages $ 140,000
Cleaning supplies 34,000
Cleaning equipment depreciation 16,000
Vehicle expenses 35,000
Office expenses 56,000
President’s compensation 71,000
Total cost $ 352,000

Resource consumption is distributed across the activities as follows:

Distribution of Resource Consumption Across Activities
Cleaning Carpets Travel to Jobs Job Support Other Total
Wages 75 % 14 % 0 % 11 % 100 %
Cleaning supplies 100 % 0 % 0 % 0 % 100 %
Cleaning equipment depreciation 73 % 0 % 0 % 27 % 100 %
Vehicle expenses 0 % 78 % 0 % 22 % 100 %
Office expenses 0 % 0 % 55 % 45 % 100 %
President’s compensation 0 % 0 % 32 % 68 % 100 %

Job support consists of receiving calls from potential customers at the home office, scheduling jobs, billing, resolving issues, and so on.

Required:

1. Prepare the first-stage allocation of costs to the activity cost pools.

Cleaning Carpets Travel to Jobs Job Support Other Total
Wages
Cleaning supplies
Cleaning equipment depreciation
Vehicle expenses
Office expenses
President’s compensation
Total cost

2. Compute the activity rates for the activity cost pools. (Round your answers to 2 decimal places.)

Activity Cost Pool Activity Rate
Cleaning carpets per hundred square feet
Travel to jobs per mile
Job support per job

3. The company recently completed a 400 square foot carpet-cleaning job at the Flying N Ranch—a 50-mile round-trip journey from the company’s offices in Bozeman. Compute the cost of this job using the activity-based costing system. (Round your intermediate calculations and final answer to 2 decimal places.)

Cost of the job

4. The revenue from the Flying N Ranch was $88.40 (4 hundred square feet @ $22.10 per hundred square feet). Calculate the customer margin earned on this job. (Round your intermediate calculations and final answers to 2 decimal places.)

Customer margin

In: Accounting

IRAC Torts Bauer Insulation Co (BIC) was a subcontractor on an expansion project at the Dixon-Goetz...

IRAC Torts

Bauer Insulation Co (BIC) was a subcontractor on an expansion project at the Dixon-Goetz manufacturing plant in Lowville, New York which is a remote part of upstate New York approximately 40 miles from the nearest population centers.  Given the remoteness of the work site, BIC provided $30 per day in subsistence pay to each of its employees to defer part of the cost of a motel room or apartment in the nearest towns.  BIC did not require its employees to spend the money on lodging.  The employees were free to spend it or not spend it as they saw fit.  In fact the President of BIC, Zachary Bauer, would tell his employees, “if I were you, I’d pocket the money and commute!  It isn’t taxable income, its like free money!”

James LePage, a BIC employee was assigned to work on the expansion project in Lowville and he received the $30 per day subsistence pay from BIC but he elected to make the commute to the plant from his home in Rochester, NY which was 120 miles from the work site.  james, a resourceful young man, convinced a few other co-workers along the route to carpool to save additional money.  The parties would share the driving responsibilities.  The work schedule was Monday through Friday 7am to 5:30pm with a half hour for lunch and few if any breaks.  In addition to his employment with BIC, James also worked at the local Dick’s sporting goods store a second job at night as a stock clerk.

James completed his regular shift at the plant on a Tuesday and returned to Rochester at 8:30pm.  He then worked his second job before going to bed around midnight.  James then rose at 4:00am on Wednesday to get his vehicle and collect his co-workers for the daily commute to the plant, where he worked his normal shift.  The car pool with James driving left the plant around 6:00pm.  Shortly thereafter, James fell asleep at the wheel.  His vehicle crossed the centerline of the highway and collided head-on with a vehicle in which Matt Krengel was the passenger.  Matt expired in the accident and his widow, Claire McMahon, acting in her own right and as a personal representative of her late husband’s estate, filed a negligence-based wrongful death action against BIC in a New York State Court.

The lawsuit filed by McMahon claimed that BIC owed a duty of care to the other travelers on the highway to prevent injury caused by employees who had become exhausted after being required to commute long distances and work long hours and were even encouraged to do so with the $30 per day stipend.  She contended in her complaint that BIC breached its duty by “failing to take precautionary measures to prevent employees from becoming so exhausted that they pose a threat of harm to the traveling public and failing to provide alternative transportation to its exhausted employees or in the alternative, failing to provide living quarters to its employees within a reasonable from the plant site.

Discuss the legal theory put forth by Mrs. McMahon based on the various theories of negligence discussed in class.  Using the IRAC format conclude on the likelihood of success of this lawsuit.

In: Operations Management

Required information Problem 9-31 Production and Direct-Labor Budgets; Activity-Based Overhead Budget (LO 9-3, 9-4, 9-5, 9-6)...

Required information

Problem 9-31 Production and Direct-Labor Budgets; Activity-Based Overhead Budget (LO 9-3, 9-4, 9-5, 9-6)

[The following information applies to the questions displayed below.]

Spiffy Shades Corporation manufactures artistic frames for sunglasses. Talia Demarest, controller, is responsible for preparing the company’s master budget. In compiling the budget data for 20x1, Demarest has learned that new automated production equipment will be installed on March 1. This will reduce the direct labor per frame from 1.0 hour to 0.75 hour.

Labor-related costs include pension contributions of $1.30 per hour, workers’ compensation insurance of $1.00 per hour, employee medical insurance of $4 per hour, and employer contributions to Social Security equal to 7.00 percent of direct-labor wages. The cost of employee benefits paid by the company on its employees is treated as a direct-labor cost. Spiffy Shades Corporation has a labor contract that calls for a wage increase to $15.00 per hour on April 1, 20x1. Management expects to have 16,200 frames on hand at December 31, 20x0, and has a policy of carrying an end-of-month inventory of 100 percent of the following month’s sales plus 40 percent of the second following month’s sales.

These and other data compiled by Demarest are summarized in the following table.

January February March April May
Direct-labor hours per unit 1.0 1.0 0.75 0.75 0.75
Wage per direct-labor hour $ 13.00 $ 13.00 $ 13.00 $ 15.00 $ 15.00
Estimated unit sales 11,000 13,000 9,000 10,000 10,000
Sales price per unit $ 64.00 $ 61.50 $ 61.50 $ 61.50 $ 61.50
Production overhead:
Shipping and handling (per unit sold) $ 2.00 $ 2.00 $ 2.00 $ 2.00 $ 2.00
Purchasing, material handling, and inspection (per unit produced) $ 3.00 $ 3.00 $ 3.00 $ 3.00 $ 3.00
Other production overhead (per direct-labor hour) $ 6.00 $ 6.00 $ 6.00 $ 6.00 $ 6.00
  1. Prepare a production budget and a direct-labor budget for Spiffy Shades Corporation by month and for the first quarter of 20x1. (Round "Direct-labor hours per unit" to 2 decimal places.)

SPIFFY SHADES CORPORATION
Budget for Production and Direct Labor
For the First Quarter of 20x1
Month
January February March Quarter
Sales (units) 11,000 13,000 9,000 33,000
Add: Ending inventory
Total needs 11,000 13,000 9,000 33,000
Units to be produced
Direct-labor hours per unit
Total hours of direct labor time needed 0 0 0 0
Direct-labor costs:
Wages
Pension contributions
Workers' compensation insurance
Employee medical insurance
Employer's social security
Total direct-labor cost $0 $0 $0 $0
  1. For each item used in the firm’s production budget and direct-labor budget, select the other components of the master budget (except for financial statement budgets) that also, directly or indirectly, would use these data. (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer.)

  1. Sales data:

  • Selling and administrative expense budgetunanswered
  • Production-overhead budgetunanswered
  • Direct-material budgetunanswered
  • Cash budgetunanswered
  • Cost-of-goods-sold budgetunanswered
  • Sales budgetunanswered
  • Cash disbursements budgetunanswered
  1. Production data:

  • Selling and administrative expense budgetunanswered
  • Direct-material budgetunanswered
  • Cost-of-goods-sold budgetunanswered
  • Production-overhead budgetunanswered
  • Cash budgetunanswered
  • Cash disbursements budgetunanswered
  • Sales budgetunanswered
  1. Direct-labor-hour data:

  • Selling and administrative expense budgetunanswered
  • Production-overhead budgetunanswered
  • Direct-material budgetunanswered
  • Cash budgetunanswered
  • Cost-of-goods-sold budgetunanswered
  • Sales budgetunanswered
  • Cash disbursements budgetunanswered
  1. Direct-labor cost data:

  • Selling and administrative expense budgetunanswered
  • Production-overhead budgetunanswered
  • Direct-material budgetunanswered
  • Cash budgetunanswered
  • Sales budgetunanswered
  • Cost-of-goods-sold budgetunanswered
  • Cash disbursements budget
  1. Prepare a production overhead budget for each month and for the first quarter.

SPIFFY SHADES CORPORATION
Production Overhead Budget
For the First Quarter of 20x1
Month
January February March Quarter
Shipping and handling
Purchasing, material handling, and inspection
Other overhead
Total production overhead $0 $0 $0 $0

In: Accounting

PLEASE READ AND ANSWER CASE #3 TATA'S TIME(STRATEGIC MANAGEMENT IN ACTION SIXTH EDITION) It holds the...

PLEASE READ AND ANSWER

CASE #3 TATA'S TIME(STRATEGIC MANAGEMENT IN ACTION SIXTH EDITION)

It holds the number 6 spot on the list of the world's most admired companies in the steel industry. The Tata Group, based in Mumbai, India, is the largest conglomerate in that country. Its lat­est revenues are estimated at $67.4 billion, of which 61 percent is from business outside India. Tata has more than 100 operating companies in seven main business groups doing business in 80 countries: chemicals, information systems and communications, consumer products, energy, engineering, materials, and services. Its two largest businesses are Tata Steel and Tata Motors. Its Tata Tea, which owns the valued Tetley brand, also is one of the larg­est tea producers in the world. Ratan Tata, Tata Group's chairper­ son, has forged a strategy that encompasses the globe. In 1999, he issued a "clarion call to push outside India with acquisitions and exports." One of the company's executive directors recalled, "We didn't know what to expect, to be honest."

Today, Tata controls many businesses ranging from Eight O'clock Coffee Co. in the United Sates to the Taj Group of hotels, which took over management of the landmark Pierre Hotel on Central Park in New York City. Tata made its boldest global strategic push, however, in October 2006 when Tata Steel formally proposed buying British steelmaker Corus Group PLC for about $8 billion USD. Corus, which was formed by a merger of British Steel and Hoogovens, was three times the size of Tata Steel. The buyout offer soon turned into a bidding war when Tata Group discovered another company, Companhia Siderùrgica, Nacional of Brazil (CSN), was also preparing a bid and therefore upped its opening offer to $9.2 billion; CSN then raised the stakes by offering to pay $9.6 billion. A Tata Group spokesman said that the company's attempt to acquire Corus was "based on a compelling strategic rationale." Ratan Tata explained further by saying, "The revised terms deliver substantial additional value to Corus shareholders." The increased takeover bid did not impress investors as the company's share price fell 6 percent after the news was announced. Analysts and investors both "expressed concern that Tata is overpricing Corus, whose operating costs are among the highest of any steel maker—something that would affect its profitability and its plans to expand in India." However, Ratan Tata knew that the acquisition could catapult Tata Steel from its mid-50s ranking in the global steel list to the sixth-largest industry competitor. He said, "Analysts were taking a short-term, harsh view of the deal. Hopefully, the market will look back and say it was the right move." By the end of JanuaQi 2007, the U.K. Takeover Panel called an auction in order to end the bidding war and "presided over the contest that started on Tuesday, January 30." The "contest" continued for several hours until CSN pulled out. Tata Steel won its coveted prize for $12.2 billion—a 22 percent premium over what it had originally offered. That acquisition represented the latest consolidation in the global steel industry. The combined Tata-Corus can produce 25 million tons of steel a year. The deal also represented the largest foreign acquisition by an Indian company and made the diversified Tata Group the largest company in India.

In 2008, Tata made an even bigger global splash, at least in terms of recognized consumer brand names. It acquired the Land Rover and Jaguar brands from Ford for an estimated $2.3 billion.

Tata's leaders believe the group "can survive on the world stage only by being both too big to beat and too good to fail." In December 2012, when Chairman Ratan Tata steps down, Cyrus Mistry will take over as chairman of Tata Group and he "faces the daunting challenge of steering a giant, increasingly multinational conglomerate of more than 100 companies through economic headwinds at home and abroad."

DISCUSSION QUESTIONS

1. Discuss the advantages and drawbacks of going international using Tata Group's experiences.

2. What strategic challenges do you think Cyrus Mistry might face as he guides his company? Using what you know about managing strategically, how might he respond to these challenges?

3. Do some research on India's economic and political-legal environments. What opportunities and threats do you see?​​​​​​​ In light of these, do you think Ratan Tata's strategy of push­ing outside India makes sense? Explain.

​​​​​​​THANK YOU!

In: Operations Management

Use the data and develop 95% and 99% prediction intervals for the following A. the hours...

Use the data and develop 95% and 99% prediction intervals for the following
A. the hours per week that an individual will spend in his vehicle
B. the number of miles driven per week
Vehicle Driven Type Satisfaction with vehicle Gender Age # of hours per week in vehicle Miles driven per week Number of Children Average number of riders Miles from work
Truck Domestic Yes Male 31 10 450 0 1 30
Truck Domestic Yes Male 29 5 370 1 1 22
Truck Foreign No Male 26 12 580 0 1 15
Truck Domestic No Male 18 6 300 0 1 20
SUV Domestic Yes Male 49 21 1000 0 1 22
SUV Foreign Yes Male 50 16 840 2 1 45
SUV Domestic Yes Male 48 15 1400 3 4 25
SUV Foreign Yes Male 45 5 300 2 2 20
SUV Domestic Yes Male 45 15 850 0 1 25
SUV Domestic Yes Male 44 10 700 2 1 40
SUV Foreign Yes Male 41 5 350 1 1 20
SUV Domestic Yes Male 41 30 1500 4 3 15
SUV Foreign No Female 39 6 280 1 1 17
SUV Foreign Yes Female 36 4 400 0 1 20
SUV Foreign Yes Female 33 3 420 0 1 25
SUV Domestic Yes Male 31 10 675 0 1 35
SUV Domestic No Female 31 15 800 1 1 50
SUV Domestic No Female 29 4 300 1 1 20
SUV Domestic Yes Male 28 3 400 1 1 15
Mini Van Domestic Yes Female 55 8 400 0 2 0
Mini Van Domestic No Female 43 10 700 2 3 0
Mini Van Domestic Yes Female 41 10 720 1 2 15
Mini Van Foreign Yes Female 38 10 450 4 5 0
Mini Van Foreign Yes Female 39 15 1000 1 2 0
Mini Van Domestic No Male 35 5 350 2 2 0
Mini Van Domestic Yes Female 33 10 800 2 3 0
Mini Van Foreign Yes Female 32 2 200 4 5 5
Mini Van Foreign Yes Female 28 8 350 3 4 0
Car Domestic Yes Female 21 4 150 0 1 0
Car Domestic No Female 62 5 175 0 2 0
Car Domestic Yes Female 61 5 355 0 1 15
Car Foreign Yes Male 60 5 150 0 1 10
Car Domestic No Male 58 10 600 0 1 35
Car Domestic Yes Female 51 11 600 0 1 40
Car Domestic Yes Female 47 4 300 0 1 21
Car Domestic No Male 46 4 275 0 1 18
Car Domestic No Male 44 6 285 2 3 16
Car Foreign No Female 42 5 400 2 3 22
Car Foreign Yes Female 41 5 350 2 2 23
Car Domestic No Female 41 10 600 1 2 34
Car Domestic Yes Female 39 10 700 1 2 45
Car Foreign Yes Female 34 10 600 1 2 16
Car Foreign Yes Male 33 5 400 1 2 22
Car Foreign Yes Male 30 5 350 1 2 18
Car Domestic Yes Female 29 5 250 0 1 19
Car Foreign Yes Female 27 6 355 0 2 23
Car Foreign Yes Female 26 5 175 0 1 11
Car Domestic No Female 24 5 300 0 1 4
Car Domestic Yes Female 22 5 350 0 1 3
Car Foreign No Female 19 5 500 0 2 4

In: Statistics and Probability

mpg cyl disp hp drat wt qsec vs am gear carb Mazda RX4 21 6 160...

mpg cyl disp hp drat wt qsec vs am gear carb
Mazda RX4 21 6 160 110 3.9 2.62 16.46 0 Manual 4 4
Mazda RX4 Wag 21 6 160 110 3.9 2.875 17.02 0 Manual 4 4
Datsun 710 22.8 4 108 93 3.85 2.32 18.61 1 Manual 4 1
Hornet 4 Drive 21.4 6 258 110 3.08 3.215 19.44 1 Automatic 3 1
Hornet Sportabout 18.7 8 360 175 3.15 3.44 17.02 0 Automatic 3 2
Valiant 18.1 6 225 105 2.76 3.46 20.22 1 Automatic 3 1
Duster 360 14.3 8 360 245 3.21 3.57 15.84 0 Automatic 3 4
Merc 240D 24.4 4 146.7 62 3.69 3.19 20 1 Automatic 4 2
Merc 230 22.8 4 140.8 95 3.92 3.15 22.9 1 Automatic 4 2
Merc 280 19.2 6 167.6 123 3.92 3.44 18.3 1 Automatic 4 4
Merc 280C 17.8 6 167.6 123 3.92 3.44 18.9 1 Automatic 4 4
Merc 450SE 16.4 8 275.8 180 3.07 4.07 17.4 0 Automatic 3 3
Merc 450SL 17.3 8 275.8 180 3.07 3.73 17.6 0 Automatic 3 3
Merc 450SLC 15.2 8 275.8 180 3.07 3.78 18 0 Automatic 3 3
Cadillac Fleetwood 10.4 8 472 205 2.93 5.25 17.98 0 Automatic 3 4
Lincoln Continental 10.4 8 460 215 3 5.424 17.82 0 Automatic 3 4
Chrysler Imperial 14.7 8 440 230 3.23 5.345 17.42 0 Automatic 3 4
Fiat 128 32.4 4 78.7 66 4.08 2.2 19.47 1 Manual 4 1
Honda Civic 30.4 4 75.7 52 4.93 1.615 18.52 1 Manual 4 2
Toyota Corolla 33.9 4 71.1 65 4.22 1.835 19.9 1 Manual 4 1
Toyota Corona 21.5 4 120.1 97 3.7 2.465 20.01 1 Automatic 3 1
Dodge Challenger 15.5 8 318 150 2.76 3.52 16.87 0 Automatic 3 2
AMC Javelin 15.2 8 304 150 3.15 3.435 17.3 0 Automatic 3 2
Camaro Z28 13.3 8 350 245 3.73 3.84 15.41 0 Automatic 3 4
Pontiac Firebird 19.2 8 400 175 3.08 3.845 17.05 0 Automatic 3 2
Fiat X1-9 27.3 4 79 66 4.08 1.935 18.9 1 Manual 4 1
Porsche 914-2 26 4 120.3 91 4.43 2.14 16.7 0 Manual 5 2
Lotus Europa 30.4 4 95.1 113 3.77 1.513 16.9 1 Manual 5 2
Ford Pantera L 15.8 8 351 264 4.22 3.17 14.5 0 Manual 5 4
Ferrari Dino 19.7 6 145 175 3.62 2.77 15.5 0 Manual 5 6
Maserati Bora 15 8 301 335 3.54 3.57 14.6 0 Manual 5 8
Volvo 142E 21.4 4 121 109 4.11 2.78 18.6 1 Manual 4 2

Using the Motor Trend Cars Data Set, you would like to determine if there is a relationship between MPG (miles per gallon) and specific variables included in the data set.

  1. Develop a correlation matrix using MPG (miles per gallon), HP (horsepower), WT (weight). Is the correlation between the variables MPG v HP significant? Perform the appropriate test and use a level of significance of 0.05
  2. Fit a multiple regression model using MPG (miles per gallon) as the dependent variable and HP (horsepower), and WT (weight) as the independent variables. State your regression model.
  3. Is the overall regression model significant? Conduct the appropriate hypothesis test for the significance of the overall regression model. Use a 0.05 level of significance.
  4. Are the individual independent variables significant? Conduct the hypothesis tests for the significance of each independent variable at the= 0.05 level of significance.
  5. What proportion of the variation in MPG is explained by the independent variables HP and WT?
  6. Graph the residuals from the regression you developed in part (a). Do the regression assumptions appear to be appropriate given the residual plots? Explain your answer.

In: Statistics and Probability