1. Generate a table showing the distribution of the number of nursing home facilities by state...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Generate a table showing the distribution of the number of nursing home facilities by state and county. (10 points) 2. Compute the average weekly %occupancy by state for each year (20 Points) 3. List the top 5 nursing homes that faced maximum consecutive weeks of nursing staff shortage (20 points) 4. Conduct a facility level analysis for eye protection, gowns, gloves, N95 masks that will not be available in 7 days. Define the following metric for this analysis: number of times the shortage was experienced. The metric should be categorized into 3 categories, 0-10, 11-20 and >20 instances. Sample output table is shown below (20 points) Facility Number of Instances of ABC XYZ LMN Shortage Gloves 0-10 11-20 >20 Number of Instances of Shortage N95 0-10 11-20 >20 Number of Instances of Shortage Eye Protection 0-10 11-20 >20 Number of Instances of Shortage Gowns 0-10 11-20 >20 1. Generate a table showing the distribution of the number of nursing home facilities by state and county. (10 points) 2. Compute the average weekly %occupancy by state for each year (20 Points) 3. List the top 5 nursing homes that faced maximum consecutive weeks of nursing staff shortage (20 points) 4. Conduct a facility level analysis for eye protection, gowns, gloves, N95 masks that will not be available in 7 days. Define the following metric for this analysis: number of times the shortage was experienced. The metric should be categorized into 3 categories, 0-10, 11-20 and >20 instances. Sample output table is shown below (20 points) Facility Number of Instances of ABC XYZ LMN Shortage Gloves 0-10 11-20 >20 Number of Instances of Shortage N95 0-10 11-20 >20 Number of Instances of Shortage Eye Protection 0-10 11-20 >20 Number of Instances of Shortage Gowns 0-10 11-20 >20
Expert Answer:
Related Book For
Posted Date:
Students also viewed these programming questions
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
In evaluating employee performance and determining salary raises, a company uses a large number of subjective and objective criteria gathered from numerous evaluators that are then combined together...
-
The unadjusted trial balance of Mesa Inc., at the company's year end of December 31 follows: Additional information and adjustment data: 1. The 12-month insurance policy was purchased and was...
-
Annual revenue for Corning Supplies grew by 5.5% in 2014, 1.1% in 2015, 3.5% in 2016, 1.1% in 2017, and 1.8% in 2018. What is the mean growth annual rate over this period?
-
Two canals join to form a larger canal as shown in Video V10.6 and Fig. P10.62. Each of the three rectangular canals is lined with the same material and has the same bottom slope. The water depth in...
-
Record the following transactions in the general journal of White Company: 201X Feb. 5 Purchased land for $93,000. The $93,000 included attorneys fees of $6,300. 18 White Company decided to pave the...
-
1. What is organization theories in action? 2. What is nokia organization theory in action?
-
Tonys Precision Computer Centre is picking up in business, so he has decided to expand his bookkeeping system to a general journal/ledger system. The balances from June have been forwarded to the...
-
1. [1/5 Points] DETAILS A plastic rod 1.4 m long is rubbed all over with wool, and acquires a charge of -6e-08 coulombs. We choose the center of the rod to be the origin of our coordinate system,...
-
You have access to a UK university dataset of 1632 students who recently completed their studies. For each student, the dataset reports information on the following variables: 1. Overall Average:...
-
Walsh Company manufactures and sells one product. The following information pertains to each of the company's first two years of operations: Variable costs per unit: Manufacturing: Direct materials...
-
Provisional Final Exam Page 1 : 1 ? ? \ table [ [ 3 ] , [ ? Provisional Final Exam Page 1: < w 1 2 > 6 > 5 > 4 I 7 8 16 10 11 2> 12 Identify each account as being reported on the balance sheet (BS)...
-
In the 2004 Survey of Inmates in State and Federal Correctional Facilities, 32% of state prisoners and 26% of federal prisoners said they had committed their current offense while under the influence...
-
Financial Data for Delta Air Lines, Inc (amounts in millions, except per-share amounts) For Year Ended December 31 2013 2014 2015 2016 2017 Current Assets 9651 12465 9056 7451 7844 Total Assets 52252...
-
The following is an extraction of comparative balance sheet of Caibrex Corporation as at December 31, 2020 and 2019: December 31 Cash and cash equivalents... Accounts receivable . Inventories ......
-
Multiple Choice Questions: 1. The largest component of aggregate demand is? a. Government purchases. b. Net exports. c. Consumption. d. Investment. 2. A reduction in personal income taxes, other...
-
Draw a flow net for the single row of sheet piles driven into a permeable layer as shown in Figure 8.18. Given: ¢ H1 = 3 m ¢ D = 1.5 m ¢ H2 = 0.5 m ¢ D1 = 3.75 m Calculate the...
-
Repeat Problem 16.7 with the following: density of soil above the groundwater table, ( = 1750 kg/m3; saturated soil density below the groundwater table, (sat = 1950 kg/m3; c' = 28 kN/m3,( = 22°,...
-
An infinite slope is shown in Figure 15.49. The shear strength parameters at the interface of soil and rock are ( = 26, and c' = 21 kN/m2. Given: ( = 1950 kg/m3. a. If H = 5 m and ( = 18, find the...
-
A fertilizer producing company purchases nitrates, phosphates, potash, and an inert chalk base and produces four different fertilizers A, B,C, and D. The cost of these nitrates, phosphates, potash,...
-
Heavy fuel oil, initially semisolid at $15^{\circ} \mathrm{C}$ is to be heated and pumped through a $15 \mathrm{~cm}$ diameter (inside) pipe at the rate of $20000 \mathrm{~kg} / \mathrm{h}$. The pipe...
-
The topological optimization is discussed in chapter 1. Here, we will consider a topological optimization problem for a chemical process plant. The layout of the chemical process plant has been shown...
Study smarter with the SolutionInn App