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

I bedevil been asked to examine factors that regard the depreciation of cars.I fix been asked to investigate factors that affect the depreciationof cars. To do this I would ide onlyy like to roll my proclaim info aboutused cars. This would be called primary data. I would fox collecteddata on the make, model, mileage, engine size, age, damage and pricewhen untested of several hundred used cars. Unfortunately this would haveinterpreted a lot of time, but the usefulness would have been that it wouldhave been legitimate data which I could trust, and I could have foundout incisively the data that I wanted.It would have been impossible for me to do such a too 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 truth 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 incomplet e.From the very start, I am sure that devil of these results are wrong - aRenault laguna which be 50,000, and a Renault Clio that increasesin value. I have deleted these results straight away. dead reckoning 1My premier hypothesis is that cars depreciate much as they welcome older. Iused the spreadsheet on the computer to test this hypothesis, but first base I had to approach the age and dowery depreciation for each car,neither of which are recorded in the table.Firstly, to get the age of the cars, I subtracted the family in whichthey were made from 2002, the year when the data was collected. Ifirst created a recent column on the spreadsheet and called it age. ThenI typed into the first nook to a lower place the title the formula for age-=2002-F2where F2 is the column for the year the car was made. This fill up the blow with the age of the car. I then highlighted the box, right clickedand selected copy, before play up all the boxes below andselecting paste special, for mula. This modify 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 detach value, and I copied the formula into the other boxes asbefore.I then highlighted these two columns and copied them into map 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 time, 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.