Template talk:COVID-19 pandemic data/United States medical cases/Michigan

This template is within the scope of WikiProject COVID-19, a project to coordinate efforts to improve all COVID-19-related articles. If you would like to help, you are invited to join and to participate in project discussions.COVID-19Wikipedia:WikiProject COVID-19Template:WikiProject COVID-19COVID-19 articles

Michigan: Detroit

	Michigan portal This template is within the scope of WikiProject Michigan, a collaborative effort to improve the coverage of the U.S. state of Michigan on Wikipedia. If you would like to participate, please visit the project page, where you can join the discussion and see a list of open tasks.MichiganWikipedia:WikiProject MichiganTemplate:WikiProject MichiganMichigan articles
	This template is supported by the Detroit task force.

Vaccination Info

Shouldn't vaccination info be on here if possible? — Preceding unsigned comment added by 12.165.188.175 (talk) 17:30, 19 March 2021 (UTC)[reply]

As a reader, I'd be interested in seeing vaccination statistics, in addition to positivity rate and number of hospitalizations. Vaccination statistics would be a little tricky to graph, with a decision needing to be made on graphing number of shots, people halfway to being vaccinated (Pfizer or Moderna but only one shot) as well as people fully vaccinated (Pfizer or Moderna with 2 shots, or a 1 shot vaccine like J&J). I think a single graph showing people half and fully vaccinated might be the best. A source for an unrounded daily breakdown of whatever number(s) are graphed would be needed. The currently commonly used clickondetroit.com articles don't always show this, if ever. Their source https://www.michigan.gov/coronavirus/ doesn't seem to give vaccination figures, either. Darlingm (talk) 16:17, 20 April 2021 (UTC)[reply]

Splitting Sunday/Monday Cumulative Figures Into An Average Across 2 Days

It frustrates me the State started only publishing cumulative figures for Sunday/Monday. With the way these are currently graphed, it introduces more spikes on the chart than there really are, which presumably is missed by most readers, not knowing every 7th day is missing. I think it would be better to list both dates, and give each date the average. Darlingm (talk) 16:20, 20 April 2021 (UTC)[reply]

With the State now only updating on Tuesdays and Fridays, I think it's even more important to spread their cumulative figures across daily averages. The charts are about to become even more misleading, showing an apparent spike in cases due to each point now covering half a week. Accurate comparisons can only be made in the graph within the three periods the State has now had on reporting schedules. Darlingm (talk) 22:08, 8 July 2021 (UTC)[reply]

I converted the chart data to be on a per day basis. The numbers shown in the charts is now the number of new cases and deaths, divided by the number of days in each reported batch, rounded. It would be easy to also chart the number of cases and deaths reported for the batch as a third set of data, however comparing those numbers to each other is like comparing apples and oranges, so I replaced it rather than just added a new data set. The conversion was done by copy/paste and a spreadsheet, so there's basically no chance of human error in the calculations. If any time consuming changes are desired to be made, please feel free to let me know, as I have everything loaded a the spreadsheet and can perform calculations quickly. Darlingm (talk) 19:47, 29 November 2021 (UTC)[reply]

I am less decided on if the tabular data should be updated, and if so, if it should only show the per day amounts or show the total reported and the per day amounts. I don't want to unnecessarily clutter the table. Darlingm (talk) 19:47, 29 November 2021 (UTC)[reply]

I am thinking about if there's anything that can easily be done for the 7 day averages. Although I think a trendline is very useful, even though the proper 7 day average can be computed, a lot of the reported batches cover 4-5 days now, so a lot of the 7 day averages would be a weighted average for 2 reported batches. I'm leaning toward removing the 7 day trend data as of when Michigan started reporting multiple days in batches -- to remove the inaccurate trendline at the end, where it doesn't reflect the actual data. Darlingm (talk) 19:47, 29 November 2021 (UTC)[reply]

Consolidating references

The State of Michigan (1) and the CDC (2) both provide this data in centralized locations. Switching to one of those may be easier for editors to maintain and easier for readers to navigate than citing 500 different local news stories and leading WP:MOSTREFS.

Here's what that might look like: User:Ductwork/Michigan_data Ductwork (talk) 21:25, 22 June 2022 (UTC)[reply]