COST ACCOUNTING A DATA ANALYTICS
APPROACH CHAPTERS 1 TO 14 FINAL PAPER
2026 SOLVED QUESTIONS WITH FULL
SOLUTION ALREADY PASSED
◉ Classification.
Answer: data approach that attempts to assign each unit in a
population into a small set of classes (or groups) where the unit best
fits
◉ Co-occurrence grouping.
Answer: a data approach that attempts to discover associations
between individuals based on transactions involving them
◉ Similarity matching.
Answer: a data approach that attempts to identify similar
individuals based on data known about them
◉ Regression (Data Analysis).
Answer: a technique that is used to predict a dependent variable
with one or more independent variables
,◉ Link prediction (data analytics).
Answer: attempts to predict connections between two data items
◉ Profiling.
Answer: the use of computers to combine data from multiple
sources and create electronic dossiers of detailed information on
individuals
◉ data dictionary attributes which are likely to be predictive of loan
rejection.
Answer: 1. Amount Requested = yes
2. Zip Code = yes
3. Loan Title = no
4. Debt-To-Income Ratio = yes
5. Application Date = no
6. Risk_Score = no
,7. Employment Length = yes
◉ Tableau Track software tools w/ specific analysis
needs/characteristics.
Answer: 1. Advanced visualization = Tableau Desktop
2. Analyze and share public datasets = Tableau Public
3. Data joining = Tableau Prep Builder
4. Presentations = Tableau Desktop
5. Data transformation = Tableau Prep Builder
6. Dashboards = Tableau Desktop
7. Data cleaning = Tableau Prep Builder
◉ IMPACT Cycle w/ Data Analytics tasks.
Answer: 1. Should we use company-specific data or macro-economic
data to address the accounting question? = Master the Data
, 2. What are appropriate cost drivers for activity-based costing
purposes? = Identify the Question
3. Should we consider using regression analysis or clustering
analysis to evaluate the data? = Perform the Analysiss
4. Should we use tables or graphs to show management what we've
found? = Communicate Insights
5. Now that we've evaluated the data one way, should we perform
another analysis to gain additional insights? = Address and Refine
Results
6. What type of dashboard should we use to get the latest, up-to-date
results? = Track Outcomes
◉ Microsoft Track software tool w/ specific analysis
need/characteristic.
Answer: 1. Basic visualization = Excel
2. Robotics process automation = Power Automate
3. Data joining = Power Query
APPROACH CHAPTERS 1 TO 14 FINAL PAPER
2026 SOLVED QUESTIONS WITH FULL
SOLUTION ALREADY PASSED
◉ Classification.
Answer: data approach that attempts to assign each unit in a
population into a small set of classes (or groups) where the unit best
fits
◉ Co-occurrence grouping.
Answer: a data approach that attempts to discover associations
between individuals based on transactions involving them
◉ Similarity matching.
Answer: a data approach that attempts to identify similar
individuals based on data known about them
◉ Regression (Data Analysis).
Answer: a technique that is used to predict a dependent variable
with one or more independent variables
,◉ Link prediction (data analytics).
Answer: attempts to predict connections between two data items
◉ Profiling.
Answer: the use of computers to combine data from multiple
sources and create electronic dossiers of detailed information on
individuals
◉ data dictionary attributes which are likely to be predictive of loan
rejection.
Answer: 1. Amount Requested = yes
2. Zip Code = yes
3. Loan Title = no
4. Debt-To-Income Ratio = yes
5. Application Date = no
6. Risk_Score = no
,7. Employment Length = yes
◉ Tableau Track software tools w/ specific analysis
needs/characteristics.
Answer: 1. Advanced visualization = Tableau Desktop
2. Analyze and share public datasets = Tableau Public
3. Data joining = Tableau Prep Builder
4. Presentations = Tableau Desktop
5. Data transformation = Tableau Prep Builder
6. Dashboards = Tableau Desktop
7. Data cleaning = Tableau Prep Builder
◉ IMPACT Cycle w/ Data Analytics tasks.
Answer: 1. Should we use company-specific data or macro-economic
data to address the accounting question? = Master the Data
, 2. What are appropriate cost drivers for activity-based costing
purposes? = Identify the Question
3. Should we consider using regression analysis or clustering
analysis to evaluate the data? = Perform the Analysiss
4. Should we use tables or graphs to show management what we've
found? = Communicate Insights
5. Now that we've evaluated the data one way, should we perform
another analysis to gain additional insights? = Address and Refine
Results
6. What type of dashboard should we use to get the latest, up-to-date
results? = Track Outcomes
◉ Microsoft Track software tool w/ specific analysis
need/characteristic.
Answer: 1. Basic visualization = Excel
2. Robotics process automation = Power Automate
3. Data joining = Power Query
