Assignment
1. Data Creation and Manipulation. Using the data available, create the following variables. Do not include any of these answers in your submission.
a. Categorical variables (not dummy variables!) for month, day of month, day of week, hour, and minute
b. A variable that reflects the inter-arrival times of patients (time between successive arrivals)
2. Data Description. The following questions require you to describe certain aspects of the data. For each part of this question, copy the requested results from your Excel workbook and paste it into your Word document AS A PICTURE! Do not embed any Excel data into your Word document, and do not provide a copy of (any part of) the data itself.
a. Construct a table showing the average number of patients that arrive on each day of the week (i.e., on Sunday, Monday, ..., Saturday).
b. Plot the average inter-arrival times over the 24 hour period (x-axis) for each day of the week (i.e., each day of the week is a separate line on a common plot).
Assignment
1. Data Creation and Manipulation. Using the data available, create the following variables. Do not include any of these answers in your submission.
a. Categorical variables (not dummy variables!) for month, day of month, day of week, hour, and minute
b. A variable that reflects the inter-arrival times of patients (time between successive arrivals)
2. Data Description. The following questions require you to describe certain aspects of the data. For each part of this question, copy the requested results from your Excel workbook and paste it into your Word document AS A PICTURE! Do not embed any Excel data into your Word document, and do not provide a copy of (any part of) the data itself.
a. Construct a table showing the average number of patients that arrive on each day of the week (i.e., on Sunday, Monday, ..., Saturday).
b. Plot the average inter-arrival times over the 24 hour period (x-axis) for each day of the week (i.e., each day of the week is a separate line on a common plot).