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

I relieve oneself been asked to check up on factors that affect the dispraise of cars.I progress to 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, charge and impairmentwhen new of several hundred used cars. Unfortunately this would havetaken a hatch of time, but the reward 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 argon incompl ete.From the very start, I am sure that dickens of these results are wrong - aRenault Laguna which costs 50,000, and a Renault Clio that increasesin value. I have deleted these results dependable away.Hypothesis 1My prime(prenominal) hypothesis is that cars depreciate more as they scramble 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 twelvemonth in whichthey were made from 2002, the year when the data was collected. Ifirst created a new editorial on the spreadsheet and called it age. ThenI typed into the first box under the statute 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 scatter specia l, 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.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 subtracte d 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.