Description of this paper

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

Description

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 &amp; age, and used car price &amp;

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

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

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 : \$22