In this lab, you will: Part 1. Identify the questions. Part 2. Load the data. Part...

  
 
 

Transcribed Image Text:

In this lab, you will: Part 1. Identify the questions. Part 2. Load the data. Part 3. Perform a regression analysis in Excel. This Lab relies on information and work from Chapter 2 Lab 2-5. Refer to Chapter 3 pages 120 through 121 for instructions and steps for each of the lab parts. After completing Lab parts 1 through 3, complete the following requirements. Software needed Excel • Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Ⓡ Data ● College Scorecard_Data Dictionary: College_Scorecard_Data_Dictionary. 3. After running the regression analysis in Part 3, input the numbers for the following coefficients. (Round your answers to 3 decimal places. Enter negative answers with minus sign.) Intercept SAT_AVG coefficient R Square 111.000 1.000 X UNITID - a unique identifier for the institution INSTNM Institution name CITY - City STABBR - State postcode CONTROL - 1 = Public. 2 = Private nonprofit. 3 = Private for-profit CCBASIC - Carnegie Classification, basic: Not applicable (Not classified) -2 0 1 Associate's Colleges: High Transfer-High Traditional 2 Associate's Colleges: High Transfer-Mixed Traditional/Nontraditional 3 Associate's Colleges: High Transfer-High Nontraditional 4 Associate's Colleges: Mixed Transfer/Vocational & Technical-High Traditional 5 Associate's Colleges: Mixed Transfer/Vocational & Technical-Mixed Traditional/Nontraditional 6 Associate's Colleges: Mixed Transfer/Vocational & Technical-High Nontraditional Associate's Colleges: High Vocational & Technical-High Traditional 7 8 Associate's Colleges: High Vocational & Technical-Mixed Traditional/Nontraditional Associate's Colleges: High Vocational & Technical-High Nontraditional Special Focus Two-Year: Health Professions Special Focus Two-Year: Technical Professions 9 y 10 11 12 13 Special Focus Two-Year: Arts & Design Special Focus Two-Year: Other Fields 456TBR2-2722-23 14 15 16 17 18 19 20 21 28 29 30 31 33 Baccalaureate/Associate's Colleges: Associate's Dominant Doctoral Universities: Highest Research Activity Doctoral Universities: Higher Research Activity Doctoral Universities: Moderate Research Activity Master's Colleges & Universities: Larger Programs Master's Colleges & Universities: Medium Programs Master's Colleges & Universities: Small Programs Baccalaureate Colleges: Arts & Sciences Focus Baccalaureate Colleges: Diverse Fields Baccalaureate/Associate's Colleges: Mixed Baccalaureate/Associate's Special Focus Four-Year: Faith-Related Institutions Special Focus Four-Year: Medical Schools & Centers Special Focus Four-Year: Other Health Professions Schools Special Focus Four-Year: Engineering Schools Special Focus Four-Year: Other Technology-Related Schools Special Focus Four-Year: Business & Management Schools Special Focus Four-Year: Arts, Music & Design Schools Special Focus Four-Year: Law Schools Special Focus Four-Year: Other Special Focus Institutions Tribal Colleges In this lab, you will: Part 1. Identify the questions. Part 2. Load the data. Part 3. Perform a regression analysis in Excel. This Lab relies on information and work from Chapter 2 Lab 2-5. Refer to Chapter 3 pages 120 through 121 for instructions and steps for each of the lab parts. After completing Lab parts 1 through 3, complete the following requirements. Software needed Excel • Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Ⓡ Data ● College Scorecard_Data Dictionary: College_Scorecard_Data_Dictionary. 3. After running the regression analysis in Part 3, input the numbers for the following coefficients. (Round your answers to 3 decimal places. Enter negative answers with minus sign.) Intercept SAT_AVG coefficient R Square 111.000 1.000 X UNITID - a unique identifier for the institution INSTNM Institution name CITY - City STABBR - State postcode CONTROL - 1 = Public. 2 = Private nonprofit. 3 = Private for-profit CCBASIC - Carnegie Classification, basic: Not applicable (Not classified) -2 0 1 Associate's Colleges: High Transfer-High Traditional 2 Associate's Colleges: High Transfer-Mixed Traditional/Nontraditional 3 Associate's Colleges: High Transfer-High Nontraditional 4 Associate's Colleges: Mixed Transfer/Vocational & Technical-High Traditional 5 Associate's Colleges: Mixed Transfer/Vocational & Technical-Mixed Traditional/Nontraditional 6 Associate's Colleges: Mixed Transfer/Vocational & Technical-High Nontraditional Associate's Colleges: High Vocational & Technical-High Traditional 7 8 Associate's Colleges: High Vocational & Technical-Mixed Traditional/Nontraditional Associate's Colleges: High Vocational & Technical-High Nontraditional Special Focus Two-Year: Health Professions Special Focus Two-Year: Technical Professions 9 y 10 11 12 13 Special Focus Two-Year: Arts & Design Special Focus Two-Year: Other Fields 456TBR2-2722-23 14 15 16 17 18 19 20 21 28 29 30 31 33 Baccalaureate/Associate's Colleges: Associate's Dominant Doctoral Universities: Highest Research Activity Doctoral Universities: Higher Research Activity Doctoral Universities: Moderate Research Activity Master's Colleges & Universities: Larger Programs Master's Colleges & Universities: Medium Programs Master's Colleges & Universities: Small Programs Baccalaureate Colleges: Arts & Sciences Focus Baccalaureate Colleges: Diverse Fields Baccalaureate/Associate's Colleges: Mixed Baccalaureate/Associate's Special Focus Four-Year: Faith-Related Institutions Special Focus Four-Year: Medical Schools & Centers Special Focus Four-Year: Other Health Professions Schools Special Focus Four-Year: Engineering Schools Special Focus Four-Year: Other Technology-Related Schools Special Focus Four-Year: Business & Management Schools Special Focus Four-Year: Arts, Music & Design Schools Special Focus Four-Year: Law Schools Special Focus Four-Year: Other Special Focus Institutions Tribal Colleges

Answer rating: 100% (QA)

In this lab you will Programme Sub CalculateMovingAvera... View the full answer