Statistical Analysis on Excel

Running head: STATISTICAL ANALYSIS ON EXCEL
Statistical Analysis on Excel
Name of the Student:
Name of the University:
Author Note:

1STATISTICAL ANALYSIS ON EXCEL
Table of Contents
Price of two and three year old cars...........................................................................................2
Construction of Frequency Histogram for the Price of Two and Three Year Old Cars........2
Calculation of Descriptive Statistics for the Price of Two and Three Year Old Cars...........3
Difference in price between dealer and seller............................................................................4
Boxplots for Prices of Private Seller and for Used Car Dealer Prices:..................................4
Descriptive Statistics for Private Sale Prices and for Used Car dealer Prices.......................5
Relationship for Price and Age and Between Price and Odometer Reading.............................6
Scatter Plot for Age and Price................................................................................................6
Scatter Plot for Odometer and Price.......................................................................................7
Correlation Coefficient for Age and Price.............................................................................8
Correlation Coefficient for Odometer and Price....................................................................9

2STATISTICAL ANALYSIS ON EXCEL
Price of two and three year old cars
Construction of Frequency Histogram for the Price of Two and Three Year Old Cars
> $13600 13600-14600 14600-15600 15600-16600 16600-17600 17600-18600 18600-19600
0
1
2
3
4
5
6
7
8
9
10
Distribution of Car prices
Prices
Frequency
Figure 1: Frequency Histogram of the Prices of Two and Three year Old Cars
The figure 1 shows the car price is slightly positively skewed.