\$20 Bonus + 25% OFF

# Car Data Statistical Analysis

347 Downloads5 Pages / 1,093 Words Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

## Question:

Describe about the Report on Car Data Statistical Analysis?

Statistical data analysis plays an important role in decision making. Here, we analyse the data for different types of cars. We study the price of the cars and other related variables of the cars. We check whether there is any significant variable which effects on the price of the car. We also check whether there is any linear relationship exists between the mileage of the car and price of the car. We see some descriptive statistics for given variables. The data is collected for the 73 cars. The method of random sampling is used for data collection. All selected cars are of same make and model. The make of the car is Chevrolet and model of the cars is cavalier. We select the four characteristics or variables given as price, mileage, trim and type from given data set. Data is accessed from different online and offline sources. Data is collected from websites such as https://www.autotrader.co.uk/ and https://www.carsource.co.uk/. Data is given in the appendix section. After data collection, the next important step is data analysis or statistical analysis. In statistical data analysis, we use some statistical tools and statistical techniques.  For this statistical analysis purpose, we used the SPSS statistical software for outputs for descriptive statistics, graphs and different tests. We use some descriptive statistics for summarising the variables given in the data set. We also use some inferential statistics to check some claims about the car data. We have to check the relationship between the given variables. We have to see some graphical analysis for given variables. We have to see some inferential statistics or testing of hypothesis for checking our claims regarding the given car data.

After statistical analysis, we made some conclusions regarding the car data.  The scatter diagram for the variables price of the car and mileage of the car shows that there is negative association or linear relationship exists. The correlation coefficient between price and mileage is given as -0.84, this means, there is a high negative linear relationship or association or correlation exists between the price and mileage of the car. This means, as there is an increment in the price of the car, there is decrement in the mileage of the car or vice versa. About 70.6% of the variation in the price is explained by the mileage of the car. The average price of the car is given as 19431. The minimum price is noted as 8500 while maximum price is noted as 32950. The average mileage of the car is given as 44992 units. The minimum mileage is observed as 3558 units and maximum mileage observed as 154000 units. The value for coefficient of determination or R square is given as 0.706 which means, about 70.6% of the variation in the price is explained by the mileage of the car. The regression equation for this regression model is given as below:

Price = 24920.172 – 0.122*mileage

We use this regression model because the correlation between price and mileage is high however all other correlations are significant.

Some of the descriptive statistics for the price of the cars is summarise as below:

 Descriptive Statistics N Minimum Maximum Sum Mean Std. Deviation Price 73 8500.00 32950.00 1418463.00 19431.0000 5112.65422 Valid N (listwise) 73

The average price of the cars is given as 19431 approximately and the minimum price of the car is observed as 8500 approximately. The maximum price of the car is observed as 32950 approximately. Standard deviation is given as 5112.65 and the values for skewness and kurtosis are negative values so we can conclude that the data skewed at negative side or left side from the mean.

The descriptive statistics for the mileage of the cars is summarising as below:

 Descriptive Statistics N Minimum Maximum Sum Mean Std. Deviation Mileage 73 3558.00 154000.00 3284459.00 44992.5890 35203.72920 Valid N (listwise) 73

Five number summaries for the price of the car is given as below:

 Five-Number Summary Minimum 10546.78 First Quartile 12126.9 Median 12944.94 Third Quartile 13725.45 Maximum 15053.93

The five-number summary for the mileage of the car is given as below:

 Five-Number Summary Minimum 1160 First Quartile 15794 Median 20043 Third Quartile 25031 Maximum 39946

The residual analysis for the given regression model is summarising as below:

 Residuals Statisticsa Minimum Maximum Mean Std. Deviation N Predicted Value 6131.9106 24486.0898 19431.0000 4294.91472 73 Residual -7507.92676 8818.44629 .00000 2773.61510 73 Std. Predicted Value -3.096 1.177 .000 1.000 73 Std. Residual -2.688 3.157 .000 .993 73 a. Dependent Variable: Price

Residual mean is given as zero with the standard deviation of 2773, this suggests that the model is a balanced model.

For checking the claim whether the mileage for different engine size is same or not, we have to use the one way analysis of variance. The null and alternative hypothesis is given as: null hypothesis: The mileage for different engine size is same. Alternative hypothesis: The mileage for different engine size is not same. For checking this claim, we have to use the one way ANOVA test. The p-value for this ANOVA test is given as 0.482 which is greater than level of significance or alpha value 0.05, so we do not reject the null hypothesis.

The correlation coefficient between price and mileage found as -0.84, this means there is high negative correlation or association or linear relationship exists between the price and mileage. The correlation coefficient between price and engine size is given as 0.278 while the correlation coefficient between the price and gearbox size is given as 0.161. The correlation coefficient between the price and age or year is given as 0.736 which is high positive correlation. This means, for two variables mileage and age, the correlations found as high or strong. The correlation matrix is given in the appendix section.

Detailed data analysis with figures and complete data is given in the appendix section.

