document.write( "<A HREF=/cgi-bin/jump-to-question.mpl?question=142549>Question 142549</A>: <I><SPAN STYLE=\"word-break: break-all;\"> Exercise using Excel									<BR>\n" );
document.write( "									<BR>\n" );
document.write( "The School Committee members of a midsized New England city agreed that a strict									<BR>\n" );
document.write( "discipline code has caused an increase in the number of student suspensions.  The 									<BR>\n" );
document.write( "number of suspensions for September 1992 - February 1993 for a sample of the schools is provided below. {Data}									<BR>\n" );
document.write( "The average number of suspensions for the previous year  mean{X bar}  = 130.5 and the Standard deviation {STDEV}									<BR>\n" );
document.write( "was 158.2									<BR>\n" );
document.write( "(a)  Set up the null and alternative hypothesis to test if the averave number of suspensions									<BR>\n" );
document.write( "has changed.									<BR>\n" );
document.write( "(b)  Test your hypothesis with alpha = 0.05.									<BR>\n" );
document.write( "(c)  Find the p value.									<BR>\n" );
document.write( "(d)  Display the data in an Excel Chart to see if it is reasonable to assume that the underlaying population 									<BR>\n" );
document.write( "distribution is normal.									<BR>\n" );
document.write( "(e)  Based on the p value, what can you conclude about the average number of suspensions?									<BR>\n" );
document.write( "									<BR>\n" );
document.write( "									<BR>\n" );
document.write( "Data:									<BR>\n" );
document.write( "	Suspensions								<BR>\n" );
document.write( "Central	245				a) - c)  mu   = 195				<BR>\n" );
document.write( "MCDI	1		Step 1	H(0)  mean  equal 		130.5			<BR>\n" );
document.write( "Chestnut	65			H(A)  mean  not equal		130.5			<BR>\n" );
document.write( "Duggan	133			Sigma is given as = 158.2					<BR>\n" );
document.write( "Kennedy	97		Step 2	Critical Values (Z) = +/-1.96 because alpha is 0.05					<BR>\n" );
document.write( "Forest Park	149					(n)^0.5	Z	P(Z<-1.352)	p = 2*P(Z<-1.352) = 2*0.0885<BR>\n" );
document.write( "Putnam	1024		Step 3	Test Statistic Z  		3.317		Calculate Z here in cell H25.	<BR>\n" );
document.write( "Kiley	56			p value = 	0.177				<BR>\n" );
document.write( "Central Academy	254						Why is Z minus?  		<BR>\n" );
document.write( "Commerce	114		Step 4/5	d)  See Below.					<BR>\n" );
document.write( "Bridge	7			e)  What do you think?					<BR>\n" );
document.write( "STDEV=	287.15								<BR>\n" );
document.write( " mu = 		195.00							<BR>\n" );
document.write( "									<BR>\n" );
document.write( "	ReOrder								<BR>\n" );
document.write( "MCDI	1								<BR>\n" );
document.write( "Bridge	7								<BR>\n" );
document.write( "Kiley	56								<BR>\n" );
document.write( "Chestnut	65								<BR>\n" );
document.write( "Kennedy	97								<BR>\n" );
document.write( "Commerce	114								<BR>\n" );
document.write( "Duggan	133								<BR>\n" );
document.write( "Forest Park	149								<BR>\n" );
document.write( "Central	245								<BR>\n" );
document.write( "Central Academy	254								<BR>\n" );
document.write( "Putnam	1024								<BR>\n" );
document.write( " </SPAN>\n" );
document.write( "</I><HR><TABLE width=100%><TR><TD><B><A HREF=http://www.algebra.com/>Algebra.Com's</A> Answer #103767 by </B><A HREF=/tutors/aboutme.mpl?userid=stanbon><B>stanbon(75887)</B></A><img src=\"/images/stars/stars-13.gif\" alt=\"\" >&nbsp;<A HREF=/tutors/aboutme.mpl?userid=stanbon><IMG SRC=http://www.algebra.com/images/aboutme-small.gif BORDER=0 alt=\"About Me\" VALIGN=MIDDLE></A>&nbsp;<IMG SRC=http://www.algebra.com/images/nopicture.jpg><BR>You can <A HREF=\"/cgi-bin/embed-solution.mpl?show=1&solution=103767\">put this solution on YOUR website!</A><BR><SPAN STYLE=\"word-break: break-all;\"> The School Committee members of a midsized New England city agreed that a strict <BR>\n" );
document.write( "discipline code has caused an increase in the number of student suspensions. The number of suspensions for September 1992 - February 1993 for a sample of the schools is provided below. {Data} <BR>\n" );
document.write( "The average number of suspensions for the previous year mean{X bar} = 130.5 and the Standard deviation {STDEV} was 158.2 <BR>\n" );
document.write( "---------------------------------------<BR>\n" );
document.write( "(a) Set up the null and alternative hypothesis to test if the average number of suspensions has changed.<BR>\n" );
document.write( "Ho: u = 130.5<BR>\n" );
document.write( "H1: u is not equal to 130.5\r<BR>\n" );
document.write( "\n" );
document.write( "--------------------------------------- <BR>\n" );
document.write( "(b) Test your hypothesis with alpha = 0.05. <BR>\n" );
document.write( "Critical values for 2-tail test with alpha = 5%: z = +-1.96<BR>\n" );
document.write( "Test statistic: z(195) = (195-130.5)/[158.2/sqrt(10)] = 1.2893...<BR>\n" );
document.write( "---------------------------------------<BR>\n" );
document.write( "(c) Find the p value. <BR>\n" );
document.write( "p-value = 2*P(1.2893 < z < 10) = 0.1973<BR>\n" );
document.write( "-----------------------------------------<BR>\n" );
document.write( "(d) Display the data in an Excel Chart to see if it is reasonable to assume that the underlaying population distribution is normal. <BR>\n" );
document.write( "I'll leave that to you.<BR>\n" );
document.write( "-----------------------------<BR>\n" );
document.write( "(e) Based on the p value, what can you conclude about the average number of suspensions?<BR>\n" );
document.write( "The p value is greater than 5% so fail to reject Ho. <BR>\n" );
document.write( "The average number of suspensions has not changed.<BR>\n" );
document.write( "================<BR>\n" );
document.write( "Cheers,<BR>\n" );
document.write( "Stan H.<BR>\n" );
document.write( " </SPAN>\n" );
document.write( "</TD></TR></TABLE>\n" );