What I wanted to achieve
The aim of this task was to compare a random selection of premium cars using data from carsales.com.au to see how price relates to engine power. I wanted to find out if more expensive cars usually have more horsepower and whether this could be used as a simple way to judge value for money.
How I went about it
To do this, I recorded the price and horsepower of each car and then compared these two values. I started by using price versus power as a basic value for money measure, even though I know this does not show the full picture of what makes a car valuable.
Initial reactions
When I first plotted the data, I noticed that as the price of the cars increased, the horsepower usually increased as well. This showed a clear relationship between price and power, where more expensive cars generally produced more power.
Next layer of analysis
After looking more closely, I realised that a straight line did not properly represent the data. A linear trend suggests that cheaper cars cannot have reasonable power, which is not true. I then used an exponential trend line, which better showed how horsepower increases more quickly at lower prices and more slowly at higher prices.
Worth mentioning
Some cars did not follow the main trend. Certain luxury cars were very expensive but did not have especially high horsepower. Other performance focused cars produced a lot of power for their price. This shows that not all premium cars are designed with the same priorities.
Conclusion
This comparison shows that while price and horsepower are related, horsepower alone is not enough to measure value. Different premium cars offer value in different ways. Even after looking at the data, personal preference still matters at the end of the day.