Jump to content

Questions on Queries


Recommended Posts

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%

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...