I need this done soon as possible. I can do this in about an hour only I couldnt do it with the negative # so please make it quick. Say 4 hours? so i dont worry?

Please you must know what to do here before accepting to do this problem. Im just having problem with doing the histogram with these negative numbers in tow.

It would be good if you use Excel 2010. If you dont have excel 2010 or QIMacro can you do the graphs anyway but tell me how you did it and send your workings as well  so I can replicate it using excel 2010 or QIMacro.
The aim of this research is to see whether there is any association between the perceived importance of owning a computer and the perceived importance of global warming among young New Zealanders. It will find out how boys view owning a computer and global warming and how girls view owning a computer and the issue of global warming.
Instructions

a)Split the score for owning a computer into 2 columns – boys and girls.

b)Graph separately on histograms. Then compare the scores using:

1.

side by side boxplots

2.      descriptive stats

3.      outliers

4.      normal quantile plots (as in section E of assignment 2)

Complete the comparison with a:

*     two sample t-test

*    confidence interval for the difference between the two means.

if you can provide description of the result of the graphs or explain what the graph mean. Provide your workings please

Use importwarm and importcomputer and gender to make the graphs

2

>Important – global warming v

0

0

1

2

0

1

00

100

74

1

3

0

7

96

9

73

100

0

8

-1

-3

-1

0

6
-4

67

0

-1

4

100

5

0

10
2

6

40

-1
100
100

5

100
-4
100

-1

0

33

-100

24
100

33

0
28

-3

77

-97

-100

21

100

-58

43
40
34

-100

70

-1
0

89
100
48
100

97

0
0
-24

97

65
19
8

65
97

100
68
17

41
60
-28
4
100

3

29
19

-8

26
96

-9

-100
1

100
-1
62
-52
100

0

9

0
100

100
0
64
-1

-100
6

70
-33
-8

85

-75

45
29

-10

28
-2

0

100

-1
-73

11

100
-9

100

73
100

88

14
33
100
98

-24
-1
0
71
-43

-44

-1
38
64
-100
32
-5
-9
-26
-1
100

50

-4
100

23
16

64
100
4
-100
9
-2
0
32

13

-100
65

61

38
26

0
52
64

59

-14
1
100
45

 – 4 8 1 0 -2 – 20 – 6 3 33 – 23 28 10 4 7 – 74 100 – 73 – 21 – 2 9 -1 – 19 -6 89 -8 96 60 43 44 67 – 69 – 13 97 -10 – 88 48 -19 -7 -9 5 -4 -3 -43 64 58 – 77 40 62 53 -33 30 27 -5 34 -97 37 – 81 29 42 24 56 75 – 59 98 68 26 -24 -100 -58 – 95 -30 54 38 12 -40 – 86 – 70 72 41 14 -27 22 -44 52 -52 -75 -28 -88 – 85 – 65 -56 45 17 – 80 -23 39 79 – 50 -14 -98 -17 -73 32 – 11 – 25 -21 -50 -70 – 90 -32 82 -77 71 – 99 -59 – 51 -80 -26 – 61 63 – 47 -39 – 16 -45 46 -74 -71 -63 -95 31
importcomp

uter importwarm

importcomputer
Important – global warming vs. important – owing a computer
58
98
95

91 -42

73
85

-22

-5
100
27
96
44
-7
79
100
5
58
70
-73
56
38
-17
100
73
100
98
98
100
9
47
100
85
100
56
98
100
100

-20

-1

-99

1
100
71
100
100
30
70
48
-75

-90

100
100
30
5
100
69

-82

-1
-3

83

-99
100
-30
60
-30
100
100
-73

84

100

-89

100
48
84
52
100
100
100
96
100
99
-40
59
44
100

55

70
100
97
100
100
100
98
71
-39
84
-20
25
62
22
10
97
91
100

-38

-80

18

68
2

-41 -81 -46

21
99

-55

100
79
100
100
100
59
96
-28
100
100
100
100
5
71
100
3
100
100
71
100
-43
63
-2
0
89
74
31
100
4
100
41
100
100
3
100
-77

-47

100
-50
100
69
72
-28
23
100
29

66

100
100
-52
100
-5
100
99
100
100
65
100
100
12
4
-47
96
95
100
-44
100

57 -54 92

63

-12

98
100
-46
30
43

15

-98
-20
86

-72

3
97
0
100
-20
100
3
8
-5
-9
59
-27

78

-21
-88

-57 -53

99
-30
68
100
100
100
32
-1
50
63
100
100
-52
-45
-100
100
100
79
100
86
100
97
100
-41

35

95

-29

45
100
100
100
8

-78

53
-95
82
32
100
-23
80
100
95
83
73
100
97
-1
96

## importwarm – importcomputer

importwarm importcomputer

58

0

100 98

0

0 95

0

-2

0

0

-20 -42

0

73

0

32 85
33 -22
-23 -5
28 100
100
47
1 27

-74
100

-73 96
-21 44
-29 -7
-100 79
100 100
-19 5
74 58
1 70

-6

89 -73

56

96 38
60 -17
43 100
44 73
67

100

98

97 98
-100 100
7 9
-88 47
48 100
96
-19 85

100

73 56
100 98
-95 100
-40 100
-38 -20
-43 -1
64 -99
58 1
-77 100
-1 71

-40 100

-3 100
-1 30
62 70
0 48
53 -75
6 -90
-33 100
30 100
27 30
-4 5
-5 100
67 69
34 -82
0 -1
-97 -3
-1 -83
4 -99

100

37 100
5 -30
-81 60
0 -30
10 100
2 100
6 -73
40 84
29 100
-1 -89

100 100
100

42 48
5 84
24 52
56 100

100 100

-4 100
100 96
75 100
-59 99
98 -40
-1 59
68 44
26 100
0 55
-24 70
33

-100 100

-100 97
-58 100
24 100

100 100

-95
-30 98
33 71

54

0 -39
28 84
38 -20
12 25
-3 62
77 22
-40 10

97

-97 91
-70 100
-100 -38
72 -80
21 18
41 68
100 2
14 -41
-58 -81
-27
43 -46
40 21
34 99
22 -55
-44 100

