Background: In this assignment, you will design a visualization for a small data set and provide a rigorous rationale for your design choices. You should in theory be ready to explain the contribution of every pixel in the display.

Data Set: Antibiotics

After the World War II, antibiotics were considered as "wonder drugs", since they were easy remedy for what had been intractable ailments. To learn which drug worked most effectively for which bacterial infection, performance of the three most popular antibiotics on 16 bacteria were gathered.

Table 1: Burtin’s data

I HAVE ATTACHED THE FILE OF THE TABLE!!

The values in the table represent the minimum inhibitory concentration (MIC), a measure of the effectiveness of the antibiotic, which represents the concentration of antibiotic required to prevent growth in vitro. The reaction of the bacteria to Gram staining is described by the covariate “gram staining”. Bacteria that are stained dark blue or violet are Gram-positive. Otherwise, they are Gram-negative.

Dataset:

.csv Download .csvand .txt Download .txtfiles

Assignment

Your task is to design a static (i.e., single image) visualization that you believe effectively communicates the data (20 points) and provide a short write-up (no more than 2 pages long) describing your design (60 points).

You may find it most instructive to create the chart from scratch using Excel or Tableau Public.

PLEASE TRY TO DO IT ON EXCEL OR TABLEAU PUBLIC!!

While you must use the data set given, note that you are free to transform the data as you see fit. You are also free to incorporate external data as you see fit. Your chart image should be interpretable without looking at your short write-up. Appropriate title, axis labels or legends are needed.

The write-up should include but not limited to the following components:

• Describe how your created the visualization, what software was used, any external data used, the steps you took to create the visualization etc. (10 points)
• Tell the story of the figure. In the big picture, what story (or stories) are you trying to tell?  (10 points)
• Justification of visual encodings. Use the what-how-why framework to analyze your vis. Data: What are data and dataset types? Encodings: marks and channels used? Tasks: What are tasks of your vis? (20 points)
• Effectiveness of visualization. In your write-up, you should provide a rigorous rationale for your design Document the visual encodings you used and why they are appropriate for the data. These decisions include the choice of chart type, size, color, scale, and other visual elements, as well as the use of sorting or other data transformations. How do these decisions facilitate effective communication? Any pros or cons of design? (20 points)

The writing quality of the report will also be evaluated in grading. Please proofread your submission before submitting it and make sure it is free of spelling and grammar issues. (10% of the grade.)

Submission Instructions:

Save the write-up as a Word file ,save the visualization as an image format (PNG or JPEG). Submit both files.

If you only include the image inside the Word file, you will lost the 20 points for not including the individual image file.