[Video] How to Anonymize Your Data in a Spreadsheet

How to Anonymize Your Data in a Spreadsheet

Thirteen minute video on how to anonymize your data in a spreadsheet using customer names in a fictitious sales ledger as the example with LibreOffice Calc — a free, open source spreadsheet program similar to Microsoft Excel. LibreOffice Calc has many of the features, functions, and user interface elements of Excel, but has some differences.

Our web site:
https://www.mathematical-software.com/

Last updated August 30, 2024

(C) 2024 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Video] Evacuate Gaza

Evacuate Gaza to Minimize Loss of Civilian Lives

Short video on evacuating the Gaza Strip in Israel to minimize loss of civilian lives.

Uncensored Video Sites: BitChute NewTube Odysee Rumble

About Us:

Main Web Site: https://mathematical-software.com/
Censored Search: https://censored-search.com/
A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests!

Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com

Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/

Legal Disclaimers: http://wordpress.jmcgowan.com/wp/legal/

Support Us:
PATREON: https://www.patreon.com/mathsoft
SubscribeStar: https://www.subscribestar.com/mathsoft

Rumble (Video): https://rumble.com/c/mathsoft
BitChute (Video): https://www.bitchute.com/channel/HGgoa2H3WDac/
Brighteon (Video): https://www.brighteon.com/channels/mathsoft
Odysee (Video): https://odysee.com/@MathematicalSoftware:5
NewTube (Video): https://newtube.app/user/mathsoft
Minds (Video): https://www.minds.com/math_methods/
Archive (Video): https://archive.org/details/@mathsoft

#

(C) 2023 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

My Response to Ambassador McFaul’s Tweet on Gaza

(Former) US Ambassador Michael McFaul’s Tweet

The short twitter feed answer:

Evacuate the civilians before using force. Cut off food and water slowly to force them to leave. Provide food etc. only outside. Search everyone who leaves for weapons. Detain Hamas fighters who try to sneak out. Only use force after all civilians are safe.

The longer non-twitter feed answer:

Evacuate the civilian population from Gaza before using force. Establish checkpoints at the border and search everyone leaving for any weapons. Tell them not to bring any weapons including guns, long knives, incendiary materials etc. Set up tents in the desert with plenty of water, basic food, vitamins, other amenities and some sort of benign entertainment as well as medical facilities etc. etc. Cut off food and water as is already being done, perhaps slower however, to force the civilians to leave. Identify and detain Hamas fighters and officials who leave. Those who cannot be linked to war crimes should be prisoners of war. Those culpable for war crimes — murder of civilians etc. — should be arrested and stand trial in some credible international court, not Israel judiciary. Wait until ideally all or most of the civilians are out of the way. If Hamas is not willing to surrender at this point or earlier, then attack. Civilians should be free to return to their homes after Hamas surrenders or is destroyed.

(C) 2023 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Article] CDC Recommendations Paper Published

Recommendations for Improving the United States
Centers for Disease Control (CDC) Data Practices
for Pneumonia, Influenza, and COVID-19 (Click Here)

CDC FluView Interactive: https://gis.cdc.gov/grasp/fluview/mortality.html

CDC Leading Causes of Death Report (2017):

See Table C on Page 9 of PDF Report

https://www.cdc.gov/nchs/data/nvsr/nvsr68/nvsr68_06-508.pdf

About Us:

Main Web Site: https://mathematical-software.com/
Censored Search: https://censored-search.com/
A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests!

Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com

Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/

Legal Disclaimers: http://wordpress.jmcgowan.com/wp/legal/

Support Us:
PATREON: https://www.patreon.com/mathsoft
SubscribeStar: https://www.subscribestar.com/mathsoft

BitChute (Video): https://www.bitchute.com/channel/HGgoa2H3WDac/
Brighteon (Video): https://www.brighteon.com/channels/mathsoft
Odysee (Video): https://odysee.com/@MathematicalSoftware:5
NewTube (Video): https://newtube.app/user/mathsoft
Minds (Video): https://www.minds.com/math_methods/
Locals (Video): https://mathematicalsoftware.locals.com/
Archive (Video): https://archive.org/details/@mathsoft

(C) 2023 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Video] Boost Sales with AI

