Message-ID:

Don't try to have the last word -- you might get it. -- Lazarus Long

interests / alt.usage.english / Help with creating a question - segment of age group

Help with creating a question - segment of age group

<a2b0a4d1-2ba7-409f-9be4-e6fbadc59620n@googlegroups.com>

https://www.novabbs.com/interests/article-flat.php?id=130150&group=alt.usage.english#130150

copy link Newsgroups: alt.usage.english

X-Received: by 2002:ac8:5a15:0:b0:2f3:d052:216a with SMTP id n21-20020ac85a15000000b002f3d052216amr12333036qta.597.1652142329905;
Mon, 09 May 2022 17:25:29 -0700 (PDT)
X-Received: by 2002:a81:6dca:0:b0:2f8:ea70:ed31 with SMTP id
i193-20020a816dca000000b002f8ea70ed31mr17095175ywc.175.1652142329716; Mon, 09
May 2022 17:25:29 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: alt.usage.english
Date: Mon, 9 May 2022 17:25:29 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=69.157.59.98; posting-account=jovOSwoAAABZ57ySkF4tvU1dZXaGCHJ3
NNTP-Posting-Host: 69.157.59.98
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <a2b0a4d1-2ba7-409f-9be4-e6fbadc59620n@googlegroups.com>
Subject: Help with creating a question - segment of age group
From: lezaw...@gmail.com (Userme)
Injection-Date: Tue, 10 May 2022 00:25:29 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1543

by: Userme - Tue, 10 May 2022 00:25 UTC

Hi
I have 2 tables like the one in this link/pictures (sorry for sending the link but hard to explain it)

https://www.timeatlas.com/wp-content/uploads/excel-segment-groups.jpg

So I want to ask a question to find the age of each voter and based on the age to find which age segment (young, mature, etc.) that voter belong to. Is this question fine? How you would write it yourself?
++++++++
Q) Find the age of each voter then use the lookup table (the small table) to find the segment based on that age?
++++++++

Thank you very much.

Re: Help with creating a question - segment of age group

<c963195d-d104-4375-9721-e0ef61fb989bn@googlegroups.com>

copy mid

https://www.novabbs.com/interests/article-flat.php?id=130194&group=alt.usage.english#130194

copy link Newsgroups: alt.usage.english

X-Received: by 2002:a05:620a:318e:b0:6a0:99c9:f6ca with SMTP id bi14-20020a05620a318e00b006a099c9f6camr6901087qkb.485.1652193923856;
Tue, 10 May 2022 07:45:23 -0700 (PDT)
X-Received: by 2002:a5b:38a:0:b0:64a:d339:bdef with SMTP id
k10-20020a5b038a000000b0064ad339bdefmr9827015ybp.248.1652193923694; Tue, 10
May 2022 07:45:23 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer02.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: alt.usage.english
Date: Tue, 10 May 2022 07:45:23 -0700 (PDT)
In-Reply-To: <a2b0a4d1-2ba7-409f-9be4-e6fbadc59620n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=100.8.211.134; posting-account=tXYReAoAAABbl0njRzivyU02EBLaX9OF
NNTP-Posting-Host: 100.8.211.134
References: <a2b0a4d1-2ba7-409f-9be4-e6fbadc59620n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <c963195d-d104-4375-9721-e0ef61fb989bn@googlegroups.com>
Subject: Re: Help with creating a question - segment of age group
From: gramma...@verizon.net (Peter T. Daniels)
Injection-Date: Tue, 10 May 2022 14:45:23 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 1983

by: Peter T. Daniels - Tue, 10 May 2022 14:45 UTC

On Monday, May 9, 2022 at 8:25:31 PM UTC-4, Userme wrote:
> Hi
> I have 2 tables like the one in this link/pictures (sorry for sending the link but hard to explain it)
>
> https://www.timeatlas.com/wp-content/uploads/excel-segment-groups.jpg
>
> So I want to ask a question to find the age of each voter and based on the age to find which age segment (young, mature, etc.) that voter belong to. Is this question fine? How you would write it yourself?
> ++++++++
> Q) Find the age of each voter then use the lookup table (the small table) to find the segment based on that age?
> ++++++++
>
> Thank you very much.

Add a comma before "then"; no question mark after an imperative.

I don't know anything about Excel so I can't say anything about the content.
"Age group" rather than "age segment."

