La presente investigación aplica el método simplex de programación lineal (PL) en la empresa objeto estudio para obtener máxima utilidad venta sus productos estrella. Una vez definido problema, se establece función objetivo y las restricciones, luego procesa modelo matemático utilizando software Solver – Excel obtiene solución óptima. Esto es, dadas ciertas condiciones cuanto a disponibilidad r...

著者ら [1]は,2011年の東日本大震災後に見られ た情報リテラシーにかかわる問題点を論じた際に, 公開されたデータの機械可読性の低さを指摘した。 それらのデータは,Excel に入力されていながら, 公開情報が PDF だけであったり,時にはデータ抽 出禁止の設定がなされていたり画像化されていたり して,集約や再解析にたいへん手間がかかった。 しかし,震災データに限らず,政府統計の総合窓 口 e-Stat [3] や自治体などで公開されているデータ を調べるにつれて,そもそも Excelへの入力の段階 でデータの再利用を考えず,罫線を多用した紙の帳 票作成を最終目的とするものが多いことに気づい た。こうしたデータは,PDFでなく Excelファイル (またはそれから生成した CSVファイル)で公開さ れたとしても,データを再解析するには余計な手間 がかかる。 こうした巧妙だがデー...

Spreadsheets, and MS Excel in particular, are established analysis tools. They offer an attractive user interface, provide an easy to use computational model, and offer substantial interactivity for what-if analysis. However, as opposed to RDBMS, spreadsheets do not provide a central repository hence they do not provide shareability of models built in Excel and lead to proliferation of multiple...

Numerous statistical and graphical problems have been reported for different versions of Microsoft Excel, including the newest version (Excel 2007). We report newly discovered problemswith Excel 2007when generating polynomial trend line equations, having a userspecified (forced) intercept, from graphed data. We also remind users of Excel’s Trendline function of problems with Excel 2003 that hav...

Survival curves are frequently used for reporting survival or mortality outcomes of experimental pharmacological/toxicological studies and of clinical trials. Microsoft Excel is a simple and widely used tool for creation of numerous types of graphic presentations however it is difficult to create step-wise survival curves in Excel. Considering the familiarity of clinicians and biomedical scient...

Some of the problems that rendered Excel 97, Excel 2000 and Excel 2002 unfit for use as a statistical package have been fixed in Excel 2003, though some have not. Additionally, in fixing some errors, Microsoft introduced other errors. Excel’s new and improved random number generator, at default, is supposed to produce uniform numbers on the interval (0,1); but it also produces negative numbers....

The emergence of data analytics has fundamentally transformed supply chain management strategies in the global marketplace during past decade. Classification is one most popular methods and receives a great deal attention literature, but there are still some questions concerning performance characteristics different classification methods. This paper analyzes three methods: trees, k-nearest nei...