A healthcare manager is interested in determining the number of…

A healthcare manager is interested in determining the number of ACOs with 25,000 or more assigned beneficiaries.

  1. Navigate to https://data.cms.gov/. Select the ACO category and locate the Medicare Shared Savings Program Accountable Care Organizations Performance Year 1 Results data set. Click “Export” and download the file into MS Excel format.
  2. Insert a new column entitled “Beneficiary Grouping” to the right of the “Total Assigned Beneficiaries Column”. In the first cell of this new column, input the following formula: =F(F2<25000,”< 25000″,”25000+”) This will assign a value of “<25000” for all ACOs with fewer than 25,000 beneficiaries and “25000+” to ACOs with 25,000 or more assigned beneficiaries. Copy the formula down to all rows. Note that if the “Total Assigned Beneficiaries” column were in column C instead of F, the formula would read =IF(C1<25000,…).
  3. Construct a pivot table that compares the total counts of ACOs with fewer than 25,000 beneficiaries and ACOs with 25,000 or more assigned beneficiaries. Include a filter for the beneficiaries’ state of residence. What is the total number of ACOs with 25,000 or more assigned beneficiaries?
  4. Suppose the manager is interested in the total expenditure per assigned beneficiary for ACOs with fewer than 25,000 beneficiaries compared to those with 25,000 or more beneficiaries. Modify the pivot table in part (b) to display the sum of assigned beneficiaries and the sum of total expenditures for ACOs with fewer than 25,000 beneficiaries versus those with 25,000 or more beneficiaries.
  5. Calculate the average expenditure per beneficiary for each beneficiary grouping by dividing the sum of expenditures by the sum of assigned beneficiaries.

How to Get Help with your Assignment in 3 mins

  1. Place Your Assignment Request in under 3 mins

    To access our online order form, click the "Order Now" button below.
  2. Complete the Payment

    Click on checkout link at the bottom of the order page to pay.
  3. Download Your Assignment

    Once we receive payment, one of our highly qualified essay writing experts will work on your assignment and complete it within your selected deadline.

What does the completed assignment have?

  • Thorough Research and High-Quality Essay Writing
  • Native UK, US, Canadian, Australian Writers
  • Up-to-date Sources Only (Less than 5 years)
  • 24/7 Online Support
  • Essay in 1,3, 6, 8, 12, 16, 20 hours +...!
  • 100% Plagiarism Free
  • 100% Privacy Guarantee
  • Times New Roman, 12pt
  • Any Referencing Styles (APA, MLA, Harvard, Chicago, Turabian...)
  • 275+ Words per page
  • Single/Double Spaced Papers
  • Plagiarism Report on Request

Why do college students choose our assignment help service?

  • list icon instant gradesExcellent Grades Guaranteed! (A+ or B Minimum)
  • list icon instant grades Privacy Guarantee - No one will ever know!
  • list icon instant gradesAlways delivered on time
  • list icon instant grades High-Quality Essays
  • list icon instant grades24/7 Instant Online Support
  • list icon instant gradesTitle Page --- FREE!
  • list icon instant gradesTable of Contents --- FREE!
  • list icon instant gradesReferences List ---FREE!
  • list icon instant gradesRevisions---FREE!
  • list icon instant gradesPlagiarism Report ---FREE!
  • list icon instant gradesEditing before submitting it to you ---FREE!