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.