-100 79

52 100
70 100

-1

0 100
-52 59
89 96
100 -28

48 100
100 100

-75 100
-28 100
97 5
-88 71

0
0 100

-24 3

100

97 100

71

65 100
-56 -43
19 63
45 -2
8 0
17 89
-80 74
-23 31

65 100

97 4
39 100
-79 41

100 100

68 100
17 3
-50 100
41 -77
60 -47

-28 100

4 -50

100 100

-14 69
3 72
29 -28
19 23
-8 100

26

96 29
-98 66
-9 100
-17 100
-73 -52
32 100
-100 -5
1 100

99

100

-1 100

62

-52 100

100

-21 65

0 100
-50 100

9 12
0 4
100 -47
-70 96
-90 95

100
0 100

64 -44
-1
-32

-100 100

6 57
82 -54
70 92
-33 63
-8 -12
85 98

-77 100

-75 -46
71 30
45 43
29 15
-99 -98
-59 -20
-10 86
28 -72
-2 3

97

0 0
-80 100
100 -20
-26 100
-61 3
-1 8
-73 -5
11 -9

100

-9 59
63 -27
-47 78
-39 -21

-88

100 -57
-45 -53
73 99
100 -30
88 68
14 100
33 100

100

98
46 100
-24 32
-1 -1
0 50
71 63
-43 100
-74 100
-44
-71 -52
-1 -45
38 -100
64 100

-100 100

32 79

-5 100

-9 86

-26 100

-1 97

100 100

-63 -41
50 35
-4 95

100

23 -29
16 45

64 100
100 100
4
-100 100

9 8
-2 -78
0 53
32 -95
13
-100 82
65 32

-95 100

61 -23
38 80
26
31 100
0 95
52 83
64
59 73
-14 100
1 97
100 -1
45 96
-48 Slope(m)

=
b=
R2=
F=
df=
-61 SumSq=
-83
-69
-13
-79
-86
-85
-65
-11
-25
-51
-16

importwarm – importcomputer

importwarm
importcomputer

importwarm – importcomputer

importwarm importwarm importwarm

70 54 �

importcomputer importcomputer importcomputer � 100 0 �
 �

Subg

rou

ps
Values
importwarm – importcomputer
-30
1
45
0
70
30

## importwarm – importcomputer 2

importwarm importcomputer

-48 58 importwarm 0 70 -30 1 45 54 0 0 0 -100 -30 1 46 100 0
100 98 importcomputer 0 100 0 70 30 0 0 0 0 -100 0 70 100 100 0

0 95

-2 -91
-20 -42
-61 73

32 85
33 -22
-23 -5
28 100
100
47
1 27
-74
100
-73 96
-21 44
-29 -7
-100 79
100 100
-19 5
74 58
1 70
-6
89 -73
-83 56
96 38
60 -17
43 100
44 73
67
-69 100
-13 98
97 98
-100 100
7 9
-88 47
48 100
96
-19 85
-79 100
73 56
100 98
-95 100
-40 100
-38 -20
-43 -1
64 -99
58 1
-77 100
-1 71
-40 100
-3 100
-1 30
62 70
0 48
53 -75
6 -90
-33 100
30 100
27 30
-4 5
-5 100
67 69
34 -82
0 -1
-97 -3
-1 -83
4 -99
100
37 100
5 -30
-81 60
0 -30
10 100
2 100
6 -73
40 84
29 100
-1 -89
100 100
100
42 48
5 84
24 52
56 100
100 100
-4 100
100 96
75 100
-59 99
98 -40
-1 59
68 44
26 100
0 55
-24 70
33
-100 100
-100 97
-58 100
24 100
100 100
-95
-30 98
33 71
54
0 -39
28 84
38 -20
12 25
-3 62
77 22
-40 10
-86 97
-97 91
-70 100
-100 -38
72 -80
21 18
41 68
100 2
14 -41
-58 -81
-27
43 -46
40 21
34 99
22 -55
-44 100
-100 79
52 100
70 100
-1
0 100
-52 59
89 96
100 -28
48 100
100 100
-75 100
-28 100
97 5
-88 71
0
0 100
-24 3
-85 100
97 100
-65 71
65 100
-56 -43
19 63
45 -2
8 0
17 89
-80 74
-23 31
65 100
97 4
39 100
-79 41
100 100
68 100
17 3
-50 100
41 -77
60 -47
-28 100
4 -50
100 100
-14 69
3 72
29 -28
19 23
-8 100
26
96 29
-98 66
-9 100
-17 100
-73 -52
32 100
-100 -5
1 100
-11
-25 99
100
-1 100
62
-52 100
100
-21 65
0 100
-50 100
9 12
0 4
100 -47
-70 96
-90 95
100
0 100
64 -44
-1
-32
-100 100
6 57
82 -54
70 92
-33 63
-8 -12
85 98
-77 100
-75 -46
71 30
45 43
29 15
-99 -98
-59 -20
-10 86
28 -72
-2 3
-51 97
0 0
-80 100
100 -20
-26 100
-61 3
-1 8
-73 -5
11 -9
100
-9 59
63 -27
-47 78
-39 -21
-16 -88
100 -57
-45 -53
73 99
100 -30
88 68
14 100
33 100
100
98
46 100
-24 32
-1 -1
0 50
71 63
-43 100
-74 100
-44
-71 -52
-1 -45
38 -100
64 100
-100 100
32 79
-5 100
-9 86
-26 100
-1 97
100 100
-63 -41
50 35
-4 95
100
23 -29
16 45
64 100
100 100
4
-100 100
9 8
-2 -78
0 53
32 -95
13
-100 82
65 32
-95 100
61 -23
38 80
26
31 100
0 95
52 83
64
59 73
-14 100
1 97
100 -1
45 96

 Low Outlier Start Box Bottom Mid Line Box Top End High Outlier Neg Start Neg End Low Whisker Q1 Q2 Q3 High Whisker XL2007 Err Bars Outliers

## Data

importwarm

importcomputer

17 -48 1 2 2 91 32

58

25 19 13

Q1

Q3

17

100 28 -30 -19 28 100 98

nzl 13

importwarm -100 -30 1 46 100

