{"id":"https://openalex.org/W2041750629","doi":"https://doi.org/10.1080/03610910802154241","title":"An Algorithm for Enhancing Spreadsheet Regression with Out-of-Sample Statistics","display_name":"An Algorithm for Enhancing Spreadsheet Regression with Out-of-Sample Statistics","publication_year":2008,"publication_date":"2008-08-27","ids":{"openalex":"https://openalex.org/W2041750629","doi":"https://doi.org/10.1080/03610910802154241","mag":"2041750629"},"language":"en","primary_location":{"id":"doi:10.1080/03610910802154241","is_oa":false,"landing_page_url":"https://doi.org/10.1080/03610910802154241","pdf_url":null,"source":{"id":"https://openalex.org/S153329750","display_name":"Communications in Statistics - Simulation and Computation","issn_l":"0361-0918","issn":["0361-0918","1532-4141"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547"],"host_organization_lineage_names":["Taylor & Francis"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Communications in Statistics - Simulation and Computation","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5015048469","display_name":"Frank G. Landram","orcid":null},"institutions":[{"id":"https://openalex.org/I188674872","display_name":"West Texas A&M University","ror":"https://ror.org/04gnp7x40","country_code":"US","type":"education","lineage":["https://openalex.org/I188674872"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Frank Landram","raw_affiliation_strings":["West Texas A&M University","West Texas A&M University , Canyon, Texas, USA"],"affiliations":[{"raw_affiliation_string":"West Texas A&M University","institution_ids":["https://openalex.org/I188674872"]},{"raw_affiliation_string":"West Texas A&M University , Canyon, Texas, USA","institution_ids":["https://openalex.org/I188674872"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079164266","display_name":"Robert Pavur","orcid":"https://orcid.org/0000-0002-3283-0434"},"institutions":[{"id":"https://openalex.org/I123534392","display_name":"University of North Texas","ror":"https://ror.org/00v97ad02","country_code":"US","type":"education","lineage":["https://openalex.org/I123534392"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Robert J. Pavur","raw_affiliation_strings":["University of North Texas","University of North Texas, Denton, Texas, USA"],"affiliations":[{"raw_affiliation_string":"University of North Texas","institution_ids":["https://openalex.org/I123534392"]},{"raw_affiliation_string":"University of North Texas, Denton, Texas, USA","institution_ids":["https://openalex.org/I123534392"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5008012558","display_name":"Bahram Alidaee","orcid":"https://orcid.org/0000-0002-1302-391X"},"institutions":[{"id":"https://openalex.org/I368840534","display_name":"University of Mississippi","ror":"https://ror.org/02teq1165","country_code":"US","type":"education","lineage":["https://openalex.org/I368840534","https://openalex.org/I4210141039"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Bahram Alidaee","raw_affiliation_strings":["The University of Mississippi","The University of Mississippi , Oxford, Mississippi, USA"],"affiliations":[{"raw_affiliation_string":"The University of Mississippi","institution_ids":["https://openalex.org/I368840534"]},{"raw_affiliation_string":"The University of Mississippi , Oxford, Mississippi, USA","institution_ids":["https://openalex.org/I368840534"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5015048469"],"corresponding_institution_ids":["https://openalex.org/I188674872"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.14842767,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"37","issue":"8","first_page":"1578","last_page":"1592"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9918000102043152,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T13197","display_name":"Spreadsheets and End-User Computing","score":0.9918000102043152,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11875","display_name":"Statistics Education and Methodologies","score":0.9916999936103821,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6513856053352356},{"id":"https://openalex.org/keywords/regression-analysis","display_name":"Regression analysis","score":0.5528334975242615},{"id":"https://openalex.org/keywords/regression","display_name":"Regression","score":0.5472630262374878},{"id":"https://openalex.org/keywords/sample","display_name":"Sample (material)","score":0.5360584259033203},{"id":"https://openalex.org/keywords/computational-statistics","display_name":"Computational statistics","score":0.5035886168479919},{"id":"https://openalex.org/keywords/dimension","display_name":"Dimension (graph theory)","score":0.48241838812828064},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.4773041009902954},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4771710932254791},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3373851776123047},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.32953688502311707},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.23579168319702148}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6513856053352356},{"id":"https://openalex.org/C152877465","wikidata":"https://www.wikidata.org/wiki/Q208042","display_name":"Regression analysis","level":2,"score":0.5528334975242615},{"id":"https://openalex.org/C83546350","wikidata":"https://www.wikidata.org/wiki/Q1139051","display_name":"Regression","level":2,"score":0.5472630262374878},{"id":"https://openalex.org/C198531522","wikidata":"https://www.wikidata.org/wiki/Q485146","display_name":"Sample (material)","level":2,"score":0.5360584259033203},{"id":"https://openalex.org/C176222170","wikidata":"https://www.wikidata.org/wiki/Q5157340","display_name":"Computational statistics","level":2,"score":0.5035886168479919},{"id":"https://openalex.org/C33676613","wikidata":"https://www.wikidata.org/wiki/Q13415176","display_name":"Dimension (graph theory)","level":2,"score":0.48241838812828064},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.4773041009902954},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4771710932254791},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3373851776123047},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.32953688502311707},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.23579168319702148},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C202444582","wikidata":"https://www.wikidata.org/wiki/Q837863","display_name":"Pure mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C43617362","wikidata":"https://www.wikidata.org/wiki/Q170050","display_name":"Chromatography","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1080/03610910802154241","is_oa":false,"landing_page_url":"https://doi.org/10.1080/03610910802154241","pdf_url":null,"source":{"id":"https://openalex.org/S153329750","display_name":"Communications in Statistics - Simulation and Computation","issn_l":"0361-0918","issn":["0361-0918","1532-4141"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320547","host_organization_name":"Taylor & Francis","host_organization_lineage":["https://openalex.org/P4310320547"],"host_organization_lineage_names":["Taylor & Francis"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Communications in Statistics - Simulation and Computation","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W54269387","https://openalex.org/W1548087870","https://openalex.org/W1983350937","https://openalex.org/W2004130537","https://openalex.org/W2020589258","https://openalex.org/W2020851265","https://openalex.org/W2023699776","https://openalex.org/W2034562813","https://openalex.org/W2035879195","https://openalex.org/W2036400974","https://openalex.org/W2079356438","https://openalex.org/W2502759836","https://openalex.org/W2797195457","https://openalex.org/W2797532987","https://openalex.org/W2898519191","https://openalex.org/W3015395995","https://openalex.org/W3111456773","https://openalex.org/W3125406841","https://openalex.org/W3141341243","https://openalex.org/W4205188732","https://openalex.org/W4232628633","https://openalex.org/W4246048519"],"related_works":["https://openalex.org/W2312753042","https://openalex.org/W4289356671","https://openalex.org/W2389155397","https://openalex.org/W2165884543","https://openalex.org/W3186837933","https://openalex.org/W2368989808","https://openalex.org/W2034959125","https://openalex.org/W2355687852","https://openalex.org/W2621086889","https://openalex.org/W3174513558"],"abstract_inverted_index":{"An":[0],"innovative":[1],"algorithm":[2,16,44],"is":[3,38],"developed":[4],"for":[5],"obtaining":[6],"spreadsheet":[7,47,58,82,86],"regression":[8,50,59,87],"measures":[9],"used":[10],"in":[11,28,91,95],"computing":[12,29],"out-of-sample":[13],"statistics.":[14,31],"This":[15],"alleviates":[17],"the":[18,33,66],"leave-one-out":[19],"computational":[20,76],"simulation":[21],"complexity":[22],"and":[23,72,93],"memory":[24],"size":[25],"problems":[26],"perceived":[27],"these":[30],"Hence,":[32],"purpose":[34],"of":[35,65],"this":[36],"article":[37],"to":[39,57,89],"describe":[40],"a":[41,54],"computationally":[42],"enhanced":[43],"that":[45],"gives":[46],"users":[48],"advanced":[49],"capabilities":[51],"thereby":[52,84],"adding":[53],"new":[55],"dimension":[56],"operations.":[60],"These":[61,75],"statistics":[62],"include":[63],"diagonals":[64],"hat":[67],"matrix,":[68],"legitimate":[69],"forecasting":[70],"intervals,":[71],"PRESS":[73],"residuals.":[74],"innovations":[77],"promote":[78],"learning":[79],"while":[80],"eliminating":[81],"inadequacies":[83],"making":[85],"attractive":[88],"academicians":[90],"teaching":[92],"practitioners":[94],"acquiring":[96],"further":[97],"application":[98],"competence.":[99]},"counts_by_year":[],"updated_date":"2026-02-01T03:34:12.195049","created_date":"2025-10-10T00:00:00"}