Skip to content
AI, TECHNOLOGY AND MEDICINE NEWS
Choose where brand links take you.
YOUR NEXT DISCOVERY
Home / Tech to the rescue
DOCUMENTARY GUIDE

How to check an AI-generated data analysis

If an AI assistant gives you a sales total, ask which rows it included. You can then repeat the calculation in a spreadsheet and find the order that changes the result.

By Actualiza2 · Published on

Define which orders count

Imagine four fictional orders, all in euros. Two October orders for €450 and €300 were completed, and a €120 order was cancelled. Another order for €200 was completed in November. The question is how much the completed October orders added up to. Order status and month are separate filters.

Repeat the calculation using the original data

The two orders that meet both criteria add up to €450 + €300 = €750. A total of €870 would include the cancelled order. A total of €950 would include the November order. In Excel, SUMIFS can add amounts that meet both the month and status criteria. If the column contains full dates, filter from the first day of the month up to, but excluding, the first day of the following month. Microsoft documentation

Ask the assistant for the file, columns, included rows and calculation. Use that list to check the original. If rows repeat, first find out whether they are duplicates or separate lines from the same order.

Label the result precisely

If expenses in the example were €420, the difference is €330. To call that accounting profit, you would need to know which revenues and expenses the figures cover and whether any items are missing. For this example, report the orders included, their total and the calculated difference.

Prepared from the cited documentation. Actualiza2 has not tested this procedure on physical devices.