Do you think the department should restrict funding

Assignment Help Accounting Basics

Reference no: EM133360021

need an email to send through the data please, I cannot upload the file.

(a) The department wants your help to understand the relationship between admission rates (ADM_RATE) and completion rates for first-time, full-time students at four-year institutions (C150_4). Before you may do any advanced analysis they want you to provide some descriptive information about the two variables (ADM_RATE, C150_4). Provide them with the mean, median, and standard deviation of these variables and comment on them. They ask you to interpret the output for them in plain English as they don't know much about statistics. Please attach screenshots or the Excel file to receive part marks if you make a mistake.

(b) The department asks you to identify which states (field name: STABBR) have the highest and lowest average completion rate. Please attach screenshots or the Excel file to receive part marks if you make a mistake.

(c) They are wondering if admission rates can explain why some institutions have low completion rates, whereas others have high completion rates. They ask you to perform regression analysis and interpret the output for them in plain English as they don't know much about statistics. Please attach screenshots or the Excel file to receive part marks if you make a mistake.

(d) Based on your answer in part a, do you think the department should restrict funding to institutions with low rates of completion? Are there any unintended consequences of this action? What other information may you need to consider?

Reference no: EM133360021

Questions Cloud

Estimated tax payments were made during 2020 : ACCT 4300 William Paterson University Beginning balance in allowances for uncollectible accounts 500 End balance in allowances for uncollectible accounts 800

Compute basic and diluted earnings per share for the year : Compute basic and diluted earnings per share for the year ended December 31, 2021 (round to two decimal places).

What types of virtualization datacenters would most benefit : Do you think it would be possible or a good idea and in what circumstances to not use vCenter Server? What types of Virtualization Datacenters would most

What role does leadership play in strategic planning : What role does leadership play in strategic planning? Why does an effective organization need a strategic plan?

Do you think the department should restrict funding : do you think the department should restrict funding to institutions with low rates of completion? Are there any unintended consequences of this action?

How a cloud database management system distributes data : Literature supported explanation on when and why to use cloud databases and when to use ones managed on a single-device one.

What was the value of amortization expense : selling and administrative expenses of $70,000, interest expenses, and an EBIT of $150,000. What was the value of amortization expense

What you hope to accomplish in your internship : What you hope to accomplish in your internship and how it relates to your short and long term career goals. Tips for developing goals for your career may

Which is a product of our sociocultural environment : "Human values development," which is a product of our sociocultural environment, reflects the content and process of learning what is considered right.

User Account

All Pages