Choose and Analyze Crash Data
a. Choose three data types (columns) to analyze. Examples of data types includes: crash severity, weather conditions, location, or time.
b. Choose how you want to analyze the data using functionality learned
Choose and Analyze Crash Data
a. Choose three data types (columns) to analyze. Examples of data types includes: crash severity, weather conditions, location, or time.
b. Choose how you want to analyze the data using functionality learned in class. For example, you could use a function to determine minimum, maximum, frequency/count, mode, average, etc. of the data. Make the analysis meaningful.
i. The following sections of your Walkenbach textbook may be helpful:
1. Tables (ch. 5)
2. Pivot Tables (chs. 33, 34)
3. Hiding Rows and Columns (p. 66)
4. Printing Row and Column Titles (pp. 182-183)
5. Worksheet Function Reference (App. A)
4. Write a Memo Summarizing Your Analysis and Conclusions
a. Write a memo to the instructor that provides/includes the following:
i. Describe the highway segment, date range, and milepost range that you selected. Explain why you selected the segment.
ii. Describe the types of data that you analyzed and why.
iii. Explain how you 