More work with that FBI Spreadsheet this time on AWB and Shall/May Issue

J

JimDandy

New member
Tacked on some columns with 2011 Census projected data, and some rows with the US - AWB states, and US - AWB and MAY issues states.. anyone with some excel experience want to double check my formulas?

Here's what it looks like if I got my stuff right..
 

Attachments

std dev? And if I can I will. I'm looking for an editor so there are two eyes checking formula because I'm a excel worker, not an excel wonder...
 
devil's advocate here...at first glance it looks to me like these states show the more urban the state's population, the higher the #/100k

Overall, urbanization appears to be a bigger factor than an AWB. Which is an interesting point, as the states with a more rural population I would assume have more (per capita) semi-automatic rifle than those with a more urban population.
 
Actually the most telling trend is the geographic location. Southern States are several of the top 5. Alabama is not on the list either, along with the FLA we already knew about. But the rest of the Deep South hits the high notes pretty well, along with Maryland and DC which could be argued as border states.

However, realizing that, the rest of the country with MAY issue and no AWB can still absorb those much higher rates, and still come out lower per capita than those states with an AWB, May Issue laws, or both.

I still have no idea what you mean by standard deviation, not something I've dealt with before. I've got the VERY basic concept, but no clue how to discover it let alone implement it.

I can't post the sheet because the website only allows PDFs and images. If you have a filesharing site I can upload it to for you, give me location and it's off to the cloud for you.
 
Without going all technical, standard deviation is a measure of how tightly a set of values clusters around the mean (arithmetic average) of those values: the smaller the SD, the less those values spread out around the mean.

Easy to calculate in Excel: the basic formula is =STDEV(number 1;number 2;...). Generally you'll replace "number 1..." with the cell references where the numbers can be found: so =STDEV(A1;A50) will give the standard deviation of the values in the cells from A1 to A50.

Easy as pi. :)

It's a pity that you can't just upload the spreadsheet here and insert it into your post as an attachment -- wouldn't it just raise the tone if we could all upload spreadsheets? Talk about responsible gun owners... :p
 
Excel has a function built in for Standard Deviation, but I don't know what it's supposed to demonstrate in this context.

OP, we can't check your formulae because they don't show up in a .PDF.

It would also help immensely if you just reformat to landscape orientation so all the columns show up on one page. Also, do you have sufficient data to break down "Firearms" into handguns, rifles, and shotguns? Showing how few murders are actually committed with rifles could go a long way (except for the Feinsteins of the world) toward showing just how foolish banning AR-type rifles is.
 
Right, I have to have someone willing to accept an email attachment who will PM me their email address.
Click to expand...
You were able to attach the .PDF. When I clicked your link, it gave me an option to open or to save the file. Can't you just attach the Excel file?
 
Nope, the excel extension is not one of the ones allowed by the board.

Edit: If anyone knows of a free cloud hosting service I'd be happy to put it there for collaborative work as well.
 
that is probably because excel files can contain macros, which is a kind of executable code.... and it is very hard for anti-virus software to scan a macro for a harmful intent. The people who run this website are smart to not allow excel files.
 
I've had someone offer to host it. As I told them, with any luck, we can get it cleaned up, glean some more info from it then start handing it out to folks with a cover letter denoting the conclusions resulting from the spreadsheet.
 
If you have a Google account you could upload it there in their format and just post the link here.

Sent from my ADR6425LVW using Tapatalk 2
 
Jim, I don't understand the second and third columns of data. First is "Total Murders." That I get.

Then you have "Non-Firearm Minus Long Guns" and "Knives Minus Long Guns."

Farther over, you have a column for "Gun" (meaning, I assume, all firearms) murders per 100k population. Then you have one for "rifle." But "long guns" also includes shotguns. It would seem to me that, if you're going to break down total gun murders, it should be broken down into Handgun, Rifle, Shotgun, and Unidentified Firearm.

If you want to PM me your e-mail address, I'll take a shot at doing some cleaning up of the format and send my result back to you.
 
I've done a few things with this spreadsheet since I found it on the FBI website...

Long guns vs non guns for an AWB. To show that they just aren't used often in crime for example.

Lately I've been working on States with permissive gun laws vs Restrictive... FOID cards, state AWB bans, May/Shall issue permits...
 
If you want to stick with files, the .CSV file can be exported from and loaded to major spreadsheet apps. Click Export, CSV (MSDOS), and if it asks say you want commas. The resulting file is just cells separated by commas and is not a potential security issue like a spreadsheet file.
 
Here's another link for those who want another path to the file, provided by a currently anonymous TFL user. It's linked here, so users can download and alter it as they see fit.
 
You must log in or register to reply here.
Back
Top