NavigationPopular content |
About StatOpsStatOps stands for Statistics and Operations Research. Most of the posts are "tidbit" in nature and easily accessible to the layperson. Please also see the Help section where we can help you with advice to statistics problems. Excel Considered Harmful (by me)I've been meaning to post this for a while: Excel is a horrible way to store and transmit data. Let me explain further what I mean: when working with data, it's important that those data are not modified unless you want to modify them. Excel likes to tamper with whatever you insert into its cells unless they're text type, so something that may appear to Excel to be a date is irrevocably lost when Excel decides to corrupt it. Just another example of Microsoft-induced lossage (another rant altogether). Excel is not a database. It doesn't preserve your data as you intended them to be. And while I'm at it, creating multiple tabs is not a substitute for some kind of indicator. Whenever I encounter data that is generally a mess and disorganized it has been sent to me as an Excel file. Excel is good at what it is, but it isn't, as I say, a database or a reliable means to transmit data to another party.
SpamI just cleaned out a number of spammy link comments. I feel as if I've neglected my poor site (which I have) and it got some sort of disease. Luckily I've got what's needed to cure it!
New JobI start my new job next week. I assume I will sign a non-disclosure agreement, and I certainly wouldn't blog about what I do there. But the company's focus is creating models to predict when credit requests are likely to be fraudulent. Statistics in action!
Why study statistics?1. It has a wide range of utility. 2. It has strong career potential.
|
SearchRecommended ReadingUser login |