Fire Stats: Data Analysis for the Fire Service

Partners

Basic Operations

auto fill
auto sum
block, copy, paste
block, cut, paste
deleting and clearing data
entering numeric data
entering text data
name, insert, delete a sheet
navigating with ctrl and arrow keys
right click
undo

Formatting

cell format tool bar
format painter
adjusting right of decimal_demo
cell format icons
freezing panes
insert and delete columns
insert and delete rows
paste values
setting colum widths 1
setting colum widths 2
transpose

Statistical Functions

Count
average1
average2
max
min
range
standard deviation
sum

Basic Math Functions

addition
division
entering numeric data
multiplication
subtraction
sum

Sorting and Filtering

sorting with icons 1
sorting with icons 2
sorting with menus 1
sorting with menus 2
using the auto filter

Other Operations

adding comments
concatenating data
parsing data 1
parsing data 2
paste values_demo
remove or edit a comment

Analysis Toolpak

Activate the Analysis ToolPak
Analysis ToolPak -- Descriptive Statistics

Holding Cell References Constant

holding cell references constant 1
holding cell references constant 2
holding cell references constant 3

Pivot Tables

pivot table 1
pivot table 2
pivot table 3
pivot table 4

Extracting Date and Time Data

extracting day from a date field
extracting hour from a time field
extracting month from a date field
extracting year from a date field

Time Formats

time formats 1
time formats 2

FireStats’ founder and president, Paul Rottenberg, is an experienced conference presenter who gives engaging, dynamic and relevant presentations on fire service statistical methods, the need for management sciences to be embraced in the Fire Service, and his own statistical observations of Fire Service operations through statistics.