Page 20 - CT_AI_Class-8
P. 20
After correction:
Student Gadget Screen Sleep Outdoor Academic Screen
Type Time Hours Activity Score Time Level
Student 1 Mobile 5 hrs 6 30 min 65 High
Student 2 Laptop 2 hrs 9 1 hr 80 Low
Student 3 Tablet 4 hrs 7 45 min 70 High
Student 4 Laptop 1.5 hrs 8 1.5 hr 85 Low
Student 5 Mobile 4 hrs 6 1 hr — High
Handling Missing Values
Academic Score for Student 5 is missing.
Available Academic Scores:
65, 80, 70, 85
Average = (65 + 80 + 70 + 85) ÷ 4Average = 300 ÷ 4Average = 75
Fill missing value:
Student 5 Academic Score = 75
After correction:
Student Gadget Screen Sleep Outdoor Academic Screen
Type Time Hours Activity Score Time Level
Student 1 Mobile 5 hrs 6 30 min 65 High
Student 2 Laptop 2 hrs 9 1 hr 80 Low
Student 3 Tablet 4 hrs 7 45 min 70 High
Student 4 Laptop 1.5 hrs 8 1.5 hr 85 Low
Student 5 Mobile 4 hrs 6 1 hr 75 High
2. Data formatting: Data formatting involves organising data in a structured and consistent
format so that it can be easily analysed.
This includes:
Converting text into numerical values (if required)
Standardising units (e.g., minutes to hours)
Arranging data neatly in rows and columns
Ensuring consistent data format
18 Artificial Intelligence (CT & AI)-VIII
