ifi. The absolute change in the percentage of unvaccinated residents iv. The percent change in the percentage of unvaccinated residents f. Repeat "e" for the In Progress and Fully Vaccinated Residents. You do not need to show work, put results in table on last page. g. (You are basically copying values from the table): Compared to two years ago, there are (number) more/fewer (circle) residents with Fully Vaccinated status. However the vaccination rate in terms of percentage has gone from (percentage) to (percentage) ,an absolute reduction in percentage of (percentage). Based on the above, if your Company is boasting an increase in Fully Vaccinated residents, what do you think they are referring to? Do you think this is an accurate portrayal of the vaccination program at your facility? Explain.Part III Future Targets - 18 months The State informs your facility that you are not in compliance with current standards and are thus "flagged" for an audit when new regulations come into force in two years. You will be audited after 18 months to make sure you will be in compliance. The State is capping occupancy for your facilities at a "hard 6825". You look at turnover numbers and decide that targeting an occupancy of 6800 will keep you well within this limit. The State is launching a 60-60 Vaccine Incentive Program. Some incentives are for achieving a 60%% reduction in the number of Unvaccinated residents based on current levels. The incentive is pro-rated if the facility achieves a maximum of 12% Unvaccinated rate without reaching this target. The more lucrative incentives are available for facilities that achieve a Fully Vaccinated status in at least 60%% of residents. After discussions with the Facilities Financial Manager, it is decided to target 63% to make sure the facilities get this incentive. Future Targets: 6800 occupants , 60% decrease in Unvaccinated occupants from current levels, 63% of residents will be Fully Vaccinated. h. What is the absolute reduction in occupancy from current levels i. Find the percentage reduction in the number of occupants in your facilitiesb. Construct the Bar Chart Current Vaccination Status 45 40 35 Percent Relative Frequency Unvaccinated In Progress Fully Vaccinated Part 2 Past Status - 2 years ago Your predecessor left the job under some unfortunate circumstances and a lot of the records are missing. You are informed that the resident population increased 14% over the past two years. c. Find the resident population 2 years ago (round to integer)5 6 100% + n. You can now complete the "Future" table on the last page with values calculated. You are prohibited by law from kicking residents out of your facilities so you will have to rely on "usual turnover" without taking in new residents and/or incentivize residents to move out. The vaccines are quite expensive as well, so if you are able to have Unvaccinated residents move out, this would be a plus. o. Is it possible to meet targets simply by having Unvaccinated residents move out? Address each of the three targets. p. How many more Unvaccinated residents could you have and still receive some incentive for this category?Quantitative Reasoning Project: Name: Describing and Analyzing Data Complete this project in "worksheet form" by showing work in the space provided and copying the final answers designated place. For all calculations, show the formula used, the values substituted in, and the calculated result rounded to the nearest cent. If you use a formula more than once there is no need to show that formula twice. Scenario You have been hired to assess the vaccination status of residents in a large group of residential facilities and bring them into compliance with impending State standards. The vaccine schedule requires two shots to be administered within 6 months to one year of each other (or else you have to "start over" and the vaccine status reverts to unvaccinated). There is also a fair amount of turnover in the facilities. The last page of this document has three tables to fill in so that you can compare them. Part 1 Current Status Vaccine Status Frequency You go through the medical records for all 7,120 current Unvaccinated 1563 residents and construct the Frequency Distribution In Progress 2851 Table as shown. Fully Vaccinated 2703 a. Find the Percent Relative Frequencies and complete the table (last page). Show one calculation here.j. Find the target number of Unvaccinated residents. k. Find the absolute reduction in the number of Unvaccinated residents 1. Find the target number of Fully Vaccinated residents m. Find the target number and percentage of "In Progress"d. You are unable to locate any records, and can only locate a report that contains the Vaccination Status following Pie Chart. Use the formula for the Percent Relative Frequency and rearrange it to find the frequencies. Use the total from 16% "Part 1 a". 41% Unvaccinated 43% Show one calculation here and fill in the In Progress table (last page) Fully Vaccinated e. For Unvaccinated Residents, find i. The absolute increase in number of residents ii. The percent relative increase in number of residents/00449-dt-content-rid-25754277_1/courses/83027_22190S/Quantitative%20Reasoning%20Data%20Project%20F2021%281... (1) * 6 / 6 100% + Comparison - Two Years Ago to Today TABLE 1 2 Years Ago Current Data e&f i&ii Frequency e&f iii&iv Change in Percentage Vaccine Status %Relative d. Frequency a. % Relative Frequency i. Absolute ii. % Relative iii. Absolute iv. % Relative Frequency Frequency Difference Change Difference Change Unvaccinated 16 1563 In Progress 43 2851 Fully Vaccinated 41 2703 TOTAL 7120 Comparison - Today to 18 Mo. In Future Current Data TABLE 2 18 Month Projection Frequency Change in Percentage COPY from Table 1 % Relative Absolute % Relative Absolute % Relative a. % Relative Vaccine Status Frequency Frequency Frequency Frequency Difference Change Difference Change Unvaccinated 1563 In Progress 2851 m. m. Fully Vaccinated 2703 63% TOTAL 7120 6800 h. n. All remaining unshaded spaces Fill in all unshaded spacesb. Construct the Bar Chart Current Vaccination Status 45 40 35 Percent Relative Frequency Unvaccinated In Progress Fully Vaccinated Part 2 Past Status - 2 years ago Your predecessor left the job under some unfortunate circumstances and a lot of the records are missing. You are informed that the resident population increased 14% over the past two years. c. Find the resident population 2 years ago (round to integer)j. Find the target number of Unvaccinated residents. k. Find the absolute reduction in the number of Unvaccinated residents 1. Find the target number of Fully Vaccinated residents m. Find the target number and percentage of "In Progress"d. You are unable to locate any records, and can only locate a report that contains the Vaccination Status following Pie Chart. Use the formula for the Percent Relative Frequency and rearrange it to find the frequencies. Use the total from 16% "Part 1 a". 41% Unvaccinated 43% Show one calculation here and fill in the In Progress table (last page) Fully Vaccinated e. For Unvaccinated Residents, find i. The absolute increase in number of residents ii. The percent relative increase in number of residents5 6 100% + n. You can now complete the "Future" table on the last page with values calculated. You are prohibited by law from kicking residents out of your facilities so you will have to rely on "usual turnover" without taking in new residents and/or incentivize residents to move out. The vaccines are quite expensive as well, so if you are able to have Unvaccinated residents move out, this would be a plus. o. Is it possible to meet targets simply by having Unvaccinated residents move out? Address each of the three targets. p. How many more Unvaccinated residents could you have and still receive some incentive for this category?ifi. The absolute change in the percentage of unvaccinated residents iv. The percent change in the percentage of unvaccinated residents f. Repeat "e" for the In Progress and Fully Vaccinated Residents. You do not need to show work, put results in table on last page. g. (You are basically copying values from the table): Compared to two years ago, there are (number) more/fewer (circle) residents with Fully Vaccinated status. However the vaccination rate in terms of percentage has gone from (percentage) to (percentage) ,an absolute reduction in percentage of (percentage). Based on the above, if your Company is boasting an increase in Fully Vaccinated residents, what do you think they are referring to? Do you think this is an accurate portrayal of the vaccination program at your facility? Explain.Quantitative Reasoning Project: Name: Describing and Analyzing Data Complete this project in "worksheet form" by showing work in the space provided and copying the final answers designated place. For all calculations, show the formula used, the values substituted in, and the calculated result rounded to the nearest cent. If you use a formula more than once there is no need to show that formula twice. Scenario You have been hired to assess the vaccination status of residents in a large group of residential facilities and bring them into compliance with impending State standards. The vaccine schedule requires two shots to be administered within 6 months to one year of each other (or else you have to "start over" and the vaccine status reverts to unvaccinated). There is also a fair amount of turnover in the facilities. The last page of this document has three tables to fill in so that you can compare them. Part 1 Current Status Vaccine Status Frequency You go through the medical records for all 7,120 current Unvaccinated 1563 residents and construct the Frequency Distribution In Progress 2851 Table as shown. Fully Vaccinated 2703 a. Find the Percent Relative Frequencies and complete the table (last page). Show one calculation here