Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I don't quite understand the question. Please provide your explanations. Required: Which attributes from the College Scorecard data would you need to compare cost of

I don't quite understand the question. Please provide your explanations.

image text in transcribed

image text in transcribed

image text in transcribed

Required: Which attributes from the College Scorecard data would you need to compare cost of attendance across types of institutions (public, private non-profit, or private for-profit)? Select "Yes" for each attribute that is necessary for this analysis, and "No" for the attributes that you would not need to include. Possible Attributes Necessary? UNITID - a unique identifier for the institution INSTNM - Institution name PCTFLOAN - Percent of all federal undergraduates receiving a federal student loan CONTROL 1 = Public. 2 = Private nonprofit. 3 = Private for-profit TUITFTE Net tuition revenue per full-time equivalent student RET_FT4 - First-time, full-time student retention rate at four-year institutions COSTT4_A - Average cost of attendance CollegeScorecard.CSV Description of Variables NON+ 000 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: -2 Not applicable (Not classified) Associate's Colleges: High Transfer-High Traditional 2 Associate's Colleges: High Transfer-Mixed Traditional/Nontraditional Associate's Colleges: High Transfer-High Nontraditional 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 7 Associate's Colleges: High Vocational & Technical-High Traditional 8 Associate's Colleges: High Vocational & Technical-Mixed Traditional/Nontraditional 9 Associate's Colleges: High Vocational & Technical-High Nontraditional 10 Special Focus Two-Year: Health Professions 11 Special Focus Two-Year: Technical Professions 12 Special Focus Two-Year: Arts & Design 13 Special Focus Two-Year: Other Fields 14 Baccalaureate/Associate's Colleges: Associate's Dominant 15 Doctoral Universities: Highest Research Activity 16 Doctoral Universities: Higher Research Activity 17 Doctoral Universities: Moderate Research Activity 18 Master's Colleges & Universities: Larger Programs Master's Colleges & Universities: Medium Programs 20 Master's Colleges & Universities: Small Programs 21 Baccalaureate Colleges: Arts & Sciences Focus 22 Baccalaureate Colleges: Diverse Fields 23 Baccalaureate/Associate's Colleges: Mixed Baccalaureate/Associate's 24 Special Focus Four-Year: Faith-Related Institutions 25 Special Focus Four-Year: Medical Schools & Centers 26 Special Focus Four-Year: Other Health Professions Schools 27 Special Focus Four-Year: Engineering Schools 28 Special Focus Four-Year: Other Technology-Related Schools 29 Special Focus Four-Year: Business & Management Schools 30 Special Focus Four-Year: Arts, Music & Design Schools 31 Special Focus Four-Year: Law Schools Special Focus Four-Year: Other Special Focus Institutions 33 Tribal Colleges 19 32 ADM_RATE - admission rate SAT_AVG - average equivalent SAT of students admitted UGDS - enrollment of undergraduate certificate/degree-seeking students UGDS_WHITE - total share of enrollment of undergraduates who are white UGDS_BLACK - total share of enrollment of undergraduates who are black UGDS_HISP - total share of enrollment of undergraduates who are Hispanic UGDS_ASIAN total share of enrollment of undergraduates who are Asian UGDS_AIAN total share of enrollment of undergraduates who are American Indian/Alaska Native UGDS_NHPI total share of enrollment of undergraduates who are Native Hawaiian/Pacific Islander UGDS_2MOR total share of enrollment of undergraduates who are two or more races UGDS_NRA total share of enrollment of undergraduates who are non-resident aliens UGDS_UNKN - total share of enrollment of undergraduates whose race is unknown PPTUG_EF - share of undergraduate degree/certificate-seeking students who are part-time NPT4_PUB - Average net price for Title IV institutions (public) NPT4_PRIV Average net price for Title IV institutions (private for-profit and nonprofit) COSTT4_A- Average cost of attendance TUITETE Net tuition revenue per full-time equivalent student INEXPFTE - Instructional expenditures per full-time equivalent student PFTFAC - Proportion of faculty that is full-time PCTPELL - Percentage of undergraduates who receive a Pell Grant C150_4 - Completion rate for first-time, full-time students at four-year institutions (6 year) PFTFTUG1_EF - Share of undergraduate students who are first-time, full-time, degree- seeking undergraduates RET_FT4 - First-time, full-time student retention rate at four-year institutions PCTFLOAN Percent of all federal undergraduates receiving a federal student loan

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals Design

Authors: Marion Donnie Dutton Don F. Seaman

14th Edition Globel Edition

1292107634, 978-1292107639

More Books

Students also viewed these Databases questions