΢ͻӦ
WEIXINGJI YU YINGYONG
2000Vol.19No.5P.16-17




ExcelзϵķǱ̷

ժ ҪһExcelнзϵķͨʵ˵˸÷ЧԺʵԡ
ؼʣݷ  Թ滮
ݷݴҪ֮һݶϵͳͻѧоʱҪûѧģͺϡڻѧģһѧۻϽģԸԼͬݵҲǸͬġڽݷʱ򣬲ͬҪģеĵλԽĴ
΢˾Office׼еExcelѾΪೡµ̨ʹߡΪһֱ׼ݼ¼͹ߣдݷʱĻߣͼκԻعȡΪܹExcelиݷһЩǶBASICVBAб̴ķҪгƣԲһ㹤̼Այһ;
ڷ⣬ʵתԽתΪһԹ⣬ӶExcelĹ滮⹤ܺ׵ؽд
1 Ϻ͹滮ĵȼ۹ϵExcelеĹ滮⹤
1ѧʾ
ʧһԣС˷Ϊѧʾ£
xyΪٶǾйϵyfxabУaΪ֪nbΪm
СΪ

ΪbʹEΪС
2滮ѧʾĿ꺯fb0
Gb00
Уb0Ϊ
ʧһԣٶҪõĿ꺯Сֵ
ΪǰĿ꺯СֵԼӦĲb0
3滮֮ĵȼ۹ϵ
ȻеĴbΪ滮еĲb0еСEΪ滮еĿ꺯滮еΪգù滮ͿԵõĽ⡣ȻΪеEΪԺҪ滮ҲһԹ滮⡣
4ExcelеĹ滮⹤
װOffice׼ѡ˹滮⹤ʱ˵Ĺ߲˵лֹ滮ĿѡиĿдԻԺ󣬹߻ݶԻеĶԶй滮⡣
Microsoft Excelġ滮⡱ȡԵ¿˹ѧ˹͡УLeon LasdonͿѧAllan WarenͬGeneralized Reduced GradientGRG2Ż롣Ժ滮ȡFrontline Systems˾John WatsonDan Fylstraṩнηͷ֧߽編Microsoft Excel SolverԺķʽṩõġʹʱҪʵַֻҪĶԻнͿˡ
2 һʵ
Һƽʽʵ
DBSˮҺͶ̿ڵ·õƽ⣮DBSƽŨCͶ̿q֮Ĺϵڱ1С
1ԭʼ
C1.604.526.808.1611.512.718.229.038.957.3
q170.7228.1258.0283.7321.3335.4378.6434.6401.3429.0

Ӧ÷С˷ʽеĲ
qbC1aC£
ȻԺ޷ֱӽԻģз⡣ݾ齫ʼָΪa03b100£082ΪExcelн׼
2׼
ԱĹֵƽ
170.71.6111.34808083522.650312
228.14.52225.67944295.859096867
2586.8284.4755518700.9548418
283.78.16312.8002249846.8230885
321.311.5368.96834552272.271162
335.412.7385.81487812541.659938
378.618.2448.69847534913.796239
434.629533.43227049767.817679
401.338.9588.366487934993.87089
42957.3662.449980754498.8935
ƽ->114064.5968

ҸзֱΪԭʼݡԱԭʼݡݲĹݡƽĳʼֵд洢׼ڼĵԪF1F3ʹԪF4ֵƽۼƵƽֵ
趨滮ԻʹĿ굥ԪΪƽֵӦĵԪF4ĿΪСֵ趨ɱ䵥ԪΪֵӦ3ԪF1F3ԼΪաɵöӦ3ֱΪa0654b185100£0878ʱӦֵԼ3ͼ1ΪݵߵĶա

ͼ1ݵ߶
3 
ԱĹֵƽ
170.71.6148.9687391472.2476993
228.14.52241.8820534189.9449969
2586.8278.5091076420.6234954
283.78.16294.4132802114.7743716
321.311.5323.40220014.419245341
335.412.7331.548215314.83624515
378.618.2360.1970036338.6702774
434.629395.47094831531.082687
401.338.9416.8885563243.003089
42957.3444.4917783239.9951964
ƽ->114064.5968

3 ۺͽ
ʵԿûʹκγĸ׼׶εĹΪExcelĹʽ㣬˹ĽǶԻ䡣ԱʹǷǳġ
Ķʹ͸ʹܷܺظʵҪ֪ѧ趨ı仯Χù滮ԼָĳΪù滮е滮߻Ϲ滮
⣬ĶֱExcelϹģԿԷظıĹ췽Ӷϼ㷽ڱУԭļ㷽ƽΪԭֵıֵ԰СòĹֵָıֵ仯ΧȽϴкʵõ壬ʱֻҪдʽһıеļ㹫ʽûκζĲ
ջұѧԺѧϵ243002
ο
1ģڣExcel 70 for Windows 95̳̣ ѧ磬1997
2ϣӭݴʵƣӹ 磬1989
3ݵԼŻѧ磬1982
4JonathanBardNonlinear Parameter EstimationNew YorkAcademic Press1974
ոڣ19991220
