dear,
everyone
now i am doing a assignment about udfs. i want to make a userform to regression some foreign exchange rate data and use the parameters to forecast the exchange rate in next term.
i know that the linest function can output the parameters of the regression, but i dont know how to calculate the product of the output of linest function and the known data to do the forecast.
what i have tried is that =sum(linest(array1,array2,,)*{a,b,c,1}) (assume that there is 3 parameters), but the result was different from what i did by the data analysis in data ribbon.
thanks a lot~
everyone
now i am doing a assignment about udfs. i want to make a userform to regression some foreign exchange rate data and use the parameters to forecast the exchange rate in next term.
i know that the linest function can output the parameters of the regression, but i dont know how to calculate the product of the output of linest function and the known data to do the forecast.
what i have tried is that =sum(linest(array1,array2,,)*{a,b,c,1}) (assume that there is 3 parameters), but the result was different from what i did by the data analysis in data ribbon.
thanks a lot~