SPSS预测数据

来源：百度知道 编辑：UC知道 时间：2024/05/22 19:17:38
年份 人数 指数函数 对数函数 乘幂函数
2008 120
2009 154
2010 117
2011 141
2012 228
2013 172
2014 182
2015 194
2016 .
2017 .
2018 .
2019 .
2020 .
求本组数据2016年-2020年的人数预测及其三类对应函数（请先补充答案，之后详细写明在spss或excel里的求解步骤）
解答后追加分数

在excel里面可以做。用回归得出回归公式，然后利用回归公式推出即可。
预测结果
年份...…...年限…...数量... ... ...对数... ... ...指数... ... ...乘幂
2008...…...1...…...120... ... ... ...113.9... ...124.644174. .....116.28
2009...…...2...…...154... ... ... ...139.8375675...133.0151552...137.2496982
2010...…...3...…...117... ... ...155.0100718... ...141.9483232...151.2280761
2011...…...4...…...141... ... ...165.775135... ...151.4814341...162.001029
2012...…...5...…...228... ... ...174.1251667... ...161.6547795...170.8829167
2013...…...6...…...172... ... ...180.9476393... ...172.5113567...178.5002391
2014...…...7...…...182... ... ...186.7159578... ...184.0970511...185.2049007
2015...…...8...…...194... ... ...191.7127025... ...196.4608295...191.2159643
2016.... .....9........ ... ... ... ... ....196.1201437...209.6549471...196.6798332
2017......10......... ... ... ... ... ... ...200.0627342...223.7351688...201.6995936
2018......11......... ... ... ... ... ...