Description of this paper

Loading

I need overall help with this project. From starting it to-(Answered)

Description

Instant Solution ? Click "Buy button" to Download the solution File


Question

I need overall help with this project. From starting it to writing the analysis. Attached is the instructions and data to be used.


Different automobile manufacturers within and (in our case here) between countries have different price

 

characteristics, and these may in turn be affected by different variables. A separate data sheet, compiled

 

from a listing in the Pittsburgh Post-Gazette, has used car prices and their respective age and mileage

 

data for cars from Germany, Japan, (South) Korea and the United States for sale here in Pittsburgh.

 

The purpose of this project is to a) ascertain if and to what degree used car prices (dependent variable)

 

is explained by the corresponding independent variables, and b) arrive at a more general notion of

 

comparative ?value? when considering used cars.

 

Procedures:

 

1) Run a total of seven regressions:

 

(a) Two simple linear regression models, one each for used car price & age, and used car price &

 

miles, using the entire data set; i.e., all countries combined.

 

(b) One 2-variable model. Again, for the entire data set, run a multiple regression using both age

 

and miles. (Price is always your dependent variable.)

 

(b) Four 2-variable models. For each country (Germany, Japan, Korea and The US), run the same

 

multiple regressions using age and miles to explain variation in price.

 


 

2) Prepare a summary table in the following format (numbers are illustrations only):

 

Variable Name

 


 

b

 


 

Sig. t

 


 

R2

 


 

R2 Adj.

 


 

F

 


 

Sig. F

 


 

Age

 


 

-1,234

 


 

.045

 


 

.39

 


 

.38

 


 

15.24

 


 

.045

 


 

Miles

 


 

- .56

 


 

.015

 


 

.48

 


 

.46

 


 

19.53

 


 

.015

 


 

Age

 

Miles

 


 

- 1,125

 

- .68

 


 

.034

 

.022

 


 

.51

 


 

.47

 


 

3.920

 


 

.059

 


 

Age (Germany)

 

Miles

 


 

- 2,349

 

- .15

 


 

.066

 

.028

 


 

.35

 


 

.30

 


 

16.27

 


 

.023

 


 

Age (Japan)

 

Miles

 


 

-324

 

- .26

 


 

.087

 

.197

 


 

.22

 


 

.14

 


 

24.01

 


 

.042

 


 

Age (Korea)

 

Miles

 


 

-1,867

 

-.08

 


 

.132

 

.424

 


 

.44

 


 

.39

 


 

31.36

 


 

.001

 


 

Age (US)

 

Miles

 


 

-5,532

 

-.43

 


 

.132

 

.424

 


 

.51

 


 

.48

 


 

31.36

 


 

.001

 


 

3)

 


 

Using your computer generated regression coefficients for each country, find the predicted

 

price for a used car in these two cases: 1) for a used car that is 3 years old with 20,000 miles;

 

and 2) for a used car that is 5 years old with 60,000 miles. Then, create a table that shows

 

these predicted prices, the dollar difference as a measure of predicted depreciation and the

 

percentage change in the depreciation interval period. Pct. Change = (newer model price ?

 

older model price) / older model price. For example (again, numbers are for illustration only):

 

Predicted Price

 


 

Predicted Price

 


 

Newer Model (3yr, 20K)

 

Germany

 


 

$22,000

 


 

Older Model (5yr, 60K)

 

$16,500

 


 

Difference

 


 

Pct. Change

 


 

$5,500

 


 

33.3

 


 

Japan (etc.)

 

4) On a separate page summarize the results of your analysis.

 

a) For the entire sample taken together, in one paragraph (10 or 12-point font) discuss which is the

 

?best? regression model for explaining variation in used car pricing. Why? Consider all your indicators

 

(slopes, significance of t values, R2, in particular R2 adj., etc.) as well as multicollinearity issues in the

 

multiple regression model. Do you have any issues with the results? Why or why not? You may also

 

want to run a correlation analysis on the independent variables to test for multicollinearity.

 

b) For the four country regressions, in one paragraph briefly summarize the practical significance of

 

the regression results. You don?t need to say that ?R 2 for Germany is ---, and R2 for Japan is ---?. Your

 

table shows these. Rather, knowing what the statistical relationships are, what is the overall ?story? that

 

the results convey, along with any concerns you may have?

 

c) Using your table of predicted depreciation, discuss in one paragraph the notion of ?value? in

 

comparing used cars from the four countries. Specifically, how do the dollar differences in older vs. newer

 

predicted prices and the percentage changes in these predicted prices reflect how a country may be

 

evaluated (or judged?) on the quality of its automobile industry. Finally, it?s always nice to have an

 

introduction and a conclusion.

 

As is the case in these types of projects, items 3 and 4 are weighted more heavily. Take the

 

time to create and articulate good arguments while following the assignment parameters.

 

Submission: The discussion page (one page maximum), followed by your completed tables on the next

 

page.

 

! Note: As I mentioned in class, please be advised that each of your written submissions must be unique.

 

In the past, more than a few written submissions have been, shall we say, similar. Indeed, some have

 

been virtually identical-- word-for-word copies of each other?s work, likely in noncompliance with the

 

School of Business Code of Ethics. This is not acceptable. Should I conclude that the submissions

 

received by two students are not sufficiently distinguishable, I will substantially and negatively adjust the

 

project scores for each student accordingly. This means that you must complete the project without

 

discussing or consulting with your classmates starting now and until after you submit your projects to me.

 

Finally, the act of submitting your project on the due date and time indicates you agree to abide by

 

whatever decision and actions I may take in this regard.

 


 

 

Paper#9209569 | Written in 27-Jul-2016

Price : $19
SiteLock