Re: Help with creating a question - segment of age group

<cddfdea0-52bd-44e4-b5d2-9afd7cea1770n@googlegroups.com>

copy mid

https://www.novabbs.com/interests/article-flat.php?id=130208&group=alt.usage.english#130208

copy link Newsgroups: alt.usage.english

X-Received: by 2002:a05:620a:4488:b0:6a0:2aab:a736 with SMTP id x8-20020a05620a448800b006a02aaba736mr16969016qkp.717.1652206006485;
Tue, 10 May 2022 11:06:46 -0700 (PDT)
X-Received: by 2002:a05:6902:1202:b0:649:643e:45ce with SMTP id
s2-20020a056902120200b00649643e45cemr19711637ybu.262.1652206006319; Tue, 10
May 2022 11:06:46 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder6.news.weretis.net!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: alt.usage.english
Date: Tue, 10 May 2022 11:06:46 -0700 (PDT)
In-Reply-To: <c963195d-d104-4375-9721-e0ef61fb989bn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=199.85.253.2; posting-account=jovOSwoAAABZ57ySkF4tvU1dZXaGCHJ3
NNTP-Posting-Host: 199.85.253.2
References: <a2b0a4d1-2ba7-409f-9be4-e6fbadc59620n@googlegroups.com> <c963195d-d104-4375-9721-e0ef61fb989bn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <cddfdea0-52bd-44e4-b5d2-9afd7cea1770n@googlegroups.com>
Subject: Re: Help with creating a question - segment of age group
From: lezaw...@gmail.com (Userme)
Injection-Date: Tue, 10 May 2022 18:06:46 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 2184

by: Userme - Tue, 10 May 2022 18:06 UTC

On Tuesday, May 10, 2022 at 10:45:26 AM UTC-4, Peter T. Daniels wrote:
> On Monday, May 9, 2022 at 8:25:31 PM UTC-4, Userme wrote:
> > Hi
> > I have 2 tables like the one in this link/pictures (sorry for sending the link but hard to explain it)
> >
> > https://www.timeatlas.com/wp-content/uploads/excel-segment-groups.jpg
> >
> > So I want to ask a question to find the age of each voter and based on the age to find which age segment (young, mature, etc.) that voter belong to. Is this question fine? How you would write it yourself?
> > ++++++++
> > Q) Find the age of each voter then use the lookup table (the small table) to find the segment based on that age?
> > ++++++++
> >
> > Thank you very much.
> Add a comma before "then"; no question mark after an imperative.
>
> I don't know anything about Excel so I can't say anything about the content.
> "Age group" rather than "age segment."

Thank you very much for the help. I appreciate it.

Re: Help with creating a question - segment of age group

<277c1013-fd45-4a11-9d9d-a44ada148bc2n@googlegroups.com>

copy mid

https://www.novabbs.com/interests/article-flat.php?id=130314&group=alt.usage.english#130314

copy link Newsgroups: alt.usage.english

X-Received: by 2002:a05:622a:6115:b0:2f1:d8fa:84aa with SMTP id hg21-20020a05622a611500b002f1d8fa84aamr24510893qtb.689.1652281243136;
Wed, 11 May 2022 08:00:43 -0700 (PDT)
X-Received: by 2002:a81:134b:0:b0:2f7:dba3:f7fa with SMTP id
72-20020a81134b000000b002f7dba3f7famr26113170ywt.290.1652281242902; Wed, 11
May 2022 08:00:42 -0700 (PDT)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: alt.usage.english
Date: Wed, 11 May 2022 08:00:42 -0700 (PDT)
In-Reply-To: <cddfdea0-52bd-44e4-b5d2-9afd7cea1770n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=109.157.128.27; posting-account=LTVTUwoAAABvcjQekwKZJC2tQOEPjtss
NNTP-Posting-Host: 109.157.128.27
References: <a2b0a4d1-2ba7-409f-9be4-e6fbadc59620n@googlegroups.com>
<c963195d-d104-4375-9721-e0ef61fb989bn@googlegroups.com> <cddfdea0-52bd-44e4-b5d2-9afd7cea1770n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <277c1013-fd45-4a11-9d9d-a44ada148bc2n@googlegroups.com>
Subject: Re: Help with creating a question - segment of age group
From: spainsha...@gmail.com (spains...@gmail.com)
Injection-Date: Wed, 11 May 2022 15:00:43 +0000
Content-Type: text/plain; charset="UTF-8"

