{"id":"https://openalex.org/W2187938579","doi":"https://doi.org/10.19030/ajbe.v9i1.9574","title":"Determining The Optimal Values Of Exponential Smoothing Constants \u2013 Does Solver Really Work?","display_name":"Determining The Optimal Values Of Exponential Smoothing Constants \u2013 Does Solver Really Work?","publication_year":2016,"publication_date":"2016-01-18","ids":{"openalex":"https://openalex.org/W2187938579","doi":"https://doi.org/10.19030/ajbe.v9i1.9574","mag":"2187938579"},"language":"en","primary_location":{"id":"doi:10.19030/ajbe.v9i1.9574","doi":"https://doi.org/10.19030/ajbe.v9i1.9574","is_oa":true,"landing_page_url":"https://doi.org/10.19030/ajbe.v9i1.9574","pdf_url":"https://clutejournals.com/index.php/AJBE/article/download/9574/9670","source":{"id":"https://openalex.org/S2764912790","display_name":"American Journal of Business Education (AJBE)","issn_l":"1942-2504","issn":["1942-2504","1942-2512"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":"https://openalex.org/P4324341412","host_organization_name":"Clute Institute","host_organization_lineage":["https://openalex.org/P4324341412"],"host_organization_lineage_names":["Clute Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"American Journal of Business Education (AJBE)","raw_type":"journal-article"},"volume":null,"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"hybrid","oa_url":"https://clutejournals.com/index.php/AJBE/article/download/9574/9670","any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5111922858","display_name":"Handanhal V. Ravinder","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I166088655","display_name":"Montclair State University","ror":"https://ror.org/01nxc2t48","country_code":"US","type":"education","lineage":["https://openalex.org/I166088655"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Handanhal V. Ravinder","raw_affiliation_strings":["Montclair State University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Montclair State University","institution_ids":["https://openalex.org/I166088655"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5111922858"],"corresponding_institution_ids":["https://openalex.org/I166088655"],"apc_list":null,"apc_paid":null,"fwci":6.5731,"has_fulltext":true,"cited_by_count":36,"citation_normalized_percentile":{"value":0.96345022,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":"9","issue":"1","first_page":"1","last_page":"14"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11918","display_name":"Forecasting Techniques and Applications","score":0.9735999703407288,"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"}},"topics":[{"id":"https://openalex.org/T11918","display_name":"Forecasting Techniques and Applications","score":0.9735999703407288,"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/T13706","display_name":"Management and Optimization Techniques","score":0.007199999876320362,"subfield":{"id":"https://openalex.org/subfields/1408","display_name":"Strategy and Management"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12671","display_name":"Management and Marketing Education","score":0.005900000222027302,"subfield":{"id":"https://openalex.org/subfields/1405","display_name":"Management of Technology and Innovation"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/exponential-smoothing","display_name":"exponential smoothing","score":0.9990000128746033},{"id":"https://openalex.org/keywords/solver","display_name":"Solver","score":0.777999997138977},{"id":"https://openalex.org/keywords/microsoft-excel","display_name":"Microsoft Excel","score":0.4180000126361847},{"id":"https://openalex.org/keywords/mean-absolute-deviation","display_name":"mean absolute deviation","score":0.7910000085830688},{"id":"https://openalex.org/keywords/mean-squared-error","display_name":"mean squared error","score":0.9990000128746033},{"id":"https://openalex.org/keywords/forecast-error","display_name":"forecast error","score":0.593999981880188},{"id":"https://openalex.org/keywords/forecasting-education","display_name":"forecasting education","score":0.796999990940094}],"concepts":[{"id":"https://openalex.org/C3770464","wikidata":"https://www.wikidata.org/wiki/Q775963","display_name":"Smoothing","level":2,"score":0.8645617961883545},{"id":"https://openalex.org/C133710760","wikidata":"https://www.wikidata.org/wiki/Q775837","display_name":"Exponential smoothing","level":2,"score":0.8483074903488159},{"id":"https://openalex.org/C2778770139","wikidata":"https://www.wikidata.org/wiki/Q1966904","display_name":"Solver","level":2,"score":0.8325873613357544},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.6565967798233032},{"id":"https://openalex.org/C2777027219","wikidata":"https://www.wikidata.org/wiki/Q1284190","display_name":"Constant (computer programming)","level":2,"score":0.5281132459640503},{"id":"https://openalex.org/C151376022","wikidata":"https://www.wikidata.org/wiki/Q168698","display_name":"Exponential function","level":2,"score":0.507297694683075},{"id":"https://openalex.org/C139945424","wikidata":"https://www.wikidata.org/wiki/Q1940696","display_name":"Mean squared error","level":2,"score":0.4993009567260742},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.49031880497932434},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.47591835260391235},{"id":"https://openalex.org/C28826006","wikidata":"https://www.wikidata.org/wiki/Q33521","display_name":"Applied mathematics","level":1,"score":0.4633508324623108},{"id":"https://openalex.org/C2780009758","wikidata":"https://www.wikidata.org/wiki/Q6804172","display_name":"Measure (data warehouse)","level":2,"score":0.4383406937122345},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.3775619864463806},{"id":"https://openalex.org/C149782125","wikidata":"https://www.wikidata.org/wiki/Q160039","display_name":"Econometrics","level":1,"score":0.29576200246810913},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.28114786744117737},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.10916855931282043},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.10203367471694946},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.19030/ajbe.v9i1.9574","doi":"https://doi.org/10.19030/ajbe.v9i1.9574","is_oa":true,"landing_page_url":"https://doi.org/10.19030/ajbe.v9i1.9574","pdf_url":"https://clutejournals.com/index.php/AJBE/article/download/9574/9670","source":{"id":"https://openalex.org/S2764912790","display_name":"American Journal of Business Education (AJBE)","issn_l":"1942-2504","issn":["1942-2504","1942-2512"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":"https://openalex.org/P4324341412","host_organization_name":"Clute Institute","host_organization_lineage":["https://openalex.org/P4324341412"],"host_organization_lineage_names":["Clute Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"American Journal of Business Education (AJBE)","raw_type":"journal-article"}],"best_oa_location":{"id":"doi:10.19030/ajbe.v9i1.9574","doi":"https://doi.org/10.19030/ajbe.v9i1.9574","is_oa":true,"landing_page_url":"https://doi.org/10.19030/ajbe.v9i1.9574","pdf_url":"https://clutejournals.com/index.php/AJBE/article/download/9574/9670","source":{"id":"https://openalex.org/S2764912790","display_name":"American Journal of Business Education (AJBE)","issn_l":"1942-2504","issn":["1942-2504","1942-2512"],"is_oa":false,"is_in_doaj":false,"is_core":true,"listed_in":["cwts-core"],"host_organization":"https://openalex.org/P4324341412","host_organization_name":"Clute Institute","host_organization_lineage":["https://openalex.org/P4324341412"],"host_organization_lineage_names":["Clute Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"American Journal of Business Education (AJBE)","raw_type":"journal-article"},"sustainable_development_goals":[],"sustainable_development_goals_aurora":[{"display_name":"Quality education","score":0.6600000262260437,"id":"https://metadata.un.org/sdg/4"}],"study_designs":[],"awards":[],"funders":[{"id":"https://openalex.org/F4320312440","display_name":"Montclair State University","ror":"https://ror.org/01nxc2t48"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2187938579.pdf","grobid_xml":"https://content.openalex.org/works/W2187938579.grobid-xml"},"referenced_works_count":12,"referenced_works":["https://openalex.org/W1489114135","https://openalex.org/W1578181006","https://openalex.org/W2001656019","https://openalex.org/W2037453616","https://openalex.org/W2065156069","https://openalex.org/W2086941789","https://openalex.org/W2098148222","https://openalex.org/W2132782512","https://openalex.org/W2189463472","https://openalex.org/W2990405309","https://openalex.org/W4235142039","https://openalex.org/W4292329842"],"related_works":["https://openalex.org/W2752889686","https://openalex.org/W4361275854","https://openalex.org/W2187822626","https://openalex.org/W2189463472","https://openalex.org/W4210704828","https://openalex.org/W4388484638","https://openalex.org/W4246045214","https://openalex.org/W2566922320","https://openalex.org/W2087029127","https://openalex.org/W2279642160"],"abstract_inverted_index":{"A":[0],"key":[1],"issue":[2],"in":[3,24,110],"exponential":[4],"smoothing":[5,14,46,87,100,132],"is":[6,20,32,122],"the":[7,10,13,33,45,80,86,90,94,99,106,111,114,130],"choice":[8],"of":[9,12,35,44,52,82,92,108,113,116],"values":[11,43],"constants":[15,47,88],"used.":[16],"One":[17],"approach":[18,72],"that":[19,48,120],"becoming":[21],"increasingly":[22],"popular":[23],"introductory":[25],"management":[26,30],"science":[27],"and":[28,73,89,118],"operations":[29],"textbooks":[31],"use":[34,107],"Solver,":[36],"an":[37,75],"Excel-based":[38],"non-linear":[39],"optimizer,":[40],"to":[41,128],"identify":[42,129],"minimize":[49],"a":[50,123],"measure":[51],"forecast":[53,96],"error":[54],"like":[55],"Mean":[56,61],"Absolute":[57],"Deviation":[58],"(MAD)":[59],"or":[60],"Squared":[62],"Error":[63],"(MSE).":[64],"We":[65,78,102],"point":[66],"out":[67],"some":[68],"difficulties":[69],"with":[70,98],"this":[71],"suggest":[74,119],"easy":[76],"fix.":[77],"examine":[79],"impact":[81],"initial":[83,95],"forecasts":[84],"on":[85,105],"idea":[91],"optimizing":[93],"along":[97],"constants.":[101,133],"make":[103],"recommendations":[104],"Solver":[109,127],"context":[112],"teaching":[115],"forecasting":[117],"there":[121],"better":[124],"method":[125],"than":[126],"appropriate":[131]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":9},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":2},{"year":2013,"cited_by_count":1}],"updated_date":"2026-10-16T09:59:22.235173","created_date":"2016-06-24T00:00:00"}