Excel can be a very useful tool. Though it cannot easily do the most advanced statistical tasks. Excell can tackle most everyday business analytics. Today we see how a business advisor discusses a range of challenges including smoothing data. Balanced Scorecards Ron Person shows how to produce balanced scorecards in a book that is packed…
Category: Academic Marketing
Field Guide to Lies
Daniel Levitin has an very enjoyable and informative popular science book in his Field Guide to Lies. He surveys how we know what we know, and how we communicate it to others. To be fair not all of it is about lies, for instance, he discusses how data is collected. A lot of the problems he…
The Persistence of Academic Customs
Recently I was reading Max Weber’s thoughts on “Science as a Vocation” given in a lecture on November 7th, 1917. By science Weber means knowledge creation in the broader sense so pretty much all academics should be included as scientists. It can also tell us about the persistence of academic customs. The Persistence of Academic Customs There…
Teaching CLV Badly
Ex-Ivey PHD student and now University of Calgary professor, Charan Bagga, and I have just published an article. This focused on the teaching of CLV (Customer Lifetime Value). We surveyed the state of case-based teaching materials related to CLV and found them a pretty shoddy bunch. Teaching CLV badly seems to be the default way to teach…
The Secret Axis: Label Your Axis So As Not To Lie
Gary Smith’s advice on statistics, Standard Deviations, is a really useful and entertaining book. In this Smith points out a number of major problems with the way stats are used. Some problems arise from deliberate tricks played by researchers/managers describing data. Other problems arise through carelessness; the researcher/manager using the data doesn’t realize they are abusing…
The Red Queen And Implications For Best Practice
It is hard to spend any time at a business school without hearing the phrase best practice. We teach students best practice. Junior professors seek hints from senior folk on best practice. Even schools regularly go through bouts of benchmarking to see if they are adopting best practice. Best practice essentially is something that gets the most…
Lying With Statistics
While statistics can help us understand the world there is plenty of opportunity to abuse them to mislead. Darrell Huff wrote a short book that was first published in 1952 on lying with statistics. Some of the text shows its age (lots of male pronouns and references to gentleman) but many of the lessons remain applicable today. Reading Huff’s…
How Do Academic Marketers Choose Their Objectives?
I think one of the great problems in marketing academia is that we spend a lot of time thinking about our models and very little time on our data. We have increasing clear views of how things connect up but we don’t really know what it is that we are connecting up. Deciding what objective…
Spurious Correlations: A Big Problem With Big Data?
Tyler Vigen has done great work popularizing Spurious Correlations. He has found an effective way to convey an important message. Namely, that correlation does not equal causation. Lots of things are correlated but that doesn’t mean that they have anything to do with each other. Data Dredging To create his graphs Vigen indulges in: Data Dredging… a technique used…
How Do We Determine Author Order?
Academics enjoy splitting into obscure little groups. What is more they rarely agree about what is interesting. Perhaps the only thing we can agree on is that academics, and the problems facing academics, are fascinating. A major problem for academics is determining author order on joint works. Academic Teams Most academic articles are created by teams. Given that, in marketing…