Introduction to using Math Recognition Artificial Intelligence (AI) to boost sales at no extra cost by estimating the combination of ad expenditures that maximizes sales for the current ad budget. Demonstration using sales and advertising expenditure data from McDonalds (restaurants) annual reports. About 9 minutes.

About Us:

Main Web Site: https://mathematical-software.com/
Censored Search: https://censored-search.com/
A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests!

Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com

Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/

Legal Disclaimers: http://wordpress.jmcgowan.com/wp/legal/

Support Us:
PATREON: https://www.patreon.com/mathsoft
SubscribeStar: https://www.subscribestar.com/mathsoft

BitChute (Video): https://www.bitchute.com/channel/HGgoa2H3WDac/
Brighteon (Video): https://www.brighteon.com/channels/mathsoft
Odysee (Video): https://odysee.com/@MathematicalSoftware:5
NewTube (Video): https://newtube.app/user/mathsoft
Minds (Video): https://www.minds.com/math_methods/
Locals (Video): https://mathematicalsoftware.locals.com/
Archive (Video): https://archive.org/details/@mathsoft

(C) 2023 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Video] The Cognitive Bias Paradox

The Cognitive Bias Paradox: Knowing Cognitive Biases Can Worsen Them

Uncensored Video Links: NewTube BitChute ARCHIVE Brighteon Odysee Rumble

About twelve minute video on the Cognitive Bias Paradox: Knowing Cognitive Biases Can Worsen them with possible ways to overcome this difficult problem.

Text Articles

Short URL: bit.ly/43CZJXH
Long URL: http://wordpress.jmcgowan.com/wp/the-cognitive-bias-paradox/

Short URL: http://bit.ly/wv713
Long URL: http://wordpress.jmcgowan.com/wp/the-worldview-prison/

About Us:

Main Web Site: https://mathematical-software.com/
Censored Search: https://censored-search.com/
A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests!

Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com

Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/

Legal Disclaimers: http://wordpress.jmcgowan.com/wp/legal/

Support Us:
PATREON: https://www.patreon.com/mathsoft
SubscribeStar: https://www.subscribestar.com/mathsoft

Rumble (Video): https://rumble.com/c/mathsoft
BitChute (Video): https://www.bitchute.com/channel/HGgoa2H3WDac/
Brighteon (Video): https://www.brighteon.com/channels/mathsoft
Odysee (Video): https://odysee.com/@MathematicalSoftware:5
NewTube (Video): https://newtube.app/user/mathsoft
Minds (Video): https://www.minds.com/math_methods/
Archive (Video): https://archive.org/details/@mathsoft

(C) 2023 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

The Cognitive Bias Paradox

Knowing cognitive biases can worsen them. Paradoxically, detailed knowledge of cognitive biases such as “confirmation bias” and “cognitive dissonance” provides a powerful set of tools to reinforce these very biases and dismiss data, evidence, and even direct personal experiences that contradict our preconceived ideas and prejudices.

In practice, one thinks:

I am one of the special intelligent, educated elite who are well aware of the cognitive biases. Knowing the biases, I am able to compensate for them, for example through ‘steelmanningmy opponent’s arguments. In contrast, the data or evidence from any third party contradicting my evidence-based beliefs is clearly the product of cognitive biases X,Y, and Z leading to cherry picking of evidence, faulty statistical methodologies, or other mistakes.

That personal experience that contradicts my evidence-based belief is a special case, a fluke, a coincidence, the product of some perceptual error such as the well known phenomenon cited by skeptics of misperceiving the rising Moon, Venus, Jupiter, lighthouses, and other conventional objects as a silvery flying saucer, or some other perceptual or cognitive flaw mined from the literature or made up as needed.

This is due in part to the so-called GI Joe Fallacy:

Knowing about one’s biases does not always allow one to overcome those biases — a phenomenon referred to as the G. I. Joe fallacy.

G.I. Joe Phenomena: Understanding the Limits of Metacognitive Awareness on Debiasing
by Ariella S. Kristal, Harvard Business School
and Laurie R Santos, Yale University
Working Paper 21-084
(C) 2021

Also, see this video from Khan Academy: https://www.khanacademy.org/partner-content/wi-phi/wiphi-critical-thinking/wiphi-cognitive-biases/v/gi-joe-fallacy

