Turn on thread page Beta
    • Thread Starter
    Offline

    3
    ReputationRep:
    I have some government statistics I would like to lay out on a scatter graph to show a correlation between welfare spending and shoplifting over time (2006-2016). However, I'm hopeless at maths and advanced graphs, so I don't know how to exactly plot this data. I'm not too sure if I should add the years, it seems incorrect without them. The X and Y-axis represent the shoplifting and welfare statistics.
    Offline

    13
    ReputationRep:
    (Original post by IrnBruMan)
    I have some government statistics I would like to lay out on a scatter graph to show a correlation between welfare spending and shoplifting over time (2006-2016). However, I'm hopeless at maths and advanced graphs, so I don't know how to exactly plot this data. I'm not too sure if I should add the years, it seems incorrect without them. The X and Y-axis represent the shoplifting and welfare statistics.
    Could you clarify the data you have? What are these 'welfare statistics' and how are you measuring 'shoplifting'?

    It would be helpful if you could provide a data table - can be with made-up data under the same headings if you don't want to share the data
    • Thread Starter
    Offline

    3
    ReputationRep:
    (Original post by kingaaran)
    Could you clarify the data you have? What are these 'welfare statistics' and how are you measuring 'shoplifting'?

    It would be helpful if you could provide a data table - can be with made-up data under the same headings if you don't want to share the data
    I'm measuring welfare spent in each year from 2006 to 2015 (I lack data for 2016) in terms of how much percent of the overall government expenditure of that year it consisted of (i.e £2 billion in 2006 of an overall expenditure of, say £100 billion, so 2% of overall expenditure). I can't show it in actual values because then the data would be incorrect as the overall expenditure has increased over the years.

    In terms of shoplifting, I'm measuring it by how many recorded cases there were in each year.

    From looking at the data, each year, apart from in 2013, when welfare decreased, shoplifting increased. And when welfare increased or remained the same, shoplifting decreased. That's a negative correlation is it not but the graph I made is showing a positive one. I think it might have to do with the values.

    Here's the data, it's all available to the public anyway so I don't mind sharing it:

    2006: shoplifting - 28,247, welfare - 7.4% of total expenditure that year.
    2007: shoplifting - 28,750, welfare - 7.3%.
    2008: shoplifting - 29,186, welfare - 7%.
    2009: shoplifting - 32,048, welfare - 6.7%.
    2010: shoplifting - 30,332, welfare - 6.7%.
    2011: shoplifting - 29,660, welfare - 6.7%.
    2012: shoplifting - 29,758, welfare - 6.3%.
    2013: shoplifting - 26,449, welfare - 6.3% (actually decreased but small enough for there to be no percentage change).
    2014: shoplifting - 27,693, welfare - 6.1%.
    2015: shoplifting - 27,364, welfare - 6.2%.
    2016: shoplifting - 28,424, welfare - no data, though doesn't matter.
    Offline

    13
    ReputationRep:
    (Original post by IrnBruMan)
    I'm measuring welfare spent in each year from 2006 to 2015 (I lack data for 2016) in terms of how much percent of the overall government expenditure of that year it consisted of (i.e £2 billion in 2006 of an overall expenditure of, say £100 billion, so 2% of overall expenditure). I can't show it in actual values because then the data would be incorrect as the overall expenditure has increased over the years.

    In terms of shoplifting, I'm measuring it by how many recorded cases there were in each year.

    From looking at the data, each year, apart from in 2013, when welfare decreased, shoplifting increased. And when welfare increased or remained the same, shoplifting decreased. That's a negative correlation is it not but the graph I made is showing a positive one. I think it might have to do with the values.

    Here's the data, it's all available to the public anyway so I don't mind sharing it:

    2006: shoplifting - 28,247, welfare - 7.4% of total expenditure that year.
    2007: shoplifting - 28,750, welfare - 7.3%.
    2008: shoplifting - 29,186, welfare - 7%.
    2009: shoplifting - 32,048, welfare - 6.7%.
    2010: shoplifting - 30,332, welfare - 6.7%.
    2011: shoplifting - 29,660, welfare - 6.7%.
    2012: shoplifting - 29,758, welfare - 6.3%.
    2013: shoplifting - 26,449, welfare - 6.3% (actually decreased but small enough for there to be no percentage change).
    2014: shoplifting - 27,693, welfare - 6.1%.
    2015: shoplifting - 27,364, welfare - 6.2%.
    2016: shoplifting - 28,424, welfare - no data, though doesn't matter.
    I think you could plot the years on your horizontal axis and have two vertical axis (on the same graph), one with the number of cases and one with the percentage of expenditure (use a different scale for each). That can help bring out the comparison a bit more and allows you to cover everything that you want?
    • Thread Starter
    Offline

    3
    ReputationRep:
    (Original post by kingaaran)
    I think you could plot the years on your horizontal axis and have two vertical axis (on the same graph), one with the number of cases and one with the percentage of expenditure (use a different scale for each). That can help bring out the comparison a bit more and allows you to cover everything that you want?
    Thank you.
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: January 23, 2017
Poll
Do you think parents should charge rent?
Useful resources

Make your revision easier

Maths

Maths Forum posting guidelines

Not sure where to post? Read the updated guidelines here

Equations

How to use LaTex

Writing equations the easy way

Student revising

Study habits of A* students

Top tips from students who have already aced their exams

Study Planner

Create your own Study Planner

Never miss a deadline again

Polling station sign

Thinking about a maths degree?

Chat with other maths applicants

Can you help? Study help unanswered threads

Groups associated with this forum:

View associated groups

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.