Create a pivot table of average price per square foot by location and by sale status. Specifically, create this table in what we call a long format, with both location and status being columns. Notice that some locations don't have a corresponding average price per square foot for every sale type (for example there is no average price per square foot for regular sales in Bakersfield). What does is mean for the data