Statistical Soup: What you can do with stats

1
Statistical SoupWhat you can do with stats
reports

• Diane Brodson,
• Arlington Heights Memorial Library
• Ane Carriveau, Ripon College

2
Who we are

• Arlington Heights Memorial Library
• Public Library
• Population 74,138
• Staff 240 includes 23 FT librarians plus 52 FT
  165 PT staff
  
• 200 Volunteers 196 JLVs
• 459,000 Items

• Lane Library Ripon College
• Liberal Arts College
• Bachelors degree (no graduate students)
• Serving 1000 students and 60 Faculty
• 4 librarians, 1 Staff, 40 student workers
• 240,000 items

3
Ways to get stats reports

• Web management reports
• Millennium statistical reports

4
What do you need to find out?

• Age of collection
• Item counts (how many do you have?)
• Circulation stats (how popular is it? get
  turnover rates)
  
• Internal use? Copy use?
• Money spent by format, by genre, by Dewey
• Fulfillment rate (number holds by format and
  genre)
  
• Using data
• to increase budgets
• sunset collections
• make sure youre buying evenly
• make sure youre buying what patrons want
• To maintain the collections
• Zero-circ reports (weeding)
• New book added (move into regular collection)
• DVD circs over 50 (earmark for cleaning)

5
Using Milstats
Scroll down to click Statistics
Scroll down to click the Statistics icon.
6
Milstats Opening Screen
Click New Query
7
Name it Grab it!
Name it!
Grab it!
Corey Seemans Milstats 101
8
Define it! (what are you counting?)
Items

• Choose items
• Click Field Statistics
• Fastest Accumulation
• Run the Query!

9
It may take a few hours let it run over night!
Click Results
When complete
10
Select report! (Export to Excel?)
11
Open in Excel
12
Clean up the columns
13
In Excel

• Choose what is important to see.
• Add a column for turnover rate?
• Formula LYRCirc / record count
• Remember the Caveats!
• Are you comparing 4-week books with one-week
  DVDs?
  
• Corey cautions people to keep saved queries in
  Results Files.

14
Adding a column for turnover rate.
LYRCRC/ Record Count Turnover rate Caveat a
snapshot!
15
Adult Print and AV
16
SCAT Table 2
17
SCAT Table 2 turnover rates
To see what is circulating the most
18
What isnt circulating well?
Are these areas candidates for weeding?
19
Combining statistics
20
Possible Academic Uses

• Evaluating your collection
• Space planning
• Weeding
• Justifying your budget
• Checking for coding mistakes
• Seeing how your users search

21
Academic Space Planning
22
Academic Collection Planning
23
Age of Collection
24
Circ Stats from Web Reports
Choose your criteria.
25
Checkout Report by Location
Use arrows to scroll through reports
26
Circ Stats by Location and Call Number
27
Opac Searches
28
Kinds of Searches by Index
29
Remember Innopacusers Group
Even if you cant go..
30
You can get slides
Like Ben Kleins Using WMR for Circ Work
31
Remember CS Direct
FAQs, Tutorials, Archives
32
Thank you

• Any Questions?
• Contact us
• Ane Carriveau carriveaua_at_ripon.edu
• Diane Brodson dbrodson_at_ahml.info