1 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. A partial view of the data is provided in the table. A B C D 1 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% What ranges should be entered into the Excel regression dialog box? Dependent Variable: A1:A51; Independent Variable: B1:C51 Dependent Variable: B1:B51; Independent Variable: C1:D51 Dependent Variable: A1:A51; Independent Variable: B1:D51 Dependent Variable: D1:D51; Independent Variable: B1:C51...,,.. please select any one from given option