Magasins2Féquilibré.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	X	Y	Z	AA	AB	AD	AE	AF	AG	AH	AJ	AK	AL	AM	AN
1	gender/Style	2 fois/semaine	Hebdomadaire	Souvent		SCT	gender/Style	2 fois/semaine	Hebdomadaire	Souvent		SCR	gender/Style	2 fois/semaine	Hebdomadaire	Souvent		SCM	gender/Style	2 fois/semaine	Hebdomadaire	Souvent	SCtr1 Genre	gender/Style	2 fois/semaine	Hebdomadaire	Souvent	SCtr2 Style	gender/Style	2 fois/semaine	Hebdomadaire	Souvent	SCI	gender/Style	2 fois/semaine	Hebdomadaire	Souvent
2	Homme	296,36	269,22	269,74		408560,457	Homme	822,72405	3116,225937	3058,440243		179881,8163	Homme	3760,939602	3492,219025	9781,012201		228678,6407	Homme	1065,587211	10,70489336	1900,596684	84293,32161	Homme	702,4443468	702,4443468	702,4443468	110321,7562	Homme	73,75660669	1029,682528	1654,60477	34063,56293	Homme	216,9090747	78,44349669	556,2365018
3	Homme	300,54	292,18	305,81			Homme	600,4051767	1079,987723	369,9147			Homme	3265,722462	1305,738225	3947,483241			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
4	Homme	305,41	297,28	311,54			Homme	385,4612334	770,7934234	182,33551			Homme	2732,832452	963,171225	3260,295801			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
5	Homme	313,46	297,44	350,39			Homme	134,16975	761,93481	642,46196			Homme	1955,983302	953,265625	333,026001			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
6	Homme	331,41	307,1	352,57			Homme	40,53656669	321,95723	757,7265534			Homme	690,4544523	450,076225	258,212761			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
7	Homme	336,18	320,21	356,7			Homme	124,0290567	23,35950003	1002,155097			Homme	462,5295423	65,691025	142,539721			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
8	Homme	341,64	321,97	359,87			Homme	275,4548767	9,444353361	1212,90832			Homme	257,4901623	40,259025	76,895361			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
9	Homme	352,25	322,76	364,44			Homme	740,21178	5,212850028	1552,110477			Homme	29,55553225	30,858025	17,631601			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
10	Homme	354,86	328,85	371,03			Homme	889,04355	14,49198003	2114,78884			Homme	7,98910225	0,286225	5,716881			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
11	Homme	356,87	333,9	373,09			Homme	1012,94732	78,44349669	2308,498193			Homme	0,66667225	31,192225	19,811401			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
12	Homme	357,8	337,24	373,21			Homme	1073,01013	148,7627434	2320,043833			Homme	0,01288225	79,655625	20,894041			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
13	Homme	361,69	343,64	375,95			Homme	1342,990393	345,84221	2591,50568			Homme	16,02801225	234,855625	53,450721			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
14	Homme	369,82	345,17	384,57			Homme	2004,964803	405,08942	3543,443887			Homme	147,2218222	284,091025	253,796761			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
15	Homme	379,68	345,53	386,92			Homme	2985,183557	419,71034	3828,742503			Homme	483,7140422	296,356225	334,194961			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
16	Homme	383,24	348,27	387,51			Homme	3386,87141	539,4857867	3902,105267			Homme	652,9813622	398,202025	356,114641			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
17	Homme	396,6	348,74	391,68			Homme	5120,380397	561,53991	4440,467557			Homme	1514,260482	417,180625	530,887681			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
18	Homme	401,13	349,06	400,52			Homme	5789,206207	576,8082834	5696,75237			Homme	1887,337692	430,355025	1016,398161			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
19	Homme	403,04	349,08	405,86			Homme	6083,50601	577,7693567	6531,36055			Homme	2056,939962	431,185225	1385,402841			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
20	Homme	404,15	354,22	417,48			Homme	6257,89108	851,2876034	8544,568157			Homme	2158,856832	671,069025	2385,443281			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
21	Homme	407,6	354,44	433,9	351,5468333		Homme	6815,63073	864,17381	11849,81016			Homme	2491,357482	682,515625	4258,998121			Homme	1065,587211	10,70489336	1900,596684		Homme	702,4443468	702,4443468	702,4443468		Homme	73,75660669	1029,682528	1654,60477		Homme	216,9090747	78,44349669	556,2365018
22	Femme	184,62	227	425			Femme	19718,66574	9612,46253	9991,36853			Femme	8208,994212	935,992836	3868,715601			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
23	Femme	202,31	275	276,37			Femme	15063,4302	2504,31853	2369,077153			Femme	5316,378482	302,968836	7470,317761			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
24	Femme	207,75	328	277,15			Femme	13757,68695	8,742863361	2293,755413			Femme	4552,673202	4957,004836	7336,093801			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
25	Femme	234,5	338	302,29			Femme	8198,06503	167,87953	517,7065934			Femme	1658,403452	6465,124836	3661,581121			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
26	Femme	239,26	194,64	308,93			Femme	7358,751683	17004,98588	259,63414			Femme	1293,373332	3963,206116	2902,084641			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
27	Femme	241,58	225,7	314,39			Femme	6966,10019	9869,064763	113,48996			Femme	1131,885092	1017,227236	2343,624921			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
28	Femme	251,23	227,4	325,42			Femme	5448,383573	9534,187997	0,1420033611			Femme	575,6880422	911,677636	1397,339161			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
29	Femme	253,41	238,09	338,55			Femme	5131,310567	7560,853193	182,4345467			Femme	475,8287822	380,406016	588,111001			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
30	Femme	260,74	250,89	347,34			Femme	4134,897243	5498,692127	497,1487767			Femme	209,7717722	44,943616	239,042521			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
31	Femme	261,56	251,6	370,55			Femme	4030,11245	5393,89873	2070,87188			Femme	186,6912322	35,928036	60,047001			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
32	Femme	264,46	253,11	373,28			Femme	3670,320083	5174,380467	2326,79209			Femme	115,8529322	20,106256	109,809441			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
33	Femme	269,05	253,33	373,32			Femme	3135,234713	5142,778273	2330,652637			Femme	38,11210225	18,181696	110,649361			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
34	Femme	283,71	254,87	384,27			Femme	1708,430667	4924,27332	3507,817787			Femme	72,02068225	7,420176	460,917961			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
35	Femme	312,27	256,01	386,35			Femme	163,1537867	4765,5781	3758,527813			Femme	1372,443162	2,509056	554,555401			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
36	Femme	315,09	257,61	401,28			Femme	99,06552669	4547,231967	5812,054757			Femme	1589,337822	0,000256	1480,633441			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
37	Femme	317,18	257,66	404,92			Femme	61,82939003	4540,49115	6380,308503			Femme	1760,347892	0,004356	1774,010161			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
38	Femme	332,32	263,76	406,86			Femme	52,95230336	3755,626517	6693,994217			Femme	3260,010312	38,019556	1941,195481			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
39	Femme	352,7	264,57	411,97			Femme	764,90043	3657,003887	7556,274353			Femme	6002,608052	48,664576	2417,590561			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
40	Femme	358,25	265,1	413,7			Femme	1102,69378	3593,18323	7860,034097			Femme	6893,399702	56,340036	2590,708201			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
41	Femme	362,48	269,54	414,08	298,5395		Femme	1401,51649	3080,60151	7927,55769			Femme	7613,696792	142,706916	2629,535841			Femme	2481,999187	4549,390084	1425,653978		Femme	702,4443468	702,4443468	702,4443468		Femme	73,75660669	1029,682528	1654,60477		Femme	216,9090747	78,44349669	556,2365018
42		316,455	292,9545	365,72	325,0431667
43
44							Effets fixes							Effets mixtes
45							Calcul Cours							Calcul Cours
46
47		2 fois/semaine	Hebdomadaire	Souvent			Source de variation	Somme des Carrés (SC)	Degrés de liberté (ddl)	Moyenne des carrés	F	Signification		Source de variation	Somme des Carrés (SC)	Degrés de liberté (ddl)	Moyenne des carrés	F	Signification
48	Homme	357,6865	328,315	368,639						(MC)		(p-value)					(MC)		(p-value)
49	Femme	275,2235	257,594	362,801			Genre	84293,32161	1	84293,32161	53,42084522	0		Genre	84293,32161	1	84293,32161	4,949178205	0
50							Style	110321,7562	2	55160,8781	34,95817551	0		Style alétoire	110321,7562	2	55160,8781	34,95817551	0
51							Interaction	34063,56293	2	17031,78146	10,79388193	0,00005093403941		Interaction	34063,56293	2	17031,78146	10,79388193	0,00005093403941
52							Erreur	179881,8163	114	1577,910669				Erreur	179881,8163	114	1577,910669
53							Total	408560,457	119					Total	408560,457	119
54
55
56
57							Sortie SPSS							Sortie SPSS
58
59							Tests des effets inter-sujets							Tests des effets inter-sujets
60							Variable dépendante:amtspent							Variable dépendante:amtspent
61							Source	Somme des carrés de type III	ddl	Moyenne des carrés	D	Sig.		Source		Somme des carrés de type III	ddl	Moyenne des carrés	D	Sig.
62							Modèle corrigé	228678,641a	5	45735,728	28,985	,000		Ordonnée à l'origine	Hypothèse	1,268E+07	1	1,268E+07	229,843	,004
63							Ordonnée à l'origine	1,268E+07	1	1,268E+07	8034,908	,000		Ordonnée à l'origine	Erreur	110321,756	2	55160,878a
64							gender	84293,322	1	84293,322	53,421	,000		gender	Hypothèse	84293,322	1	84293,322	4,949	,156
65							style	110321,756	2	55160,878	34,958	,000		gender	Erreur	34063,563	2	17031,781b
66							gender * style	34063,563	2	17031,781	10,794	,000		style	Hypothèse	110321,756	2	55160,878	3,239	,236
67							Erreur	179881,816	114	1577,911				style	Erreur	34063,563	2	17031,781b
68							Total	1,309E+07	120					gender * style	Hypothèse	34063,563	2	17031,781	10,794	,000
69							Total corrigé	408560,457	119					gender * style	Erreur	179881,816	114	1577,911c
70
71
72														Tests des effets inter-sujets
73							Sortie R							Variable dépendante:amtspent
74							Df Sum Sq Mean Sq F value Pr(>F)							Source		Somme des carrés de type III	ddl	Moyenne des carrés	D	Sig.
75							gender1 1 84293 84293 39.69 5.53e-09 ***							Ordonnée à l'origine	Hypothèse	1,268E+07	1	1,268E+07	103,562	,016
76							style1 1 48541 48541 22.86 5.17e-06 ***							Ordonnée à l'origine	Erreur	209168,277	1,709	122422,418a
77							gender1:style1 1 29357 29357 13.82 0.000311 ***							style	Hypothèse	110321,756	2	55160,878	3,239	,236
78							Residuals 116 246369 2124							style	Erreur	34063,563	2	17031,781b
79							---							gender	Hypothèse	84293,322	1	84293,322	4,949	,156
80							Signif. codes: 0 ‘*’ 0.001 ‘’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1							gender	Erreur	34063,563	2	17031,781b
81														style * gender	Hypothèse	34063,563	2	17031,781	10,794	,000
82														style * gender	Erreur	179881,816	114	1577,911c
83
84
85														ANOVA
86														Source	Somme des carrés de type III	ddl	Carré moyen
87														Modèle corrigé	228678,641	5	45735,728
88														Ordonnée à l'origine	1,268E+07	1	1,268E+07
89														style	110321,756	2	55160,878
90														gender	84293,322	1	84293,322
91														style * gender	34063,563	2	17031,781
92														Erreur	179881,816	114	1577,911
93														Total	1,309E+07	120
94														Total corrigé	408560,457	119
95
96
97
98
99
100