---
title: "Gummi Bear DOE: Printing a Data Collection Sheet"
description: "Gummi Bear DOE: Printing a Data Collection Sheet"
image: https://blog.minitab.com/hubfs/B2BML%20-%20NEW%20FILE%20MANAGER%20STRUCTURE/Blog%20Images/Imported_Blog_Media/response_illustration_w640-3.gif
---
English
- [English](https://blog.minitab.com/en/?hsLang=en)
- [Français](https://blog.minitab.com/fr/?hsLang=en)
- [Deutsch](https://blog.minitab.com/de/?hsLang=en)
- [Português](https://blog.minitab.com/pt/?hsLang=en)
- [Español](https://blog.minitab.com/es/?hsLang=en)
- [日本語](https://blog.minitab.com/ja/?hsLang=en)
- [한국어](https://blog.minitab.com/ko/?hsLang=en)
- [中文（简体）](https://blog.minitab.com/zh/?hsLang=en)
- [ Partners](https://www.minitab.com/en-us/company/partners/)
- [ Contact](https://www.minitab.com/en-us/company/contact-us/)
- [ Talk to Minitab](https://www.minitab.com/en-us/talk-to-minitab/)
- [ My Account](https://licensing.minitab.com/account/manage)
[](https://www.minitab.com/en-us/)
- Products
Back
[Products](https://www.minitab.com/en-us/products/)
[All Products](https://www.minitab.com/en-us/products/)
- [Minitab Solution Center](https://www.minitab.com/en-us/products/minitab-solution-center/)
- [Minitab Statistical Software](https://www.minitab.com/en-us/products/minitab/)
- [Minitab Connect](https://www.minitab.com/en-us/products/connect/)
- [Minitab Model Ops](https://www.minitab.com/en-us/products/model-ops/)
- [Minitab Education Hub](https://www.minitab.com/en-us/products/education-hub/)
- [Minitab Engage](https://www.minitab.com/en-us/products/engage/)
- [Minitab Workspace](https://www.minitab.com/en-us/products/workspace/)
- [Real-Time SPC](https://www.minitab.com/en-us/products/real-time-spc/)
- [Prolink Data Collection & SPC](https://www.minitab.com/en-us/products/prolink)
- [Simul8 Discrete Event Simulation](https://info.minitab.com/en/new-to-simul8?hsLang=en)
- [SPM](https://www.minitab.com/en-us/products/spm/)
- Solutions
Back
[Solutions](https://www.minitab.com/en-us/solutions/)
[All Solutions](https://www.minitab.com/en-us/solutions/)
- [Analytics](https://www.minitab.com/en-us/solutions/analytics/)
- [Statistics & Predictive Analytics](https://www.minitab.com/en-us/solutions/analytics/statistical-analysis-predictive-analytics/)
- [Data Science & Machine Learning](https://www.minitab.com/en-us/solutions/analytics/data-science-machine-learning/)
- [Business Analytics & Intelligence](https://www.minitab.com/en-us/solutions/analytics/business-analytics-intelligence/)
- [Statistical Process Control](https://www.minitab.com/en-us/solutions/analytics/statistical-process-control/)
- [Quality Analytics](https://www.minitab.com/en-us/solutions/analytics/quality-analytics/)
- [Live Analytics](https://www.minitab.com/en-us/solutions/analytics/live-analytics/)
- [Reliability & Life Data Analysis](https://www.minitab.com/en-us/solutions/analytics/reliability/)
- [Discrete Event Simulation](https://info.minitab.com/en/new-to-simul8?hsLang=en)
- [Process Mining](https://info.minitab.com/en/new-to-simul8?hsLang=en)
- [Key Capabilities](https://www.minitab.com/en-us/solutions/key-capabilities/)
- [Continuous Improvement](https://www.minitab.com/en-us/solutions/key-capabilities/continuous-improvement/)
- [Data Integration & Data Prep](https://www.minitab.com/en-us/solutions/key-capabilities/data-integration-data-prep/)
- [Diagramming & Mind Mapping](https://www.minitab.com/en-us/solutions/key-capabilities/diagramming-mind-mapping/)
- [Digital Twins](https://info.minitab.com/en/new-to-simul8?hsLang=en)
- [Model Deployment & ML Ops](https://www.minitab.com/en-us/solutions/key-capabilities/model-deployment-ml-ops/)
- [Innovation & Project Management](https://www.minitab.com/en-us/solutions/key-capabilities/innovation-project-management/)
- [Process Excellence: Detect, Correct & Prevent](https://www.minitab.com/en-us/solutions/key-capabilities/process-excellence/)
- [Featured Industries](https://www.minitab.com/en-us/solutions/industry/)
- [Academic](https://www.minitab.com/en-us/solutions/industry/academic/)
- [Energy & Natural Resources](https://www.minitab.com/en-us/solutions/industry/energy-resources/)
- [Government & Public Sector](https://www.minitab.com/en-us/solutions/industry/government/)
- [Healthcare](https://www.minitab.com/en-us/solutions/industry/healthcare/)
- [Insurance](https://www.minitab.com/en-us/solutions/industry/insurance/)
- [Manufacturing & Industrial](https://www.minitab.com/en-us/solutions/industry/manufacturing-industrial/)
- [Services](https://www.minitab.com/en-us/solutions/industry/service-industries/)
- [Software & Technology](https://www.minitab.com/en-us/solutions/industry/software-technology/)
- [Construction](https://www.minitab.com/en-us/solutions/industry/construction/)
- [Featured Roles](https://www.minitab.com/en-us/solutions/role/)
- [Engineering](https://www.minitab.com/en-us/solutions/role/engineering/)
- [Business Analysis](https://www.minitab.com/en-us/solutions/role/business-analysts/)
- [Information Technology](https://www.minitab.com/en-us/solutions/role/information-technology/)
- [Supply Chain](https://www.minitab.com/en-us/solutions/role/supply-chain/)
- [Customer Service & Contact Center](https://www.minitab.com/en-us/solutions/role/customer-service-contact-center/)
- [Human Resources](https://www.minitab.com/en-us/solutions/role/human-resources/)
- [Marketing](https://www.minitab.com/en-us/solutions/role/marketing/)
- [Research and Development](https://www.minitab.com/en-us/solutions/role/research-and-development/)
- Resources & Services
Back
[Resources & Services](https://www.minitab.com/en-us/resources-services/)
[All Resources & Services](https://www.minitab.com/en-us/resources-services/)
- [Resources](https://www.minitab.com/en-us/resources-services/resources/)
- [Case Studies](https://www.minitab.com/en-us/resources-services/resources/case-studies/)
- [eBooks & White Papers](https://www.minitab.com/en-us/resources-services/resources/ebooks-and-white-papers/)
- [Blog](https://blog.minitab.com/blog/?hsLang=en)
- [Data Sets](https://www.minitab.com/en-us/resources-services/resources/data-set/)
- [Webinars & Events](https://www.minitab.com/en-us/resources-services/resources/events/)
- [Education Hub](https://www.minitab.com/en-us/resources-services/resources/education-hub/)
- [Services](https://www.minitab.com/en-us/resources-services/services/)
- [Training](https://www.minitab.com/en-us/resources-services/services/training/)
- [Deployment](https://www.minitab.com/en-us/resources-services/services/deployment/)
- [Consulting](https://www.minitab.com/en-us/resources-services/services/statistical-consulting/)
- [Self-Paced Learning](https://www.minitab.com/en-us/resources-services/services/self-paced-learning/)
- [Continuing Education](https://www.minitab.com/en-us/resources-services/services/continuing-education/)
- Support
Back
[Support](https://www.minitab.com/en-us/support/)
[Technical Support](https://www.minitab.com/en-us/support/)
- [Subscriptions & Activation](https://www.minitab.com/en-us/support/subscriptions-and-activation/)
- [Minitab Quick Start](https://www.minitab.com/en-us/support/quick-start/)
- [Training](https://www.minitab.com/en-us/resources-services/services/training/)
- [Installation Support](https://www.minitab.com/en-us/support/installation/)
- [Support Videos](https://www.minitab.com/en-us/support/videos/)
- [Support Documentation](https://www.minitab.com/en-us/support/documents/)
- [Software Updates](https://www.minitab.com/en-us/support/software-updates/)
- [Product Downloads](https://www.minitab.com/en-us/support/downloads/)
- [Support Policy](https://www.minitab.com/en-us/support/policy/)
- Company
Back
[Company](https://www.minitab.com/en-us/company/)
[Company](https://www.minitab.com/en-us/company/)
- [About Us](https://www.minitab.com/en-us/company/our-company/)
- [Leadership Team](https://www.minitab.com/en-us/company/leadership-team/)
- [Partners](https://www.minitab.com/en-us/company/partners/)
- [Careers](https://www.minitab.com/en-us/company/careers/)
- [Contact](https://www.minitab.com/en-us/company/contact-us/)
- [News](https://www.minitab.com/en-us/company/press-releases/)
[Try/Buy](https://www.minitab.com/en-us/try-buy/)
- [Statistics](https://blog.minitab.com/en/blog/tag/statistics)
- [Data Analysis](https://blog.minitab.com/en/blog/tag/data-analysis)
-
- [Quality Improvement](https://blog.minitab.com/en/blog/tag/quality-improvement)
- [Subscribe](https://info.minitab.com/blog/subscribe?hsLang=en)
## Notice
You are now leaving minitab.com.
Click Continue to proceed to:
Continue
Go Back
# Gummi Bear DOE: Printing a Data Collection Sheet
[Cody Steele](https://blog.minitab.com/en/blog/author/cody-steele) | 8/22/2012
Topics: [Design of Experiments - DOE](https://blog.minitab.com/en/blog/tag/design-of-experiments-doe)
- [Share](https://www.linkedin.com/shareArticle?mini=true&url=https://blog.minitab.com/en/blog/statistics-and-quality-improvement/gummi-bear-doe-printing-a-data-collection-sheet)
- [Share](https://www.facebook.com/sharer.php?u=https://blog.minitab.com/en/blog/statistics-and-quality-improvement/gummi-bear-doe-printing-a-data-collection-sheet)
Recently, we’ve discussed how to do the [design](https://blog.minitab.com/blog/statistics-and-quality-improvement/gummi-bear-doe-replicates-and-center-points-part-2?hsLang=en) and [factor setup](https://blog.minitab.com/blog/statistics-and-quality-improvement/gummi-bear-doe-choosing-factor-levels?hsLang=en) for design of experiments in [Minitab Statistical Software](http://www.minitab.com/en-US/products/minitab/). We’re almost ready to launch some gummi bears. But there’s something else to consider. When we produce the data for design of experiments, how does the data get from the measuring device to Minitab?
If you’re lucky, you have an electronic thingamajig that takes measurements and beams them directly to a desktop computer where they’re stored in an analyzable format. But that’s Joan-Ginther-or-[Jim-Frost-lucky](https://blog.minitab.com/blog/adventures-in-statistics/do-you-feel-lucky-punk?hsLang=en). The rest of us are probably going to have to use a classic 4-step process:
1. Measure all the gummi bear distances
2. Write down all of the gummi bear distances
3. Go from the data collection area to the computer
4. Type the numbers into Minitab
We’ve talked quite a bit about using Minitab for [measurement systems analysis](https://blog.minitab.com/blog/statistics-and-quality-improvement/statistics-with-gummi-bears-catapults-part-2-measurement-considerations?hsLang=en), but it pleases me to note that Minitab can even make writing down the distances easier. If you made your design in Minitab the way I did, you have a worksheet that looks something like this (though the order of the rows will be different, since the experiment is randomized):
Before you print the worksheet, add headers to columns to the right of the design so you have a place to record your data. I’m planning to measure the distance parallel to the catapult and perpendicular to the catapult, so I’ll make two columns. It’s also nice to have a little bit of extra space to make notes. Maybe you notice that the position of the fulcrum was a little off, but you decide to try the analysis with the measurement in the data. That’s a detail it’s easy to forget if you don’t write it down. I’ll make a “Notes” column too, and end up with a worksheet like this:
With all the columns in, I could print my worksheet, but there will be a problem. I’ll get three pages with the design:
And three pages with a single notes column:
This is a problem that some scotch tape or wider paper could fix, but instead, notice that the labels are much longer than the data inside the columns. Especially where I’ve called something a “position.” You can narrow the label text in Minitab, and then narrow the columns:
1. Choose **Tools > Options**.
2. In the list at left, expand **Data Window**.
3. Select **Label Font**.
4. In **Font**, choose **Arial Narrow**.
5. In **Style**, uncheck **Bold**.
6. In **Size**, choose **8**. Click **OK**.
7. Highlight the 3 columns with “position” in the title.
8. Choose **Editor > Column > Width**.
9. Select **Fixed Width** and enter *11.86*. Click **OK**.
Now that the worksheet is ready to print, we can send it to the printer:
1. Choose **File > Print Worksheet**.
2. Uncheck **Print Row Labels**.
3. Add a title (I used *Gummi Bear Experiment*).
4. Click **Properties** and make sure that the paper orientation for your printer is **Landscape**. Click **OK** in both dialog boxes.
Mine looks like this:
But you can also feel free to use this [PDF file](http://www.scribd.com/doc/103588909/Gummi-Bear-DOE-Data-Collection-Worksheet), as long as you don’t mind running the experiment in the same order as me. Either way will let you practice design of experiments to build your confidence!
## You Might Also Like
[3 Ways to Reduce Experimentation Costs in Product Development](https://blog.minitab.com/en/blog/3-ways-to-reduce-experimentation-costs-in-product-development?hsLang=en)
[Minitab Doe By Effex](https://blog.minitab.com/en/blog/tag/minitab-doe-by-effex) | 4 Minute Read
[Move Beyond Guesswork in R&D by Understanding Variability](https://blog.minitab.com/en/blog/move-beyond-guesswork-in-rd-by-understanding-variability?hsLang=en)
[Research And Development](https://blog.minitab.com/en/blog/tag/research-and-development) | 4 Minute Read
[The Future of Experimentation: How DOE Is Shaping Industry Innovation](https://blog.minitab.com/en/blog/the-future-of-experimentation-how-doe-is-shaping-industry-innovation?hsLang=en)
[Minitab Doe By Effex](https://blog.minitab.com/en/blog/tag/minitab-doe-by-effex) | 7 Minute Read
---
- [Careers](https://www.minitab.com/en-us/company/careers/)
- [Trust Center](https://www.minitab.com/en-us/trust-center/)
- [Suppliers](https://www.minitab.com/en-us/suppliers/)
- [Site Map](https://www.minitab.com/en-us/site-map/)
- [](https://www.linkedin.com/company/minitab/)
- [](https://www.facebook.com/Minitab/)
- [](https://www.youtube.com/user/MinitabInc)
- [](https://www.instagram.com/minitab/)
---
© 2025 Minitab, LLC. All Rights Reserved.
- [Terms of Use](https://www.minitab.com/en-us/legal/terms-of-use/)
- [Privacy Policy](https://www.minitab.com/en-us/legal/privacy-policy/)
- [Legal](https://www.minitab.com/en-us/legal/)
- Cookies Settings