Business Analytics and Statistics Assignment

Added on - 15 Mar 2020

  • 16

    pages

  • 2410

    words

  • 22

    views

  • 0

    downloads

Showing pages 1 to 4 of 16 pages
Running Head: STATISTICSBusiness Analytics and StatisticsName of the studentName of the universityAuthor’s note
1STATISTICSAbstractThe following analysis presents the prices of used cars in Berlin. From the analysis it isseen that it is found that most of the cars have a price less than $25,000. Moreover most of thecars are between 16 and 55 years of age. Four different types of cars: Convertible, Hatchback,Sedan and Coupe were considered for the study. The power, kilometres travelled, fuel type, werealso used to estimate the price of a used car. The estimate was found to be a good fit for thestudy, although some of the variables were not statistically significant. The price of used carswas not normally distributed.
2STATISTICSTable of ContentsIntroduction......................................................................................................................................3Part a............................................................................................................................................3Part b............................................................................................................................................4Part c............................................................................................................................................5Part d............................................................................................................................................6Part e............................................................................................................................................7Part f.............................................................................................................................................7Part g............................................................................................................................................8Part h............................................................................................................................................8Part i.............................................................................................................................................9Part j...........................................................................................................................................11Part k..........................................................................................................................................11Part l...........................................................................................................................................11Part m.........................................................................................................................................11Part n..........................................................................................................................................12Part o..........................................................................................................................................14Part p..........................................................................................................................................14Conclusion.....................................................................................................................................15
3STATISTICSIntroductionThe present analysis is the evaluation of prices of used cars from Berlin. The prices of700 cars have been selected and analysed. The analysis of the cars considers the age of the cars,kilometres driven, the fuel used and car type. The analysis of prices of cars is done usingdifferent statistical techniques.Part aTable 1: Descriptive statistics for price, age, kilometres and Power of carspriceagekilometerPowerKWMean15151.5613.46121292.86136.80Standard Error675.950.291610.952.34Median955413150000124Mode2940014150000129Standard Deviation17883.947.5842621.6261.98Sample Variance319835297.6857.401816602237.893841.02Kurtosis61.614.420.024.77Skewness5.611.58-1.221.85Range26386554145000403Minimum7351500042Maximum26460055150000445Sum1060609294228490500095760Count700700700700From the above table it is found that the average price of a car is $15151.56 with astandard deviation of $17883.94. The median price of a used car is $9554. The mean price of acar is higher than the median price. Thus the prices of cars is skewed right.From the above table it is found that the average age of a car is 13.46 with a standarddeviation of 7.58. The median age of a used car is 13. The mean age of a car is higher than themedian age. Thus the age of cars is skewed right.From the above table it is found that the average distance travelled by a car is 121292.86km with a standard deviation of 42621.62 km. The median distance travelled of a used car is150000. The mean distance travelled of a car is lower than the median distance travelled. Thusthe distance travelled by used cars is skewed left.The average power of a car is 136.80kW with a standard deviation of 61.98kW. Themedian power of the used car is 124kW. The mean power of a car is higher than the medianpower. Thus the power of cars is skewed right.
desklib-logo
You’re reading a preview
card-image

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document