install.packages('readxl')
install.packages('forecast')
install.packages('fUnitRoots')
install.packages('tseries')
library(readxl)
library(forecast)
data <- read_excel(path = 'C:\\Users\\Admin\\Desktop\\新建文件夹\\价格预测--ARIMA.xlsx')
price= data
pricets=ts(price,start=c(2017/1/1),frequency = 12)
pricets
plot(pricets)
pricetsdiff=diff(pricets,differences=2)
plot.ts(pricetsdiff)
library(fUnitRoots)
urdfTest(pricets)
library(tseries)
adf.test(pricetsdiff)
acf(pricetsdiff,lag.max=20)
acf(pricetsdiff,lag.max=20,plot=FALSE)
pacf(pricetsdiff,lag.max=20)
pacf(pricetsdiff,lag.max=20,plot=FALSE)
library(forecast)
pricearima=Arima(pricets,order=c(12,2,10))
pricearima
pricearimaforecast=forecast(pricearima,h=5,level=c(90,99))
pricearimaforecast
plot(forecast(pricearimaforecast))
qqnorm(pricearima$residuals);qqline(pricearima$residuals)
acf(pricearimaforecast$residuals,lag.max=20)
Box.test(pricearimaforecast$residuals,lag=20,type="Ljung-Box")
plot.ts(pricearimaforecast$residuals)