by: spains...@gmail.com - Wed, 11 May 2022 15:00 UTC

On Tuesday, May 10, 2022 at 7:06:49 PM UTC+1, Userme wrote:
> On Tuesday, May 10, 2022 at 10:45:26 AM UTC-4, Peter T. Daniels wrote:
> > On Monday, May 9, 2022 at 8:25:31 PM UTC-4, Userme wrote:
> > > Hi
> > > I have 2 tables like the one in this link/pictures (sorry for sending the link but hard to explain it)
> > >
> > > https://www.timeatlas.com/wp-content/uploads/excel-segment-groups.jpg
> > >
> > > So I want to ask a question to find the age of each voter and based on the age to find which age segment (young, mature, etc.) that voter belong to. Is this question fine? How you would write it yourself?
> > > ++++++++
> > > Q) Find the age of each voter then use the lookup table (the small table) to find the segment based on that age?
> > > ++++++++
> > >
> > > Thank you very much.
> > Add a comma before "then"; no question mark after an imperative.
> >
> > I don't know anything about Excel so I can't say anything about the content.
> > "Age group" rather than "age segment."
> Thank you very much for the help. I appreciate it.

Your question relates to databases again. Follow Peter's instruction to rename
the "Segment" and "Label" columns to "Age group", and you have a Relational
Database with the Key Field being "Age group". Access would be able to link
them together, but you are using Excel - why not teach your students to do the
things only Excel can do?

A Cash Flow Forecast is the most obvious "spreadsheet-only" task.

Re: Help with creating a question - segment of age group

<mn.5c837e65a18b4054.127094@snitoo>

copy mid

https://www.novabbs.com/interests/article-flat.php?id=130432&group=alt.usage.english#130432

copy link Newsgroups: alt.usage.english

Path: i2pn2.org!i2pn.org!eternal-september.org!reader02.eternal-september.org!.POSTED!not-for-mail
From: snidely....@gmail.com (Snidely)
Newsgroups: alt.usage.english
Subject: Re: Help with creating a question - segment of age group
Date: Wed, 11 May 2022 19:15:16 -0700
Organization: Dis One
Lines: 45
Message-ID: <mn.5c837e65a18b4054.127094@snitoo>
References: <a2b0a4d1-2ba7-409f-9be4-e6fbadc59620n@googlegroups.com> <c963195d-d104-4375-9721-e0ef61fb989bn@googlegroups.com> <cddfdea0-52bd-44e4-b5d2-9afd7cea1770n@googlegroups.com> <277c1013-fd45-4a11-9d9d-a44ada148bc2n@googlegroups.com>
Reply-To: snidely.too@gmail.com
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-15"; format=flowed
Content-Transfer-Encoding: 8bit
Injection-Info: reader02.eternal-september.org; posting-host="52d95b072886a32af687836bda524607";
logging-data="18436"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/m5V1jnCexgBC/K4W1Np9GUHd9cE/zeo8="
Cancel-Lock: sha1:csIlcKuSwWIWX7CgPvewwzpkV+A=
X-Newsreader: MesNews/1.08.06.00-gb
X-ICQ: 543516788

by: Snidely - Thu, 12 May 2022 02:15 UTC

On Wednesday or thereabouts, spains...@gmail.com declared ...
> On Tuesday, May 10, 2022 at 7:06:49 PM UTC+1, Userme wrote:
>> On Tuesday, May 10, 2022 at 10:45:26 AM UTC-4, Peter T. Daniels wrote:
>>> On Monday, May 9, 2022 at 8:25:31 PM UTC-4, Userme wrote:
>>>> Hi
>>>> I have 2 tables like the one in this link/pictures (sorry for sending the
>>>> link but hard to explain it)
>>>>
>>>> https://www.timeatlas.com/wp-content/uploads/excel-segment-groups.jpg
>>>>
>>>> So I want to ask a question to find the age of each voter and based on the
>>>> age to find which age segment (young, mature, etc.) that voter belong to.
>>>> Is this question fine? How you would write it yourself? ++++++++ Q) Find
>>>> the age of each voter then use the lookup table (the small table) to find
>>>> the segment based on that age? ++++++++
>>>>
>>>> Thank you very much.
>>> Add a comma before "then"; no question mark after an imperative.
>>>
>>> I don't know anything about Excel so I can't say anything about the
>>> content. "Age group" rather than "age segment."
>> Thank you very much for the help. I appreciate it.
>
> Your question relates to databases again. Follow Peter's instruction to
> rename the "Segment" and "Label" columns to "Age group", and you have a
> Relational Database with the Key Field being "Age group". Access would be
> able to link them together, but you are using Excel - why not teach your
> students to do the things only Excel can do?
>
> A Cash Flow Forecast is the most obvious "spreadsheet-only" task.

