Tuesday, 8 July 2008

More fun with numbers

I've really got to lay off the number-crunching, because a) I'm not really achieving anything, and b) I'm not a statistician! But playing with numbers does help me to put things into perspective and get myself into a zen place about our pending adoption.

This time I ventured into a realm of terror--Excel! I am not an Excel person, normally avoiding it at all costs. But I wanted to make a graph or chart and couldn't think of any better software package, at least not one that resides on my computer. So I gathered my figures and asked my husband to help me figure out how to create a basic chart.

WARNING: This chart covers referrals received by my agency only, so it may not be relevant to your agency!

What you're seeing is referrals by year, with each colour corresponding to a different year. This chart doesn't address LIDs in any way; it is based on the day a batch of referrals arrived. For example, the referrals shown for July 2008 would be those received this week. And again, referrals are specific to my agency.

I'm a visual person, and for me this helps more clearly illustrate the change in referral patterns and helps me come to terms with the slow-down that is so often talked about.

2 comments:

melody said...

oh my.

since we share the same agency, i have great interest in your chart, but my interest has now become morbid fascination...

UGH.

mlschot

Patience said...

It's a little scary, isn't it! I'm missing numbers for about 5 or 6 months out of 48, but there's enough data there to illustrate the point. Unfortunately.

I'll keep plotting after the Olympics to see if the referral pattern shifts.