Question

• Use Excel’s ToolPak to compute One-Way ANOVA and submit your statistical output.
• Are there significant salary differences between the four departments? Please provide evidence to support your conclusion.

Dept. 1	Dept. 2	Dept. 3	Dept. 4
$32,782	$35,467	$23,654	$65,487
$32,920	$35,468	$36,578	$46,184
$29,548	$29,876	$37,548	$54,899
$39,828	$43,674	$53,234	$34,869
$31,528	$36,431	$54,679	$35,487
$38,985	$26,578	$47,536	$26,548
$41,889	$36,571	$31,425	$34,231
$38,791	$56,326		$39,331
$28,985			$36,512
$24,749			$68,425
			$36,487
			$34,632
			$46,211
			$51,698
			$69,246
			$48,695
			$34,987
			$35,631
			$39,743
			$41,255
			$26,452

Answer 1

Following steps need to be followed:

Step 1: Put the data onto the excel spreadsheet

Step 2: Go to data --> data analysis --> ANOVA: Single factor

Step 3: Select the data and get the output

Conclusion:

SInce the p value (0.1598) is more the the assume significance value of 0.05. There is no significant difference between the salary of the four departments