COVID-19 Data and Variation


Quick Links

SPC for Excel Software

Visit our home page

SPC Training

SPC Consulting

Ordering Information

Thanks so much for reading our publication. We hope you find it informative and useful. Happy charting and may the data always support your position.

Sincerely,

Dr. Bill McNeese
BPI Consulting, LLC

View Bill McNeese

Connect with Us

Comments (9)

  • Sergey Grigoryev, WWW.DEMING.PROApril 30, 2020 Reply

    Dear Dr. Bill,Thank you for this article written in simple and accessible language.With respect,Sergey Grigoryev<br />DEMING.PRO

  • P V Krishnam RajuApril 30, 2020 Reply

    good analysis

  • Arumuganainar MuthuramalingamApril 30, 2020 Reply

    Great control chart analysis!1) Number of New COVID-19 Cases per Day in the United States – Bad special causes noticed and unstable 2) Number of New COVID-19 Cases per Day in the United States with Control Limits Split – Eventhough cases per day higher but from 4.03.2020 no further hike and stable 3) % of Tests That are Positive for COVID-19 in the United States – Stared to decline and UCL and LCL too4) Number of New People Hospitalized Each Day in the United States Due to COVID-19 – 50% reduction from 19.04.2020 and stable 5) Number of Deaths per Day from COVID-19 in the United States – Deaths are high from 10.04.2020 but stable and out of control6) Number of New COVID-19 Cases per Day in Texas: On 9.04.2020 bad special cause and out of UCL, after that the status quo maintained.7) % of Tests That are Positive for COVID-19 in Texas : On 28.03.20 & 07.04.2020 two bad special causes and particularly 28.03.20 very high positive cases, however reducing trend noticed after 14.04.20208) Number of Deaths per Day from COVID-19 in Texas : Controlled but increased day by day, however hike controlled from 16.04.2020. Conclusion : After 15.04.2020, there is control in all aspects.

  • guido casadioApril 30, 2020 Reply

    Hi Dr Bill, I’m observing the figure N.5 about the death per day.”For the last part of the chart, the average number of deaths per day from COVID-19 is 1,876. The control limit range is 1,209 to 2,542. Note that the last two points are below the LCL. This is an indication that the number of deaths per day may be decreasing – in fact, you probably should set the control limits for the time period from 4/7 through 4/25 and use that baseline period to judge future decreases in the number of deaths. But the two points below the LCL are encouraging.”this part for me is not clear beacause in the last part of the chart I don’t see 2 points below the LCL.probably I’m not looking the right chart or I’m not looking in the right way, let me know.Guido Casadio

    • billApril 30, 2020 Reply

      Hello, yes we messed up on the chart and put the chart for Texas in twice;  Figure 5 should have been for the USA.  That has been corrected in the above.

  • Keith GreavesApril 30, 2020 Reply

    Really interesting data, charts and opinions but I’m a little confused by Figure 5: Number of Deaths per Day from COVID-19 in the United States.The narrative doesn’t appear to match the chart ?

    • billApril 30, 2020 Reply

      Thanks Keith, yes we put the chart for Texas in twice; we have corrected that.  Figure 5 should have been for the USA.  

  • Tom GauseAugust 24, 2020 Reply

    Hello, Bill! Thanks for the article. How did you manage to create a control chart with control lines on a slant like in Figure 2? I'm using Minitab. When I create the same graph, I get the image below, which clearly shows out-of-control data points. Is that a feature of SPC, by any chance?

Leave a Reply

Your email address will not be published. Required fields are marked *