# Using Sum Values for Category Data in Minitab

Z

#### ZeissBDR

To whom it may concern:

I am trying to develop descriptive statistics - ideally with graphs - for a distribution of lenses sold according to the dioptric power of the lenses. The data exists in two columns of a table: one column contains the numeric dioptric power of the lenses (the data categories) and the other column contains the sum of all lenses of a given diopter sold during the period under review.

I cannot seem to find the means in MiniTab to analyze this data. If there was a single column of data points it would be an easy affair to have MiniTab manipulate the data and create the desired statistics and graphs. But it seems impossible to analyze data where the data consists of sums for each of a series of discrete, linear values (dioptric powers of lenses sold).

Is it possible to directly analyze the data or to manipulate the data in a way that makes it possible? Note that my eventual goal is to perform a means test (hypothesis test) to determine if two populations have the same mean.

Kind regards,

Brian

Here is how the data appears, for your information:

dpt. Qty.
0.0 550
0.5 72
1.0 602
1.5 80
2.0 600
2.5 98
3.0 709
3.5 111
4.0 649
4.5 125
5.0 804
5.5 123
6.0 777
6.5 155
7.0 766
7.5 138
8.0 966
8.5 227
9.0 1095
9.5 270
10.0 1498
10.5 872
11.0 1580
11.5 1116
12.0 1648
12.5 1199
13.0 2013
13.5 1526
14.0 2329
14.5 1827
15.0 2889
15.5 2582
16.0 3892
16.5 3900
17.0 5579
17.5 6555
18.0 9749
18.5 11737
19.0 15937
19.5 17375
20.0 22665
20.5 23170
21.0 24811
21.5 22415
22.0 20893
22.5 16392
23.0 14320
23.5 9867
24.0 8419
24.5 5576
25.0 4919
25.5 2672
26.0 2965
26.5 1620
27.0 1867
27.5 998
28.0 1365
28.5 679
29.0 946
29.5 553
30.0 854
30.5 158
31.0 388
31.5 74
32.0 443

#### Miner

##### Forum Moderator
Staff member

Use Graph > Bar Chart > Bars Represent = Values from a Table > One column of values = Simple > Graph variables = Qty > Categorical variable = dpt

I attached the graph below.

#### Attachments

• 71 KB Views: 86
A

#### allan-M

the Minitab site has a macro to "untally" data like this
<support> ,macros> <data manipulation>
You may need to learn up how to run macros, but that's there as well
Expand Frequencies Macro

This macro "untallies" data by taking a frequency table and creating from it a single column of data.
For example, say that the numbers are in C1, the frequencies are in C2, and you want the results stored in C3. In the Command Line Editor, or in the Session window at the command prompt (MTB>), type:
%expand C1 C2 C3
The resulting columns would look like:
C1 C2 C3 5 2 5 6 3 5 7 1 6 6 6 7Note: This macro is designed to append the output to any data that may already exist in the column specified for the output.

Z

#### ZeissBDR

Firstly, I have to say that I am impressed by the rapid reply in this Elsmar Cove community. This is my first time using it and to receive two relevant replies in one day is very impressive. Frankly, I' surprised and disappointed that MiniTab doesn't have a user forum like this - or an official link to this forum, because the support at the MiniTab site for technical questions is not very comprehensive.

To the members of the community who replied to me:

@ Miner: Thank you for the reply. I actually knew how to create the graph in the manner you described. The challenge I needed to resolve was the creation of statistics, such as mean, standard deviation, etc. This apparently requires that the data be untallied. Which leads me to the reply from allan-M...

@ allan-M: This was precisely the trick! I have untallied the data this morning and I am able to now derive statistics from it.

Kind regards,

Brian

#### Miner

##### Forum Moderator
Staff member
You are very welcome. One additional thought that came to mind was have you performed an MSA on your classification process?