Ah, but a lot more businesses are run with Excel than with Access, and
Excel macros may make up 70% of programming in the world, with VB
getting to another 20%. These are rough estimates, but following
Dylan Beattie's talk at NDC Oslo 2021.

[naked ootoob link a.o.r]

/dps

--
"That's a good sort of hectic, innit?"

" Very much so, and I'd recommend the haggis wontons."
-njm

Re: Help with creating a question - segment of age group

<9ee924e7-4cf9-4eb3-a999-cb191465e5c9n@googlegroups.com>

copy mid

https://www.novabbs.com/interests/article-flat.php?id=130490&group=alt.usage.english#130490

copy link Newsgroups: alt.usage.english

X-Received: by 2002:a05:622a:6115:b0:2f1:d8fa:84aa with SMTP id hg21-20020a05622a611500b002f1d8fa84aamr28714389qtb.689.1652361468663;
Thu, 12 May 2022 06:17:48 -0700 (PDT)
X-Received: by 2002:a0d:ff05:0:b0:2ea:25ed:d714 with SMTP id
p5-20020a0dff05000000b002ea25edd714mr31326891ywf.454.1652361468386; Thu, 12
May 2022 06:17:48 -0700 (PDT)
Path: i2pn2.org!i2pn.org!usenet.blueworldhosting.com!feed1.usenet.blueworldhosting.com!peer01.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: alt.usage.english
Date: Thu, 12 May 2022 06:17:48 -0700 (PDT)
In-Reply-To: <mn.5c837e65a18b4054.127094@snitoo>
Injection-Info: google-groups.googlegroups.com; posting-host=109.157.128.27; posting-account=LTVTUwoAAABvcjQekwKZJC2tQOEPjtss
NNTP-Posting-Host: 109.157.128.27
References: <a2b0a4d1-2ba7-409f-9be4-e6fbadc59620n@googlegroups.com>
<c963195d-d104-4375-9721-e0ef61fb989bn@googlegroups.com> <cddfdea0-52bd-44e4-b5d2-9afd7cea1770n@googlegroups.com>
<277c1013-fd45-4a11-9d9d-a44ada148bc2n@googlegroups.com> <mn.5c837e65a18b4054.127094@snitoo>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <9ee924e7-4cf9-4eb3-a999-cb191465e5c9n@googlegroups.com>
Subject: Re: Help with creating a question - segment of age group
From: spainsha...@gmail.com (spains...@gmail.com)
Injection-Date: Thu, 12 May 2022 13:17:48 +0000
Content-Type: text/plain; charset="UTF-8"
X-Received-Bytes: 3635

by: spains...@gmail.com - Thu, 12 May 2022 13:17 UTC

On Thursday, May 12, 2022 at 3:15:25 AM UTC+1, snide...@gmail.com wrote:
> On Wednesday or thereabouts, spains...@gmail.com declared ...
> > On Tuesday, May 10, 2022 at 7:06:49 PM UTC+1, Userme wrote:
> >> On Tuesday, May 10, 2022 at 10:45:26 AM UTC-4, Peter T. Daniels wrote:
> >>> On Monday, May 9, 2022 at 8:25:31 PM UTC-4, Userme wrote:
> >>>> Hi
> >>>> I have 2 tables like the one in this link/pictures (sorry for sending the
> >>>> link but hard to explain it)
> >>>>
> >>>> https://www.timeatlas.com/wp-content/uploads/excel-segment-groups.jpg
> >>>>
> >>>> So I want to ask a question to find the age of each voter and based on the
> >>>> age to find which age segment (young, mature, etc.) that voter belong to.
> >>>> Is this question fine? How you would write it yourself? ++++++++ Q) Find
> >>>> the age of each voter then use the lookup table (the small table) to find
> >>>> the segment based on that age? ++++++++
> >>>>
> >>>> Thank you very much.
> >>> Add a comma before "then"; no question mark after an imperative.
> >>>
> >>> I don't know anything about Excel so I can't say anything about the
> >>> content. "Age group" rather than "age segment."
> >> Thank you very much for the help. I appreciate it.
> >
> > Your question relates to databases again. Follow Peter's instruction to
> > rename the "Segment" and "Label" columns to "Age group", and you have a
> > Relational Database with the Key Field being "Age group". Access would be
> > able to link them together, but you are using Excel - why not teach your
> > students to do the things only Excel can do?
> >
> > A Cash Flow Forecast is the most obvious "spreadsheet-only" task.
> Ah, but a lot more businesses are run with Excel than with Access, and
> Excel macros may make up 70% of programming in the world, with VB
> getting to another 20%. These are rough estimates, but following
> Dylan Beattie's talk at NDC Oslo 2021.

