Question: Q . These data can be found in the file Franchises. Create a PivotTable to summarize these data using classes 0 - 9 , 9

Q.
These data can be found in the file Franchises. Create a PivotTable to summarize these data using classes 0-9,999,10,000-19,999,20,000-29,999, and 30,000-39,999 to answer the following questions. (Hint: Use Number of U.S. Locations as the COLUMNS, and
use Count of Number of U.S. Locations as the VALUES in the PivotTable.)
a. Ilow many franchises have between 0 and 9,999 locations?
b. How many franchises have more than 30,000 locations?
Q . These data can be found in the file

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!