Data Set Antibiotics Case Study Assignment

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

	Antibiotics
Bacteria	Penicilin	Streptomycin	Neomycin	Gram Staining
Aerobacter aerogenes	870	1	1.6	Negative
Brucella abortus	1	2	0.02	Negative
Brucella anthracis	0.001	0.01	0.007	Positive
Diplococcus pneumoniae	0.005	11	10	Positive
Escherichia coli	100	0.4	0.1	Negative
Klebsiella pneumoniae	850	1.2	1	Negative
Mycobacterium tuberculosis	800	5	2	Negative
Proteus vulgaris	3	0.1	0.1	Negative
Pseudomonas aeruginosa	850	2	0.4	Negative
Salmonella (Eberthella) typhosa	1	0.4	0.008	Negative
Salmonella schottmuelleri	10	0.8	0.09	Negative
Staphylococcus albus	0.007	0.1	0.001	Positive
Staphylococcus aureus	0.03	0.03	0.001	Positive
Streptococcus fecalis	1	1	0.1	Positive
Streptococcus hemolyticus	0.001	14	10	Positive
Streptococcus viridans	0.005	10	40	Positive

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 are free to use any graphics or charting tool –including drafting it by hand. Go to  Useful Resources   Download Useful Resources provided by the instructor for a list of visualization tools. You may find it most instructive to create the chart from scratch using Excel or a graphics API of your choice.

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 and name it as M4_VisDesign, 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 lose the 20 points for not including the individual image file.