User Account

All Pages

The boss believes more cylinders lead to lower mpg

Assignment Help Basic Statistics
Reference no: EM131548775

You are working as a data analyst for the XYZ car company. Your boss has given you an assignment looking at the fuel economy of cars and the profit a company makes on each car sold.

The boss has given you data on 30 different cars and wants you to analyze it. The first thing your boss would like to know is what affects a car's fuel economy (measured as the average number of miles per gallon or MPG). Your boss has been told the following things affect a car's fuel economy:

Number of cylinders- the boss believes more cylinders lead to lower MPG

Transmission- your boss believes manual transmissions have higher MPG than all other types of transmissions.

Weight- your boss believes heavier cars have lower MPG.

Powered axles- your boss believes front-wheel drive is superior to rear-wheel drive, rear-wheel drive is superior to four-wheel drive, and four-wheel drive is superior to all-wheel drive when it comes to MPG.

In addition the boss want to know if cars produced by XYZ company have better or worse fuel economy compared to cars made by other companies.

The boss also wants you to determine if fuel economy affects the cost of producing the car and the profit the company makes from the car. The boss says the following increase the cost of the car:

Number of cylinders- the boss believes more cylinders lead to a higher cost.

Transmission- your boss believes manual transmissions are the cheapest. Automatic transmissions are the second cheapest. An ATMC transmission is the third cheapest, and a DCT transmission is the most expensive.

Weight- your boss believes heavier cars cost more to produce.

Powered axles- your boss believes two-wheel drive cars cost less to produce.

Your boss also wants to know if having a higher MPG increase the cost of producing the car.

Finally, your boss wants to know if better fuel economy affects the profit they make on a car. The boss does not have any good information on what affects per-car-profit and is leaving it up to you to figure that out.

Assignment:

You must decide what analyses to run to answer the boss's questions. Remember the boss is not trained in statistical analysis so you will need to explain what you are doing and why chose to do it that way.

This is does not just mean method, but also how you recoded any variables or anything else you have done (assume the boss is an idiot and you must carefully explain your work). You must also report what you find.

The boss wants a report that is typed, double-spaced, with one inch margins, in 12 point Times New Roman font. The report can be no more than 5 typed pages. The boss also wants your analysis attached as tables (one analysis per page). These do not count against the page limit.

(Data provided as attachment)

Codebook:

Car number: identifier

Number of cylinders: number of cylinders the car has

Country: 1=American, 2=Japanese, 3= German, 4=Italian, 5=other

Milespergallon: the car's MPG

Weightinlbs: car's weight

Price: the car's price

Transmission: 1=manual, 2=automatic, 3=ATMC, 4=DCT

Cost: how much a car cost to make

Profit: the amount of profit per car

Poweredaxels: 1=frontwheel drive, 2=rearwheel drive, 3= four wheel drive, 4= all-wheel drive

XYZ car: 1=yes, 0=no

Attachment:- finaldata.rar

Reference no: EM131548775

Questions Cloud

Briefly discuss your analysis plan : In the first part of this section, briefly discuss your analysis plan. Make sure you identify the question that you are hoping to answer.
What is the current share price : If the required return on this stock is 13 percent, what is the current share price?
What financial informationwould you think would be relevant : What financial information (ratios or otherwise) would you think would be relevant or irrelevant from the viewpoint of possible investors in this company?
Capital budgeting in class problem : X Company is considering replacing an existing processor with a new processor that costs $200,000. Shipping and setup costs for the new processor
The boss believes more cylinders lead to lower mpg : Transmission- your boss believes manual transmissions have higher MPG than all other types of transmissions.
Summarize differences and suggest rationale for the findings : Compose your work using a word processor and save it, as a Plain Text. Summarize the differences and suggest a rationale for these findings.
Identify how decisions impact a business : Select a business decision within the organization. Identify the potential ethical implications associated with this decision.
Calculate the standard deviation and coefficient : Please download monthly stock prices for the last five years (should be 60 entries- one per month over 5 years) for Amazon and Ford Motor Company.
What is the incremental profit : a. What is the incremental profit? b. What is the project's expected rate of return for the next year.

Reviews

Write a Review

Basic Statistics Questions & Answers

  A researcher wanted to investigate whether there was a

a researcher wanted to investigate whether there was a difference in satisfaction ratings in an assisted living

  Explain differences in three categories using significance

The data (in milliamps) are shown below. Using the .05 level of significance, are there any differences in the three categories.

  Differentiable an equivalent condition

A function g(x) is convex if the chord connecting any two points on the function's graph lies above the graph. When g(x) is differentiable, an equivalent condition is that for every x, the tangent line at x lies entirely on or below the graph.

  Decision regarding the null hypothesis

What is your decision regarding the null hypothesis? (Click to select) Reject Cannot reject H0. There is (Click to select)

  Estimate mean age of cars driven by students at your college

Estimate the mean age of cars driven by students at your college. Use the range rule of thumb to make a rough estimate of the standard deviation of the ages of cars driven by students at your college.

  Determine the trend line and generate a forecast for cpi

Use the regression tool in Excel or the "bulit in" Excel functions to determine the trend line and generate a forecast for CPI in the year 2011.

  Chance of selecting a sample whose sample mean is larger

A power of 0.2203 can be interpreted to mean there is a 22.03% chance of selecting a sample whose sample mean is larger than 166.3 lb.

  Election-day polls are taken from voting precincts

Election-day polls are taken from voting precincts selected because they are believed to be representative of all voters.

  Determining one sample z test for proportion

The election is one week away. You think you have the election sewn up, but the seem appears to be unraveling. You run a poll, draw a random sample of 500 adults.

  Developing three regression models

Develop three regression models to predict the selling price based upon each of the other factors individually. Which of these is best?

  Calculate a logistic regression

Identify at least three variables for which you could calculate a logistic regression. Describe the variables and their scale of measurement.

  There is no proof the new policy is more effective

There is no proof the new policy is more effective, but we cannot finish the policy has no effect on smog. Interpretation of P-value for the given context.

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