Excel analyzes quantitative variables by arranging them into pivot tables. These tables sort data into groups, totaling the figures that fall under each qualitative division.

Relying on quantitative data can overlook the human element of consumer behavior, leading marketers to miss out on valuable insights only qualitative data can provide.

The quantitative approach looks at the market and demographic numbers, while the qualitative approach looks at customer-driven data like opinions and consumer needs.