Exemplar - DataTables.xls

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
1	CANSIM
2	Table 502-0003
3	Average hours per week of television viewing, by sex1,2
4	Annual	v21419770 - Canada; Males; 18 years and over (hours)	v21419782 - Canada; Females; 18 years and over (hours)	Difference
5	1998	21.4	26.4	5
6	1999	20.9	25.5	4.6
7	2000	20.9	25.5	4.6
8	2001	20.9	25.3	4.4
9	2002	21	25.8	4.8
10	2003	20.7	26.3	5.6
11	2004	20.9	25.6	4.7
12	Mean	20.95714286	25.77142857	4.814285714
13	Median	20.9	25.6	4.7
14	Mode	20.9	25.5	4.6
15
16
17	CANSIM
18	Table 502-0003
19	Average hours per week of television viewing, by sex1,2
20	Annual	v21419788 - Newfoundland and Labrador; Females; 18 years and over (hours)	v21419800 - Prince Edward Island; Females; 18 years and over (hours)	v21419812 - Nova Scotia; Females; 18 years and over (hours)	v21419824 - New Brunswick; Females; 18 years and over (hours)	v21419836 - Quebec; Females; 18 years and over (hours)	v21419872 - Ontario; Females; 18 years and over (hours)	v21419884 - Manitoba; Females; 18 years and over (hours)	v21419896 - Saskatchewan; Females; 18 years and over (hours)	v21419908 - Alberta; Females; 18 years and over (hours)	v21419920 - British Columbia; Females; 18 years and over (hours)		MEAN (hours) For all provinces	MODE (hours) for all provinces	STANDARDDEVIATION (hours) for all provinces	Variance	Ontario z-score	Quebec z-score	PEI z-score	Percentile (90th) (of all data)	3rd Quartile (of all data)	1st Quartile (of all data)	IQR (of all data)	Range (of all data)
21	1998	26.7	24.9	27.3	28.8	30.4	25.3	25.7	26.1	23.5	23.7		26.24	25.7	2.163947011	4.682666667	-0.4343914131	1.922413062	-0.6192388229	28.5	27.45	24.325	3.125	7.3
22	1999	29	24.8	25.7	26.7	29.5	24.2	24.4	24.5	23.1	23.6		25.55		2.197599701	4.829444444	-0.6143065999	1.797415607	-0.3412814444
23	2000	28	24.7	27	26.5	29.1	24.1	24.4	25.2	23.6	23.5		25.61		1.939329781	3.761	-0.778619508	1.799590783	-0.469234273
24	2001	27.1	22.7	28.1	27.8	28.5	23.9	24.9	25.1	23.2	24		25.53		2.161815081	4.673444444	-0.7539960352	1.373845537	-1.309085141
25	2002	26.6	25.1	27.8	28.4	28.9	24.5	26.3	25.4	24.3	24.3		26.16		1.725752654	2.978222222	-0.9618991437	1.587713044	-0.6142247544
26	2003	27.8	25.6	27.9	27.5	29.1	25	24.8	26.3	23.7	26.2		26.39		1.673618834	2.801	-0.8305355868	1.61924564	-0.472031017
27	2004	26.8	23.5	27.2	28.4	28.5	24.7	26.4	25.7	23.9	23.4		25.85		1.921371038	3.691666667	-0.5985309329	1.379223454	-1.22308495
28												MEAN=	25.90428571		1.969062014	3.916777778	-0.7103256028	1.639921018	-0.7211686289
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100