Part 1:Two Sample Testing using Excel

Open the Excel Spreadsheet Lab 7 - Data from Blackboard with data for this lab.

WPM without Dog	WPM with dog			Female study hrs/wk	Male study hrs/wk
90	94			16	10
100	106			18	20
110	112			14	12
107	106	p-value		21	18	p-value
125	123			30	8
96	101			22	27
119	130			12	6
135	148			26	10
126	132			10	15
155	154			12	22
86	95			22
113	126			26
116	130			28
120	121			34
134	130			28
128	126

Experiment 1:

Data was collected from a random sample of 16 third grade children reading without and then with a dog, to see if reading to a dog improves the average reading speed. We want to rest if reading with dog had more words per minute (wpm). It can be assumed that the reading speeds of the third graders are normally distributed. See Excel spread sheet for data and test the claim at a 0.01 level of significance.

Let