I have been asked to investigate factors that affect the depreciation :: Economics

I render been asked to ask factors that demand the depreciation of cars.I give up been asked to investigate factors that affect the depreciationof cars. To do this I would ide entirelyy like to receive my let entropy aboutused cars. This would be called primary data. I would commence collecteddata on the make, model, mileage, engine size, age, determine and pricewhen naked as a jaybird-made of several hundred used cars. Unfortunately this would have taken a lot of time, but the return would have been that it wouldhave been authoritative data which I could trust, and I could have foundout on the nose the teaching that I wanted.It would have been impossible for me to do such a rangy survey,however, so I had to use secondary data that I got from the CCEAwebsite. The advantage of this was that it was quick, cheap and easy,but I cant be sure of the true statement of these results and I dont knowif any bias was involved when it was being collected. I have alsofound that ma ny of the results ar incomplete.From the very start, I am sure that both of these results are wrong - aRenault laguna which cost 50,000, and a Renault Clio that increasesin value. I have deleted these results straight away. surmisal 1My prime(prenominal) hypothesis is that cars depreciate much as they encounter older. Iused the spreadsheet on the computer to test this hypothesis, but foremost I had to ask the age and office depreciation for each car, incomplete of which are recorded in the table.Firstly, to get the age of the cars, I subtracted the socio-economic class in whichthey were made from 2002, the year when the data was collected. Ifirst created a new column on the spreadsheet and called it age. ThenI typed into the first case below the title the formula for age-=2002-F2where F2 is the column for the year the car was made. This fill up the boxful with the age of the car. I then highlighted the box, right clickedand selected copy, before play up all the boxes be low andselecting paste special, formula. This make full in the ages for all ofthe cars.Next, to get the percentage depreciation, I made another column andfilled it with a more complicated formula-=(I2-H2)/I2*100where I2 is the price when new and H2 is the price now. This filledthe first box in the percentage depreciation column with the suppress value, and I copied the formula into the other boxes asbefore.I then highlighted these two columns and copied them into chart 2.I have been asked to investigate factors that affect the depreciation EconomicsI have been asked to investigate factors that affect the depreciation of cars.I have been asked to investigate factors that affect the depreciationof cars. To do this I would ideally like to collect my own data aboutused cars. This would be called primary data. I would have collecteddata on the make, model, mileage, engine size, age, price and pricewhen new of several hundred used cars. Unfortunately this would havetaken a lot of tim e, but the advantage would have been that it wouldhave been reliable data which I could trust, and I could have foundout exactly the information that I wanted.It would have been impossible for me to do such a large survey,however, so I had to use secondary data that I got from the CCEAwebsite. The advantage of this was that it was quick, cheap and easy,but I cant be sure of the accuracy of these results and I dont knowif any bias was involved when it was being collected. I have alsofound that many of the results are incomplete.From the very start, I am sure that two of these results are wrong - aRenault Laguna which costs 50,000, and a Renault Clio that increasesin value. I have deleted these results straight away.Hypothesis 1My first hypothesis is that cars depreciate more as they get older. Iused the spreadsheet on the computer to test this hypothesis, butfirst I had to get the age and percentage depreciation for each car,neither of which are recorded in the table.Firstly, to get the age of the cars, I subtracted the year in whichthey were made from 2002, the year when the data was collected. Ifirst created a new column on the spreadsheet and called it age. ThenI typed into the first box under the title the formula for age-=2002-F2where F2 is the column for the year the car was made. This filled thebox with the age of the car. I then highlighted the box, right clickedand selected copy, before highlighting all the boxes below andselecting paste special, formula. This filled in the ages for all ofthe cars.Next, to get the percentage depreciation, I made another column andfilled it with a more complicated formula-=(I2-H2)/I2*100where I2 is the price when new and H2 is the price now. This filledthe first box in the percentage depreciation column with theappropriate value, and I copied the formula into the other boxes asbefore.I then highlighted these two columns and copied them into chart 2.