Please explain which columns from the Excel I have to use in order to do the regression so I can answer Question 2. Which one goes to the Input Y range and which one to the Input X range. I uploaded a screenshot where you can see the first row of the Excel. The Excel has 260 observations.

2. A number of regional economists suggest that a labor force with a higher share of college graduates sets the base for a more successful metropolitan area. Using the data associated with this problem set on Blackboard, regress the per capita personal income by metropolitan area on the share of the adult population that has a college degree or higher by metropolitan area. Present a table with your results.

3. Use excel to graph the basic data and the estimated regression line from (2). Write a short paragraph interpreting those findings, their significance and their limitations.

4. Using the equation you estimated in (2) what would you predict would be the increase in per capita personal income in Chicago if the share of the adult population with a college degree increased by five percentage points? Explain.

A B C D E Total Metropolitan Personal Per Capita college or higher 1 Metropolitan Statistical Area Population Income Income share 2 Akron, OH 697558 19,460,700,000 $ 27,898 0.215 3 Albany-Schenectady-Troy, NY 839570 27,631,400,000 32,911 0.256 4 Albuquerque, NM 877676 22,493,500,000 $ 25,628 0.213 5 Allentown-Bethlehem-Easton, PA-NJ 820490 24,872,100,000 30,314 0.193 6 Amarillo, TX 246399 6,480,477,636 $ 26,301 0.154 7 Anchorage, AK 447361 15,447,300,000 $ 34,530 0.197 8 Ann Arbor, MI 353632 12,412,500,000 $ 35,100 0.363 9 Anniston-Oxford-Jacksonville, AL 114315 2,577,476,393 $ 22,547 0.138 10 Asheville, NC 499767 12,897,500,000 $ 25,807 0.242 11 Atlanta-Sandy Springs-Roswell, GA 5516118 160,670,000,000 $ 29,127 0.243