Plot of frequency of cognitive bias related words and phrases
Cognitive Bias Words and Phrases from 1940 to 2019

The use of phrases such as “cognitive bias,” “confirmation bias”, and “cognitive dissonance” has grown dramatically in the last twenty years as shown by Google’s NGRAM viewer above. Indeed if you follow many political or scientific controversies in recent decades, it is likely you will have heard these phrases used to dismiss the data, evidence, opinions, and even direct personal experiences of the “other side” in these debates.

By most accounts the phrase “cognitive dissonance” entered general use from the publication of the popular science book When Prophecy Fails: A Social and Psychological Study of a Modern Group That Predicted the Destruction of the World by Leon Festinger, Henry Riecken, and Stanley Schacter in 1956 and A Theory of Cognitive Dissonance by Leon Festinger in 1957. Awareness of cognitive dissonance and other cognitive biases has soared in the last few decades. The publication of Daniel Kahneman’s popular science book Thinking, Fast and Slow in 2011 is often credited with contributing to recent greater awareness of cognitive biases.

Political Polarization in United States from Pew Research

Yet, in fact, this wider awareness of cognitive bias does not appear to have improved the quality of logical argument or debate. Quite the opposite if anything, with censorship and thought-stopping labels such as “conspiracy theory,” “conspiracist,” “conspiracy theorist,” “conspiracy thinking”, even “conspiracy” used as a short hand for “conspiracy theory” in the pejorative, non-literal sense that has become ubiquitous, “denialism” and “denier” in the Holocaust denial sense, “fake news,” “misinformation,” “disinformation,” and “malinformation” proliferating.

More and more people may simultaneously believe that their knowledge of cognitive biases makes them immune to error while dismissing the views of others as hopelessly wrong due to their unrecognized cognitive biases.

Is there anything we can do about this growing problem?

Paradoxically, simply knowing that detailed knowledge of cognitive biases can actually aggravate these biases is not enough. Knowing is not even half the battle.

It is unclear what will actually work. Modern technologies and system such as the Internet as a whole, smartphones, and Twitter can bombard us with huge quantities of often emotional, propagandistic content. Scaling back the quantity of this content may be helpful.

Going through the “news” and other content one consumes, systematically striking out the many popular thought-stopping words and phrases such as “conspiracy theory” and ironically especially invoking “cognitive bias,” “cognitive dissonance,” “confirmation bias,” and related phrases, leaving hopefully a small set of alleged “facts” — not opinion or analysis, may help us drill down to the substance of the content.

Common Thought-Stopping Words and Phrases Today

pseudoscience
climate denial
XXX denial
climate denialism
XXX denialism
anti-vaccine
anti-science
anti-XXX
conspiracy theory
conspiracy thinking
conspiracy theorist
conspiracist
conspiracy
fake news
misinformation
disinformation
malinformation
election interference
far right (more common)
far left (less common)
Russian
Putin
woke
racist
racism
white supremacy
white supremacism
xenophobia
homophobia
Russophobia
XXXphobia
pedo
pedophilia

PARADOXICALLY:
cognitive bias
confirmation bias
cognitive dissonance
cherry picking data/evidence/etc.

The reader can probably list several more from their own experience. It is easier to identify thought-stopping words and phrases that you disagree with.

  • Edit out thought stopping words and phrases
  • Edit out other emotional words and phrases
  • Identify remaining factual or logical claims
  • Check the facts yourself (don’t rely on so-called fact checkers)
    • Locate original source or citation
    • Verify what the original source or citation says in the body of the article — don’t rely on abstracts, summaries, titles, headlines.
      • Wikipedia relies on secondary sources. Track down the primary (original) sources. Wikipedia is not reliable on “controversial” subjects.
    • Check sources of funding, possible conflicts of interest or biases of any authors or publishers.
    • Verify the claimed “facts” through personal experience if possible.
  • Check the logic yourself
  • Make a list of alternate interpretations of the “facts.” Remember the parable of the blind men and the elephant.
  • Check for rebuttals to the factual or logical claims from other sources. Repeat this process in evaluating the rebuttals.

See: The Worldview Prison

(C) 2023 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Video] How to Negotiate an End to the Russian-Ukraine War

Uncensored Video Links: NewTube BitChute Odysee Rumble Archive

