Systems
Part a) Collecting Data
To store all of my data I chose to use Excel because it made it easy for me to organize everything and
also makes it easier to analyze the data later on using graphs. This is the sheet I produced.
I also considered the cost of delivery and created a new table where it includes the delivery cost,
because that will be the most accurate data to use to find the cheapest prices.
Part b) Discuss the data you have collected
Collecting the data was definitely time consuming and finding suitable competitors was relatively hard.
However, I do feel like considering the accuracy of the data and how useful it is, the time and effort that
it took to collect it would have been worth it. This is because the data shows us almost 100 prices for
different items from different competitors. I also chose to collect data on the delivery costs because that
will play a role in the total price as well because some competitors had more expensive delivery than