Excel Exercise 3: Instruction: Ensure that your spread sheet is logically laid out and the information...
Fantastic news! We've Found the answer you've been seeking!
Question:
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
Expert Answer:
Related Book For
Government and Not for Profit Accounting Concepts and Practices
ISBN: 978-1118155974
6th edition
Authors: Michael H. Granof, Saleha B. Khumawala
Posted Date:
Students also viewed these accounting questions
-
The SEU students open a ticket on support system to havesolved their university account problem. Students tickets arrivalis best described by Poisson distribution with mean of 4 ticketssubmitted per...
-
The director of the internal audit department of a midsize city received a memo from a member of the city council that included the following: I am certain that you have followed recent press reports...
-
Find a couple of bad project management examples from around the world. What were the reasons for the failure? (500 words max) Find a couple of good project management examples from around the world....
-
The random variable X measures the concentration of ethanol in a chemical solution, and the random variable Y measures the acidity of the solution. They have a joint probability density function f(x,...
-
Lori Callebaut opened Callebaut Cleaning Service, AG on July 1, 2017. During July the following transactions were completed. July 1 Shareholders invested 20,000 cash in the business in exchange for...
-
Compute the expected frequencies under the null hypothesis of homogeneity. Exercises 79 refer to the following data: At an assembly plant for light trucks, routine monitoring of the quality of welds...
-
How would each of the following changes tend to affect aggregate payout ratios (that is, the average for all corporations), other things held constant? Explain your answers. a. An increase in the...
-
John has just turned 20 and his rich relatives are thinking of giving him an investment while he is young, which will pay for his retirement. They hope that by investing early, the investment they...
-
Consider the blending system shown in Figure. A feedback control system is used to reduce the effect of disturbances in feed composition, x 1 , n the controlled variable, product composition, x....
-
Job 101 has beginning balance of 100. DM used during the period is 150 and OH applied is 200. Budgeted OH is 1,000 and Budgeted activity is 2,000 DL cost. If job 101 was completed and sold at 20%mark...
-
Rank the following conditions as having the most inherent risk (as discussed in the chapter), the second most inherent risk, and so on. Give reasons for your rankings. a. The processing of charge...
-
A client who recently received a financial statement audit is somewhat confused about the meaning of the independent auditor's report. She understands that "everything is okay," but she is not...
-
Which of the following audit risk components may be assessed in non quantitative terms? a. Inherent risk and control risk but not detection risk. b. Inherent risk but not control risk and detection...
-
A primary purpose of an operational audit is to provide a. The results of internal examinations of financial and accounting matters to a company's top-level management. b. A measure of management...
-
An auditor ordinarily sends a standard confirmation request to all banks with which the client has done business during the year under audit, regardless of the year-end balance. One purpose of this...
-
Design a class named Fan to represent a fan. The class contains: Three constants named SLOW, MEDIUM, and FAST with the values 1, 2, and 3 to denote the fan speed. The Fan class VideoNote...
-
Coastal Refining Company operates a refinery with a distillation capacity of 12,000 barrels per day. As a new member of Coastal's management team, you have been given the task of developing a...
-
On January 1, 2015, the JKG Foundation received a $10 million bequest consisting of a commercial warehouse building and $5 million of cash. The foundation immediately invested the $5 million cash in...
-
The GASB requires a government to prepare budgetary comparisons for its general fund and major special revenue funds that have a legally adopted annual budget. The city for which you work does not...
-
The budgeted and actual revenues and expenditures of Seaside Township for a recent year (in millions) were as presented in the schedule that follows. 1. Prepare journal entries to record the budget....
-
Last year during the week of July 4th, Murrysville Regional Hospital reported that they treated 264 patients for fireworks-related injuries.
-
During a recent year, the average U.S. diners spent a month on food prepared outside the home was \($144\) . What is meant by a biased sample? determine whether descriptive or inferential statistics...
-
The number of stores a person visits on a shopping trip Name and define the four types of measurement levels used in statistics. determine whether the data are qualitative or quantitative.
Study smarter with the SolutionInn App