Question: The file P12 06 xlsx contains the weekly sales at the local
The file P12_06.xlsx contains the weekly sales at the local outlet of West Coast Video Rentals for each of the past 36 weeks. Perform a runs test and find a few autocorrelations to determine whether this time series is random.
Answer to relevant QuestionsDetermine 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 P12_12.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month ...The closing value of the Dow Jones Industrial Average for each trading day for a one-year period is provided in the file P12_19.xlsx.a. Use the random walk model to forecast the closing price of this index on the next ...Consider the proportion of Americans under the age of 18 living below the poverty level. The data are in the file P02_44.xlsx.a. Find the first six autocorrelations of this time series.b. Use the results of part a to specify ...The closing value of the AMEX Airline Index for each trading day during a one-year period is given in the file P12_17.xlsx.a. How well does the moving average method track this series when the span is 4; when the span is ...
Post your question