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.
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.
.csv Download .csvand .txt Download .txtfiles
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:
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.)
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.