---
title: "Complete a quantitative study"
description: "Check a fictional checkout survey, build a regional workbook, and prepare a slide in about 25 minutes."
---

> Documentation Index
> Fetch the complete documentation index at: https://docs.insightgig.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Complete a quantitative study

Make a workbook that shows how many shoppers saw a delivery fee in a fictional grocery checkout study. Allow about 25 minutes to check the data and prepare a slide. A detailed evaluation or revisions may take longer.

## Before you begin

Download [the retail checkout practice files](/downloads/retail-checkout-practice.zip). In File Explorer, right-click the download and select **Extract All**. Name the extracted folder `Retail checkout study`.

If you used the files for [Complete a qualitative study](/research-workflows/complete-a-qualitative-study/), keep that project. Check that its survey file has 1,200 responses. If you have an earlier version, extract the new download to a separate folder.

[Sign in to the desktop app](/get-started/sign-in-to-desktop/) and [Check credits and usage](/console/usage-and-billing/track-usage/) before starting. Have Excel and PowerPoint available to check the final files.

The `Survey` folder contains a questionnaire and a CSV file, which is a table saved as text. The dataset has 1,200 fictional responses. It has 300 per region, with 100 in each of three age bands per region.

Your workbook and slide can look different from the screenshots. With the same counting rules and source file, the counts and percentages should match the guide.

## Part 1 Check the measure and its base

1. Open the `Retail checkout study` project from [Before you begin](/research-workflows/complete-a-quantitative-study/#before-you-begin). If you just extracted the folder, use [Add and switch projects](/projects-and-files/open-and-switch-projects/#open-the-folder-picker) to add it.
2. Start a session in **Retail checkout study**. Select **Open project files** and expand **Survey**. Read `survey-guide.md` and confirm that `checkout-survey.csv` contains the named fields.
3. Identify the base for fee visibility. The guide uses shoppers who answered **yes** or **no**. Keep blanks as unanswered.

You should know the input file, field, and rule before asking for a percentage.

## Part 2 Calculate and check the results

1. In the session you opened in Part 1, select **Research** and send this request.

   ```txt
   Read Survey/survey-guide.md and Survey/checkout-survey.csv.
   Check the unique response count and the region and age quotas.
   Report yes, no, valid base, blanks, and fee-visibility percentage by region.
   Save Analysis and Reporting/survey-checks.md and link it in the reply.
   ```

2. Open `survey-checks.md` from the reply. For North, verify 206 yes, 80 no, and 14 blank. The fee percentage is 206 divided by 286, or 72.0%.

   ![Survey checks open in the project file panel with counts and percentages for each region](@/assets/images/research-workflows/checkout-survey-checked-results.png)

Check that the valid bases add to 1,152 and the blanks add to 48. The results describe this fictional quota sample.

## Part 3 Create and review the workbook

1. Send the request in [Create a spreadsheet](/research-workflows/create-a-spreadsheet/#describe-the-workbook) to save `Analysis and Reporting/fee-visibility.xlsx` in this project.

2. Open the workbook from the reply. Compare its counts with `survey-checks.md` from Part 2 and inspect one formula in Excel.

3. Follow [Evaluate research outputs](/research-workflows/evaluate-outputs/) to recompute the results and check the workbook. Read its findings and check any limits it reports.

You should have a checked workbook that shows how each percentage was calculated.

## Part 4 Prepare a slide for the study team

1. In **Research**, send this request in the same project. It uses `survey-checks.md` from Part 2 and `fee-visibility.xlsx` from Part 3.

   ```txt
   Create one editable PowerPoint slide in Analysis and Reporting/fee-visibility-slide.pptx.
   Use fee-visibility.xlsx and survey-checks.md from Analysis and Reporting.
   Show the fee-visibility percentage, valid base, and blank count for each region and the total.
   Name the source workbook and say these are fictional quota-sample results.
   Show me the proposed content before making the slide.
   ```

2. Check the proposed content and approve it. Open the saved `.pptx` file in PowerPoint when it is ready.

3. Compare all four regions and the total with the workbook. North is 72.0% from 286 valid answers, and West is 75.0% from 292.

   ![PowerPoint comparison slide showing fee visibility, valid bases, and blank answers for each region](@/assets/images/research-workflows/checkout-briefing-slide.png)

You should have one editable survey slide that cites the workbook and describes the sample limits. The screenshot shows the regional comparison as part of a longer briefing.

## Next steps

Follow [Analyze survey data](/research-workflows/analyze-quantitative-data/) for a wider survey analysis. Use [Synthesize research findings](/research-workflows/synthesize-findings/) to bring interview evidence into the same report.

Follow [Create a PowerPoint presentation](/research-workflows/create-a-powerpoint-presentation/) to use that synthesis in a five-slide briefing.

Source: https://docs.insightgig.ai/research-workflows/complete-a-quantitative-study/index.mdx