Absolutely. But not the data lookup functions, surely? Excel is fantastic
and firing up a pivot table connected to a 3D ribbon chart, is nothing short
of miraculous. This family tree (which I have linked to before) is an Excel
macro:

https://www.youtube.com/watch?v=NOsLspFE2mQ

Re: Help with creating a question - segment of age group

<3982b221-147e-4a9c-b8a2-9c37132576fbn@googlegroups.com>

copy mid

https://www.novabbs.com/interests/article-flat.php?id=130497&group=alt.usage.english#130497

copy link Newsgroups: alt.usage.english

X-Received: by 2002:a05:622a:1351:b0:2f3:b1e4:9d2e with SMTP id w17-20020a05622a135100b002f3b1e49d2emr184580qtk.412.1652367910339;
Thu, 12 May 2022 08:05:10 -0700 (PDT)
X-Received: by 2002:a25:848d:0:b0:648:961b:5c2b with SMTP id
v13-20020a25848d000000b00648961b5c2bmr217567ybk.41.1652367910065; Thu, 12 May
2022 08:05:10 -0700 (PDT)
Path: i2pn2.org!i2pn.org!aioe.org!news.mixmin.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: alt.usage.english
Date: Thu, 12 May 2022 08:05:09 -0700 (PDT)
In-Reply-To: <a2b0a4d1-2ba7-409f-9be4-e6fbadc59620n@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=2a01:e0a:ab8:8630:3470:a921:2d13:5ada;
posting-account=iXFtuQoAAACf6-We4FJmsBUwGjyuQKj5
NNTP-Posting-Host: 2a01:e0a:ab8:8630:3470:a921:2d13:5ada
References: <a2b0a4d1-2ba7-409f-9be4-e6fbadc59620n@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <3982b221-147e-4a9c-b8a2-9c37132576fbn@googlegroups.com>
Subject: Re: Help with creating a question - segment of age group
From: beberc...@aol.com (Bebercito)
Injection-Date: Thu, 12 May 2022 15:05:10 +0000
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

by: Bebercito - Thu, 12 May 2022 15:05 UTC

Le mardi 10 mai 2022 à 02:25:31 UTC+2, Userme a écrit :
> Hi
> I have 2 tables like the one in this link/pictures (sorry for sending the link but hard to explain it)
>
> https://www.timeatlas.com/wp-content/uploads/excel-segment-groups.jpg
>
> So I want to ask a question to find the age of each voter and based on the age to find which age segment (young, mature, etc.) that voter belong to. Is this question fine? How you would write it yourself?
> ++++++++
> Q) Find the age of each voter then use the lookup table (the small table) to find the segment based on that age?
> ++++++++

Not exactly your query, but incidentally "New" isn't a relevant term for
an age group. Maybe "Youth" could be used instead, but that would
imply also renaming the "Young" group, which isn't easy in just one
word. Maybe just "Adult"?

>
> Thank you very much.

Subject	Author
Help with creating a question - segment of age group	Userme
Re: Help with creating a question - segment of age group	Peter T. Daniels
Re: Help with creating a question - segment of age group	Userme
Re: Help with creating a question - segment of age group	spains...@gmail.com
Re: Help with creating a question - segment of age group	Snidely
Re: Help with creating a question - segment of age group	spains...@gmail.com
Re: Help with creating a question - segment of age group	Bebercito