Question

Identify whether the regression, t-test or ANOVA would be best to test the following hypothesis and then run the appropriate test in Excel: "More males hear about the gym through "word of mouth" advertising than females".

Word Of Mouth Word Of Gender Word Of Mouth Gender Word Of Mouth Word Of Mouth Gender Mouth (1-M;2-F) Advertising (1-M;2-F) Advertising Gender (1-M;2-F) Advertising Gender (1-M;2-F) Advertising (1-M2-F) Advertising 0 0 0 0

Answer 1

In this given data we have only two sample so we used two sample t test for this given data for female and male

t-Test: Two-Sample Assuming Equal Variances
	2	1
Mean	1.805309735	0.530973
Variance	0.158185841	0.251264
Observations	113	113
Pooled Variance	0.204725032
Hypothesized Mean Difference	0
df	224
t Stat	21.17009462
P(T<=t) one-tail	1.15417E-55
t Critical one-tail	1.65168456
P(T<=t) two-tail	2.30834E-55
t Critical two-tail	1.970610961
			Book1 Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW EW Sign i Show Detail Hide Detail A& Data Analysis さ properties Hrom rom rom Hrom Other Easting Retresh Acss Web Text SourcrsConnections All lext to lash RemoveData Consolidate What-It Relationships Group Ungroup Subtotal yAdvanced Columns Fill Duplicates Va lidation GetErtemal Drs , Cnnneetinns All-Stat Links 치 Sort Hither·apply Get External Dat Data Tcols 0 10 12 13 15 16 17 18 19 20 t-Test: Two-Sample Assuning Equal Variances 1.805309735 0.530973 Variance 0.158185841 0.251264 113 113 Paoled Variance 0.204725032 hesiced Meari 24 25 26 27 21.1/009462 1.15417E 55 1.65169456 2.30B34E-55 1.970610961 P(T-t) one tail Critical ane-tail t Critical two-tall 32 Sheet Seledt destnation ard press ENTER ur thouse Paste ョ圜凹- +101% 1145 AM 3/31/20159