Description
In this project, you will be employing all the theories/concepts from this course work. This is NOT a group project, so you will not use any help from outside including internet, current or old friends, and professors from this university or others. You are allowed to get limited help from SVSU tutors. You can always contact me if you have any questions regarding this project. Please follow the instructions for this project and select the appropriate techniques that you have learned in this class in order to answer the following questions. Points will be deducted if the submission does not follow the following format:
Use only clean sheets of good quality 8 1/2" x 11" white paper. Text should be typed on one side only. Do not put any perfume or cologne on the sheets, neither try to decorate the sheets of paper; remember, it's an academic piece of writing. A title page is essential. Pages should be consecutively numbered, with numbers put in the upper right hand corner, flush with the right margin and 1/2" from the top with 12 font size and 1.5 spacing.
Total points = 100 points
The data in Used Cars represent characteristics of cars that are currently part of an inventory of a used car dealership. The variables included are car, year, age, price ($), mileage, power(hp), fuel (mph), Region of origin (manufactured in USA or in a foreign country), and single ownership (Yes= owned by one or No= owned by more than one owner). The excel file for this problem is stored in Canvas under module called “Used Cars”.
You want to describe each of these variables, and you would like to predict the price of the used cars. Make sure to take appropriate steps to analyze this data set and write a mini report for the Car Dealer. Also, do you think that the model is missing some important variables? If so, what are those missing variables? Please explain. (100 points)
[Hints: Following computations will be helpful to write this report. Write hypotheses, Summary Statistics, Correlation, Figures or Charts, regression models, checking assumptions, testing for autocorrelation, and the like
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Running head: USED CARS ANALYSIS REPORT
Used Cars Analysis Report
Name
Institution
1
USED CARS ANALYSIS REPORT
2
Problem statement
The car dealer wishes to have a significant understanding about how the relationship between
the price of the used cars and other variables that are considered in this case. The analysis in this
case, therefore, will provide a better environment where it would be easy to predict the future
prices of the used cars when focusing on the key factors, which include the year of manufacture,
age, price, mileage, power, fuel, a region of origin and single ownership.
a.
Description of variables
The descriptive statistics, in this case, provide a clear understanding of each variable that is
considered in the study to create a better environment where it is easy to understand the important
underlying key aspects.
Descriptive Statistics
N
Minimum Maximum Mean Std.
Deviation
Age
500
1
Valid N
(listwise)
500
16
8.36
4.791
The descriptive statistics shows that the ...