Test which factors affect the price of a second hand car using a variety of different statistical techniques
GCSE MATHS STATISTICS COURSEWORK SPECIFY THE PROBLEM AND PLAN Introduction I am going to test which factors affect the price of a second hand car using a variety of different statistical techniques. From what I discover using these techniques I will conclude which factors are the most important. I will examine only cars within the reach of a normal family, i.e. not luxury cars. I will also exclude classic cars as these are unlikely to perform like normal second hand cars. Using a given set of data on the prices paid for second hand cars, I chose ten of these factors and did a survey of the class' parents to make initial assumptions of which factors they were most influenced by when buying a second hand car. The survey asked them to choose the 3 most important and 3 least important from a list of ten. Using the results of this data, shown on page ... , I selected three hypotheses to test. I will test these using a given data set. If I need to take more samples to test the hypotheses more conclusively, I will obtain data from other sources. The types of information in the column represent the factors which can easily be defined when buying a car, even though there may be other ones that affect a person buying a car, even if they cannot be measured. An example is their opinion of the person selling them the car, as this will affect them a lot even though it is not possible
What factors influence the price of a second hand car
What factors influence the price of a second hand car? There are many factors that will influence the buyer when purchasing a second hand car; age, model, make, colour, style, fuel, mot and condition to name a few. I think that the age, mileage and engine size of the car will influence the buyer more than any other factor. My reasons are: * Age: I think age will be a major factor because older cars are generally not as popular as their newer counter parts, and an older car will probably have more problems than a younger model. * Mileage: I think mileage will be a major factor because a high mileage means a car has been driven a lot making the engine less efficient and may mean the car will be high maintenance. * Engine size: I think the larger the engine size the higher the price of the second hand car because a big engine size means the car will go faster which is quite important to most people. To find out whether my hypotheses are correct I will need to collect some data. I have been provided with a data base of 100 cars. I will not use all 100 cars as this is too much data for me to work with. Instead I will take a sample of 40 cars as this will be an easier and fair amount to work with. To decide which cars to include in my sample I will first put the makes of the cars into a frequency table: Make Frequency Ford 6 Vauxhall 3 Rover 2 Fiat 0 Volkswagen 7
Car sales
Car Sales Data Handling Project Introduction This is a project on sampling fifty cars from a database of over two hundred cars. The sampling was done by random selection. I am investigating the comparative relationships that the age and mileage of a car have on the used price. I will compare the used price of 50 cars, which have been randomly selected, to their age/mileage. In order to do this investigation I am using an Excel Spreadsheet that contains data on cars of differing ages and mileage along with other details listed in the screen below- Hypotheses: The older the car, and the higher the mileage of the car, the lower the used price will be. Plan The data could also be analysed in many ways * I will obtain the information from a data base in the program excel named, 'Car Sales'. * I will investigate the relationship through graphs and charts- created in excel * The fixed variable that I have chosen is the used price of the cars. * I will investigate what factors affect it. * I will be investigating a range of variables to go with used price. These include . price new 2. price used 3. age 4. colour 5. engine 6. fuel 7. MPG 8. mileage 9. service 0. owners 1. length of MOT 2. road tax 3. insurance 4. doors 5. style 6. C looking 7. seats 8. gears 9. Air con. 20. air bags I will not be investigating every variable, but
Investigate what influences the price of a second hand car.
Introduction: The question that I was ask on this piece of coursework was to investigate what influences the price of a second hand car. What I will do in this investigation is use graphs and charts to find out what it is that affects the price of a second hand car. I got the information to do this from a data sheet that contains 100 cars and some information about them, from that 100 I had to pick 36 so to do this I used the random select button on my calculator then it showed me a number that was in decimals so to convert it into a whole number I times it by 100 and marked it off on my data sheet, I then repeated this process 36 times and put them into a table which is shown bellow. The reason I used the random select button was because if I would have chosen 36 cars my self then it wouldn't be fare because I could have picked the first 36 cars and the first 36 cars could have been the most expensive. I predict that red will be the Modal color of car and that ford will be the Modal make of car, I predict this because ford is a very cheap car and I think that most people will by ford cars because they are so cheap. I also predict that age, mileage and number of owners will affect the price of a second hand car. Below there is a table contain data about 36 cars the factors that I have listed below are those that I think are most important because this is the information
Ford Motor Company
BACKGROUND .1 Ford Motor Company Ford was the pioneer of the motor vehicle, just over 100 years ago. Today, Ford Motor Company is a family of automotive brands consisting of: Ford, Lincoln, Mercury, Mazda, Jaguar, Land Rover, Aston Martin, and Volvo, employing 350,321 (Yahoo Finance) workers in more than 200 countries. .2 Motor Industry The American oligopoly in the motor industry, consisting of Ford, General Motors and Chrysler, has suffered from poor financial results recently. As reported by www.guardian.co.uk (16/06/03), "the big three US car-makers are wrestling with the combined effects of over-capacity, growing competition from Europe and Japan, huge pension and health care costs, and a damaging increase in incentives to get customers into the showrooms". A real sign that the car industry is in the midst of major change came when www.reuters.com (25/01/04) reported that Toyota had overtaken Ford as the world's second-biggest automobile manufacturer. The Japanese firm's strategy of focusing on quality, efficient manufacturing and targeting new markets paid off with their market capitalisation, at $120bn, totalling more than the "big three" combined. The main value driver for the motor industry is platforms, or production lines. The Japanese and European firms invested heavily in multi-car platforms and can now base a number of cars on one platform, rather than
Gary’s used car sales
My task for this coursework is to statistically analyse the data given to me regarding Gary's used car sales. I shall begin with looking at the data. The following data was given to me. No. Price Price when New Age Make Mileage Engine Size £6,970 £11,600 3 Ford 24,000 .6 2 £3,350 £7,100 7 Peugeot 85,000 .1 3 £3,995 £13,800 6 Ford 52,000 2.0 4 £5,300 £16,300 6 Vauxhall 70,000 2.0 5 £6,500 £8,700 3 Fiat 24,000 .2 6 £1,500 £8,700 9 Vauxhall 82,000 .6 7 £995 £8,500 9 Ford 02,000 .8 8 £3,000 £10,400 7 Vauxhall 63,000 .7 9 £7,495 £9,770 Vauxhall 8,000 .4 0 £850 £7,540 0 Ford 24,000 .6 1 £5,595 £11,000 4 Ford 41,000 .6 2 £4,995 £9,880 3 Ford 34,000 .4 3 £5,595 £14,000 4 Ford 55,000 .6 4 £4,995 £11,500 4 Rover 40,000 .4 5 £2,600 £12,000 7 Rover 82,000 .6 6 £1,000 £6,200 0 Peugeot 19,000 .1 7 £750 £5,100 1 Peugeot 96,000 .0 8 £1,350 £9,140 8 Ford 08,000 .6 9 £2,950 £17,750 8 Ford 96,000 2.9 20 £3,250 £9,990 7 Vauxhall 86,000 .6 21 £5,650 £11,150 3 Vauxhall 34,000 .6 22 £4,600 £7,300 2 Rover 7,000 .1 23 £5,400 £7,300 Rover 1,000 .1 24 £4,800 £7,300 Rover 26,000 .1 25 £2,700 £13,000 5 Fiat 51,000 2.0 26 £11,000 £13,800 Peugeot 9,000 .8 27 £2,800
Gary's Car Sales.
Introduction This assignment was completed on a PC, written with MS Word and the graphs, charts and tables included where created using MS Excel and pasted into this document. Firstly the car data from the assignment was entered into Excel. This then allowed tables, charts & graphs to be created that could represent the various comparisons to be made. Car No. Price Age (Years) Make Cost When New Mileage Engine Size (Litres) £6,970.00 3 Ford £11,600.00 24000 .6 2 £3,350.00 7 Peugeot £7,100.00 85000 .1 3 £3,995.00 60 Ford £138,000.00 52000 2.0 4 £5,300.00 6 Vauxhall £16,300.00 70000 2.0 5 £6,500.00 3 Fiat £8,700.00 24000 .2 6 £1,500.00 9 Vauxhall £8,700.00 82000 .6 7 £995.00 9 Ford £8,500.00 02000 .8 8 £3,000.00 7 Vauxhall £10,400.00 63000 .7 9 £7,495.00 Vauxhall £9,770.00 8000 .4 0 £850.00 0 Ford £7,540.00 24000 .6 1 £5,595.00 4 Ford £11,000.00 41000 .6 2 £4,995.00 3 Ford £9,880.00 34000 .4 3 £5,595.00 4 Ford £14,000.00 55000 .6 4 £4,995.00 4 Rover £11,500.00 40000 .4 5 £2,600.00 7 Rover £12,000.00 82000 .6 6 £1,000.00 0 Peugeot £6,200.00 19000 .1 7 £750.00 1 Peugeot £5,100.00 96000 .0 8 £1,350.00 8 Ford £9,140.00 08000 .6 9 £2,950.00 8 Ford £17,750.00 96000 2.9 20 £3,250.00 7 Vauxhall
Used car prices.
Year 11 Math Coursework- Used car prices In this coursework I'm trying to find out the difference on the prices of a second hand car, a list of cars is given factors in different categories with the information of the cars' original and second hand prices, details such as the size, the history and other small information. These factors affect their original prices and their second hand prices; I must first separate these to find what main factor affects the price dramatically. This should first be done by cataloging them. There are a lot of different makes and ages of cars listed, I'm going to separate the list of makes first: Mercedes, Vauxhall, Nissan, Renault, Rover, Fiat, BMW, Daewoo, Toyota, Volkswagen, Seat, Hyundai, Citroen, Bentley, Lexus, Peugot, Honda, Landrover, Porche, Suzuki, Audi, Rolls Royce, Mitsubishi, Ford There are 24 different makes of cars listed, it would be hard to compare each make separately, as well as there are different models for each make, therefore, I should compare the cars that are in the same make first to find out what influence tare there to the second hand price. I'm using Mercedes as a stratified sample and concentrate on the cars' original and second hand price first. Make Model Price when new Price Age Mileage Mercedes A140 Classic 4425 0999 4000 Mercedes Elegance 26425 7500 2 22000 Mercedes AvantGarde 7915 1750
Used car prices
Introduction In this coursework, investigation will be held on the factors that affect the prices of cars. The data, which will be used, has been collected from the internet. I restricted my source to internet, because if I were to look through magazines & newspapers I would have to go through quite a hassle collecting data; where as in the internet I can search for cars with specific specifications done with minor effect. As new cars are in demand, in business terms, car manufacturers are making a lot of money. These new cars are brought and customers usually get tired of the car or some needs are not met from the car or because of financial reasons, they decide to sell the car. Now at this point, it is not possible to sell the car at the price bought. So therefore price needs to be decreased from the original price. In this case, all the factors that affect car prices will need to be taken in to account and a fair price is later judged accordingly. The factors that I shall investigate upon are age and mileage. For age, I have chosen to use 10 Renault Clio and 10 Vauxhall Corsa. These two will be used because, they are small cars of different makes and the fact that it is small, people (in general) tend to buy small cars. For mileage, I decided to use 10 Fiat Punto and 10 Volkswagen Golf. The above cars were chosen, as I believe that they are few of the demanding cars
Used Car Prices
Maths Coursework Used Car Prices There are many factors that will strongly affect the price of a used car, such as the: - make - age - engine size - condition of the car - mileage - type of fuel used - number of previous owners Plan I plan to investigate how mileage, engine size and age of the car will affect the second-hand selling price of a used car, as I believe that these are the most important factors that will have the greatest effect on the price. - Firstly, I will analyse the data we have been given in the appendix. - I will input this data on to a spreadsheet to aid my analysis. - Using the 'Auto Filter' function I will group cars under their make, enabling for a fair comparison to be made between the price and the factors that will affect price. - I will produce scatter graphs which will display the results in such a way that a trend can be spotted easily. - From these trends I will make a few simple hypotheses, stating what I would expect to find from examining a different set of data - To test these hypotheses I will use external resources such as car magazines, which contain a listing of used cars and their mileage, engine size and age, thus enabling me to obtain a wider range of the data I require. A sample size of approximately 50 cars would be sufficient for investigation. - I will use random sampling to obtain my data set to remove bias from