ACC 263 - Data Analytics and Statistics in Accounting (3 CR.)

Introduces the field of business analytics in accounting, finance, and business management. Focuses on the way in which enterprises such as corporations, non-profits, and governments can use data to gain insights and make better decisions. Presents the application of selected data mining techniques to support business analytics. Lecture 3 hours.

General Course Purpose
Analytics has been defined as extensive use of data, statistical and quantitative analysis, exploratory and predictive models, and fact-based management to drive outcomes and decisions. Analytics is not only analytical methodologies and techniques used logical analysis, but also a process of transforming data into actions through analysis and insights in the context of organizational decisions making, problem solving and judgment. Analytics include a range of activities, such as standard and ad hoc reports, queries, and alerts, and quantitative models. These quantitative models include statistical analysis, forecasting/extrapolation, predictive modeling,

Prerequisite(s): ACC 212.

Course Objectives

Explain how business managers use business analytics to formulate and solve business and
Use and apply MS Excel to solve business problems
Apply various analytical techniques to evaluate the consequences of different business/accounting problems and to select the best alternative
Articulate the robustness and limitations of descriptive and predictive modeling techniques

Major Topics to be Included

Data Analytics Overview
The Excel Basics and Visualizing/Exploring Data
Descriptive Measures and Statistics
Probability Distributions
Sampling, Statistical Inference, and Judgment
Spreadsheet Modeling and Analysis
Trend and Regression Analyses
Foresting Techniques

Revised 9/2021