<aside> <img src="/icons/bell_red.svg" alt="/icons/bell_red.svg" width="40px" /> This activity requires advanced features that are only available to free ChatGPT users on a limited basis. It may time out during this exercise. If you want to explore this feature extensively, you should consider signing up to a Plus account.

</aside>

<aside> <img src="/icons/list_gray.svg" alt="/icons/list_gray.svg" width="40px" /> Contents

</aside>

What to learn

Large Language Models have many limitations and one of them is dealing with numbers and exact data. But they can make up for this with one of their strengths which is writing computer code.

Many tools such as Gemini or ChatGPT use this to make up for problems with math. So when a user asks a numerical question, the model is trained to write some computer code to calculate it, the system runs the code and displays the answer.

ChatGPT Plus has a mode called Advanced Data Analysis that takes this much further. It essentially starts a small virtual computer in the background and lets you perform quite complex tasks including data analysis on Excel sheets or image transformations.

Many people assume this is all done by the “AI” itself but the LLM only writes the code based on the users’ instructions.

What to do

<aside> <img src="/icons/cursor-click_gray.svg" alt="/icons/cursor-click_gray.svg" width="40px" /> Click on the triangle next to each step to see more details and/or get resources necessary for the task.

Read through all steps first.

</aside>

<aside> <img src="/icons/barricade_red.svg" alt="/icons/barricade_red.svg" width="40px" /> Note: These steps are still under development.

</aside>

Step 1: Go to ChatGPT

Step 2 (Option A): Generate and analyse dummy data

Step 2 (Option B): Upload file to analyse it

Step 3: Confirm the process