Hi, need help with this assignment. Please see the attached for instructions. 

 

PlanStateProvider GroupMembershipDischargesCommercialCAProvider GroupA140,00011,200MedicareCAProvider GroupA40,0004,000CommercialORProvider GroupA55,0003,850MedicareORProvider GroupA40,0003,600CommercialWAProvider GroupA100,0009,500MedicareWAProvider GroupA80,0009,200CommercialCAProvider GroupB200,00015,000MedicareCAProvider GroupB100,00012,000CommercialORProvider GroupB45,0002,925MedicareORProvider GroupB30,0003,300CommercialWAProvider GroupB80,0007,200MedicareWAProvider GroupB60,0008,100CommercialCAProvider GroupC150,00010,500MedicareCAProvider GroupC50,0007,000CommercialORProvider GroupC40,0002,400MedicareORProvider GroupC25,0003,250CommercialWAProvider GroupC110,0009,350MedicareWAProvider GroupC90,00013,950CommercialCAProvider GroupD250,00021,500MedicareCAProvider GroupD150,00019,500CommercialORProvider GroupD35,0002,660MedicareORProvider GroupD20,0002,400CommercialWAProvider GroupD70,0007,070MedicareWAProvider GroupD50,0007,250CommercialCAProvider GroupE145,00016,200MedicareCAProvider GroupE45,0009,000CommercialORProvider GroupE60,0008,850MedicareORProvider GroupE45,0008,600CommercialWAProvider GroupE105,00014,500MedicareWAProvider GroupE85,00014,200CommercialCAProvider GroupF205,00020,000MedicareCAProvider GroupF105,00017,000CommercialORProvider GroupF50,0007,925MedicareORProvider GroupF35,0008,300CommercialWAProvider GroupF85,00012,200MedicareWAProvider GroupF65,00013,100CommercialCAProvider GroupG155,00015,500MedicareCAProvider GroupG55,00012,000CommercialORProvider GroupG45,0007,400MedicareORProvider GroupG30,0008,250

Create queries on Microsoft Access to answer the fowling questions:What is the TOTAL membership, TOTAL discharge days, and TOTAL discharges for Commercial andMedicare Plans? (6 points)What is the total membership, total discharge days, and total discharges for Commercial and MedicarePlans in CALIFORNIA? (2 point)What is the average ‘Average Length of Stay (ALOS)’ for Commercial Plans and for Medicare Plans? (4points)What is the average ‘Average Length of Stay (ALOS)’ for California Commercial Plans and for MedicarePlans in California? (2 points)Note: ALOS = total discharge days/total discharges.Which provider group has the lowest Medicare membership and which provider group has the highestCommercial membership? [Note: There are more than one provider groups with the same name in somecases, so you will have to add those using the ] ( 10 points)One point for clear answers to the above questions in a word document and the access database withCLEARLY named queries and table.

• 1495173064-Assignment 9.docx
• 1495173064-data assignment 1.xls

ComputerScienceExpert

(11)

Status NEW Posted 19 May 2017 05:05 AM My Price 9.00

-----------

Attachments

file 1495173067-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer