| Excel规划求解的两类应用 |
| |
| 引用本文： | 顾运筠.Excel规划求解的两类应用[J].计算机应用与软件,2005,22(1):137-139. |
| |
| 作者姓名： | 顾运筠 |
| |
| 作者单位： | 上海体育运动技术学院,上海,200030 |
| |
| 摘 要： | Excel规划求解在很多方面都有应用，但它的应用在一般的教材和Excel的帮助中都没有详细的介绍。本文介绍用Excel规划求解来解决线性规划和非线性回归这两类问题。这两类问题分别在经济、交通、通信和生物医学等领域都有广泛的应用。如果不用Excel的规划求解，解决线性规划和非线性回归问题是相当复杂的编程运算。应用了规划求解则可以直观而简捷地求得答案。本文对两类问题都提供案例，给出解决方案的步骤。
|
| 关 键 词： | 答案 教材 运算 求解 线性规划 帮助 一般 问题 经济 交通 |
TWO SORTS OF APPLICATIONS USING EXCEL SOLVER |
| |
| Gu?Yunyun.TWO SORTS OF APPLICATIONS USING EXCEL SOLVER[J].Computer Applications and Software,2005,22(1):137-139. |
| |
| Authors: | Gu?Yunyun |
| |
| Abstract: | Although Excel solver is very useful in practice,there is no detail information about the application of Excel Solver in text books and Excel help.This article introduce a simple,easy method to solve linear programming problem and non linear regression problem.Both problems have a wide application in various practical fields,such as economics,transportation,communication,biomedicine and etc.Figuring out these two problems are difficult,but the method described here is to use the Solver function of Microsoft Excel spreadsheet to both problems.It is easy to be understood and implemented step by step. |
| |
| Keywords: | Excel Solver Linear programming Non linear regression Curve-fit |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
