SOS: want to randomly fill address field in a spreadsheet
Dear all I am wondering if anyone knows how to fill randomly a spreadsheet with a list of address picked from a given area or region or city? thanks for your help Regards, Babiga -- -- BIRREGAH Babiga, Phd Enseignant-Chercheur/ Assistant professor ICD UMR-CNRS 6279 STMR Sciences et Technologies pour la Maîtrise des Risques Joint Research Unit in Sciences and Technologies for Risk Management Department of Operational Research, Applied Statistics and Simulation UTT - ROSAS LM2S H107 12 Rue Marie Curie CS 42060 10004 TROYES CEDEX Tél. +33 (0) 325715869 Fax. +33 (0) 325715649 QR: http://goo.gl/Et0A4
I would number another column in your address list and then run your random-number generator against that. Steve Lovaas Sent from my iPhone
On Apr 28, 2014, at 5:11 PM, "Babiga Birregah" <bbirregah@gmail.com> wrote:
Dear all I am wondering if anyone knows how to fill randomly a spreadsheet with a list of address picked from a given area or region or city? thanks for your help
Regards, Babiga --
-- BIRREGAH Babiga, Phd Enseignant-Chercheur/ Assistant professor ICD UMR-CNRS 6279 STMR Sciences et Technologies pour la Maîtrise des Risques Joint Research Unit in Sciences and Technologies for Risk Management Department of Operational Research, Applied Statistics and Simulation UTT - ROSAS LM2S H107 12 Rue Marie Curie CS 42060 10004 TROYES CEDEX Tél. +33 (0) 325715869 Fax. +33 (0) 325715649 QR: http://goo.gl/Et0A4 _______________________________________________ The Air-L@listserv.aoir.org mailing list is provided by the Association of Internet Researchers http://aoir.org Subscribe, change options or unsubscribe at: http://listserv.aoir.org/listinfo.cgi/air-l-aoir.org
Join the Association of Internet Researchers: http://www.aoir.org/
thanks but my concerns is that: 1) how to pick a list of postal addresses corresponding to a given area or city (from a map) 2) and then randomly choose some of them to fill my excel column of addresses regards Babiga 2014-04-29 1:26 GMT+02:00 Lovaas,Steven <Steven.Lovaas@colostate.edu>:
I would number another column in your address list and then run your random-number generator against that.
Steve Lovaas
Sent from my iPhone
On Apr 28, 2014, at 5:11 PM, "Babiga Birregah" <bbirregah@gmail.com> wrote:
Dear all I am wondering if anyone knows how to fill randomly a spreadsheet with a list of address picked from a given area or region or city? thanks for your help
Regards, Babiga --
-- BIRREGAH Babiga, Phd Enseignant-Chercheur/ Assistant professor ICD UMR-CNRS 6279 STMR Sciences et Technologies pour la Maîtrise des Risques Joint Research Unit in Sciences and Technologies for Risk Management Department of Operational Research, Applied Statistics and Simulation UTT - ROSAS LM2S H107 12 Rue Marie Curie CS 42060 10004 TROYES CEDEX Tél. +33 (0) 325715869 Fax. +33 (0) 325715649 QR: http://goo.gl/Et0A4 _______________________________________________ The Air-L@listserv.aoir.org mailing list is provided by the Association of Internet Researchers http://aoir.org Subscribe, change options or unsubscribe at: http://listserv.aoir.org/listinfo.cgi/air-l-aoir.org
Join the Association of Internet Researchers: http://www.aoir.org/
-- -- BIRREGAH Babiga, Phd Enseignant-Chercheur/ Assistant professor ICD UMR-CNRS 6279 STMR Sciences et Technologies pour la Maîtrise des Risques Joint Research Unit in Sciences and Technologies for Risk Management Department of Operational Research, Applied Statistics and Simulation UTT - ROSAS LM2S H107 12 Rue Marie Curie CS 42060 10004 TROYES CEDEX Tél. +33 (0) 325715869 Fax. +33 (0) 325715649 QR: http://goo.gl/Et0A4
Google a postcode or zip code file for the map area. Use the zip code or postal code list as your index. Do the research to fill in other address information you will need later. You should now have an excel file with one row per address. You are now done step 1 in your request. Then using Steven's help suggestion create a random variable in a column beside the address info. Setting the random variable is what is known as sampling in a sense. Say a random number between 0 and 1 and if greater than 0.5 you select them if less you don't select them. You can filter your address list on the value of the random variable and presto you have your list of addresses randomly selected. If you can't do this then hire a statistician. Read a book on sampling methods. On Mon, Apr 28, 2014 at 7:30 PM, Babiga Birregah <bbirregah@gmail.com>wrote:
thanks but my concerns is that: 1) how to pick a list of postal addresses corresponding to a given area or city (from a map) 2) and then randomly choose some of them to fill my excel column of addresses regards Babiga
2014-04-29 1:26 GMT+02:00 Lovaas,Steven <Steven.Lovaas@colostate.edu>:
I would number another column in your address list and then run your random-number generator against that.
Steve Lovaas
Sent from my iPhone
On Apr 28, 2014, at 5:11 PM, "Babiga Birregah" <bbirregah@gmail.com> wrote:
Dear all I am wondering if anyone knows how to fill randomly a spreadsheet with a list of address picked from a given area or region or city? thanks for your help
Regards, Babiga --
-- BIRREGAH Babiga, Phd Enseignant-Chercheur/ Assistant professor ICD UMR-CNRS 6279 STMR Sciences et Technologies pour la Maîtrise des Risques Joint Research Unit in Sciences and Technologies for Risk Management Department of Operational Research, Applied Statistics and Simulation UTT - ROSAS LM2S H107 12 Rue Marie Curie CS 42060 10004 TROYES CEDEX Tél. +33 (0) 325715869 Fax. +33 (0) 325715649 QR: http://goo.gl/Et0A4 _______________________________________________ The Air-L@listserv.aoir.org mailing list is provided by the Association of Internet Researchers http://aoir.org Subscribe, change options or unsubscribe at: http://listserv.aoir.org/listinfo.cgi/air-l-aoir.org
Join the Association of Internet Researchers: http://www.aoir.org/
--
-- BIRREGAH Babiga, Phd Enseignant-Chercheur/ Assistant professor ICD UMR-CNRS 6279 STMR Sciences et Technologies pour la Maîtrise des Risques Joint Research Unit in Sciences and Technologies for Risk Management Department of Operational Research, Applied Statistics and Simulation UTT - ROSAS LM2S H107 12 Rue Marie Curie CS 42060 10004 TROYES CEDEX Tél. +33 (0) 325715869 Fax. +33 (0) 325715649 QR: http://goo.gl/Et0A4 _______________________________________________ The Air-L@listserv.aoir.org mailing list is provided by the Association of Internet Researchers http://aoir.org Subscribe, change options or unsubscribe at: http://listserv.aoir.org/listinfo.cgi/air-l-aoir.org
Join the Association of Internet Researchers: http://www.aoir.org/
participants (3)
-
Babiga Birregah -
Lovaas,Steven -
Peter Timusk