Question

Differentiate between structured and unstructured data giving one example.

The principal of a school wants to do the following analysis on the basis of food items procured and sold in the canteen:

1. Compare the purchase and sale prices of fruit juice and biscuits.
2. Compare sales of fruit juice, biscuits, and samosa.
3. Variation in the sale price of fruit juices of different companies for the same quantity (in ml).

Create an appropriate dataset for these items (fruit juice, biscuits, samosa) by listing their purchase price and sale price. Apply basic statistical techniques to make the comparisons.

Answer 1

Structured data: All data sets have the same number of attributes and they differ by value.

Unstructured data: All data sets may or may not contain different no. of attributes.

Sample data

Product	Company	Sales price per unit	The purchase price per unit	Units sold
Fruit juice	Real	50	43	5
Samosa	Chandan	20	15	6
Biscuits	Britannia	10	7	7
Fruit juice	Pepsi	40	35	5
Samosa	Kundan	25	10	6
Biscuits	Parle	5	3	7
Fruit juice	Coke	45	32	5
Samosa	Sugandh	20	8	6
Biscuits	Cadbury	25	15	7