17

0 77 39 51 94 88 7 95 nzl

79 17 13

importcomp -100 0

100 100

girl 17

-2 -2 -2 -4 96 1 1 -91 nzl zaf 22 17 13 Gisborne Region

boy 18

13 Auckland Region

girl 17 -20 3 -8 -13 61 58

-42

nzl 30 25 13 Taranaki Region

boy 18 -61 58 54 -22 60 4 56 73

zaf 0 0 13 Auckland Region

=

99

girl 18 32 16 5 1

51 3 85 fra nzl 25 28 13 Auckland Region

=

girl 16 None 33 100 100 100 61 100 48 -22 aus nzl 32 22 13

=

girl 17

-23 -23

-23 36 -23 11 -5 fra nzl 63 50 13

=

girl 17 Home and Away 28 44 9 54 73 0 64 100 nzl zaf 50 14 13 Auckland Region
boy

84 -100 100 nzl zaf 45 30 13

Check for outliers using the 1.5 IQR rule

boy 17

-99 -1 24 6 24 47

nzl 28 16 13 Otago Region Importwarm Importcomp

girl 17 None 34 nzl zaf 0 0 13 Auckland Region IQR = Q3-Q1 = 76 100
boy 17

1 74 75 75 74 100 99 27 nzl zaf 32 21 13 Otago Region

= 114

girl 17

-74 2 32 can gbr-sco 7 21 13 Auckland Region

= 160

boy 17 10 -100 0 88 -21 -21 100

nzl 13 Auckland Region

= -144

0

boy 17

-73

-48 -46 -25 -28 -88 96

nzl 13 Auckland Region

girl 17

-21 -38 31 -72 15

56 44 gbr-eng nzl 26 24 13

girl 17 None -29 68 -5 46 61 22 63 -7 gbr-eng zaf 7 0 13 Auckland Region
girl 17

-100 37 62 36 -54 79 nzl zaf 30 25 13 Taranaki Region

boy 18 100 100 100 100 100 100 100 100 nzl

40 12 13 Waikato Region

girl 17

-19 28 28 28 85 29 18 5 aus nzl 0 3 13 Taranaki Region

girl 17 None 74 73 74 82 82

82 58 can nzl 27 32 13 Auckland Region

girl 17 None 1 1 60 -27 34 -18 -33 70

13

boy 17 -6 44 44 30 100

aus nzl 22 20 13 Waikato Region

boy 18

89 87 26 98 86 95 -3 -73 gbr-eng nzl 23 10 13 Hawkes Bay Region

girl 17

rou 13 Auckland Region

girl 17

-83 -24 2 42 100

-91 56 aus nzl 37 21 13 Auckland Region

girl 17 Modern Family 96 70 96 -2 73 73 -1 38 fra nzl 37 28 13 Hawkes Bay Region
girl 17

60 53 31 -14 -7 53 -74 -17 fra nzl 23 25 13

boy 19

43 99 100 74 100 100 100 100 aus nzl 25 30 13 Auckland Region

girl 18

44 65 66 34 88 65 6 73

aus 13 Canterbury Region

boy 17 The Big Bang Theory 66 66 0 82 82 67 67 aus gbr-eng 28 42 13 Auckland Region
girl 17

-69 12 -100 100 100 aus zaf 20 26 13 Hawkes Bay Region

girl 17 Jersey Shore -13 -18 -88 -85 -88 -69

98 aus zaf 33 21 13 Bay of Plenty Region

girl 17 97 98 99 97 67 60 96 98 can nzl 13 Auckland Region
boy 17 -100 47 36 100 5 100 jpn

80 0 13 Auckland Region

girl 18

7 25 -17 -11 4 20 42 9 aus nzl 13 Taranaki Region

girl 17 Home and Away -88 -87 -70 1 100 -89 -33 47 nzl zaf 30 27 13 Taranaki Region
boy 17 13 Auckland Region
girl 18 Shortland Street 48 41 54 84 100 88 100 100 fji nzl 21 14 13 Auckland Region
girl 17 Jersey Shore 99 96 nzl zaf 100 23 13

boy 17 The Big Bang Theory -19 -56 -56 17 -26 58 100 85 nzl

13 Otago Region

girl 17 Home and Away -79 41 -86 -65 57 45 53 100 nzl zaf 32 16 13 Auckland Region
girl 18 None 73 18 6 36 66 -1 -1 56 nzl zaf 12 17 13 Taranaki Region
girl 17 Jersey Shore 100 10 100 1 100 100 -1 98 nzl gbr-wal 52 14 13 Taranaki Region
girl 17 -95 -88 -21 -78 -41

25 100 nzl zaf 27 29 13 Bay of Plenty Region

boy 18 -40

-58

-74

-95 100

jpn 58 58 13 Auckland Region

boy 17

-38 100 86 -53 64 -1 28 -20 aus nzl 40 38 13 Hawkes Bay Region

girl 17

-43 -43 -43 -43 -20 -3 17 -1 nzl zaf 23 65 13 Bay of Plenty Region

boy 18 The Big Bang Theory 64 79 43 89 98 89 32 -99 aus zaf 25 18 13 Waikato Region
boy 17

58 57 59 1 42 42 42 1 aus zaf 18 25 13 Otago Region

boy 17

-77 55 -12 100 46 -100 -57 100 aus zaf 13 21 13 Otago Region

boy 17 Skins -1 44 82 100 100 96 -97 71 aus nzl 13 Hawkes Bay Region
boy 17

-40 -40 -40 -40 -40 -40 -40 100 arg aus

14 13 Auckland Region

boy 16 -3 -11 46 23 87 41 35 100 arg aus 27 19 13 Auckland Region
girl 17 Gossip Girl -1 13 14

38 -12 58 30 gbr-eng nzl 27 25 13 Auckland Region

boy 17 Top Gear 62 62 61 61 63 62 66 70 aus nzl 15 10 13 Auckland Region
girl 17 None 0 47 47 -47 90 -27 2 48 gbr-eng nzl 25 16 13 Auckland Region
girl 17 53 37 69 32 75 100 -5 -75 nzl zaf 35 28 13 Taranaki Region
girl 17 6 14 -21 -75 33 -12 100 -90 nzl zaf 23 17 13 Gisborne Region
girl 17 Jersey Shore -33 -68 -76

