State Percent of Population that is Male Per Capita Income Crime Rate 2 Alabama 48.50% $33,710 3.89% 3 Alaska 52.20% $43,749 3.49% 4 Arizona 49.70% $33,773 3.94% 5 Arkansas 49.00% $32,373 4.06% 6 California 49.70% $41,893 3.08% 7 Colorado 50.10% $42,107 3.01% 8 Connecticut 48.60% $55,427 2.47% 9 Delaware 48.50% $39,425 4.07% 10 Florida 48.90% $38,345 4.10% 11 Georgia 48.80% $34,531 4.04% 12 Hawaii 50.20% $40,952 3.58% 13 Idaho 50.10% $31,556 2.22% 14 Illinois 49.00% $42,025 3.12% 15 Indiana 49.30% $34,028 3.36% 16 Iowa 49.40% $37,882 2.52% 17 Kansas 49.60% $38,545 3.49% A criminologist wants to investigate the relationship between crime rate, income, and gender composition. The criminologist collects data from the 50 U.S. states on the crime rate, percentage of the population that is male, and per capita income in 2010. Based on the partial view of the data, what ranges should be entered into the Excel regression dialog box? Dependent Variable: A1:A51; Independent Variable: B1:C31 Dependent Variable: B1:B51; Independent Variable: C1:D51 Dependent Variable: A1:A51; Independent Variable: B1:D51 Dependent Variable: D1:D51; Independent Variable: B1:C51