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.
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.
