Compare two means and calculate p value with pivot table

[akswartz85]

Hi, I've built this table:

<style type="text/css"><!--br {mso-data-placement:same-cell;}--></style>

	s_male	Values
	0			1
hs_name1	AVERAGE of sat_composite	STDEV of sat_composite	COUNT of s_lasid	AVERAGE of sat_composite	STDEV of sat_composite	COUNT of s_lasid
Hope High School	986	600	639	979	630	579
James High School	837	568	473	830	612	428
Juniper High School	789	525	538	722	577	466
Kennedy High School	531	468	314	523	484	239
King High School	683	540	275	619	569	258
Lincoln High School	842	538	354	933	534	279
Meadowbrook High School	484	517	292	484	507	274
North Falls High School	1056	531	590	1046	547	564
Orange High School	905	597	555	828	619	526
Polk High School	680	569	567	691	568	501
South Falls High School	898	602	488	904	584	461
Upper Hills High School	457	491	349	431	490	248
Washington High School	795	609	482	818	635	401
Grand Total	801	585	5916	796	603	5224

<tbody>
</tbody>

I now want to calculate if the average SAT_composite score for women (s_male=0) is statistically different than for men (s_male = 1).

I've been trying to figure this out and I am a little lost. Any help would be greatly appreciated. Thanks!

 

[DRSteele]

Statistics can be baffling. I think if you watch this video and the others in this large playlist on youtube from ExcelIsFun we might be able to figure how to test your hypothesis (i.e., SAT scores are statistically different between male homosapiens and female ones).

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://youtu.be/v7esBjWSAz4

playlist: [FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://www.youtube.com/watch?v=_UHVGyGT1GM&list=PLrRPvpgDmw0ngx_uPhvasTbOWLOztsaBj[/FONT]_{^{<strike>
</strike>}}[/FONT]