Chapter 11 Exercises: Exact Time Series Analysis
First, you will be creating a chart of the exact times of cases in a given pattern. In the Time Series Tables and
Charts tab, complete the table with the appropriate values of military time and the rounded values. Then
complete the table with the appropriate counts for each hour (number of cases with times falling in that hour).
Next, go to the Day of Week Table and Chart tab, highlight the table to create a column chart of the exact day of
week analysis. Format and print out the chart to turn it in.
Finally, go to the Time of Day Day of Week tab, and complete the table with the appropriate counts from the data
matrix for both time of day and day of week. Once that is complete highlight the count table and create a 2-D
surface chart depicting both the time of day/day of week chart. Format and print out the chart to turn it in.
Case Time of Occurrence Military Time Rounded Hour of Day
1 9:10 PM 21:10 2100 to 2159 0000 to 0059
2 8:02 PM 0100 to 0159
3 9:33 PM 0200 to 0259
4 11:45 PM 0300 to 0359
5 12:21 AM 0400 to 0459
6 7:35 AM 0500 to 0559
7 12:36 PM 0600 to 0659
8 6:45 PM 0700 to 0759
9 10:38 PM 0800 to 0859
10 11:56 PM 0900 to 0959
11 2:31 AM 1000 to 1059
12 4:55 AM 1100 to 1159
13 1:02 AM 1200 to 1259
14 1:14 PM 1300 to 1359
15 3:22 AM 1400 to 1459
16 5:48 AM 1500 to 1559
17 5:01 AM 1600 to 1659
18 9:11 AM 1700 to 1759
19 7:00 PM 1800 to 1859
20 5:55 PM 1900 to 1959
21 3:21 AM 2000 to 2059
22 8:24 PM 2100 to 2159
23 9:15 PM 2200 to 2259
24 7:16 PM 2300 to 2359
25 10:45 PM
26 7:46 PM
27 11:22 PM
28 11:16 PM
29 6:25 PM
30 9:56 PM
Count
Day of the Week Count
Sun 11
Mon 2
Tue 1
Wed 8
Thu 2
Fri 4
Sat 2
Case Time of Occurrence Day of Occurrence Hour of the Day Sun Mon Tue Wed
1 9:10 PM Thursday 0000 to 0059
2 8:02 PM Wednesday 0100 to 0159
3 9:33 PM Thursday 0200 to 0259
4 11:45 PM Sunday 0300 to 0359
5 12:21 AM Friday 0400 to 0459
6 7:35 AM Wednesday 0500 to 0559
7 12:36 PM Sunday 0600 to 0659
8 6:45 PM Friday 0700 to 0759
9 10:38 PM Saturday 0800 to 0859
10 11:56 PM Tuesday 0900 to 0959
11 2:31 AM Wednesday 1000 to 1059
12 4:55 AM Wednesday 1100 to 1159
13 1:02 AM Wednesday 1200 to 1259
14 1:14 PM Saturday 1300 to 1359
15 3:22 AM Friday 1400 to 1459
16 5:48 AM Sunday 1500 to 1559
17 5:01 AM Sunday 1600 to 1659
18 9:11 AM Wednesday 1700 to 1759
19 7:00 PM Sunday 1800 to 1859
20 5:55 PM Friday 1900 to 1959
21 3:21 AM Wednesday 2000 to 2059
22 8:24 PM Sunday 2100 to 2159
23 9:15 PM Sunday 2200 to 2259
24 7:16 PM Wednesday 2300 to 2359
25 10:45 PM Sunday
26 7:46 PM Sunday
27 11:22 PM Thursday
28 11:16 PM Sunday
29 6:25 PM Thursday
30 9:56 PM Sunday
Thu Fri Sat