Twenty-two minute video on how to negotiate an end to the Russian-Ukraine war.

Also see: https://wordpress.jmcgowan.com/wp/video-how-the-ukraine-war-could-go-nuclear/

About Us:

Main Web Site: https://mathematical-software.com/
Censored Search: https://censored-search.com/
A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests!

Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com

Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/

Legal Disclaimers: http://wordpress.jmcgowan.com/wp/legal/

Support Us:
PATREON: https://www.patreon.com/mathsoft
SubscribeStar: https://www.subscribestar.com/mathsoft

Rumble (Video): https://rumble.com/c/mathsoft
BitChute (Video): https://www.bitchute.com/channel/HGgoa2H3WDac/
Brighteon (Video): https://www.brighteon.com/channels/mathsoft
Odysee (Video): https://odysee.com/@MathematicalSoftware:5
NewTube (Video): https://newtube.app/user/mathsoft
Minds (Video): https://www.minds.com/math_methods/
Archive (Video): https://archive.org/details/@mathsoft

#

(C) 2023 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Video] Can AI Boost Cracker Barrel’s Stagnant Sales?

Uncensored Video: BitChute NewTube Rumble Odysee

Short video on using AI to estimate how to boost the Cracker Barrel restaurant and gift shop chain’s sales by improving advertising expenditures.

Short Article: http://wordpress.jmcgowan.com/wp/article-can-ai-boost-cracker-barrels-stagnant-sales/

Short Link: bit.ly/3ojdV9t

About Us:

Main Web Site: https://mathematical-software.com/
Censored Search: https://censored-search.com/
A search engine for censored Internet content. Find the answers to your problems censored by advertisers and other powerful interests!

Subscribe to our free Weekly Newsletter for articles and videos on practical mathematics, Internet Censorship, ways to fight back against censorship, and other topics by sending an email to: subscribe [at] mathematical-software.com

Avoid Internet Censorship by Subscribing to Our RSS News Feed: http://wordpress.jmcgowan.com/wp/feed/

Legal Disclaimers: http://wordpress.jmcgowan.com/wp/legal/

Support Us:
PATREON: https://www.patreon.com/mathsoft
SubscribeStar: https://www.subscribestar.com/mathsoft

Rumble (Video): https://rumble.com/c/mathsoft
BitChute (Video): https://www.bitchute.com/channel/HGgoa2H3WDac/
Brighteon (Video): https://www.brighteon.com/channels/mathsoft
Odysee (Video): https://odysee.com/@MathematicalSoftware:5
NewTube (Video): https://newtube.app/user/mathsoft
Minds (Video): https://www.minds.com/math_methods/
Archive (Video): https://archive.org/details/@mathsoft

(C) 2023 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).

[Article] Can AI Boost Cracker Barrel’s Stagnant Sales?

Cracker Barrel (NASDAQ: CBRL), the restaurant and gift shop chain, is one of many successful businesses whose sales in constant dollars have stagnated after a period of rapid, even exponential growth. Historically, Cracker Barrel relied almost exclusively on roadside billboards and word of mouth for its dramatic growth from a small business in Lebanon, TN in 1969 to sales of about $2.4 billion in 2004. Adjusted by the US Consumer Price Index (CPI), Cracker Barrel’s 2022 sales were only $2.1 billion in 2004 dollars.

This decline in real sales has occurred despite or even because of a sustained attempt to diversify away from the historically successful billboard advertising into other media.

Is it possible to use modern Artificial Intelligence (AI) technologies such as ChatGPT or other less well known methods to boost Cracker Barrel or other businesses now stagnant sales?

This article examines Cracker Barrel’s publicly reported expenditures on billboards and other media using Artificial Intelligence based Math Recognition to evaluate the effectiveness of Cracker Barrel’s strategies since 2004, generally supporting the company’s focus on other media, now about two thirds of ad expenditures, although also indicating the effectiveness of current advertising methods whether billboards or “other media” is small compared to the spectacular results in the 1980’s and 1990s.

Indeed the public financial data suggests Cracker Barrel may be fighting a negative effect from growing US Gross Domestic Product (GDP), needing to advertise more and more simply to sustain, never mind boost, company revenues.

