| Course | ACC 337 Introduction to Accounting Analytics |
|---|---|
| Topic | Topic 3 |
| Paper type | Dataset question triage |
| Length | About 970 words, 2 pages |
| Format | APA 7 student paper |
| School | Grand Canyon University (GCU) |
| Program | BS in Accounting |
| Updated | September 2026 |
Free sample paper for ACC 337 Topic 3
One Table, Three Questions, Three Different Verdicts: A Dataset Triage for Wildflower Home Goods' Order Lines
[Author Name]
Colangelo College of Business, Grand Canyon University
ACC-337: Introduction to Accounting Analytics
Topic 3 Assignment
[Instructor Name]
[Date]
The organization, setting and figures below are a composite written as a model document. No real employer, client, colleague or patient is described.
One Table, Three Questions, Three Different Verdicts: A Dataset Triage for Wildflower Home Goods' Order Lines
The Request
Wildflower Home Goods, a composite online seller of bedding, kitchenware and decor, exported a year of order lines and asked three questions: whether returns cluster in certain products, whether the spring promotion raised revenue per order, and which customers are most profitable. Before any analysis, this triage asks whether the table can answer each question, partly answer it or not answer it at all. Running an analysis that the data cannot support produces a confident number with no meaning, and the first defense against that is knowing what the data contains (Appelbaum et al., 2017). All figures are illustrative.
What the Table Contains, and What It Does Not
The table holds 210,000 order lines in eight fields. Table 1 lists them, and it also lists what is absent, which matters as much as what is present.
Table 1
Inventory of the Order Line Table
| Field | Content | Complete? |
|---|---|---|
| Order ID | Unique per order, repeated on each line | Yes |
| Order date | Date the order was placed | Yes |
| SKU | Product code | Yes |
| Quantity | Units on the line | Yes |
| Unit price | Price charged before discount | Yes |
| Discount code | Promotion code used, if any | Blank on 81% of lines, as expected |
| Return flag | Whether the line was returned within 60 days | Yes |
| Ship-to ZIP code | Delivery ZIP | Yes |
| Absent: customer identifier | No field links orders by the same customer | |
| Absent: product cost | No field gives the cost of goods sold |
Verdicts
Table 2 gives the verdict for each question.
Table 2
Triage of the Three Questions
| Question | Verdict | Why |
|---|---|---|
| Do returns cluster in certain products? | Answerable now | Every line has a SKU and a return flag |
| Did the spring promotion raise revenue per order? | Partly answerable | A catalog mailing went out the same days, so a change cannot be assigned to either cause from this table alone |
| Which customers are most profitable? | Not answerable from this table | No customer identifier and no product cost |
Question 1: Returns by Product
This question is answerable now. Every line carries a SKU and a return flag, so return rates can be computed by product and by category. A first pass shows an overall return rate of 6.8% of lines, with two bedding SKUs, a linen duvet cover and a matching sham set, returned at 19% and 17%, and no other SKU above 11%. The table can show where returns cluster. It cannot show why, since there is no return reason field; the customer service system, which records reasons, would be the next source.
Question 2: The Spring Promotion
This question is only partly answerable. Average revenue per order during the three promotion weeks in April was $78, against $64 in the same three weeks the year before and $66 in the three weeks before the promotion. The difference is real in the data. But a printed catalog mailed to 90,000 past customers arrived during the same days, so the table cannot say whether the promotion, the catalog or both raised order size.
Two things would narrow it. The discount code field shows which orders used the promotion code; comparing revenue per order for orders with and without the code during those weeks separates code users from others, though customers who received the catalog may also have used the code. And the catalog mailing list, matched to ship-to ZIP codes, would allow comparing ZIP codes that received catalogs with those that did not. Neither fully resolves the overlap, and the triage says so rather than presenting the $14 difference as the promotion's effect.
Question 3: Most Profitable Customers
This question cannot be answered from this table at all. Profitability requires two things the table lacks. There is no customer identifier, so orders by the same customer cannot be grouped; each order appears on its own. And there is no product cost, so even a single order's profit cannot be computed. Revenue alone would rank customers by spending, which is a different question, since a customer who buys heavily discounted items and returns a quarter of them may spend a lot and earn Wildflower little.
Two further sources would make the question answerable: the e-commerce platform's customer table, which links order IDs to customer accounts, and the inventory system's standard cost for each SKU. With both joined to this table, customer profitability could be computed as revenue less discounts, product cost and the cost of returns. Accounting has long held the data for analyses like this in separate systems; the analytical work is largely in joining them correctly (Vasarhelyi et al., 2015).
Why Not Run All Three Anyway
It would be easy to produce an answer to every question from this table. Revenue per order could be compared before and during the promotion and labeled the promotion's effect. Customers could be approximated by ship-to ZIP code and ranked by revenue, and the top ZIP codes labeled the most profitable customers. Both outputs would look like findings, with charts and percentages. Both would be wrong in ways a reader could not see.
The first would credit the promotion with whatever the catalog did. The second would group unrelated households that happen to share a ZIP code and would measure spending, not profit. Decisions made on either, such as repeating the promotion without the catalog or offering loyalty discounts to a ZIP code, could cost Wildflower money. A triage that stops at "not answerable" for question 3 is more useful than a ranking that looks precise and means nothing.
Recommendation
Proceed with question 1 now. Report question 2 with its limitation stated in the first sentence, and add the discount code comparison. Request the customer table and product costs before attempting question 3. Stating plainly what the data can and cannot support is part of the analysis, not a failure of it (American Institute of Certified Public Accountants, 2017).
References
American Institute of Certified Public Accountants. (2017). Guide to audit data analytics. AICPA.
Appelbaum, D., Kogan, A., & Vasarhelyi, M. A. (2017). Big data and analytics in the modern audit engagement: Research needs. Auditing: A Journal of Practice & Theory, 36(4), 1-27. https://doi.org/10.2308/ajpt-51684
Vasarhelyi, M. A., Kogan, A., & Tuttle, B. M. (2015). Big data in accounting: An overview. Accounting Horizons, 29(2), 381-396. https://doi.org/10.2308/acch-51071
Reading the GCU ACC 337 Topic 3 instructions
ACC-337 Topic 3 asks students to decide which questions a dataset can support. Many papers run every requested analysis. The assignment rewards triage that begins with an inventory of the fields present and absent, then gives each question a verdict, answerable, partly answerable or not answerable, with a reason. Students should show a first result where the data supports one, explain what confounds a partly answerable question and what would narrow it, name the additional sources that would make an unanswerable question answerable, and explain the harm of producing figures the data cannot support.
How the ACC-337 Topic 3 example is put together
The finished triage opens with an inventory of the table: 210,000 order lines, eight fields, and a list of what is absent, which matters as much as what is there. No field identifies a customer across orders, and no field carries the cost of the goods sold. The three questions are then taken in turn. Whether returns cluster in certain products is answerable now, since every line carries a SKU and a return flag. Whether the spring promotion raised revenue per order is answerable only partly, because a catalog mailing went out during the same days, so the data can show a change without assigning it to either cause. Which customers are most profitable cannot be answered from this table at all, and the example points to the two further sources that would make it answerable.
Reading the ACC 337 Topic 3 rubric
Faculty grading the triage reward verdicts tied to fields. Excellent triage notices missing fields, such as a customer identifier or product cost, before attempting an analysis. Credit goes to identifying an overlapping event, like a catalog mailing, that prevents crediting a promotion. The rubric values naming specific sources to join for unanswerable questions. The highest level explains why tempting substitutes, such as ranking ZIP codes by revenue, would mislead. Triage that presents every question as answerable usually lands in a middle band.
ACC 337 Topic 3 help: mistakes that cost marks
Running every question through the table as if all three were answerable produces the weakest version of this assignment. A profitability ranking built without cost data can only rank customers by revenue, and presenting it as profit misleads the manager who asked. Papers often give the promotion question a clean yes, because revenue per order did rise, without noticing that the catalog mailing supplies a second explanation for the same rise. Verdicts that cite no field leave the reader unable to tell whether the writer looked at the table or guessed. Listing the fields present and never the fields absent misses the gaps that decide most outcomes. A triage that stops at the verdicts, with no recommendation on which question to pursue first, hands the manager a sorting exercise rather than a plan.
Get an ACC-337 Topic 3 example written to your instructions
Send the ACC-337 Topic 3 instructions and your classroom rubric, along with the dataset description and the questions your section was given. A custom example follows, built to those criteria, with the table inventoried, missing fields named, each question given a verdict tied to specific fields and a first query recommended, delivered in 24 to 48 hours. There is no charge for the first.
More ACC 337 papers and BS in Accounting samples
- ACC 337 Topic 1: Business Question Reframing Memo
- ACC 337 Topic 2: Data Preparation Log
- ACC 337 Topic 4: Rule-based Anomaly Screen
- ACC 337 Topic 5: Pattern Versus Evidence Dq Post
- ACC 337 Topic 6: Chart Choice Rationale
- ACC 337 Topic 7: Management Findings Brief
- ACC 337 Topic 8: Reproducible Analysis Workpaper
- ACC 335 Topic 3: Design Versus Operation Memo
- ACC 260 Topic 3: Contribution Format Restatement
- ACC 250 Topic 3: Revenue Timing Memo
ACC 337 Topic 3 questions, answered
What if none of the questions can be answered?
Then the triage is still worth writing, and it says so plainly. Name the fields each question needs, where in the organization they are likely held and what joining them to this table would require. A paper that finds a dataset unfit for the questions put to it, and explains exactly why, has done the analytic work this topic sets. Forcing an answer out of unsuitable data is the mistake to avoid.
Is a partly answerable question worth pursuing?
Often, provided the partial answer is labeled as partial. Here the table can show that spring revenue per order rose against the prior spring, which is useful to know even though the cause stays open. The example states what additional data would separate the promotion from the mailing, such as a flag showing which customers received the catalog, so the reader can decide whether narrowing it further is worth the cost.
Should the triage include any queries?
A few simple counts help, such as the number of lines carrying a return flag or the share of orders using a discount code, since they show the fields actually hold usable values. Save the full analysis for later topics. A triage filled with results has blurred the line between deciding what to ask and asking it, and that line is the skill this point in the course typically tests.
Where can I find a free ACC 337 Topic 3 sample paper?
The whole triage appears here, with the request, the field inventory, the verdicts, returns by product, the spring promotion, most profitable customers, why not run all three and the recommendation. Send your dataset for a free worked triage.
Why is customer profitability not answerable in ACC 337 Topic 3?
The table has no field linking orders to a customer and no product cost, so neither customers nor profit can be measured from it.