Accountants in the workplace need to be familiar with effective techniques for dealing with business data. This unit uses spreadsheet tools and accounting examples to introduce the most important data analysis methods. The unit helps students understand variability and detect when variation is random and when something significant is going on. This unit also enables students to uncover the relationships between variables that can be hidden in business data. Students learn how to look at accounting data and use it to forecast business performance. Students are also given examples of the misuse of statistics in an accounting context. The unit is taught through data- driven examples, exercises and business case studies.
1 x 3hr lecture and 1 x 2hr tutorial
weekly homework (10%); assignment (20%); mid-semester exam (20%); final exam (50%)
Students should be capable of reading data in tabulated form, working with Microsoft EXCEL, and doing High School level of mathematics
ECMT5001 or QBUS5001