基于Excel曲线拟合的稳压电源数据分析  

Data Analysis for Regulated Power Supply Based on Excel Curve Fitting

作　　者：吴春林[1] 吴凌燕[1] 王守权[1] 吴昊[1] 

机构地区：[1]海军航空工程学院青岛校区,山东青岛266041

出　　处：《仪表技术》2017年第6期44-45,48,共3页Instrumentation Technology

摘　　要：通过Proteus对稳压电源电路进行仿真,并采集相关电压数据,利用Excel中的LINEST()和INDEX()函数对采集的数据进行曲线拟合,验证了稳压电源电压的输出特性,在Excel软件对电路的分析方面具有参考价值。The paper adopted the Proteus software to simulate the stabilized voltage supply circuit. The related voltage data are collected and processed through curve fitting with functions LINEST （ ） and INDEX （ ） of the Excel to verify outputcharacteristic of regulated power supply. It was verified that the software Excel had the reference value to the analysis of the circuit.

关 键 词：稳压电源 EXCEL 曲线拟合 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]