Computer Science
Differentiate between structured and unstructured data giving one example.
The principal of a school wants to do following analysis on the basis of food items procured and sold in the canteen:
- Compare the purchase and sale price of fruit juice and biscuits.
- Compare sales of fruit juice, biscuits and samosa.
- Variation in sale price of fruit juices of different companies for 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.
Relational Database
1 Like
Answer
Structured Data | Unstructured Data |
---|---|
Data which is organized and can be recorded in a well defined format is called structured data. | Data that is not organized and does not have a defined format is called unstructured data. |
An example of structured data is a spreadsheet containing columns for item names, purchase prices, and sale prices. | An example of unstructured data include web pages consisting of text as well as multimedia contents (image, graphics, audio/video). |
Sample Dataset for Fruit Juice, Biscuits and Samosa
Product | Company | Sales price per unit | Purchase price per unit | Units Sold |
---|---|---|---|---|
Fruit Juice (250 ml) | Real | 40 | 35 | 10 |
Fruit Juice (250 ml) | Tropicana | 45 | 30 | 15 |
Samosa | Samosa Party | 30 | 27 | 20 |
Samosa | Chaayos | 36 | 30 | 25 |
Samosa | Chai Point | 33 | 29 | 15 |
Biscuit | Parle | 10 | 6 | 30 |
Biscuit | Britannia | 15 | 12 | 20 |
Biscuit | Sunfeast | 20 | 17 | 15 |
For Fruit Juice:
Mean Purchase Price = (35 + 30) / 2 = 32.5
Mean Sale Price = (40 + 45) / 2 = 42.5
Difference = Mean Sale Price - Mean Purchase Price = 42.5 - 32.5 = 10
The mean purchase price of fruit juice is 10 rupees less than the mean sales price of fruit juice.
For Biscuits:
Mean Purchase Price = (6 + 12 + 17) / 3 = 11.67
Mean Sale Price = (10 + 15 + 20) / 3 = 15
Difference = Mean Sale Price - Mean Purchase Price = 15 - 11.67 = 3.33
The mean purchase price of biscuits is 3.33 rupees less than the mean sales price of biscuits.For Fruit Juice:
Total units sold = 10 (Real) + 15 (Tropicana) = 25 units
For Biscuits:
Total units sold = 30 (Parle) + 20 (Britannia) + 15 (Sunfeast) = 65 units
For Samosas:
Total units sold = 20 (Samosa Party) + 25 (Chaayos) + 15 (Chai Point) = 60 units
Comparing the total units sold:
Biscuits had the highest sales with 65 units sold.
Samosas had the second-highest sales with 60 units sold.
Fruit juice had the lowest sales with 25 units sold.Sale price of Real Fruit Juice (250 ml): 40
Sale price of Tropicana Fruit Juice (250 ml): 45
Difference = Sale price of Tropicana - Sale price of Real
Difference = 45 - 40 = 5
The sale price of Tropicana fruit juice is 5 rupees higher than the sale price of Real fruit juice for the same quantity (250 ml).
Answered By
1 Like
Related Questions
Consider the temperature (in Celsius) of 7 days of a week as 34, 34, 27, 28, 27, 34, 34. Identify the appropriate statistical technique to be used to calculate the following:
- Find the average temperature.
- Find the temperature Range of that week.
- Find the standard deviation temperature.
A school teacher wants to analyse results. Identify the appropriate statistical technique to be used along with its justification for the following cases:
Teacher wants to compare performance in terms of division secured by students in Class XII A and Class XII B where each class strength is same.
Teacher has conducted five unit tests for that class in months July to November and wants to compare the class performance in these five months.
Suppose annual day of your school is to be celebrated. The school has decided to felicitate those parents of the students studying in classes XI and XII, who are the alumni of the same school. In this context, answer the following questions:
Which statistical technique should be used to find out the number of students whose both parents are alumni of this school ?
How varied are the age of parents of the students of that school ?
For the annual day celebrations, the teacher is looking for an anchor in a class of 42 students. The teacher would make selection of an anchor on the basis of singing skill, writing skill, as well as monitoring skill.
Which mode of data collection should be used?
How would you represent the skill of students as data?