-16 -29 53 100 nzl gbr-sco 21 10 13 Gisborne Region

boy 18 The Big Bang Theory 30 31 31 33 34 34 34 100 nzl zaf 21 19 13 Auckland Region
girl 17

27 73 73 -73 95 -71 -72 30 aus nzl 24 18 13 Taranaki Region

boy 17 -4 15 -9 -1 -39 -29 -41 5 aus nzl 14 20 13 Auckland Region
boy 17

-5 -36 -36 -45 100 -12 -68 100 nzl zaf 30 0 13 Auckland Region

girl 17 Glee 67 100 68 6 68 66 100 69 aus zaf 28 30 13 Waikato Region
girl 17

34 55 -55

71 -35 80 -82 nzl zaf 26 18 13 Taranaki Region

girl 17 Home and Away 0 -10 -11 -14 3 -9 -17 -1 aus nzl 29 22 13 Canterbury Region
girl 17 Home and Away -97 -26 50

62 5 23 -3 aus nzl 21 40 13 Waikato Region

girl 17

-1 47 2 -40 67 71 47 -83 aus nzl 32 34 13 Taranaki Region

girl 17 None 4 -35 -25 -24 100 2 -71 -99 nzl zaf 23 7 13 Auckland Region
boy 17 The Middle 100 aus nzl 27 16 13 Auckland Region
girl 17

37 37 81 -76 50 -73 25 100 nzl zaf 6 16 13 Taranaki Region

boy 16

5 3 12 8 53 16 54 -30 nzl zaf 5 21 13 Otago Region

boy 18

-81 -95 -70

34 -38 -16 60 nzl zaf 14 21 13 Otago Region

boy 17

0 -2 0 69 -3 -31 -31 -30 gbr-eng nzl 100 72 13 Auckland Region

girl 17 10 85 100 -47 57 81 23 100 gbr-eng nzl 50 33 13 Manawatu-Wanganui Region
girl 17

2 23 37 22 100 23 100 100 geo nam 3 7 13 Taranaki Region

girl 17 Go Girls 6 1 55 -28 81 -21 13 -73 aus zaf 42 15 13 Hawkes Bay Region
boy 17

40 -76

-83 58 -70 -100 84 aus nzl 13 Waikato Region

boy

29 18 -12 2 24 -26 26 100 nzl zaf

90 13 Northland Region

boy 17 The Big Bang Theory -1 27 2 92 64 20 -69 -89 fji nzl 25 15 13 Auckland Region
boy 17 100 100 100 -3 100 47 48 100 arg aus 69 96 13 Auckland Region
girl 100 72 45 20 -3 -41 -72 fji rou 0 0 13 Canterbury Region
boy

42 47 46 25 52 26 27 48 nzl zaf 36 32 13 Northland Region

girl 18 Sons of Anarchy 5 -45 -46 7 60 -43 -47 84 gbr-eng nzl 35 12 13 Canterbury Region
girl 18 Glee 24 8 -7 -5 45 22 60 52 ita nzl 89 45 13 Otago Region
girl 17 Home and Away 56 56 57 57 100 100 100 100 gbr-eng zaf 26 50 13 Gisborne Region
boy 17 100 100 100 100 100 100 100 100 nzl zaf 27 23 13 Auckland Region
girl 17 None -4 -2 0 36 56 -24 -24 100 fji nzl 20 19 13 Bay of Plenty Region
boy

100 97 98 99 97 97 97 96 nzl zaf 24 16 13 Northland Region

girl 17

75 71 64 92 67 62 54 100 nzl zaf 56 3 13 Otago Region

boy 17 Top Gear -59 -57 -56 -59 8 -21 -9 99 nzl zaf 28 26 13 Auckland Region
girl 17

98 100 100 100 100 100 100 -40 nzl zaf 5 0 13 Taranaki Region

girl 17

-1 -1 0 1 56 0 -5 59 nzl zaf 24 18 13 Manawatu-Wanganui Region

girl 17 Glee 68 20 94 55 93 60 48 44 nzl usa 26 21 13 Bay of Plenty Region
boy 17 26 56 56 46 51 35 79 100 nzl zaf 36 28 13 Auckland Region
girl 17 Chuck 0 0 23 24 61 2 89 55 aus nzl 40 32 13 Taranaki Region
boy 17 The Big Bang Theory -24 -24 12 -84 91 48 12 70 aus nzl 76 53 13 Taranaki Region
boy 17 Family Guy -7 33 aus nzl 26 12 13 Otago Region
girl 17

-100 100 100 29 37 -45 -83 100 nzl zaf 26 22 13 Auckland Region

girl 17 Gossip Girl -100 98 -10 96 -13 -5 97 fji nzl 100 0 13 Auckland Region
boy 17 Fringe -58 -58 -58 -58 40 1 -58 100 arg aus 13 Northland Region
girl 17 24 83 100 8 62 44 100 100 nzl usa 35 12 13 Bay of Plenty Region
girl 17 Shortland Street 100 100 100 100 100 100 100 100 fji nzl 7 7 13 Auckland Region
boy 17 Chuck -95 -95 nzl usa 13 Otago Region
girl 17

-30 1 16 15 83 42 42 98 nzl zaf 13 Taranaki Region

boy 17 33 100 100 33 68 35 100 71 nzl zaf 28 0 13 Auckland Region
boy 17 54 43 23 81 100 73 irl nzl 36 30 13 Manawatu-Wanganui Region
girl 17 None 0 54 52 91 30 90 55 -39 nzl zaf 76 58 13 Bay of Plenty Region
girl 17 Home and Away 28 52 35 37 98 66 33 84 aus nzl 32 24 13 Taranaki Region
boy 17 None 38 39 2 -28 -53 -11 -27 -20 aus nzl 28 23 13 Otago Region
girl 17

12 66 36 5 -17 -16 2 25 gbr-eng nzl 38 0 13 Taranaki Region

boy 17 South Park -3 10 21 35 100 -37 -3 62 13 Auckland Region
girl 16

