The file S12_01.xlsx contains the monthly number of airline tickets sold by a travel agency. Is this time series random? Perform a runs test and find a few autocorrelations to support your answer.
Answer to relevant QuestionsThe file P12_02.xlsx contains the weekly sales at a local bookstore for each of the past 25 weeks. Is this time series random? Perform a runs test and find a few autocorrelations to support your answer.Determine whether the RAND() function in Excel actually generates a random stream of numbers. Generate at least 100 random numbers to test their randomness with a runs test and with autocorrelations. Summarize your findings.The file P03_30.xlsx gives monthly exchange rates (units of local currency per U.S. dollar) for nine currencies. Technical analysts believe that by charting past changes in exchange rates, it is possible to predict future ...The purpose of this problem is to get you used to the concept of autocorrelation in a time series. You could do this with any time series, but here you should use the series of Walmart daily stock prices in the file ...The file P12_31.xlsx lists the monthly unemployment rates for several years. A common way to forecast time series is by using regression with lagged variables. a. Predict future monthly unemployment rates using some ...
Post your question