Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Exercise 3: Instruction: Ensure that your spread sheet is logically laid out and the information it presents is clear and understandable. The internal

image

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Government and Not for Profit Accounting Concepts and Practices

Authors: Michael H. Granof, Saleha B. Khumawala

6th edition

978-1-119-4958, 9781118473047, 1118155971, 1118473043, 978-1118155974

More Books

Students also viewed these Accounting questions

Question

please dont use chat gpt AI 6 7 0 .

Answered: 1 week ago

Question

10. Provide an adequate debriefing for research participants.

Answered: 1 week ago