77 77 82 76 100 78 96 22 aus nzl 27 18 13 Otago Region

girl 17 The Vampire Diaries -40 24 24 68 68 68 30 10 nzl zaf 40 25 13 Auckland Region
boy 17

-86 -79 -97 -87 -71 -88 -99 97 jpn rou 13 Northland Region

girl 17 News -97 -31 -91 21 97 -47 96 91 gbr-eng nzl 22 17 13 Taranaki Region
girl 17 Gossip Girl -70 -53 -32 -44 63 -32 46 100 nzl zaf 40 28 13 Taranaki Region
boy 17 How I Met Your Mother -100 -23 -15 -8 100 3 40 -38 irl nzl 31 28 13 Northland Region
girl 18 None 72 83 93 72 79 80 92 -80 gbr-eng nzl 25 24 13 Auckland Region
boy 17

21 28 35

100 -1 -61 18 aus nzl 15 32 13 Auckland Region

girl 17 The Vampire Diaries 41 70 72 -3 34 69 -3 68 nzl zaf 89 32 13 Hawkes Bay Region
girl Shortland Street 100 100 100 100 100 100 100 2 nzl zaf 40 35 13 Northland Region
boy 17 The Simpsons 14 39 13 -30 55 -42 100 -41 fji zaf 72 53 13 Northland Region
girl 17 -58 100 100 3 47 48 100 -81 nzl zaf 52 43 13 Taranaki Region
boy 17

2 -11 3 100 44 42 -27 fra zaf 10 17 13 Hawkes Bay Region

boy 17 43 32 23 13 0 -16 -79 -46 fji ita 100 100 13 Auckland Region
boy 17

40 41 2 -54 57 32 0 21 ita nzl 34 5 13 Auckland Region

girl 17 Skins 34 34 -71 -100 -2 -92 100 99 nzl zaf 46 12 13 Bay of Plenty Region
girl 17 Police Ten 7 22 22 22 11 85 61 60 -55 aus gbr-eng 20 30 13 Gisborne Region
boy 18 South Park -44 -44 -43 -43 -1 -64 -26 100 13 Auckland Region
boy 17 South Park -100 30 46 96 79 aus nzl 22 20 13 Otago Region
boy 17 Modern Family 52 41 90 90 99 71 100 100 fra nzl 63 27 13 Otago Region
boy 17 The Simpsons 70 78 100 62 100 89 5 100 aus nzl 13 Auckland Region
girl 17 None -1 -1 -2 -2 99 -1 70 aus nzl 45 35 13 Manawatu-Wanganui Region
boy 17 None 0 0 0 56 57 30 3 100 aus nzl 27 15 13 Auckland Region
girl 18 Modern Family -52 -45 55 -22 68 -21 33 59 gbr-eng nzl 13 23 13 Waikato Region
girl 17 Jersey Shore 89 83 82 78 62 -32 61 96 13 Auckland Region
boy 17 The Big Bang Theory 0 aus nzl

7 13 Otago Region

girl 17 Shortland Street 100 100 53 -3 100 -31 100 -28 aus nzl 52 40 13 Waikato Region
boy 17 The Big Bang Theory 48 1 28 52 -100 52 -100 100 jpn nzl 0 56 13 Auckland Region
boy 18

100 100 100 -8 65 100 100 100 nzl zaf 29 21 13 Auckland Region

girl 17 MythBusters -75 100 98 -1 -4 100 100 can nzl 13 Gisborne Region
girl 17 Desperate Housewives -28 -22 -21 -9 -2 1 26 100 nzl zaf 64 34 13 Auckland Region
girl 17 Neighbours 97 99 99 97 97 97 97 5 fji nzl 45 26 13 Canterbury Region
girl 17 Grey’s Anatomy -88 -87 -84 -85 51 -70 45 71 aus nzl 40 30 13 Northland Region
girl 17 The Big Bang Theory 0 41 72 43 98 64 28 aus gbr-eng 21 17 13 Waikato Region
girl 17 Gossip Girl 0 51 51 100 53 100 38 100 nzl zaf 35 16 13 Auckland Region
boy 17 MythBusters -24 66 80 68 85 80 85 3 aus zaf 18 0 13 Otago Region
girl 18 Desperate Housewives -85 -81 -32 11 100 -60 -95 100 nzl zaf 11 23 13 Auckland Region
girl 19 97 97 77 86 99 99 97 100 aus nzl 52 43 13 Waikato Region
girl 17 Family Guy -65 -58 -82 -62 -31 -35 -20 71 aus nzl 0 0 13 Hawkes Bay Region
boy 18 None 65 51 27 49 88 27 100 100 fji nzl 19 26 13 Auckland Region
boy 17 Chuck -56 -41 -50 -90 -43 22 34 -43 nzl zaf 7 12 13 Otago Region
girl 17 Shortland Street 19 -31 72 -15 -5 -12 33 63 aus nzl 27 20 13 Northland Region
girl 17 The Vampire Diaries 45 73 41 44 56 45 33 -2 aus nzl 22 13 13 Taranaki Region
boy 17 The Big Bang Theory 8 73 73 -54 8 -15 64 0 fra nzl 25 22 13 Canterbury Region
boy 17 Misfits 17 1 58 50 68 51 89 aus nzl 19 11 13 Waikato Region
girl 17

-80 -73 -64 -55 75 -40 -82 74 nzl zaf 14 12 13 Auckland Region

boy

-100 13 Otago Region

girl 17 None -23 -27 41 -29 3 7 -56 31 nzl wsm 35 54 13 Auckland Region
girl 17 Glee 65 65 84 -2 100 100 -2 100 gbr-eng nzl 28 26 13 Auckland Region
girl 17 House of Anubis 97 98 98 97 98 97 99 4 aus nzl 36 32 13 Otago Region
girl 17 Masterchef New Zealand 39 2 42 -49 75 2 21 100 aus nzl 29 32 13 Gisborne Region
girl 17 Home and Away -79 -82 -81 -52 75 -54 -39 41 aus nzl 18 21 13 Taranaki Region
boy 18 100 77 63 -10 100 98 98 100 fra nzl 34 28 13 Waikato Region
boy 17 68 68 69 69 -16 -18 100 100 aus gbr-eng 21 14 13 Otago Region
girl 17

