How to Make a Convincing VAERS Graph

vaerstotaladversereactions_2021_september_27.png

A warning. This corresponds to U.S. data. I think it might be interesting to see the same data on the Sinopharm injection which is a conventional vaccine.

  1. Download the vaers data set.
    45ed8e92a7400fbfeab70f8512e9c1edf066168c46266fb6ce431063f4c9a8db AllVAERSDataCSVS.zip

  2. Put the zip file into a new directory

  3. Open the command line where the zip file is and issue:
    unzip AllVERSDataCSVS.zip
    wc -l VAERSVAX.csv

  4. Use the numbers given will look like this.

  5. Open a spreadsheet and fill series in the column A in order to fill in all of the years according to how far back you wish to go. image.png

  6. Copy the numbers from the list given to you at the command line into the spreadsheet for column B1.
    image.png

  7. Set the 2021 value to zero.

  8. Click on the chart icon
    image.png

  9. Choose bar graph and click Next.
    image.png

  10. Modify the data range not include the A column. It should only be the B column with all of the data. In this case "$Sheet1.$B$1:$B$21"

  11. Click the icon on the far left of the word "Categories" and select the years you generated with fill series.
    image.png

  12. Now, it looks like you're back to square one. You're not. Click Next.

  13. Fill in title, Y-axis and X-axis. Y-axis should be the number of adverse reactions. X-axis should be year. Uncheck "Display Legend". Click Finish.

  14. Now you have a graph with the 2021 data missing.
    image.png

  15. Copy the image of this graph into GIMP.

  16. In Gimp use the measure tool to figure out the linear ratio between the number of adverse reactions and pixels. Here I found that measuring 60,000 adverse reactions was 172 pixels. So 59000 reactions should be represented with 1703 pixels.

  17. In Gimp use Image->Canvas Size to resize the image. It should be 1700 pixels high. Use selections with rectangles and fill in tool to add the 2021 data. Due to our calculations we have to make this rectangle about the right width of 10 pixels wide but 1700 pixels high! Look at how high it gets off the chart!

1 These will be off by one. Generally speaking, you should subtract one when numbers are small enough to matter.

5 коментарів