Fill This Form To Receive Instant Help
Homework answers / question archive / Case Study: What Determines the Re-sale Value of a Car? When car dealers lease a car, how do they decide what to charge? One answer, if you’ve got a lot of unpopular cars to move, is to charge whatever it takes to get the cars off the lot
Case Study: What Determines the Re-sale Value of a Car?
When car dealers lease a car, how do they decide what to charge? One answer, if you’ve got a lot of unpopular cars to move, is to charge whatever it takes to get the cars off the lot. Another answer considers the so-called residual value of a car at the end of the lease. The residual value of a leased car is the value of this car in the used-car market, or re-sale value.
Certified BMW would like you to help them estimate the re-sale value of a car, and they have provided you with a sample of 202 BMWs that have been sold by BMW dealers within a 50 mile radius of Philadelphia. They are limiting their attention to two particular models, the BMW 325 and 330 models.
What else determines the re-sale value? Certified BMW is providing you with the following variables:
This dataset is found on Moodle in the posted Excel file. To successfully fulfill your contract you need to provide them with detailed statistical analysis and communicate your results clearly in the form of written reports. For the latter, you need to be able to address potential clients who are not statisticians.
PLEASE READ THE INSTRUCTIONS CAREFULLY BEFORE YOU BEGIN.
Written reports are required for all parts of the case. Please use a typical memorandum format. Please start each memorandum with an appropriate introduction and end with a brief conclusion. I suggest you answer each question (including its sub-parts) in separate paragraphs with the appropriate Excel output as appendices. The memos need to be more detailed than a typical executive summary. Please use bullets sparingly!
You may use single spacing, but please provide ample margins for my comments, and use either 11 or 12 pt. font.
Please DO NOT mention the numbering I have used below in your memo. The numbering is only provided so that we can easily converse about a question you might have.
PART III: INFERENTIAL STATISTICS (2-3 page memorandum in Word)
For each of the following questions, please append your graphs/charts/results from Excel to your third memorandum. Please remember to provide context for this part of the case with an introduction and conclusion.
Based on the sample data, is there evidence at the 5% level of significance that the average price of all Model 330 cars is greater than $32,000? Please do not use the terminology of the “null hypothesis” in your memorandum. Explain your test in words for management.
b. Certified BMW thinks you can get a better estimate by adding additional independent variables to the equation. What criteria (not specific variables) would you suggest that they use to determine if a variable should be included? Propose at least one additional variable for this model that meets these criteria.
Already member? Sign In