Using NICE for guidance during CER CE Marking (Conformité Européene) / CB Scheme 0
Using Review articles from Pubmed for CER CE Marking (Conformité Européene) / CB Scheme 8
Using a meme generator to poke fun at quality Funny Stuff - Jokes and Humour 2
Finding Optimum Design Parameters using Taguchi method? Using Minitab Software 2
MSA - Using a R&R study for a Tape Measure Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 19
Using electronic lab notebooks in the design control process ISO 13485:2016 - Medical Device Quality Management Systems 3
Using a Non Certified vendor Supplier Quality Assurance and other Supplier Issues 5
Using/Selling power banks with your product as a "mobile version" CE Marking (Conformité Européene) / CB Scheme 3
Using internal audits as part of document reviews Document Control Systems, Procedures, Forms and Templates 21
Select the 1 Supplier based on the Parts Durability from 6 Supplier Samples using Minitab Using Minitab Software 11
MSA angle issue - Nylon parts using Aberlink 3D Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 0
Question on using audit checklist ISO 13485:2016 ISO 13485:2016 - Medical Device Quality Management Systems 20
Using of CE marking - Two CE markings on the product CE Marking (Conformité Européene) / CB Scheme 5
Using R package to implement Bayesian phase I/II dose-finding design for three outcomes ISO 13485:2016 - Medical Device Quality Management Systems 6
Defibrillator Protection applicability When using Multiple applied parts IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
Using Zinc Plated Steel in a Cleanroom Other Medical Device Related Standards 3
Incoming Inspection Records using Excel File ISO 13485:2016 - Medical Device Quality Management Systems 2
Using ring gauges General Measurement Device and Calibration Topics 2
Load Cell Calibration using a totalizer on a flow meter General Measurement Device and Calibration Topics 0
Can Neoprene be Cleaned Using Isopropyl Alcohol (IPA) Manufacturing and Related Processes 4
Anyone using the Intellect QMS software? Quality Assurance and Compliance Software Tools and Solutions 1
Sterilization using beta radiation Other Medical Device Related Standards 2
Using the phrase "herein referred to" Document Control Systems, Procedures, Forms and Templates 8
Struggling with using the 5.6 version Ford Capacity Analysis Report APQP and PPAP 5
Study Type 1 on a CMM using a measuring support Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 4
MRB (Material Review Board) Process using MS Sharepoint or MS Teams Manufacturing and Related Processes 2
510k FDA review, will they accept Biocompatibility result generated using feasibility product lots? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 8
AS9100D 7.1.5.2 Calibration or Verification Method using outside cal lab AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
Medical Device CE Marking - Using a disposable bearing CE Marking (Conformité Européene) / CB Scheme 3
Calibration tolerance question using Pipettes Medical Device and FDA Regulations and Standards News 3
Risk Analysis using Monte Carlo Simulation instead of Scoring and Heat Map Risk Management Principles and Generic Guidelines 2
Using tailoring guidelines to tailor a QMS procedure ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 2
We found out we have been using a equipment without validation for past 4 years Quality Manager and Management Related Issues 6
Using Laboratory Notebooks in R&D and Design and Development ISO 13485:2016 - Medical Device Quality Management Systems 3
Importer shell game - Using a third party logistics provider (3PL) in the EU EU Medical Device Regulations 5
Work performed in Canada on US patients using US device Canada Medical Device Regulations 1
Is using ANSI/ASQ Z1.4-2008 the correct sampling plan to determine Pass/Fail of Apparel measurements? AQL - Acceptable Quality Level 8
What are the pros and cons of using an audit software for internal auditing? General Auditing Discussions 7
Evaluating nonconformances for escalation using Bayesian methods? Statistical Analysis Tools, Techniques and SPC 2
Using non-conforming components even though the final assembly is conforming? Manufacturing and Related Processes 5
Using Unreleased Documents & Process Maps for Internal Audit purposes ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 12
Clause 7.7 Replicate, Recalibration and Intermediate checks using Artifact ISO 17025 related Discussions 1
Are any medical device companies using the 2011 FDA process validation guidance instead of GHTF/SG3/N99-10:2004? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
Unit of Use DI (Device Identifier) - Products using the same device US Food and Drug Administration (FDA) 0
Using Arduino based sensors for Poke-Yoke Manufacturing and Related Processes 6
Using your Manufacturer's ISO certification ISO 13485:2016 - Medical Device Quality Management Systems 5
Adverse Event Clinical Trial using a 510K approved Device Other US Medical Device Regulations 6
Using non CE parts in a machine CE Marking (Conformité Européene) / CB Scheme 1
Gauge R&R on multiple dimensions using 3D measurement system Capability, Accuracy and Stability - Processes, Machines, etc. 6
Hospital IT expectations for connected medical device using WIFI Medical Information Technology, Medical Software and Health Informatics 0