Step 1 What is the math problem?
Step 2 How do I do it in MINITAB?
So here, what is the math problem? The percentage of the population that is Female is
So in MINITAB we have
a) # of Females: Calc > Calculator, Store in: c4, Expression: SUM('Female')
b) # of People: Calc > Calculator, Store in: c5, Expression: SUM('Male' + 'Female')
c) and finish: Calc > Calculator, Store in: c6, Expression: ROUND(c4/c5*100,1)
Of course you can do all of this ay once:
Calc > Calculator, Store in: c4, Expression: ROUND(SUM('Female') / SUM('Male' + 'Female')*100,1), 51.9%
Problem 2: First we need to know how many people we have in each age group:
Calc > Calculator, Store in: People, Expression: 'Male' + 'Female'
Now we need to know which is the largest number, and what is the corresponding age group:
Data > Sort > Sort Columns: Age People, by Column: People, check Descending, put in new worksheet, read off result: 10 year olds
Problem 3: Calc > Calculator, Store in: c5, Expression: 'Male' < 'Female'
How many '1's are there? here is a math idea: all the numbers in this column are 0's and 1's, so their sum is the number of 1's:
Calc > Column Statistics > select c5, answer: 82
Too much math? Use
Stat > Tables >c5
Problem 4: Age is a text column, and therefore can't be used in a scatterplot. We make a corresponding column as follows:
Calc > Make Patterned Data > Simple set of numbers, Store Patterned data in: Ages, From first value=0 , To last value=99 , in steps of=1
Then add 102 107 and 112 at the end of this column (Note (100+104)/2 = 102)
Find the percentage of Males with Calc > Calculator, Store in: % Males, Expression: 'Male' / 'People' * 100
Draw graph with Graph > Scatterplot, Simple > Y variables= % Males, X variables= Ages, click on Labels, Title: Gender Ratios, Footnote: your name
Change symbols by clicking on a dot, right-click, Edit Symbols.
Add text by clicking the text box T above graph, click at correct position inside graph, type Strange!
Add line using the line icon above the graph, then select line and change size to 4