17 -43 -43 54 29 3 fji nzl 56 23 13 Gisborne Region

boy 18

-50 -54 -58 -67 41 -42 54 100 fra nzl 32 28 13 Auckland Region

girl 17 The Vampire Diaries 41 81 90 49 88 51 50 -77 nzl zaf 29 34 13 Bay of Plenty Region
boy 17 Home and Away 60 27 60 0 97 29 60 -47 aus fra 21 3 13 Auckland Region
boy 16 -28 -38 -20 -27 100 32 100 100 fra nzl 99 100 13 Auckland Region
boy 17 4 4 5 -55 -55 -18 -53 -50 aus zaf 23 16 13 Waikato Region
girl 17 Desperate Housewives 100 67 67 36 32 59 -85 100 irl nzl 100 101 13 Auckland Region
girl 17 Family Guy -14 9 11 23 72 22 24 69 aus zaf 14 8 13 Manawatu-Wanganui Region
girl 17 Gossip Girl 3 3 -4 -7 -6 12 -2 72 aus nzl 42 36 13 Auckland Region
girl 17

29 39 47 47 90 38 46 -28 gbr-eng nzl 24 18 13 Taranaki Region

girl 17 Gossip Girl 19 99 -28

100 36 98 23 fra nzl 40 6 13 Auckland Region

boy 17 Top Gear 13 Auckland Region
boy 17 News -8 100 40 66 13 100 35 100 13 Auckland Region
girl 17 Bones 26 26 25 25 25 26 29 fji nzl 20 10 13 Bay of Plenty Region
girl 17 None 96 98 97 81 58 75 89 29 nzl zaf 87 65 13 Taranaki Region
boy Go Girls -98 -83 -43 -89 14 100 -82 66 nzl zaf 24 17 13 Auckland Region
boy 17 -9 -11 -9 29 80 -35 81 100 geo jpn 10 12 13 Auckland Region
boy 17 SpongeBob SquarePants -17 47 -37 73 88 -48 13 100 nzl zaf 26 21 13 Waikato Region
girl 17 -73 -72 14 10 -52 gbr-eng nzl 0 0 13 Canterbury Region
boy 17

32 36 43 26 55 47 20 100 nzl zaf 25 18 13 Auckland Region

boy 17 The Simpsons -100 -54 -37 -36 16 -5 -71 -5 nzl zaf 48 20 13 Auckland Region
girl 17

1 -2 -11 -12 0 -22 -7 100 wsm ton 21 35 13 Auckland Region

boy 17 The Big Bang Theory -11 9 45 64 -68 aus nzl 32 17 13 Auckland Region
boy Sons of Anarchy -25 36 98 5 6 16 35 99 nzl zaf 28 25 13 Northland Region
boy 17 Seven Days 4 9 100 aus wsm 30 29 13 Otago Region
boy 17 Supernatural -1 -2 -72 -26 100 75 67 100 fra nzl 34 60 13 Auckland Region
girl 18 62 13 67 4 98 100 -4 aus zaf 35 18 13 Bay of Plenty Region
girl 17 Friends -52 -50 -50 -49 -27 -97 -97 100 nzl gbr-wal 12 24 13 Auckland Region
boy 17 None -56 100 -1 nzl zaf 32 28 13 Auckland Region
boy 16 Desperate Housewives 12 13 60 28 -11 100 100 fra nzl 18 23 13 Otago Region
girl 17 SpongeBob SquarePants -21 -49 -74 38 99 27 -17 65 gbr-eng nzl 13 Auckland Region
girl 17 SpongeBob SquarePants 0 43 99 100 1 58 83 100 nzl zaf 50 45 13 Auckland Region
boy 17

-50 -5 34 -27 68 -17 100 aus nzl 55 56 13 Auckland Region

boy 18 News 9 21 16 25 31 31 21 12 nzl zaf 26 21 13 Hawkes Bay Region
girl 17

0 100 2 1 27 2 98 4 gbr-eng nzl 32 7 13 Auckland Region

boy 17 How I Met Your Mother 100 100 100 100 84 87 -3 -47 nzl zaf 27 7 13 Auckland Region
girl 17 Castle -70 28 88 -32 100 -5 -47 96 nzl zaf 68 43 13 Bay of Plenty Region
girl 17 None -90 37 76 -19 89 42 100 95 fra nzl 0 0 13 Gisborne Region
boy 17 Scrubs 1 4 26 100 100 fra nzl 15 20 13 Otago Region
girl 17

0 15 -44 4 -11 -46 63 100 nzl zaf 32 35 13 Taranaki Region

girl 17

64 64 83 100 36 81 -17 -44 gbr-eng nzl 13 Hawkes Bay Region

girl 17 None 100 -1 aus nzl 34 15 13 Canterbury Region
boy 17 The Big Bang Theory -18 -75 -16 19 -52 -66 -32 nzl zaf 26 22 13 Auckland Region
girl 17 None -100 -11 -100 90 24 46 54 100 nzl zaf 18 27 13 Canterbury Region
girl 17 6 5 34 11 74 15 15 57 nzl zaf 22 15 13 Taranaki Region
girl 17 The Big Bang Theory 82 82 11 34 -1 -3 80 -54 aus nzl 23 26 13 Bay of Plenty Region
17 Fringe 70 70 70 90 100 72 72 92 nzl zaf 19 24 13 Gisborne Region
girl 17 Dr Who -33 -48 -16 -36 -44 -25 -16 63 aus nzl 20 30 13 Auckland Region
boy 17

-8 -9 -9 95 95 -11 -10 -12 arg aus 60 40 13 Auckland Region

boy 17 The Vampire Diaries 85 76 75 76 98 83 98 nzl zaf 35 14 13 Auckland Region
boy 17 -77 -61 -90

-99 -83 -13 100 nzl wsm 8 54 13 Canterbury Region

