Excel Exercise 3: Instruction: Ensure that your spread sheet is logically laid out and the information...

Transcribed Image Text:

Excel Exercise 3: Instruction: Ensure that your spread sheet is logically laid out and the information it presents is clear and understandable. The internal audit department of ITI Corporation set up an anonymous hotline for reporting suspected internal control breaches. After receiving several tips through the hotline alleging breaches in ITTs purchasing Department, internal auditors decided to investigate. The collected the following data on purchases orders issued in March 2018. Internal auditors suspect that purchase orders issued in the last half of the month are significantly larger than those issued in the first half of the month. Date P.O. number Amount Date P.O. number Amount 1 5001 $ 5,680 17 5020 $ 10,837 1 5002 6,936 18 5021 9,700 4 5003 6,346 18 5022 11,350 5 5004 6,360 18 5023 7,984 5 5005 5,524 19 5024 8,040 6 5006 6,863 19 5025 7,901 6 5007 5,058 20 5026 8,571 6 5008 6,753 21 5027 11,311 6 5009 6,675 22 5028 7,256 7 5010 6,583 23 5029 11,821 7 5011 6,595 24 5030 8,453 9 5012 6,485 25 5031 10,924 9 5013 5,555 26 5032 11,418 11 5014 6,631 27 5033 7,309 12 5015 6,906 28 5034 7,211 12 5016 6,479 29 5035 11,135 14 5017 6,568 29 5036 11,880 14 5018 6,485 30 5037 8,495 15 5019 5,418 31 5038 7,782 Required: Use Excel t-test function to determine if further investigation of a potential internal control breach is justified. Additionally, Do a two-sample test assuming equal variances. Check Figure: Calculated t-statistic = -7.37 Excel Exercise 3: Instruction: Ensure that your spread sheet is logically laid out and the information it presents is clear and understandable. The internal audit department of ITI Corporation set up an anonymous hotline for reporting suspected internal control breaches. After receiving several tips through the hotline alleging breaches in ITTs purchasing Department, internal auditors decided to investigate. The collected the following data on purchases orders issued in March 2018. Internal auditors suspect that purchase orders issued in the last half of the month are significantly larger than those issued in the first half of the month. Date P.O. number Amount Date P.O. number Amount 1 5001 $ 5,680 17 5020 $ 10,837 1 5002 6,936 18 5021 9,700 4 5003 6,346 18 5022 11,350 5 5004 6,360 18 5023 7,984 5 5005 5,524 19 5024 8,040 6 5006 6,863 19 5025 7,901 6 5007 5,058 20 5026 8,571 6 5008 6,753 21 5027 11,311 6 5009 6,675 22 5028 7,256 7 5010 6,583 23 5029 11,821 7 5011 6,595 24 5030 8,453 9 5012 6,485 25 5031 10,924 9 5013 5,555 26 5032 11,418 11 5014 6,631 27 5033 7,309 12 5015 6,906 28 5034 7,211 12 5016 6,479 29 5035 11,135 14 5017 6,568 29 5036 11,880 14 5018 6,485 30 5037 8,495 15 5019 5,418 31 5038 7,782 Required: Use Excel t-test function to determine if further investigation of a potential internal control breach is justified. Additionally, Do a two-sample test assuming equal variances. Check Figure: Calculated t-statistic = -7.37