Rick,
I will get this information if still needed, but I played around with the data over the weekend and maybe I've solved my issue. I am hoping to get confirmation that things are as they should be. Let me list my findings.
1. WHen I first posted this issue, I was running two EG session. My understanding was that they had two different work spaces, but maybe that was the cause of my unreplicating results. When I have only one EG sessions, rerunning the shewhart gives the same results.
2. The results in (1) are missing some values of mpin. Is that normal?
3. If close and reopen EG, running the DB query to get the data and then rerunning shewhart gives me different results. The database is static. The counts for the DB query match each time.
4. (3) led me to believe my results are dependent on the order the data is in. Previously I only had the data sorted by mpin. When I sort the data by mpin and yearmo I get the same results every time. It doesn't matter if I repull the data from the database or not. I can close and reopen EG; still the same results. It also now contains all of the values for mpin. However, the output is around 3M rows when previously they were around 63M.
When I was reading about shewhart I did not think I needed to sort by yearmo. Was that mistake by me?
... View more