girl 17 America’s Funniest Home Videos -75 -23 -46 -75 76 23 -74 -46 nzl zaf 56 40 13 Gisborne Region
girl 17 Sons of Anarchy 71 71 73 70 44 84 100 30 nzl zaf 13 Gisborne Region
girl 17 Grey’s Anatomy 45 32 23 -16 36 40 10 43 aus zaf 27 28 13 Bay of Plenty Region
girl 17 Shortland Street 29 36 17 49 -5 -9 96 15 nzl zaf 32 28 13 Auckland Region
boy 17 Castle -99 -69 -97 -92 -15 -98 nam gbr-sco 0 0 13 Hawkes Bay Region
girl 16

-59 -66 -95 -36 47 -79 -87 -20 aus nzl 24 27 13 Waikato Region

boy 17 Family Guy -10 -59 37 -77 84 -17 -31 86 nzl zaf 29 22 13 Taranaki Region
girl 17 Castle 28 43 37 -56 83 -55 -53 -72 usa gbr-wal

18 13 Bay of Plenty Region

boy 17 -2 -2 -1 1 96 -38 1 3 gbr-eng nzl 15 28 13 Otago Region
girl 17 Home and Away -51 -50 -2 -49 61 1 -48 97 can nzl 27 12 13 Canterbury Region
girl 17

0 100 100 100 100 100 100 0 aus nzl 32 36 13 Bay of Plenty Region

boy 17 SpongeBob SquarePants -80 -60 -42 -78 -41 4 29 100 fji nzl 14 15 13 Auckland Region
girl 17 100 100 100 27 42 59 21 -20 nzl gbr-sco 18 35 13 Auckland Region
girl 17 Jersey Shore -26 -40 -72 37 96 40 -59 100 gbr-eng fra 31 26 13 Auckland Region
boy 18 America’s Funniest Home Videos -61 -86 -39 90 -43 15 3 aus nzl 27 20 13 Auckland Region
girl 17 Neighbours -1 -6 -10 -1 100 -31 -76 8 aus nzl 22 43 13 Auckland Region
girl 17 The Big Bang Theory -73 -73 -19 8 47 48 -75 -5 fra nzl 33 22 13 Manawatu-Wanganui Region
girl 17 Castle 11 -30 14 -30 -30 -31 -31 -9 gbr-eng nzl 30 21 13 Bay of Plenty Region
girl 17 Supernatural -30 16 -79 -100 100 wsm ton 30 48 13 Auckland Region
boy 17 How I Met Your Mother -9 -9 -11 -6 20 -7 76 59 nzl zaf 32 26 13 Otago Region
boy 17 Family Guy 63 64 50 35 24 50 64 -27 aus gbr-eng 13 Otago Region
girl 17 Chuck -47 -47 33 1 33 -46 -88 78 aus zaf 36 24 13 Auckland Region
girl 17 Gossip Girl -39 -39 -39 -37 -35 -37

-21 nzl zaf 15 5 13 Auckland Region

boy 17 News ita nzl 13 Auckland Region
boy 18 aus nzl 13 Bay of Plenty Region
boy 19 Family Guy -16 4 4 19 22 24 45 -88 aus zaf 15 13 13 Canterbury Region
girl 17 How I Met Your Mother 100 100 100 2 58 100 100 -57 gbr-eng nzl 0 0 13 Manawatu-Wanganui Region
girl 17 None -45 7 30 -27 51 13 72 -53 gbr-eng nzl 40 32 13 Otago Region
girl Neighbours 73 100 99 73 83 99 77 99 aus nzl 46 51 13 Waikato Region
boy 17

100 -10 -1 13 99 22 -100 -30 aus gbr-eng 27 21 13 Auckland Region

girl 17 Bones 88 56 42 16 46 -73 -71 68 aus nzl 40 32 13 Bay of Plenty Region
girl 17 None 14 33 20 32 57 35 -14 100 nzl zaf 40 20 13 Auckland Region
boy 17 None 33 38 62 48 70 29 -15 100 nzl zaf 24 17 13 Auckland Region
girl 17

54 100 aus nzl 15 10 13 Gisborne Region

boy 18 The Simpsons 39 99 98 fji fra 13 Auckland Region
boy 17 Two and a Half Men 46 46 46 18 -1 -1 63 100 nzl zaf 44 44 13 Bay of Plenty Region
girl 17 Go Girls -24 19 100 25 45 -42 11 32 gbr-eng irl 17 28 13 Taranaki Region
girl 17 Bones -1 -1 -1 -1 -1 -1 -1 -1 13 Auckland Region
girl 17 The Vampire Diaries 0 23 30 32 88 54 29 50 nzl zaf 21 16 13 Taranaki Region
girl 16 71 100 100 99 54 7 32 63 aus nzl 30 27 13 Otago Region
girl 17 Friends -43 31 100 -42 100 100 -31 100 nzl zaf 43 41 13 Auckland Region
boy 17 ONE News -74 41 20 43 53 100 100 aus nzl 13 Otago Region
boy 17

-3 100 100 100 96 -44 aus nzl 28 16 13 Hawkes Bay Region

girl 17 Modern Family -71 -65 -68 -76 39 -69 -15 -52 gbr-eng zaf 29 18 13 Manawatu-Wanganui Region
boy 17 -1 90 -1 -1 72 64 79 -45 nzl zaf 50 24 13 Otago Region
girl 17 Keeping Up with the Kardashians 38 -100 38 -41 3 -18 81 -100 aus nzl 28 17 13 Auckland Region
girl 18 One Tree Hill 64 0 35 75 87 5 68 100 nzl zaf 14 26 13 Gisborne Region
boy 16 Scrubs -100 31 31 -72 62 14 73 100 nzl zaf 35 27 13 Northland Region
girl 16 Shortland Street 32 43 1 10 47 26 4 79 aus nzl 30 20 13 Gisborne Region
girl 17 Cartoon Network -5 21 -20 -28 -5 -30 -3 100 fji nzl 5 6 13 Bay of Plenty Region
girl 17 Family Guy -9 1 -6 22 98 49 69 86 aus nzl 36 14 13 Hawkes Bay Region
boy 17 Top Gear -26 100 fji nzl 21 19 13 Auckland Region
girl 18 Masterchef New Zealand -1 0 -1 57 95 57 -42 97 fji nzl 0 0 13 Taranaki Region
girl 17 100 100 100 100 7 26 28 100 gbr-eng nzl 35 50 13 Otago Region
girl 17 Home and Away -63 -11 24 65 2 30 -70 -41 fra nzl 40 38 13 Taranaki Region
girl 17 The Vampire Diaries 50 51 35 28 34 22 28 35 nzl zaf 23 15 13 Taranaki Region
girl 17 Grey’s Anatomy -4 98 99 100 100 10 74 95 nzl zaf 45 50 13 Auckland Region
boy 17 The Big Bang Theory -14 -65 -56 -96 100 aus nzl 24 18 13 Auckland Region
girl 18 American Idol 23 26 85 -45 23 48 -77 -29 nzl zaf 21 17 13 Waikato Region
girl 17 16 40 40 6 74 56 5 45 gbr-eng nzl 20 10 13 Bay of Plenty Region
boy 17

