Question Currently, a club has 5,000 members. Use sensitivity analysis (data table) to present how the number of members at the end of the 5th year would vary as the number of new members joining the club varies between 1,000 and 5,000 (in increments of 1,000), and the annual retention rate (as a percent of starting members every year) varies between 50 percent and 80 percent (in increments of 10 percentage points). Steps: 1. Identify the output variable and the input variables of interest. 2. List all information given all inputs and their respective values on an Excel worksheet. 3. Create the initial set-up (as we did in class before creating the data table). You should have a table, similar to the one in the Customers worksheet of Chapter 1, in order to arrive at the number of members at the end of the 5th year using the values given/you entered for the inputs. 4. Once you have the number of members at the end of the 5th year (based on the values you entered for the input variables), create the data table.