I have concentration of a drug in one column and binary outcome ( 0 or 1) in another column. When plotting the concentration on a graph, I want to have a square mark for 1 in outcome column and circle mark for 0 in outcome column.
I am attaching a snapshot of graph and sample data in excel. In the final analysis, I require sum of average concentration of cross over pairs of outcomes 1 and 0 as depicted in the graph. An excel macro would of great help in addition having such graph.