Assignment Task: Data Analytics for Accounting and Business Assessment

Purpose

The aim of this Assessment 2 is to evaluate your proficiency in applying statistical techniques used in data analytics to real-life financial data. Drawing from your study material (week 7 to week 10 in 110.304) and leveraging knowledge from other courses and your own research or work experience, you will conduct an analysis and effectively communicate the findings to various stakeholders.

Objectives

This assignment seeks to cover the following key generic competencies of the course:

1. Cultivate a data analytics mindset.
2. Gain experience in sourcing and processing real raw data through extraction, transformation, and loading (ETL) techniques.
3. Enhance problem-solving skills in database management.
4. Address real data challenges by applying statistical tools and techniques learned in the course and beyond, including descriptive analytics, hypothesis testing, regression analysis, and more.
5. Interpret the analytical results and effectively communicate them to users.

Detecting and Dealing with Earnings Management

Introduction

This individual report delves into financial data to uncover insights relevant to diverse stakeholders. It addresses the divergence of interests among owners, debt-holders, and corporate managers, stemming from agency problems. Managers, driven by various pressures, may resort to earnings management tactics, including discretionary accruals (DACC) and real earnings management (REM1 & REM2).

1. Discretionary Accruals (DACC): These refer to accounting adjustments made by management to manipulate financial results, often to meet certain financial objectives or present a favorable financial performance. While legal, they can be misused for fraudulent purposes, necessitating close monitoring by regulatory bodies like the Australian Securities & Investments Commission (ASIC).

2. Real Earnings Management (REM): Unlike accrual-based earnings management, REM involves manipulating a company`s financial results through operational decisions. This may include deferring maintenance or accelerating sales to achieve desired financial outcomes, potentially misleading investors and reflecting poor corporate governance.

During the COVID-19 pandemic, ASIC is vigilant about potential earnings management among firms listed on the Australian Securities Exchange (ASX). To identify pre-pandemic earnings management, ASIC has tasked analysts with applying data analytics techniques to monitor major ASX-listed companies. This report aims to explore factors indicating firms` earnings management using statistical techniques covered in the data analytics course, offering insights to ASIC, investors, and stakeholders.

Performing Statistical Analysis

Data analytics approaches rely on statistical techniques to comprehend data and unearth insights. Using Rstudio, you will conduct several statistical tests to generate results for further analysis and recommendations.

A1. Summary Descriptive Statistics: Generate descriptive statistics for key variables like DACC, REM1, REM2, and others. Present mean values for variables by industry using the GICS sector name.

A2. Pearson Correlation Matrix: Create a correlation matrix to identify possible multicollinearity among variables.

A3. Dummy Variable Creation: Generate a dummy variable to represent highly visible companies based on news coverage levels, aiding in further analysis.

These tasks are sequenced to facilitate a structured and comprehensive analysis of the financial data provided, enabling informed decision-making and strategic recommendations.