64 46 74 100 100 100 -21 100 fji fra 120

13 Auckland Region

girl 17 100 7 4 7 -35 5 100 100 gbr-eng nzl 34 22 13 Manawatu-Wanganui Region
girl 16 4 25 -37 27 -9 -30 34 aus nzl 13 Auckland Region
boy 18 -100 -1 30 -4 100 fra nzl 23 17 13 Hawkes Bay Region
girl 17 9 100 9 9 50 72 92 8 aus zaf 10 12 13 Auckland Region
boy 17 None -2 -7 9 -75 -21 4 -48 -78 ita jpn 27 10 13 Waikato Region
girl 17 The Vampire Diaries 0 0 59 -51 31 -50 -42 53 nzl zaf 13 Hawkes Bay Region
girl 17 Two and a Half Men 32 50 50 34 100 72 87 -95 gbr-eng nzl 36 18 13 Northland Region
boy 18 3 News -34 3 -32 63 -28 -26 13 nzl zaf 20 18 13 Otago Region
girl 18 Home and Away -100

-1 -90 100 -39 21 82 gbr-eng nzl 35 21 13 Taranaki Region

girl 19

65 64 90 100 100 97 55 32 nzl usa 13 Auckland Region

boy 17 MythBusters -95 -88 -93 -94 -98 -98 -96 100 nzl ton 56 31 13 Taranaki Region
girl 17 61 25 -16 29 -14 40 -17 -23 gbr-eng nzl 17 12 13 Waikato Region
girl 17 Home and Away 38 -2 4 27 60 34 38 80 aus nzl 45 22 13 Waikato Region
boy 17

-42 100 54 100 -11 100 26 aus nzl 0 120 13 Auckland Region

girl 16 CSI 31 76 33 3 71 6 86 100 aus nzl 16 32 13 Taranaki Region
girl 17 The Mentalist 0 29 56 93 27 -1 0 95 ita nzl 0 0 13 Gisborne Region
girl 17 None 52 52 45 69 81 63 58 83 aus nzl 0 0 13 Taranaki Region
girl 17 Packed to the Rafters -83 -83 -73 100 -81 -57 64 aus zaf 33 17 13 Hawkes Bay Region
girl 17 Gossip Girl 59 16 -29 56 43 75 -54 73 fra usa 80 60 13 Auckland Region
boy 18 Home and Away -14 2 17 100 -42 100 100 aus gbr-eng 26 14 13 Auckland Region
boy 17 Other 1 2 2 3 3 97 aus zaf 26 12 13 Auckland Region
boy 16 The Simpsons 100 -1 -100 100 100 100 100 -1 aus nzl 25 47 13 Auckland Region
girl 17 Outrageous Fortune 45 32 16 3 64 38 69 96 aus nzl 52 36 13 Manawatu-Wanganui Region
 gender age favtvshow importpollution importrecycling importwater importlifestyle importenergy importgovern rugbya rugbyb rugbyscorea rugbyscoreb year region Five number summary g irl 94 fra nzl Taranaki Region Min Mdn Max boy None can Auckland Region girl Grey’s Anatomy zaf Gisborne Region 69.5 Modern Family Skins Check for outliers using the 1.5 IQR rule -18 aus Importwarm Importcomp gbr-sco IQR = Q3-Q1 76 49 1.5 * IQR 114 148.5 Bay of Plenty Region Q1 – 1.5 * IQR -144 -147.5 Home and Away 36 Otago Region Q3 + 1.5 * IQR 160 248.5 South Park Canterbury Region The Big Bang Theory gbr-eng MythBusters 1.5IQR 150 Friends Q3+1.5IQR 250 jpn Q1-1.5IQR -15 Jersey Shore -76 fji Shortland Street -35 Waikato Region Glee usa Desperate Housewives 87 wsm ton Hawkes Bay Region -36 Sons of Anarchy Gossip Girl ita One Tree Hill -64 Neighbours Northland Region Top Gear Castle arg Police Ten 7 -87 nam Masterchef New Zealand Manawatu-Wanganui Region gbr-wal -68 -49 -66 -84 geo Dragonball Z Fringe America’s Funniest Home Videos Chuck Other 120 -31 -37 Go Girls Family Guy CSI -60 -67 The Middle Dr Who Scrubs Wipeout – 93 Hell’s Kitchen The Vampire Diaries Misfits -92 The Simpsons 111 MTV 3 News Criminal Minds Don’t know Bones Supernatural Project Runway American Idol ONE News How I Met Your Mother My Wife and Kids -62 House of Anubis 3 News 101 The Fresh Prince of Bel-Air Packed to the Rafters Mr. Bean SpongeBob SquarePants Survivor Keeping Up with the Kardashians -96 Seven Days The Mentalist Quite Interesting Hawaii Five-0 NCIS: Naval Criminal Investigative Service Come Fly with Me Hannah Montana -94 Two and a Half Men 122 Pretty Little Liars -34 Cartoon Network Coronation Street Outrageous Fortune WWE 125 -93 Icarly ITM Fishing Show

Question: 1. Are you: male, female?
Question: 2. How old are you?
Question:
Question:
Question:
Question:
Question:
Question:
Question:
Question:
Question:
Question:
Question:
Question:
Question:
Question: What year level are you?
Question: What region is your school in?