Complete all questions below using Tableau and the armc_100k data set. Turn in this document with your written answers to the questions (in red) and your Tableau files. The bonus question for this micro exam can be found at the end of this file. This is not a timed test, but an assignment.

Encounters and Providers

Setup:

1. Connect Encounters to Providers
2. Save the file as Encounters_Providers

Problem 1 (10 points):

1. Create a new worksheet named P1
2. Rows: Admit Date (year level)
3. Label: encounters (Count)
4. Set chart type to Horizontal Bars
5. Sort by Year of Admit Date descending (hover over the Year of Admit Date column name and click the sort icon until it is descending) from top to bottom: 2014-1960

• Question: Why is 2014 so much shorter than the previous 10+ years? Hint: there is an objective justification associated with time.

Problem 2 (10 points):

1. Duplicate worksheet P1 and name is P2
2. Go to Analytics and drop a Trend Line on the chart (drag over chart and drop on Polynomial)

• Question: What do you notice about the trend line?

Problem 3 (10 points):

1. Duplicate worksheet P2 and name is P3

1. Remove 2014 (right-click on YEAR(Admit Date) in Rows and select show Show Filter)

• Question: What was the effect on the trend line?

• Question: Which trend line (Problem 2 or 3) best represents the data and why?

Problem 4 (10 points):

1. Duplicate worksheet P1 and name is P4
2. Drag Gender to Color
3. Set CNT(encounters) in Columns as follows (drop-down arrow):
   1. Quick Table Calculation: Percent of Total
   2. Compute using: Table (across) the bars should be full width with % for the x-axis

• Question: What trend, if any, do you notice?

Medications and Patients

Setup:

1. Connect Patients, Medications, and Medication_Types
2. Save the file as Patient_Medications

Problem 1 (10 points):

1. Create a new worksheet named P1
2. Double-click Zip and change marks from Automatic to Map
3. Drag patient (Count) to Color
4. Drag Class to Filters and do a Wildcard filter for BETA BLOCKERS (exactly as is)
   1. Select Contains
   2. Uncheck Include all values when empty

• Question: Which zip code has the highest count?

Encounters and Patients

Setup:

1. Connect Encounters and Patients
2. Save the file as Encounters_Patients

Problem 1 (10 points):

1. Create a new worksheet named P1
2. Columns: Bp Diastolic set to Dimension
3. Rows: Bp Systolic set to Dimension
4. Ensure the plot is a scatter plot
5. Change mark to Density
6. Change color to Density Gray-Red Light
7. Go to Analytics and drag Median with Quartiles on to the chart then onto Table

• Question: What is the median BP?

Problem 2 (10 points):

1. Create a new worksheet named P2
2. Duplicate Problem 1 except set:
   1. Columns: Height as dimension (NOTE: this value is recorded in inches)
   2. Rows: Weight as dimension (NOTE: this value is recorded in pounds)

• Question: What is the median height and weight?

1. Drop an exponential trend line on the chart.

• Question: Does the trend line fit the data? What is the p-value of the line (hover over the line)?

Bonus

Build any visualization you want and answer the following questions (10 points).

• Question: Why did you build this visualization and what does it mean?