Intermediate Quantitative Methods for Accounting Business Report - Semester 1, 2017The International Union of Accountants is a body of many accounting firms across the globe who seeks to improve their reporting of corporate governance. Each year the Board of the International Union of Accountants conducts a review of their compliance with corporate governance. The Accounting Director of the International Union of Accountants was analysing the average environmental accounting compliance (EAC) scores of the accounting firms under her control (the score is out of 100). Accordingly, she took a sample of 60 accounting firms across the globe and, for each, determined the average score of this year, last year and the year before last year, the percentage of accountants in each firm who have at least one university degree in accounting, and the type of country. The data is stored in file ACCT5008_BR_data_2017_s1.xlss with the following variables. Column A: Accounting firm • 60 accounting firms in the sample, referred as Firm 1 to Firm 60Column B: EAC scores this year (at time t) • EAC scores for the accounting firm this yearColumn C: EAC scores last year (at time t-1) • EAC scores for the accounting firm last yearColumn D: EAC scores the year before last year (at time t-2) • EAC scores for the accounting firm in the year before last yearColumn E: Percentage of accountants in each firm who have at least one university degree in accounting, recorded as at time t (this year) 1 = less than 50%, 2 = at least 50%Column F: Country classification 1 = first world countries, 2 = second world countries, ACCT5008 – Business Report Semester 1, 2017Page 2 of 53 = third world countriesPresent a report of your findings (by answering the questions below) as the Accounting Director to the International Union of Accountants. 1. Is the percentage of accountants in each firm who has at least one university degree in accounting related to country type? 2. Is there evidence of different environmental compliance scores (EAC) over the three-year period?3. Is there evidence to suggest that the environmental compliance scores (EAC) for this year (time t) is greater than that two years ago (time t-2) among the 60 selected accounting firms?4. Is there evidence to suggest that this year environmental compliance scores (EAC) of accounting firms which has less than 50% accountants with at least one university degree in accounting is lower than this year environmental compliance scores (EAC) of accounting firms which has at least 50% accountants with at least one university degree in accounting?DUE DATE Your business report is due on Monday 15th May 2017 at 10am (Perth time). • You should submit your report in the unit Blackboard website. It is located in Assessments \ Business report. The link is open for submission from 8th May 2017.• This is the Turnitin assignment, designed to prevent plagiarism. Further information on Turnitin can be found on the university website: https://academicintegrity.curtin.edu.au/students/Turnitin_student.cfmIf assignments are not submitted by the due date, a penalty of 10% per calendar day will be deducted from the assessment mark and after seven (7) days a zero mark will be recorded.ACCT5008 – Business Report Semester 1, 2017Page 3 of 5FUTHER INSTRUCTIONS• The report covers hypothesis tests in Topic 5 to 8. However, topic 4 which contains data collection and sampling should be discussed in your report.• The report should have the following structure: Introduction, Statistical Analyses (where you perform hypothesis tests for each of the four questions) and Conclusions (where you summarize the findings and discuss the limitations)• Your report should also include technique identification and any underlying assumptions required (with checking for the required assumptions). o Why do you use a particular technique? Consider the types of data – quantitative, qualitative or ranked? How many samples? Are these samples independent? o What are the underlying assumptions? Have you checked the assumptions? ? If checking for normal distribution, consider to put up the histogram and discuss the shape. ? If you found it is not normally distributed, keep doing the test with the underlying assumption, but need to discuss this as one of your limitations in the overall conclusion.• The parameter of interests and populations must be clearly defined.• For each of the tests, you need to have a discussion about the significance level of the test (only consider significance level at 1%, 5% and 10%1) o If the null hypothesis is rejected, what should be the lowest significance level to reject the null? o If the null hypothesis is not rejected, what should be the highest significance level to accept the null?• Show all the necessary steps and calculations for your tests. o This is not a computing assignment, manual calculations must be presented for all of the above tests 1 For the F-test, only need to consider 2 significance levels: 1% and 5%ACCT5008 – Business Report Semester 1, 2017Page 4 of 5? Formula and manual calculation should be presented in the report ? The critical values of the tests should be obtained from the Appendix B of the textbook. ? With ANOVA test, you can have SST and SSE figures from Excel (ANOVA test can be obtained from Data\Data Analysis. An example of how to perform ANOVA test in Excel will be discussed in the class). • The rest of ANOVA calculation (MST, MSE, F-stat, rejection region) should be done manually.o For descriptive statistics (e.g. mean and standard deviation), Excel calculation is acceptable, no need to show the formula, just state the calculated figure. • Please type your report. o Formulae can be copied from the lecture powerpoint slides. • Consider Appendices for data and other information to support your calculation.• The report (including tables, calculations and histograms) must not exceed 16 pages; marks will be deducted for exceeding the limit. Pages must be correctly numbered throughout.• For each question above, perform separate statistical tests to answer the questions. This assignment should be presented in a professional manner and you need to demonstrate that considerable thought has gone into the analysis of data. • The marking criteria for each of the question should be as follows: ? Technique identification: why should you use a certain technique? ? Define the population of interest ? Checking the conditions of the chosen technique: If a certain condition is not met, you keep doing the test as usual but need to discuss the limitation in the Conclusions part ? Following 6 steps in the hypothesis testing procedure ? Decision to reject or accept the null hypothesis must be referred to all 3 significance levels, that is, 1%, 5% and 10%.ACCT5008 – Business Report Semester 1, 2017Page 5 of 5Mark Allocation: • The total mark for the assignment is 50 (account for 25% of your final mark) • Each question from 1) to 4) is worth 10 marks • 4 marks for presentation o Your report should be clear for reading, presented in a good format with separate sections for (original) Introduction, Statistical Analyses and Conclusions.• 6 marks for an overall summary of your results, interpretations and any limitations. o The summary should be an evaluative response of the results of significant differences found amongst the variables conducted in the tests and any qualifying statements made about the nature of the testing data used. o Limitations of the tests should be discussed.
| Accounting firm | EAC-Scrs this year (t) | EAC-Scrs last year (t-1) | EAC-Scrs the year before last year (t-2) | Acc-Dgr% at time t |
| Firm 1 | 44.8 | 45.6 | 40.0 | 1 | 3 |
| Firm 2 | 45.0 | 43.0 | 42.1 | 1 | 3 |
| Firm 3 | 50.9 | 48.0 | 45.8 | 1 | 3 |
| Firm 4 | 44.0 | 45.0 | 48.0 | 1 | 3 |
| Firm 5 | 58.7 | 54.0 | 50.0 | 1 | 2 |
| Firm 6 | 52.8 | 53.0 | 50.0 | 2 | 2 |
| Firm 7 | 51.1 | 52.0 | 50.7 | 1 | 3 |
| Firm 8 | 54.7 | 55.0 | 50.9 | 1 | 3 |
| Firm 9 | 57.0 | 53.4 | 51.3 | 1 | 3 |
| Firm 10 | 61.3 | 60.1 | 51.3 | 2 | 2 |
| Firm 11 | 56.0 | 53.0 | 52.4 | 1 | 3 |
| Firm 12 | 58.8 | 59.0 | 52.9 | 1 | 3 |
| Firm 13 | 58.2 | 55.0 | 53.7 | 1 | 3 |
| Firm 14 | 57.3 | 55.0 | 54.0 | 2 | 3 |
| Firm 15 | 54.5 | 53.0 | 54.1 | 1 | 3 |
| Firm 16 | 59.4 | 58.0 | 54.3 | 1 | 3 |
| Firm 17 | 58.2 | 57.0 | 55.0 | 2 | 3 |
| Firm 18 | 59.8 | 57.8 | 55.1 | 1 | 3 |
| Firm 19 | 64.9 | 62.9 | 58.0 | 1 | 2 |
| Firm 20 | 62.5 | 61.0 | 59.0 | 1 | 2 |
| Firm 21 | 59.6 | 57.2 | 59.0 | 2 | 3 |
| Firm 22 | 61.7 | 60.0 | 59.1 | 1 | 3 |
| Firm 23 | 61.9 | 62.0 | 60.0 | 1 | 3 |
| Firm 24 | 64.8 | 60.9 | 61.9 | 2 | 2 |
| Firm 25 | 65.7 | 64.0 | 62.4 | 2 | 3 |
| Firm 26 | 64.6 | 63.0 | 62.5 | 1 | 3 |
| Firm 27 | 62.6 | 60.7 | 64.5 | 2 | 2 |
| Firm 28 | 68.2 | 67.4 | 65.7 | 2 | 2 |
| Firm 29 | 71.8 | 70.0 | 67.0 | 2 | 2 |
| Firm 30 | 69.9 | 68.0 | 67.3 | 2 | 3 |
| Firm 31 | 69.6 | 70.0 | 68.1 | 1 | 3 |
| Firm 32 | 71.7 | 72.0 | 69.4 | 2 | 2 |
| Firm 33 | 68.8 | 67.7 | 70.0 | 1 | 2 |
| Firm 34 | 71.3 | 73.0 | 76.0 | 2 | 2 |
| Firm 35 | 81.6 | 80.1 | 83.0 | 2 | 2 |
| Firm 36 | 56.5 | 52.3 | 50.6 | 1 | 2 |
| Firm 37 | 62.5 | 61.3 | 60.4 | 2 | 1 |
| Firm 38 | 63.7 | 64.5 | 62.9 | 2 | 1 |
| Firm 39 | 65.3 | 64.1 | 63.1 | 2 | 1 |
| Firm 40 | 66.1 | 63.0 | 62.7 | 2 | 1 |
| Firm 41 | 68.5 | 66.6 | 65.1 | 2 | 1 |
| Firm 42 | 69.8 | 67.0 | 66.8 | 2 | 1 |
| Firm 43 | 70.1 | 72.0 | 67.8 | 2 | 1 |
| Firm 44 | 72.6 | 71.6 | 70.1 | 2 | 1 |
| Firm 45 | 73.9 | 72.0 | 70.6 | 2 | 1 |
| Firm 46 | 74.2 | 73.0 | 72.1 | 1 | 1 |
| Firm 47 | 75.3 | 70.5 | 74.5 | 1 | 1 |
| Firm 48 | 77.9 | 74.3 | 74.3 | 2 | 1 |
| Firm 49 | 80.2 | 78.9 | 78.0 | 2 | 1 |
| Firm 50 | 55.2 | 54.0 | 52.7 | 1 | 2 |
| Firm 51 | 48.7 | 49.5 | 50.6 | 2 | 1 |
| Firm 52 | 54.7 | 52.1 | 56.6 | 1 | 2 |
| Firm 53 | 59.8 | 52.4 | 51.8 | 1 | 3 |
| Firm 54 | 67.2 | 65.4 | 63.1 | 2 | 1 |
| Firm 55 | 73.4 | 71.4 | 51.3 | 2 | 2 |
| Firm 56 | 49.7 | 52.7 | 45.2 | 1 | 3 |
| Firm 57 | 75.7 | 77.8 | 67.9 | 2 | 2 |
| Firm 58 | 67.8 | 35.6 | 61.7 | 1 | 3 |
| Firm 59 | 57.4 | 52.7 | 58.2 | 2 | 2 |
| Firm 60 | 62.4 | 57.9 | 59.7 | 1 | 3 |