Yes
No
4) How much money do you usually spend?
£0 - £40
£40.01 - £80
£80.01 - £120
£120.01 - £160
£160.01 - £200
£200 >
5) How long does your journey take?
0 – 20 minutes
21 – 40 minutes
41 – 60 minutes
60 minutes >
Mean = Total (Mid Point x Frequency)
Total Frequency
= 3120
40 = £78 is the average amount of money spent.
The above bar chart shows the discrete data using the question “Where do you prefer to do your food shopping?”
The bar chart shows that most people I have asked in my questionnaire / survey prefer to do their food shopping at Asda.
I am now going to draw a cumulative frequency table. Using the results from the following table, I will be able to produce a cumulative frequency graph, which will enable me to see how much money people spend on average on shopping.
The cumulative frequency graph shows me that the interquartile range is small. This shows me that the majority of people spend similar amounts of money.
The cumulative frequency graph also shows me that the median is £120.01. In addition the mean is £78.
I am now going to draw a scatter diagram, comparing the two following questions;
How long does your journey take?
How much money do you spend?
I shall collect all the continuous data from each of those questions, then imput them into a table. From my table I shall plot a scatter diagram.
My scatter diagram shows me that the further away the person lives from the supermarket, the more money they are likely to spend. I predict this is because they will not visit the supermarket often, so when they do they shall get a lot of shopping. This graph has a positive correlation.
Asda Morrison’s
Soup – £ 0.37 Soup – £ 0.35
Garden peas – £ 0.98 Garden peas – £ 0.68
Pure orange juice – £ 0.34 Pure orange juice – £ 0.46
Fries – £ 0.98 Fries – £ 0.86
12 Cobs – £ 0.94 12 cobs – £ 0.92
Chicken – £ 4.99 Chicken – £ 4.99
Milk – £ 0.96 Milk – £ 0.96
Tomato Ketchup – £ 1.19 Tomato Ketchup - £ 1.17
A Dozen eggs - £ 0.68 A Dozen eggs – £ 0.74
Asda Total = £11.43
Morrison’s Total = £11.13
This shows me that to buy these products it would be cheaper to go to Morrisons supermarket, as the Asda total amount of those products is £11.43 and the Morrisons total amount of these products is £11.13. Between Asda and Morrisons there is a £0.30p difference in the overall prices.
These prices are probably why a lot of people chose to shop at Morrisons.
Although Morrisons is cheaper on prices, it may not be as good quality.
The public in which I have asked have chosen Asda to be there overall favourite supermarket. This may be because it has good quality, prices are fairly cheap, or it is the local supermarket.
The further away the supermarket is, the more money most people are more likely to spend. This may be because they do there big shops there as they probably not visit that supermarket as often.
Personally I have enjoyed doing this coursework. I enjoyed learning more about cumulative frequency diagrams and using discrete questions to find discrete data on to which I am able to use this data to form my graphs.
