Jump to content
Welby

Questions on Queries

Recommended Posts

Welby    9

I am in the process of running queries on my interviews (n=30) and I am wanting to compare different groups within the total and what words are driving their thinking. When displaying words it appears the default is 1000.

I have attached below two columns from a result which shows the most common word occurring 202 times and the least common - only once. Somewhere down this list the usage becomes irrelevant. I'm trying to determine where this might be. 

What is a ball park figure for identifying how far down this list an item is still considered significant? For example, does one use 'count' or 'weighted percentage' as the criteria? And secondly, at what point does the word usage cease to be of significance? Is it less than 20 uses or 10? Or is a weighted percentage above 0.15 a cut-off point?

In quantitative data, although disputed because values are dependent on the number of items in the scale, Nunnally (1978) recommends a minimum level of .7. for Cronbach alpha.  Do we have a similar concept operating here?

Many thanks,

Welby

 

Count

Weighted Percentage

202

2.38%

184

2.17%

122

1.44%

121

1.43%

101

1.19%

98

1.15%

87

1.03%

70

0.82%

69

0.81%

69

0.81%

67

0.79%

67

0.79%

63

0.74%

61

0.72%

61

0.72%

61

0.72%

59

0.70%

59

0.70%

58

0.68%

57

0.67%

55

0.65%

50

0.59%

49

0.58%

48

0.57%

46

0.54%

46

0.54%

45

0.53%

45

0.53%

45

0.53%

44

0.52%

44

0.52%

43

0.51%

42

0.49%

41

0.48%

40

0.47%

40

0.47%

40

0.47%

39

0.46%

38

0.45%

37

0.44%

36

0.42%

35

0.41%

35

0.41%

34

0.40%

33

0.39%

33

0.39%

32

0.38%

32

0.38%

32

0.38%

32

0.38%

31

0.37%

30

0.35%

30

0.35%

30

0.35%

30

0.35%

30

0.35%

29

0.34%

29

0.34%

28

0.33%

27

0.32%

27

0.32%

26

0.31%

26

0.31%

26

0.31%

26

0.31%

25

0.29%

25

0.29%

25

0.29%

25

0.29%

25

0.29%

24

0.28%

24

0.28%

24

0.28%

24

0.28%

23

0.27%

23

0.27%

22

0.26%

22

0.26%

22

0.26%

21

0.25%

21

0.25%

21

0.25%

21

0.25%

20

0.24%

20

0.24%

20

0.24%

19

0.22%

19

0.22%

19

0.22%

19

0.22%

19

0.22%

19

0.22%

18

0.21%

18

0.21%

18

0.21%

18

0.21%

18

0.21%

18

0.21%

18

0.21%

18

0.21%

17

0.20%

17

0.20%

17

0.20%

17

0.20%

17

0.20%

17

0.20%

16

0.19%

16

0.19%

16

0.19%

16

0.19%

16

0.19%

16

0.19%

16

0.19%

16

0.19%

15

0.18%

15

0.18%

15

0.18%

15

0.18%

15

0.18%

15

0.18%

15

0.18%

15

0.18%

15

0.18%

15

0.18%

14

0.16%

14

0.16%

14

0.16%

14

0.16%

14

0.16%

14

0.16%

14

0.16%

14

0.16%

14

0.16%

14

0.16%

13

0.15%

13

0.15%

13

0.15%

13

0.15%

13

0.15%

13

0.15%

13

0.15%

13

0.15%

13

0.15%

13

0.15%

13

0.15%

12

0.14%

12

0.14%

12

0.14%

12

0.14%

12

0.14%

12

0.14%

12

0.14%

12

0.14%

12

0.14%

12

0.14%

12

0.14%

12

0.14%

12

0.14%

12

0.14%

12

0.14%

11

0.13%

11

0.13%

11

0.13%

11

0.13%

11

0.13%

11

0.13%

11

0.13%

11

0.13%

11

0.13%

11

0.13%

11

0.13%

11

0.13%

11

0.13%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

10

0.12%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

9

0.11%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

8

0.09%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

7

0.08%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

6

0.07%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

5

0.06%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

4

0.05%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

3

0.04%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

2

0.02%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

1

0.01%

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×