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:

Question Posted: