Challenge #308: Size it up

A solution to last week's challenge can be found here.

Weekly Challenge Image 308.png This data set provides information related to various clothes-size-prediction. Using this data, find the minimum and maximum weight, age, height per size and the percentage that each size represents rounding the numbers to 2 decimal places. If a line of data is incomplete remove it.

Hint: Nobody is under the age of 10 or over 100 years old.

challenge_308_start_file.yxzp

challenge_308_solution.yxzp

Preparation

Data Preparation

Core

Basic

Accepted answers

All comments

Aaron_Harter

Fun parsing challenge!

Spoiler

challenge_308_AB Data_Aaron.yxzp

AkimasaKajitani

My solution.

Spoiler

challenge_279_start_file_AK.yxzp

balajilolla1

Spoiler

Solution Attached

challenge_279_start_file.yxmd

Kenda

Spoiler

challenge_279_start_file.yxmd

binu_acs

Spoiler

challenge_279_solution_BV.yxmd

RolandSchubert

My solution

Spoiler

challenge_308_solution_rsc.yxmd

Watermark

Happy Monday Morning

Spoiler

https://youtu.be/6pJt7onDj7U

challenge_308_MT_Solution.yxmd

Luke_C

Spoiler

challenge_279_start_file.yxmd

joelmiller66

Spoiler

challenge_279_JM_ABDC.yxmd

MarqueeCrew

Here's a challenge solution.

Spoiler

I didn't like the division by total input rather than by good data.

challenge_308_MarqueeCReW.yxmd

kunderwood

RegEx expressions are one of my favorite things to do. Good parsing challenge.

Spoiler

challenge_308_KU.yxzp

TonyA

Followed the directions and got a different result.

Spoiler

We were told to eliminate incomplete data so there should be 1845 rows, not 1850. The solution shows 1850.

challenge_308_TonyA.yxmd

MatthewBr

Spoiler

Love it - simple parse and prep

challenge_308_MatthewBraun.yxzp

davidskaife

Here's my solution!

Spoiler

challenge_308_DS.yxmd

mikemotter

Spoiler

challenge_308_start_file (clothing sizes).yxzp

ALTSkelly

Spoiler

challenge 279.yxzp

TurboToad

My solution, had to look at the source data to figure out how to separate some of the values.

Spoiler

TT_challenge_279_solution_file.yxzp

Reesetrain2

All,

Spoiler

I'm not really sure what happened as with the 1850 Total entries, I ended up with 286 Large amongst some other small differences.
-I used the Count tool & Append Field Tool, Text To Column, 2 Formula Tools.
-I always attempt to complete every challenge without the use of custom code, so no Regex for me.

-