Discuss the below:
Average time it takes to process applications
Office 1 Office 2 Office 3
Employee 1 15 11 17
Employee 2 17 21 15
Employee 3 14 12 17
Employee 4 16 27 16
Excel Output -
Anova: Single Factor
SUMMARY
Groups Count Sum Average Variance
Column 1 4 62 15.5 1.666667
Column 2 4 71 17.75 58.25
Column 3 4 65 16.25 0.916667
ANOVA
Source of Variation SS df MS F Between Groups 10.5 2 5.25 0.258904 P-value 0.777455
F crit 4.256492
Within Groups 182.5 9 20.27778
Total 193 11
Q1) What does the F crit mean?
Q2) What numbers represent the SST, SSE and SS Total?
Q3) What does the P-value number mean?
Q4) How do the F and F crit relate to each other? What do these numbers mean?
5) Re-run an ANOVA in Excel and determine if the average processing times between workers (employees are in rows) are the same or different.