Analyzing Attendence Records with Charts and Trend Line Excel 97-2003

[dashboard47]

Hi All, I have completed multiple charts and statistical analysis years ago in statistics class and I cannot remember how to do a simple analysis of a multiple year, weekly attendance record. I used the linear chart template and plotted the data that way, but I'd like to take it further and add a trend line so that I can get an idea of what's going on overall, instead of just looking at the yearly averages. Do I need a linear regression line? Data is provided below. (I originally only plotted the Jan-Dec against the 2005-2013 years and left out the avg and diff.) If you'd like to provide other ways to consider presenting the data, please feel free to share! I am new to this forum so please bear with me and thank you in advance!

	2013	2012	2011	2010	2009	2008	2007	2006	2005
Jan	242	270	242	286	279	292	314	322	315
Feb	237	240	256	235	290	292	280	298	311
Mar	277	243	257	311	275	366	297	319	395
April	222	322	348	295	354	306	346	400	324
May	235	229	229	242	273	312	274	300	330
June	197	219	226	236	242	268	253	298	313
July	203	197	183	212	212	282	252	283	275
Aug	210	211	212	221	247	272	254	292	276
Sept	202	213	223	266	236	319	305	313	305
Oct	219	221	229	240	243	259	280	300	311
Nov	-	234	272	278	289	280	315	281	340
Dec	-	237	266	255	237	276	301	356	349
AVG	-	236	245	256	265	294	289	314	320
Diff.	-	9	11	8	29	(4)	24	7	-

<tbody>
</tbody>

 

[Steve=True]

Hi Dashboard47,

One technique is to use a Six Sigma Control Charts. You can see a demonstration and download a sample file with your data here:Analyzing Attendance Records with Six Sigma Charts | Excel Dashboard Templates

Hope this helps.

Steve=True

 

[dashboard47]

Hi Dashboard47,

One technique is to use a Six Sigma Control Charts. You can see a demonstration and download a sample file with your data here:Analyzing Attendance Records with Six Sigma Charts | Excel Dashboard Templates

Hope this helps.

Steve=True

Thank you so much Steve, that's exactly what I was looking for!

 

[Steve=True]

Awesome. I am so glad to help. Thanks for the great comment.

Steve=True