Presentation on Dataset Analysis and Chart Creation for Desklib

PART-B

TABLE OF CONTENT
 Dataset
 Solving of Dataset
 Presentation of chart
 References

DATASET A
Date
No of Businesses Tax 21%
Business Income (£) Rank High/Low Income Tax Net Income
Mobile Phone Repair Shop 750070 1
Stationery Shop 1360600 1
Confectionery Retailer 580000 2
Watch Retailer 150650 4
Shoes Repair Shop 480000 2
Computer Repair Shop 230000 3
Total Net Income Total Net Income of rank 2
Average Net Income
Average Net Income of Rank
1
Highest Net Income Count of Net Income >£500k
Lowest Net Income Count of Net Income <£500k

Solution of Dataset
A B C D E F
Date 3/7/2022
No of Businesses 6Tax 21%
Business Income (£) Rank High/Low Income Tax Net Income
Mobile Phone Repair Shop 750070 1High 157515 592555
Stationery Shop 1360600 1High 285726 1074874
Confectionery Retailer 580000 2High 121800 458200
Watch Retailer 150650 4Low 31636.5 119014
Shoes Repair Shop 480000 2High 100800 379200
Computer Repair Shop 230000 3High 48300 181700
Total Net Income 2805543 Total Net Income of rank 2 837400
Average Net Income 467590.5 Average Net Income of
Rank 1 833715
Highest Net Income 1074874 Count of Net Income
>£500k 2
Lowest Net Income 119013.5 Count of Net Income
<£500k 4