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

 

[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