Tools don’t fail us; we fail to set them up for success. Any stats package will happily scramble your analysis if you paste unlabeled columns and hope for the best. Try this instead: keep tidy data, and dependent-variable columns and numeric factor columns with human-readable labels (e.g., “1=High-Impact, 2=No-Impact, 3=Personal Baseline”). Before any test, run Descriptives and sanity-check Ns, means, SDs against your source sheet. If they’re off, stop. Fix the plumbing. When the F-test clears the gate, choose only what you need: the one-way ANOVA, effect size, and (if the test is significant) the specific post-hoc you intend to interpret. Minimal clicks reduce maximum confusion. Your future self, working at 11:30 pm, will thank you for those labels and that efficient, readable stats output. “Slow is smooth, smooth is fast” applies to stats, too.
