Can you show me how to answer these correctly. 2 questions

T Blackboard @ Texas Tech Univers X Bb Regression 1 - Fall 2022 TTU Stat X 9 New Tab X + V X ttu.blackboard.com/webapps/blackboard/content/listContent.jsp?course_id=_181160_1&content_id=_8806046_1 and Management (Isus- 5345-D95) Full Term Regression 1 Home Page Attached Files: RegressionPractice Output.xlsx (24.494 KB) You will need Excel. And the attached file. My Grades If you are not familar with Excel's data analysis tools, you may want to check out this page, https://support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform- complex-data-analysis-6c67 ccf0-f4a9-487c-8dec-bdb5a2cefab6 for more description. Blackboard Support 24/7 Blackboard Support Practice Data for optional test. IT for Students Student Resources Online Etiquette Accessibility Assistance Totally Optional Practice (Reg1) BryteWave Course You will need Excel. Materials Reression 1 Test You will need Excel. Reading write-up #10 Please write a paragraph summarizing Chapter 10. Grading will be based on clarity of the writing. Make sure you proofread. Turn in your own work, do not copy from someone else (including the author of the book). The best way to do this is to set the book aside when you do the write up, that way you will not be tempted to use the same words as the author. Feel free to discuss with others, just don't copy their write-up. Type here to search Co X 76.F 2:42 PM O 11/2/2022T Blackboard @ Texas Tech Univers X Bb Take Test: Reression 1 Test - Fall 2 X 9 New Tab X + V X > C A ttu.blackboard.com/webapps/assessment/take/launch.jsp?course_assessment_id=_404582_1&course_id=_181160_1&content_id=_8806049_1&step=null My Grades Multiple Attempts Not allowed. This test can only be taken once. Force Completion This test can be saved and resumed later. Your answers are saved automatically. Blackboard Support 24/7 Blackboard Support * Question Completion Status: IT for Students Student Resources Online Etiquette Accessibility Assistance QUESTION 1 1 points Save Answer BryteWave Course Materials Download this file: Reg1Test.xIsx Perform a regression of the form Per_capita_incom = b0 + b1*Population + b2 Percent_of_people_with_bachelor's_degrees. True or false: The population of a state is a significant predictor of the per captiat income of the state at the standarg 5% alpha level? O True O False QUESTION 2 1 points Save Answer Using the regression you just ran. What is the LOWER bound on the 95% confidence interval of how much a 1% change in the percent of people with a bachelor's degree or higher changes the per capita income in a state? Save All Answers Save and Submit Type here to search 76.F 2:42 PM O X 11/2/2022 LX AutoSave Off Reg1Test - Protected View v Search (Alt+Q) K Kelly KK X File Home Insert Page Layout Formulas Data Review View Help Comments Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X G8 vix fx A Shale or lerrilers K L H H Q F G R S T U Y W X Y 2 MM AP AC AD ME AF AG AH AI A/ AK AL AH AH AQ AP AG AR AS Fee mepile less Pepelelis FreereleaskelersorHigher Document Recovery $25,745 WWWWWWW $22,109 10106801 California 431,141 WITHIN Colorado 492,957 0 Excel has recovered the following files. Save Delaware the ones you wish to keep. Hawaii EXCEL.xIsx [Original] X Version created last time the... Haier Haryland 10/6/2022 7:49 PM Hiskinum Hismissippi Hebraska Armada Heu York harla Carolina harll Dakala OLim SHPIL Careli 27, 125 WW Virginia 434,141 11 $20,249 HUMHUM $29,690 504, 151 Which file do I want to save? Close State + Ready " - 1 + 35% Type here to search X 76OF 2:42 PM O 11/2/2022X AutoSave Off Reg1Test - Protected View v Search (Alt+Q) K Kelly KK X File Home Insert Page Layout Formulas Data Review View Help Comments Share PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing X G8 vix f A B C D E F G H I J K L M N P Q R Document Recovery State or territory Per capita Income Population PercentBachelorsOrHigher Alabama $23,606 4,849,377 26 Alaska $33,062 736,732 30 Excel has recovered the following files. Save Arizona $25,715 6,731,484 30 the ones you wish to keep. Arkansas $22,883 2,966,369 23 California $30,441 38,802,500 34 Colorado $32,357 5,355,866 41 EXCEL.xIsx [Original] Connecticut $39,373 3,596,677 39 X Version created last time the... Delaware $30,488 935,614 32 10/6/2022 7:49 PM Florida $26,582 19,893,297 30 Georgia $25,615 10,097,343 31 12 Hawaii $29,736 1,419,561 33 13 Idaho $23,938 1,634,464 28 14 Illinois $30,417 12,880,580 35 Indiana $25,140 6,596,855 27 16 lowa $28,361 3,107,126 29 17 Kansas $27,870 2,904,021 33 Kentucky $23,684 4,413,457 24 Louisiana $24,800 4,649,676 24 Maine $27,978 1,330,089 32 Maryland $36,338 5,976,407 40 Massachusetts $36,593 6,938,608 44 Michigan $26,613 9,909,877 29 Minnesota $32,638 5,457,173 36 Mississippi $21,036 2,994,079 22 Missouri $26,126 6,063,589 29 Montana $25,989 1,023,579 32 Nebraska $27,446 1,881,503 32 Nevada $25,773 2,839,099 25 New Hampshire $34,691 1,326,813 37 New Jersey $37,288 8,938,175 40 Which file do I want to save? New Mexico $23,683 2,085,572 27 Close State + Ready + 75% 2:43 PM Type here to search O X 76OF 11/2/2022 LK Kelly KK AutoSave Off Reg1Test - Protected View v Search (Alt+Q) X X Comments Share File Home Insert Page Layout Formulas Data Review View Help Enable Editing X PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. G8 vix fx B C E F G H I J K L M N 0 P Q R A Document Recovery Maryland $36,338 5,976,407 40 Massachusetts $36,593 6,938,608 44 $26,613 9,909,877 29 Excel has recovered the following files. Save Michigan Minnesota $32,638 5,457,173 36 the ones you wish to keep. Mississippi $21,036 2,994,079 22 Missouri $26,126 6,063,589 29 EXCEL.xIsx [Original] Montana $25,989 1,023,579 32 X Nebraska $27,446 1,881,503 32 Version created last time the... Nevada $25,773 2,839,099 25 10/6/2022 7:49 PM 30 New Hampshire $34,691 1,326,813 37 31 New Jersey $37,288 8,938,175 40 32 New Mexico $23,683 2,085,572 27 3:3 New York $33,095 19,746,227 37 34 North Carolina $25,774 9,943,964 31 North Dakota $33,071 739,482 30 Ohio $26,937 11, 28 37 Oklahoma $25,229 3,878,051 26 38 Oregon $27,646 3,970,239 34 39 Pennsylvania $29,220 12,787,209 31 40 Rhode Island $30,830 1,055,173 34 41 South Carolina $24,596 4,832,482 28 42 South Dakota $26,959 853,175 29 43 Tennessee $24,922 6,549,352 27 44 Texas $27,125 26,956,958 30 45 Jtah $24,877 2,942,902 34 46 Vermont $29,178 626,562 38 47 Virginia $34,052 8,326,289 39 48 Washington $31,841 7,061,530 36 49 West Virginia $22,714 1,850,326 21 50 Wisconsin $28,213 5,757,564 30 $29,698 584,153 27 Which file do I want to save? 51 Wyoming Close State + + 75% Ready 2:43 PM Type here to search O X 76OF 11/2/2022 L