1. Old Faithful is a cone-type geyser in Yellowstone Park in Wyoming. Old Faithful was named by the Washburn expedition of 1870. They were impressed by its size and frequency. It is not the biggest or most regular geyser in Yellowstone, but it is the biggest regular geyser. Furthermore, it has been erupting in nearly the same fashion throughout the recorded history of Yellowstone. Through the years, it has become one of the most studied geysers in the park. One result of this close observation is that the Park Rangers are able to predict its eruptions fairly accurately. This makes Old Faithful geyser one of the easiest geysers in Yellowstone to see.

TheOld_Faithful_Data.xls dataset lists eruption times and waiting times over two 8-day periods in 1978 and 1979. The Excel file contains 4 columns with the following information:

Column A: P = Period of Observation: 1 = August 1-8, 1978; 2 = August 16-23, 1979

Column B: D = day of the recordings in month (in August)

Column C: X = duration of the current eruption in minutes (data presented to nearest minute)

Column D: Y = waiting time until the next eruption in minutes (data presented to nearest 0.1 minute)

P	D	X	Y
1	1	78	4.4
1	1	74	3.9
1	1	68	4.0
1	1	76	4.0
1	1	80	3.5
1	1	84	4.1
1	1	50	2.3
1	1	93	4.7
1	1	55	1.7
1	1	76	4.9
1	1	58	1.7
1	1	74	4.6
1	1	75	3.4
1	2	80	4.3
1	2	56	1.7
1	2	80	3.9
1	2	69	3.7
1	2	57	3.1
1	2	90	4.0
1	2	42	1.8
1	2	91	4.1
1	2	51	1.8
1	2	79	3.2
1	2	53	1.9
1	2	82	4.6
1	2	51	2.0
1	3	76	4.5
1	3	82	3.9
1	3	84	4.3
1	3	53	2.3
1	3	86	3.8
1	3	51	1.9
1	3	85	4.6
1	3	45	1.8
1	3	88	4.7
1	3	51	1.8
1	3	80	4.6
1	3	49	1.9
1	3	82	3.5
1	4	75	4.0
1	4	73	3.7
1	4	67	3.7
1	4	68	4.3
1	4	86	3.6
1	4	72	3.8
1	4	75	3.8
1	4	75	3.8
1	4	66	2.5
1	4	84	4.5
1	4	70	4.1
1	4	79	3.7
1	4	60	3.8
1	4	86	3.4
1	5	71	4.0
1	5	67	2.3
1	5	81	4.4
1	5	76	4.1
1	5	83	4.3
1	5	76	3.3
1	5	55	2.0
1	5	73	4.3
1	5	56	2.9
1	5	83	4.6
1	5	57	1.9
1	5	71	3.6
1	5	72	3.7
1	5	77	3.7
1	6	55	1.8
1	6	75	4.6
1	6	73	3.5
1	6	70	4.0
1	6	83	3.7
1	6	50	1.7
1	6	95	4.6
1	6	51	1.7
1	6	82	4.0
1	6	54	1.8
1	6	83	4.4
1	6	51	1.9
1	6	80	4.6
1	6	78	2.9
1	7	81	3.5
1	7	53	2.0
1	7	89	4.3
1	7	44	1.8
1	7	78	4.1
1	7	61	1.8
1	7	73	4.7
1	7	75	4.2
1	7	73	3.9
1	7	76	4.3
1	7	55	1.8
1	7	86	4.5
1	7	48	2.0
1	8	77	4.2
1	8	73	4.4
1	8	70	4.1
1	8	88	4.1
1	8	75	4.0
1	8	83	4.1
1	8	61	2.7
1	8	78	4.6
1	8	61	1.9
1	8	81	4.5
1	8	51	2.0
1	8	80	4.8
1	8	79	4.1
2	16	82	4.1
2	16	80	4.2
2	16	76	4.5
2	16	56	1.9
2	16	82	4.7
2	16	47	2.0
2	16	76	4.7
2	16	61	2.5
2	16	75	4.3
2	16	72	4.4
2	16	74	4.4
2	16	69	4.3
2	16	78	4.6
2	16	52	2.1
2	17	91	4.8
2	17	66	4.1
2	17	71	4.0
2	17	75	4.0
2	17	81	4.4
2	17	77	4.1
2	17	74	4.3
2	17	70	4.0
2	17	83	3.9
2	17	53	3.2
2	17	82	4.5
2	17	62	2.2
2	17	73	4.7
2	17	84	4.6
2	18	58	2.2
2	18	82	4.8
2	18	77	4.3
2	18	75	3.8
2	18	77	4.0
2	18	77	4.1
2	18	53	1.8
2	18	75	4.4
2	18	78	4.0
2	18	51	2.2
2	18	81	5.1
2	18	52	1.9
2	18	76	5.0
2	18	73	4.4
2	19	84	4.5
2	19	72	3.8
2	19	89	4.3
2	19	75	4.4
2	19	57	2.2
2	19	81	4.8
2	19	49	1.9
2	19	87	4.7
2	19	43	1.8
2	19	94	4.8
2	19	45	2.0
2	19	81	4.4
2	19	59	2.5
2	19	82	4.3
2	20	80	4.4
2	20	54	1.9
2	20	75	4.7
2	20	73	4.3
2	20	57	2.2
2	20	80	4.7
2	20	51	2.3
2	20	77	4.6
2	20	66	3.3
2	20	77	4.2
2	20	60	2.9
2	20	86	4.6
2	20	62	3.3
2	20	75	4.2
2	20	67	2.6
2	20	69	4.6
2	21	84	3.7
2	21	58	1.8
2	21	90	4.7
2	21	82	4.5
2	21	71	4.5
2	21	80	4.8
2	21	51	2.0
2	21	80	4.8
2	21	62	1.9
2	21	84	4.7
2	21	51	2.0
2	21	81	5.1
2	21	83	4.3
2	21	84	4.8
2	22	72	3.0
2	22	54	2.1
2	22	75	4.6
2	22	74	4.0
2	22	51	2.2
2	22	91	5.1
2	22	60	2.9
2	22	80	4.3
2	22	54	2.1
2	22	80	4.7
2	22	70	4.5
2	22	60	1.7
2	22	86	4.2
2	22	78	4.3
2	23	51	1.7
2	23	83	4.4
2	23	76	4.2
2	23	51	2.2
2	23	90	4.7
2	23	71	4.0
2	23	49	1.8
2	23	88	4.7
2	23	52	1.8
2	23	79	4.5
2	23	61	2.1
2	23	81	4.2
2	23	48	2.1
2	23	84	5.2
2	23	63	2.0

1. Import the Excel file into SPSS

1. Add a brief description for each of the columns

1. Label the values in the 1st column (P)

1. Save the data as an SPSS file (geyser.sav) and provide the SPSS code that is generated in the Output window. You can save the output window by going to the output window and clicking on the"Save" icon in the upper left hand corner.

1. Identify the type of variable in each of the 4 columns