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 analyzed the data (give specific examples/descriptions of the functions that you used).
iv. Summarize the conclusions from your analysis.
v. Attach a PDF printout of the Excel file with the data and your analysis to your memo. Format the table so that it is user-friendly to review and focuses on the relevant data. Some formatting suggestions are provided below:
1. Format the table using Excel’s built in styles
2. Hide columns with unnecessary information
b. Make sure to follow the memo formatting guidelines when drafting and
|$15.00||Business, Business||Proff-bit||0 time(s)|