Stratification in IDEA ppt for itt training arranged by icai rajkot

About it project on idea

1. STRATIFICATION IN IDEA Prepared by :- Prince Bhanderi Registration no. :- WRO0797024 Submitted to :- ICAI Bhawan - Rajkot Prepared by :- Prince Bhanderi 1

2. What is stratification ? Stratification is process by which you can find how many records are belongs to particular stratum and total of particular stratum through total of field. Prepared by :- Prince Bhanderi 2

3. Objective The main objective of stratification is to stratifying the data from the file into bands and gaining the profit of the data through CASEWARE IDEA. Prepared by :- Prince Bhanderi 3

4. What is band ? Each value band represents a range of data and provides a means of categorizing the data in certain ways such as numeric, character and data. Prepared by :- Prince Bhanderi 4

5. Numeric Data Characters Prepared by :- Prince Bhanderi 5 Stratification based on

6. Step by step procedure for performing Numeric stratification Prepared by :- Prince Bhanderi 6

7. Before starting stratification ensure that any active data base is selected . Prepared by :- Prince Bhanderi 7 Note :-

8. Step :- 1 To perform a stratification, go to analysis tab and click the stratification from categorize group. Prepared by :- Prince Bhanderi 8

9. Prepared by :- Prince Bhanderi 9

10. Step :- 2 The Field to stratify box asked Which field is stratified,or broken up Into bands. You have to select field which you want to stratified. Prepared by :- Prince Bhanderi 10

11. Prepared by :- Prince Bhanderi 11

12. Step :- 3 Next box is Field to total on , In this field you have to which field you want to total of given stratum. You can also select more than one field if required. Prepared by :- Prince Bhanderi 12

13. Prepared by :- Prince Bhanderi 13

14. Step :- 4 Next box is group by which represent that select field in which you want to divide into groups. Prepared by :- Prince Bhanderi 14

15. Prepared by :- Prince Bhanderi 15

16. Step :- 5 The next part is you must indicate what stratification interval is being used. The default value is 10000 but you can change accordingly requirement. Prepared by :- Prince Bhanderi 16

17. Prepared by :- Prince Bhanderi 17

18. Step :- 6 Click in the <upper limit column to write in the value of the strata. Note the text box is filled with the value 2000. Prepared by :- Prince Bhanderi 18

19. Prepared by :- Prince Bhanderi 19

20. Step :- 7 Click the second row of the spread sheet area. This automatically fills with 2000 to 4000. Prepared by :- Prince Bhanderi 20

21. Prepared by :- Prince Bhanderi 21

22. Step :- 8 Click in the third raw and drag it to the required raw . You must noted that the values are automatically taken. If you want to change increment you can change it . Prepared by :- Prince Bhanderi 22

23. Prepared by :- Prince Bhanderi 23

24. Step :- 9 Ensure that create result check box is being selected and in the result name box , you can enter numeric stratification. Prepared by :- Prince Bhanderi 24

25. Prepared by :- Prince Bhanderi 25

26. Step :- 10 After completion of all steps of stratification click on OK button for result. Prepared by :- Prince Bhanderi 26

27. Prepared by :- Prince Bhanderi 27

28. The numeric stratification result provides number of records are in given stratum and their percentage with total of selected field. You can check result from Result area of the properties window. Prepared by :- Prince Bhanderi 28 Result

29. Prepared by :- Prince Bhanderi 29

30. Prepared by :- Prince Bhanderi 30