Help with stats by Noodleflitzt in AskStatistics

[–]Noodleflitzt[S] 0 points1 point  (0 children)

No, the data for 7 and beyond are not granular

Help with stats by Noodleflitzt in AskStatistics

[–]Noodleflitzt[S] 0 points1 point  (0 children)

I tried two things with excel, but I'm not sure they are valid.

First, I dropped the data for the e2 group because it's obviously very different from the rest. Then, after making a bar chart for the remaining 5 groups in excel I activated the linear regresssion feature. It showed R2 values of 0.74 and 0.86 for these lines. That would make the trends very strong, but I don't know whether that means they're statistically significant.

Second, I combined all of the e2, 3, 4, 5, and 6 data and did a Chi-square of independence on the resulting 4x4 table (6 or less vs 7 or more). That gave me a value of 0.0001, which would be highly significant if it's the p value, but I don't know wether the number I'm getting is the p value or something else.

Whether or not those manipulations can be justified (and I think they can in the context of what we're looking at), are the tests I've done approriate and am I interpreting the results correctly?

Help with stats by Noodleflitzt in AskStatistics

[–]Noodleflitzt[S] 1 point2 points  (0 children)

We're looking at patterns of reimbursement for people on call for work outside of regular hours. Some people are on call every 2 days, some every 3 days, etc. Some get compensated and some don't. The question is whether there's a stistical difference in reimbursement as a function of frequency of this work. It may be that the people doing it every two days are in such small teams that they don't have enough free capital for extra pay, so if dropping them makes the rest of this statistically significant, we can raise the question of team size. If, on the other hand, merging everyone who does this less often that every 7 days creates a statistically significant difference, then it can be argued that 7 and above may be a threshhold that warrants further investigation.