Question: The file P12 02 xlsx contains the weekly sales at a local
The 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.
Answer to relevant QuestionsThe number of employees on the payroll at a food processing plant is recorded at the start of each month. These data are provided in the file P12_03.xlsx. Perform a runs test and find a few auto-correlations to determine ...Use a runs test and calculate auto relations to decide whether the random series explained in each part of this problem (a–c) are random. For each part, generate at least 100 random numbers in the series. a. A series of ...The unit sales of a new drug for the first 25 months after its introduction to the marketplace are recorded in the file P12_15.xlsx.a. Estimate a linear trend equation using the given data. How well does the linear trend fit ...Consider a random walk model with the following equation: Yt = Yt -1 + 500 9 et, where et is a normally distributed random series with mean 0 and standard deviation 10.a. Use Excel to simulate a time series that behaves ...The unit sales of a new drug for the first 25 months after its introduction to the marketplace are recorded in the file P12_15.xlsx. Specify one or more promising auto regression models based on autocorrelations of this time ...
Post your question