I work for a General Motors Automobile dealership. The factory provides our Customer Satisfaction data in percentages and as a 3-month rolling average. I would like to use that data to calculate the one-month data (why they won't give me an individual months data is beyond me). Other than guessing what dropped off and what was added from one month to the next, is there a way to calculate this (given a 12-month sample size)? Here is an example of 3-month rolling averages:
Jan 90.1
Feb 89.7
Mar 89.3
Apr 90.4
May 91.0
Jun 91.7
Jul 90.3
Aug 90.1
Sep 89.4
Oct 92.4
Nov 92.7
Dec 93
Jan 90.1
Feb 89.7
Mar 89.3
Apr 90.4
May 91.0
Jun 91.7
Jul 90.3
Aug 90.1
Sep 89.4
Oct 92.4
Nov 92.7
Dec 93