The file named Lagged.xlsx contains data about the number of magazine ads placed by the US Army
Question:
The file named Lagged.xlsx contains data about the number of magazine ads placed by the US Army recruiting group during each of 60 consecutive months. For each month, the kmonth lagged number of ads is defined to equal the number of ads placed k months ago. For months 7 through 60, you want to compute the one-month lagged, through six-month lagged values of the number of ads. Use the OFFSET function to efficiently compute these lagged values.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Microsoft Excel Data Analysis And Business Modeling
ISBN: 9780137613663
7th Edition
Authors: Wayne Winston
Question Posted: