1.  After opening Rockwood Mortality & Cost.xlsx, click on the Data tab near the top of the screen and select Data Analysis.

2. You will see the option for three different t-tests.

3. Excel does not allow you to test for homogeneity of variances; therefore, you must make an assumption. If you are unsure whether your variances are equal, it is always better to be a little more conservative and use the assumption of unequal variances. In this case, choose t-test: Two-Sample Assuming Unequal Variances.

4. To test for a difference in the morality raw gain, fill in the data as shown in the box below:

Variable 1 range has the cells G3 through G6. These represent the raw mortality gain scores for the alternative delivery service group. Variable 2 range is the array that you are comparing array 1 against. In this case, cells G7 through G10, represent the raw mortality gain scores for the traditional service delivery group. Clicking on output range allows you to place the output within the worksheet.

Submit your work and answer the following questions :

1. Upload your "Independent samples t-test" output table here using the upload option.

2. One of the assumptions of the t-test is that the variable from which the mean is calculated must be normally distributed. Under what conditions can this assumption be violated?

3. Refer to your t-test output table, do traditional delivery fire stations in the Rockwood Fire Department have statistically different mortality and cost-per-call gain scores than alternative delivery stations?

Station	Method of Delivery	Mortlaity Rate in 2010	Mortality Rate in 2011	Cost in 2010 (hundreds of thousands)	Cost in 2011 (hundreds of thousands)	Mortality Raw Gain	Cost Raw Gain
1	Alternative	7	4.56	3.23	2.98	-2.44	-0.25
2	Alternative	5.23	4.34	2.45	2	-0.89	-0.45
3	Alternative	3.98	3.54	1.68	1.32	-0.44	-0.36
4	Alternative	4.12	3.98	2.43	1.89	-0.14	-0.54
5	Traditional	6.12	6.06	3.23	3.22	-0.06	-0.01
6	Traditional	5.54	4.98	2.45	2.4	-0.56	-0.05
7	Traditional	5.76	3.75	2.68	2.65	-2.01	-0.03
8	Traditional	4.21	4.23	3.12	3.08	0.02	-0.04