{"id":"https://openalex.org/W4299391","doi":"https://doi.org/10.1080/10691898.2004.11910631","title":"Teaching Optimal Design of Experiments Using a Spreadsheet","display_name":"Teaching Optimal Design of Experiments Using a Spreadsheet","alternate_titles":[],"publication_year":2004,"publication_date":"2004-01-01","ids":{"openalex":"https://openalex.org/W4299391","doi":"https://doi.org/10.1080/10691898.2004.11910631","mag":"4299391"},"language":"en","primary_location":{"id":"doi:10.1080/10691898.2004.11910631","doi":"https://doi.org/10.1080/10691898.2004.11910631","is_oa":true,"landing_page_url":"https://doi.org/10.1080/10691898.2004.11910631","pdf_url":null,"source":{"id":"https://openalex.org/S167168624","display_name":"Journal of Statistics Education","issn_l":"1069-1898","issn":["1069-1898"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["abdc-b","anvur-scientific","cwts-core","doaj","jufo-1","poland-40"],"host_organization":"https://openalex.org/P4310315749","host_organization_name":"American Statistical Association","host_organization_lineage":["https://openalex.org/P4310315749"],"host_organization_lineage_names":["American Statistical Association"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Statistics Education","raw_type":"journal-article"},"parent_works":[],"lineage":["https://openalex.org/W4299391"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1080/10691898.2004.11910631","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5006651644","display_name":"Peter Goos","orcid":"https://orcid.org/0000-0002-3854-6506","observed_orcids":["https://orcid.org/0000-0002-3854-6506"]},"institutions":[{"id":"https://openalex.org/I149213910","display_name":"University of Antwerp","ror":"https://ror.org/008x57b05","country_code":"BE","type":"education","lineage":["https://openalex.org/I149213910"]}],"countries":["BE"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Peter Goos","raw_affiliation_strings":["Universiteit Antwerpen"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universiteit Antwerpen","institution_ids":["https://openalex.org/I149213910"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5089483001","display_name":"Herlinde Leemans","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I99464096","display_name":"KU Leuven","ror":"https://ror.org/05f950310","country_code":"BE","type":"education","lineage":["https://openalex.org/I99464096"]}],"countries":["BE"],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Herlinde Leemans","raw_affiliation_strings":["Katholieke Universiteit Leuven"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Katholieke Universiteit Leuven","institution_ids":["https://openalex.org/I99464096"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5006651644","https://openalex.org/A5089483001"],"corresponding_institution_ids":["https://openalex.org/I149213910","https://openalex.org/I99464096"],"apc_list":{"value":925,"currency":"GBP","value_usd":1134},"apc_paid":{"value":925,"currency":"GBP","value_usd":1134},"fwci":0.8447,"has_fulltext":false,"cited_by_count":14,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.71595464,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":86,"max":94},"biblio":{"volume":"12","issue":"3","first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11875","display_name":"Statistics Education and Methodologies","score":0.6060000061988831,"subfield":{"id":"https://openalex.org/subfields/2613","display_name":"Statistics and Probability"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T11875","display_name":"Statistics Education and Methodologies","score":0.6060000061988831,"subfield":{"id":"https://openalex.org/subfields/2613","display_name":"Statistics and Probability"},"field":{"id":"https://openalex.org/fields/26","display_name":"Mathematics"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11798","display_name":"Optimal Experimental Design Methods","score":0.37229999899864197,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12671","display_name":"Management and Marketing Education","score":0.003800000064074993,"subfield":{"id":"https://openalex.org/subfields/3304","display_name":"Education"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/optimal-design-of-experiments","display_name":"optimal design of experiments","score":0.9629999995231628},{"id":"https://openalex.org/keywords/spreadsheet-based-teaching","display_name":"spreadsheet-based teaching","score":0.8610000014305115},{"id":"https://openalex.org/keywords/interactive-learning","display_name":"interactive learning","score":0.6899999976158142},{"id":"https://openalex.org/keywords/parameter-estimators","display_name":"parameter estimators","score":0.7730000019073486},{"id":"https://openalex.org/keywords/design-matrix","display_name":"design matrix","score":0.44200000166893005},{"id":"https://openalex.org/keywords/optimization-software","display_name":"optimization software","score":0.7710000276565552},{"id":"https://openalex.org/keywords/statistics-education","display_name":"statistics education","score":0.6769999861717224}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7565075159072876},{"id":"https://openalex.org/C185429906","wikidata":"https://www.wikidata.org/wiki/Q1130160","display_name":"Estimator","level":2,"score":0.709517240524292},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.5991163849830627},{"id":"https://openalex.org/C34559072","wikidata":"https://www.wikidata.org/wiki/Q2334061","display_name":"Design of experiments","level":2,"score":0.47334909439086914},{"id":"https://openalex.org/C52913732","wikidata":"https://www.wikidata.org/wiki/Q857102","display_name":"Software design","level":4,"score":0.43389010429382324},{"id":"https://openalex.org/C186394612","wikidata":"https://www.wikidata.org/wiki/Q7098942","display_name":"Optimal design","level":2,"score":0.42987316846847534},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.33889883756637573},{"id":"https://openalex.org/C529173508","wikidata":"https://www.wikidata.org/wiki/Q638608","display_name":"Software development","level":3,"score":0.2708930969238281},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.22054138779640198},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.20925292372703552},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.13545185327529907},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.08231893181800842}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1080/10691898.2004.11910631","doi":"https://doi.org/10.1080/10691898.2004.11910631","is_oa":true,"landing_page_url":"https://doi.org/10.1080/10691898.2004.11910631","pdf_url":null,"source":{"id":"https://openalex.org/S167168624","display_name":"Journal of Statistics Education","issn_l":"1069-1898","issn":["1069-1898"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["abdc-b","anvur-scientific","cwts-core","doaj","jufo-1","poland-40"],"host_organization":"https://openalex.org/P4310315749","host_organization_name":"American Statistical Association","host_organization_lineage":["https://openalex.org/P4310315749"],"host_organization_lineage_names":["American Statistical Association"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Statistics Education","raw_type":"journal-article"},{"id":"pmh:c:irua:49942","doi":null,"is_oa":true,"landing_page_url":"https://hdl.handle.net/10067/499420151162165141","pdf_url":null,"source":{"id":"https://openalex.org/S4306401849","display_name":"Institutional Repository University of Antwerp (University of Antwerp)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I149213910","host_organization_name":"University of Antwerp","host_organization_lineage":["https://openalex.org/I149213910"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of statistics education","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.1080/10691898.2004.11910631","doi":"https://doi.org/10.1080/10691898.2004.11910631","is_oa":true,"landing_page_url":"https://doi.org/10.1080/10691898.2004.11910631","pdf_url":null,"source":{"id":"https://openalex.org/S167168624","display_name":"Journal of Statistics Education","issn_l":"1069-1898","issn":["1069-1898"],"is_oa":true,"is_in_doaj":true,"is_core":true,"listed_in":["abdc-b","anvur-scientific","cwts-core","doaj","jufo-1","poland-40"],"host_organization":"https://openalex.org/P4310315749","host_organization_name":"American Statistical Association","host_organization_lineage":["https://openalex.org/P4310315749"],"host_organization_lineage_names":["American Statistical Association"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Journal of Statistics Education","raw_type":"journal-article"},"sustainable_development_goals":[{"score":0.8278999924659729,"id":"https://metadata.un.org/sdg/4","display_name":"Quality education"}],"study_designs":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320322308","display_name":"KU Leuven","ror":"https://ror.org/05f950310"},{"id":"https://openalex.org/F4320327336","display_name":"Vlaamse regering","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W582652256","https://openalex.org/W1239058172","https://openalex.org/W1608582612","https://openalex.org/W1986098702","https://openalex.org/W2016258062","https://openalex.org/W2030289221","https://openalex.org/W2032902321","https://openalex.org/W2050035105","https://openalex.org/W2055412584","https://openalex.org/W2085499762","https://openalex.org/W2144578442","https://openalex.org/W3097925195","https://openalex.org/W3103871524","https://openalex.org/W3146425672","https://openalex.org/W4291114417","https://openalex.org/W4388257666"],"related_works":["https://openalex.org/W2255427670","https://openalex.org/W6986104405","https://openalex.org/W2792043518","https://openalex.org/W6889700067","https://openalex.org/W2617848252","https://openalex.org/W2041071387","https://openalex.org/W1929200301","https://openalex.org/W2108484033","https://openalex.org/W4388297306","https://openalex.org/W2151399021"],"abstract_inverted_index":{"In":[0],"this":[1,32,122],"paper,":[2],"we":[3],"present":[4],"an":[5],"interactive":[6],"teaching":[7],"approach":[8,21,33],"to":[9,18,49,87],"introduce":[10],"the":[11,25,53,60,77,89,92,101,117,128],"concept":[12],"of":[13,16,27,31,91],"optimal":[14,102],"design":[15,45,79,103],"experiments":[17],"students.":[19],"Our":[20],"is":[22,34,40,58,104,113],"based":[23],"on":[24,127],"use":[26,109],"spreadsheets.":[28],"One":[29],"advantage":[30],"that":[35,43,59],"no":[36],"complex":[37],"mathematical":[38],"theory":[39],"needed":[41],"nor":[42],"any":[44],"construction":[46],"algorithm":[47],"has":[48],"be":[50,125],"discussed":[51],"at":[52],"introductory":[54],"stage.":[55],"Another":[56],"benefit":[57],"students":[61],"build":[62],"all":[63],"necessary":[64],"matrices":[65],"for":[66,121],"concrete":[67],"examples":[68],"starting":[69],"from":[70],"a":[71],"sensible":[72],"initial":[73,78],"design.":[74],"By":[75],"modifying":[76],"by":[80],"trial":[81],"and":[82],"error,":[83],"they":[84,107],"can":[85,108,124],"try":[86],"improve":[88],"properties":[90],"parameter":[93],"estimators":[94],"interactively.":[95],"For":[96],"problems":[97],"in":[98,116],"which":[99,112],"finding":[100],"not":[105],"evident,":[106],"optimization":[110],"software":[111],"readily":[114],"available":[115],"spreadsheet":[118],"software.Supplemental":[119],"data":[120],"article":[123],"accessed":[126],"publisher's":[129],"website.":[130]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4299391","counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-20T13:11:24.684918","created_date":"2016-06-24T00:00:00"}
