Friday Challenge – Analyzing Attendance Records with Charts and Trend Line

For this Friday Challenge, lets see if we can help this user with their data.

Read it over, but really, the last line of the request is my favorite “other ways”.  This can be with one chart or with many in a dashboard style.

So have at it and if you want to send me your answers, leave me a comment below and I can send you an email for your submissions.

 

“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. Data is provided below. If you’d like to provide other ways to consider presenting the data, please feel free to share!”





ABCDEFGHIJ
1201320122011201020092008200720062005
2??Jan242270242286279292314322315
3Feb237240256235290292280298311
4Mar277243257311275366297319395
5April222322348295354306346400324
6May235229229242273312274300330
7June197219226236242268253298313
8July203197183212212282252283275
9Aug210211212221247272254292276
10Sept202213223266236319305313305
11Oct219221229240243259280300311
12Nov234272278289280315281340
13Dec237266255237276301356349
14AVG236245256265294289314320
15Diff.911829-4247

Looking forward to your submissions.

Steve=True





LEAVE A REPLY

Please enter your comment!
Please enter your name here