To properly build the model, and select predictor variables, create a dataset with the following columns:

City 2010 Census Population Total Pawdacity Sales Households with Under 18 Land Area Population Density Total Families

This dataset will be your training set to help you build aregression model in order to predict sales in the Practice Project in the next lesson. Every row should have sales data because we're trying to predict sales.

Notes

You should be consolidating the data at the city level andnot at the store level.We only have data at the city wide level so any analysis at the store level will not be sufficient to complete this analysis.

We simply need to focus on cleaning up and blending the data together in this step.

If you've done everything correctly, the sum for each of the above columns should be:

• Census Population:213,862
• Total Pawdacity Sales:3,773,304
• Households with Under 18:34,064
• Land Area:33,071
• Population Density:63
• Total Families:62,653

Can somebody tell me how to find the total pawdacity, census population, Households under 18, land area, population density, and total families. please explain it: white the formula and the steps