Cracker Barrel’s publicly available information on the company’s marketing and advertising expenditures is very limited, falling into two aggregate categories: billboards and “other media” which includes radio, TV, Internet, and other non-billboard methods. The data is annual for the entire United States. There is no geographical breakdown, association with specific marketing or advertising campaigns in time, location, or other important factors.

It is almost certain our Math Recognition would construct more complex models from such details and likely make more reliable predictions from more detailed data which Cracker Barrel undoubtedly has in the internal accounting systems than the relatively simple model constructed from the public data.

What is Math Recognition?

Math recognition is a key part of scientific and engineering practice. It is identifying and recognizing the mathematical formulas and objects describing the data. The Bell Curve often encountered in grading in high school or college is a well known and relatively easy to identify mathematical formula. In addition to grades it describes the frequency of heights in adults of the same sex and many other common measured quantities.

However, scientists, engineers, and financial analysts often struggle to find a viable mathematical formula or formulas for real world data. Without such a formula it is impossible to make predictions or optimize the output of systems.

Our Math Recognizer has a large and growing database of known mathematics including obscure and difficult to identify mathematical objects: special functions, differential equations, etc.. The Math Recognizer uses AI methods to recognize these mathematical formulas in data.

What is the mathematical relationship if any between a company’s advertising expenditures on competing methods and actual sales?

Photo of John Wanamaker who owned large department store in Philadelphia.  Famous quote on advertising is attributed to him.
John Wanamaker (1838-1922)

Half the money I spend on advertising is wasted; the trouble is, I don’t know which half.

John Wanamaker (1838-1922)

This is an OLD problem in business.

The Math Recognizer is able to identify a relatively simple mathematical model for the Cracker Barrel data combined with the US Gross Domestic Product (GDP) from the St Louis Federal reserve. The GDP is used as a proxy for the overall state of the economy, something the company cannot control. For example, in the revenues reported by Cracker Barrel we can easily see a sharp drop attributable to the 2020 COVID pandemic lockdowns, something clearly beyond the control of the company.

The model roughly “explains” about 86 percent of the variation in the data. This is a roughly correct interpretation of the R**2 or coefficient of determination Goodness of Fit (GoF) metric used in the analysis.

Once we have identified a model with good agreement with the data, we can optimize the output, meaning maximize the sales in this case, given a projected budget. This is actually somewhat disappointing in that the program recommends to spend the entire budget on the “other media,” non-billboard, category with a slight dip in sales due to the negative effect of GDP according to the model.

Budget in Units of $1K ($1,000), about $89.5 Million in 2022

Let’s consider a larger future budget of $150 million, an abrupt increase of about $60 million over 2022. In this case we see the expected sales in current dollars to jump from about $3.2 billion in 2022 to almost $4 billion, an increase of about $800 million per year.

Budget in Units of $1K ($1,000), about $89.5 Million in 2022, new budget of $150 Million
Budget in Units of $1K ($1,000), about $89.5 Million in 2022, new budget of $150 Million

For this increase to pay for itself, the additional $800 million in sales must cost no more than $740 million dollars — a profit margin of about 7.5% (seven point five percent). That is a good profit margin for a restaurant. Restaurants often average only 3-5 percent profit margins.

Conclusion

A simple model based on broad financial numbers like these should not be taken very seriously although it may give some insights into a company. Indeed this simple analysis appears to support Cracker Barrel’s existing policies of diversifying advertising out of billboards, despite the disappointing results with inflation adjusted sales stagnant.

An in depth analysis of finely grained internal accounting data may be able to yield more detailed, reliable, and actionable results including a predictive model.

(C) 2023 by John F. McGowan, Ph.D.

About Me

John F. McGowan, Ph.D. solves problems using mathematics and mathematical software, including developing gesture recognition for touch devices, video compression and speech recognition technologies. He has extensive experience developing software in C, C++, MATLAB, Python, Visual Basic and many other programming languages. He has been a Visiting Scholar at HP Labs developing computer vision algorithms and software for mobile devices. He has worked as a contractor at NASA Ames Research Center involved in the research and development of image and video processing algorithms and technology. He has published articles on the origin and evolution of life, the exploration of Mars (anticipating the discovery of methane on Mars), and cheap access to space. He has a Ph.D. in physics from the University of Illinois at Urbana-Champaign and a B.S. in physics from the California Institute of Technology (Caltech).