Report 1
Introduction
In this
report I am going to explain my findings and data I got from the car insurance
spreadsheet which was about the different car models that sold in 2012 and
2013. The type of data in the spreadsheet is mostly figures which shows overall
profits from the make of the car and there is also data the market share of the
car and whether it has had an impact/ change on the market. The data is
presented is separated in two different tables one of which showing the month
for the sales and this is the one I am going to be using mostly. Hopefully if I
extract good information I will be able to make graphs and recommendations from
these graphs which the managers can use for further profit for the business.
Data
With all the
data I collected from the spreadsheet I had to make sure a couple of things
which was the information’s validity, accuracy, relevance and currency. Not
knowing these things could result into me getting the wrong information and redundant
data.
Validity – First
I had to verify the information for its validity and making sure it was the
correct for my purpose. I already knew the source where the data has come from
SMMT because there was a logo on the spreadsheet so to validate this I visited
there webpage which shown information about motor vehicles and how this
organisation provides data about this.
Accuracy – The
information seems to be accurate as there is no odd patterns or spikes in the
data, for example some of the registration numbers between both of the years
seem to be similar so the information must be accurate.
Relevance – All
the data in spreadsheet was relevant to what I needed for because I was asked
to analyse data for the business linked with Motor vehicles and the spreadsheet
shown different car models along with the number of registrations and market
shares, this is just what I needed to get important information from th
Currency- The
information has not been updated because it is from the past, the data shows
information from 2013 and 2012 which I can still analyse and get important
facts but it is not the latest information to something like this current year
2015. Also even though it has 4 months’ worth of information it doesn’t show
every month which means it was not regularly updated.
Investigation
Through the
investigation process I decided to work out different values from the data to
give the company an estimate of figures such as what car was the most popular
sale for both years, which was the worst selling car for both years and the
total sales for both years. I think all of this is important information that
the business can use.

From this
first spreadsheet I decided first see which is the bestselling car for this
company so I complied this chart which
is showing the best Selling Cars for 2012 and 2013 and further indicating at
how much registrations the top cars get. As you can see each bar represents
both of the years 2012 and 2013 and from this chart it looks like 2013 was the
better year as there more registrations of the highest selling Car. This leads onto
the highest selling car which I found out to be Ford for both years and all the
months this data was recorded at.

This is the
second chart I complied but this time showing the worst selling cars for 2012
and 2013. As you can see on the side the legend shows both years however there
are not many bars this is because these cars got 0 registrations however in
April of 2013 you can see that the Saab got 2 registrations. 2013 was not the
same year as 2012 because there were different cars for example the Saab that
was very common for not selling in 2013 didn’t even appear once in 2012.

This is the
final chart I created from the data I was given and I decided to do a more
broad overview seeing the total number of car sales for both years 2012 and
2013. From this graph you can see that overall there were more sales in 2013
than 2012 and this is for every month not just 1 but the different was not that
big like there was not big jumps between the bars. Obviously if there were more
registrations (Sales) it was probably because the population was rising slowly
this means more people will need to buy a car.
Recommendations/Conclusion
Based on the
three charts/ graphs I managed to create from the data I have some
recommendations that might be useful for the business.
From the
first chart which is the best selling cars for both years I would advise for
the business to stock and order more of these as more people seem to be buying
and registering more of the vehicles on the road. From the data I pointed out
that Ford was the bestselling vehicle so anything within that range will sell
well. Even though I only have data from the past from what I can predict is
that this will continue to grow and increase the number of Ford sales thus
leading to more profit for the business.
Another
recommendation I would make from the second chart which shows the worst
selling/ registering cars for both years is for the business not to stock these
cars which are Saab, Dacia and Proton. It probably costs the business a lot of
money for them to import and stock those cars so it they didn’t order them in
the first place they would avoid this hassle and maybe not waste as much money.
In conclusion
the amount of car sales and registrations are going up as you can see by the
chart, even though the difference is very minor as long as the business
continues to carry on stocking the top few cars and not stocking the very few
selling cars they can make a lot of money. However one thing to note is the
business will have to carry on monitoring data like this because one year might
not be the same as the others and things can change very quickly like the
bestselling car, you have witnessed this with the worst selling car.
didnt even fkn help ffs useless cunt
ReplyDeleteikr
Deletesend this to me pls
ReplyDelete