## Conclusions:

The correlation coefficient between price and mileage is given as -0.84, this means, there is a high negative linear relationship or association or correlation exists between the price and mileage of the car. This means, as there is an increment in the price of the car, there is decrement in the mileage of the car or vice versa.

The value for coefficient of determination or R square is given as 0.702 which means, about 70.2% of the variation in the price is explained by the mileage of the car.

The correlation coefficient between the price and age is given as 0.736, this mean, there is high correlation or association or linear relationship exists between two variables price and age.

Two most correlated variables are price and mileage of the car.

Average mileage for the cars with different engines is same.

### Cite This Work

"Car Data Statistical Analysis." My Assignment Help, 2016, https://myassignmenthelp.com/free-samples/car-data-statistical-analysis.

My Assignment Help (2016) Car Data Statistical Analysis [Online]. Available from: https://myassignmenthelp.com/free-samples/car-data-statistical-analysis
[Accessed 03 June 2020].

My Assignment Help. 'Car Data Statistical Analysis' (My Assignment Help, 2016) <https://myassignmenthelp.com/free-samples/car-data-statistical-analysis> accessed 03 June 2020.

My Assignment Help. Car Data Statistical Analysis [Internet]. My Assignment Help. 2016 [cited 03 June 2020]. Available from: https://myassignmenthelp.com/free-samples/car-data-statistical-analysis.

### Latest Statistics Samples

#### BUACC5931-Quantitative And Qualitative Job Insecurity And Well-being

• Course Code: BUACC5931
• University: Federation University
• Country: Australia

Answers: 1.In selection of appropriate sample size, a tradeoff exists owing to higher accuracy of a larger sample versus a lower cost of a lower sample. The relevant factors for determining the minimum sample size are the accuracy desired by researcher (captured as Margin of Error) along with population standard deviation (σ) which highlights the underlying heterogeneity in  population. The formula for minimum sample size is given b...

#### MGT 602 Business Decision Analytics

Answer: Introduction According to me, life is a series of decisions some good and others bad. For example, I make a conscious decision to consume coffee instead of tea or cocoa every morning for breakfast. Other decisions I have made recently or continuously make on a daily basis are listed as follows: I normally take a bus or taxi to get to school I complete all assigned school tasks by 5pm, I only watch movies after 8pm and ensure that...

#### COMM AS401: Introduction To Applied Research

Answer: Hypothesis Null Hypothesis: students who participate in extracurricular activities perform better in class. Alternative hypothesis: Students who do not participate in extracurricular activities perform better in studies. Variables Independent variable Participating in extracurricular activities is the independent variable. The action is not influenced by another activity thus independent. It is also known the explanatory variable....

#### 25705 Financial Modelling And Analysis

• Course Code: 25705
• University: University Of Technology Sydney
• Country: Australia

Answer: Introduction: The main objective for question 5 is to determine the first-order autocorrelation of   AOret and AOSD for the full sample of the dataset provided.  The main causes of autocorrelation are sluggishness in the business cycle, and the omitting variables form the model. To detect autocorrelation, simple regression is run using the data set. In this case, Return on All order will be used as the dependent variabl...

Read More Tags: Australia Ashfield Management University of New South Wales

#### HI6007 Group Assignment Education

Answer: Question (1a) Questionnaire method of survey could be used for 100 sample of students because the method is economical to obtain quantitative data for analysis and predictions. The questionnaire method of survey is preferred for this study in order to reach the sample of 100 students easily within a short period of time, obtain first and effective answers based on individuals. Question (1b) Simple random sampling. The research targe...

Next

### Save Time & improve Grade

Just share Requriment and get customize Solution.

Orders

Overall Rating

Experts

### Our Amazing Features

#### On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

#### Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

#### 24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

#### Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

#### Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

### Our Experts

5/5

265 Order Completed

97% Response Time

### Ken Campbell

#### Wellington, New Zealand

5/5

440 Order Completed

99% Response Time

### Jack Arens

#### London, United Kingdom

5/5

2279 Order Completed

97% Response Time

### Zachary Perez

#### Washington, United States

5/5

1758 Order Completed

99% Response Time

### FREE Tools

#### Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

#### Essay Typer

Get different kinds of essays typed in minutes with clicks.

#### Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

#### Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

## Refer Just 5 Friends to Earn More than \$2000

1

1

1

### Live Review

Our Mission Client Satisfaction

Receive good grades for the said subject even receive my work in the quickest possible time, although there were spelling mistakes, it was overall a good work.

#### User Id: 421441 - 03 Jun 2020

Australia

Work well done. I am very happy with the information received and the level of service is top class.

#### User Id: 385702 - 03 Jun 2020

Australia

Great work is done by experts. All the requirements are done whatever, I asked for> I again appreciate the whole team. I would rate 5 stars to them. thanks

#### User Id: 279240 - 03 Jun 2020

Australia

It was good, but could be better if the pictures weren't used for case studies. Also the plaigarism was low.

Australia