Please explain step by step
SALARY TABLE 2020-VB INCORPORATING THE 2.6% GENERAL SCHEDULE INCREASE AND A LOCALITY PAYMENT OF 16.51% FOR THE LOCALITY PAY AREA OF VIRGINIA BEACH-NORFOLK, VA-NC TOTAL INCREASE: 3.13% EFFECTIVE JANUARY 2020 Annual Rates by Grade and Step Step 1 Step 2 Step 3 Step 4 Step 5 Step 6 Step 7 Step 8 Step 9 Step 10 $ 22,770 $ 23,533 $ 24,290 $ 25,043 $ 25,800 $ 26,243 $ 26,991 $ 27,746 $ 27,776 $ 28,484 25,602 26,211 27,059 27,776 28,088 28,914 29,740 30,566 31,392 32,219 27,934 28,865 29,796 30,727 31,658 32,589 33,520 34,451 35,382 36,313 31,359 32,404 33,449 34.494 35,539 36,584 37,629 38,674 39,719 40,765 35,085 36,254 37,424 38,594 39,764 40,933 42,103 43,273 44,443 45,612 39,109 40.413 41,716 43.020 44,324 45,628 46,931 48,235 49,539 50,843 43,459 44,908 46,356 47,804 49,252 50,700 52,149 53,597 55,045 56,493 48,130 49,735 51,339 52,943 54,548 56,152 57,756 59,361 60,965 62,569 53,160 54,932 56,704 58,476 60,248 62,021 63,793 65,565 67,337 69,109 58,542 60,493 62,445 64,396 66,348 68,299 70,251 72,202 74, 154 76, 105 64,318 66,462 68,606 70,750 72,893 75,037 77,181 79,325 81,468 83,612 12 77,091 79,661 82,232 84,802 87,372 89,942 92,512 95,083 97,653 100,223 13 91,671 94,727 97,783 100,839 103,895 106,952 110,008 113,064 116,120 119,176 14 108,328 111,938 115,549 119,159 122,770 126,381 129,991 133,602 137,213 140,823 15 127,422 131,670 135,918 140,166 144,414 148,662 152,910 157,158 161,406 165,654An individual is looking for a position of increased responsibility and has found such a position with the federal government. There are four openings with identical job descriptions needing to be filled, one located in each of the following cities: Los Angeles, Washington DC, New York City (Manhattan), and Virginia Beach. The individual wants to live in a one bedroom apartment while living in the city of employment. She has been selected for the position and can choose which city to live in. Cash flow is an important factor in the choice. The federal pay schedules pay a different amount for the same job based on locality to account for cost of living. For this position, Los Angeles pays $66,531, Washington DC pays $59,534, New York City pays $67,320, and Virginia Beach pays $53,160. (SALARY TABLE 2020-VB (opm.gov)) The individual's apartment will be the largest living expense, so she goes onto the Internet and searches for seven randomly selected apartments in each city and records their monthly rent. If there is a rent price range, she chooses the lowest value in the range for this analysis. She then computes which cities will cost more to live in, if any, after paying for apartment rent assuming that those randomly selected are representative rents. (Do not include the effects of taxes in the analysis - just the effects of locality pay and apartment rents of those randomly selected.) Is there a city which is likely to be significantly more expensive in terms of her cash flow in this situation to live in. Show all data collected and computations in Excel. a. State the null hypothesis. 3 pts. b. State the alternate hypothesis. 3 pts. c. Use Excel to compute the ANOVA table for this problem. Show the table in an Excel file with the corresponding data. 4 pts. d. Draw your conclusion. Justify your answers. 5 pts
