In the first part of this blog, Using Solver in Excel, Part 1, we started looking at what we can do with the Solver add-in to the Excel spreadsheet program. We looked at using Solver for the design of ...

今回は「ソルバー」という機能の使い方を紹介していこう。前回の連載で紹介した「ゴールシーク」と少し似ている機能だが、複数の解答がある問題を逆算したり、さまざまな条件を指定したりできるのがソルバーならではの特長。Excelをユニークに活用 ...

Excel can solve equations through several of its mathematical functions, but the single Excel tool that works on the largest variety of equations is the program's Solver Add-in. This tool reads an ...

Stratified mean-per-unit sampling is a key tool used by auditors. The popularity of this statistical procedure arises from its unique ability to produce trustworthy ...