Question #1
Q1 [20 points). The le \"MBA application\" includes a sample of individuals who have received an undergraduate degree and are currently working in the industry. You would like to explore the factors that determine their likelihood to apply for the IvaA programs in the country. The data includes their family size, their current salary, their undergraduate GPA, and whether they have applied to at least one MBA program in the nation at the time of the survey. Use Pivot Table to identify the following values: 1. Percentage of individuals who earn high salaries with low undergraduate GPA choose to apply for the MBA programs. 2. Percentage of individuals who earn low salaries 'om small family choose NOT to apply for the MBA programs. 3. Percentage of individuals who have small family and low GPA choose to apply for the MBA programs. 4. What factors seem to affect an individual's likelihood to apply for the MBA programs in the data? Please note: Name the worksheet \"your last name_Q1\". Q4 {18 points}. You are given the following unit sales data for five sales associates from Monday to Saturday. Please set up a worksheet (name the worksheet \"your last name_Q4\") to complete the following tasks: 1. Rank your employees by units of product sold for each day during the week (descending order). Hint: use the \"rank\" function to complete the performance ranking. 2. Use the icons introduced in class to track the daily change in performance ranking over the week (up, down, or stays the same) for each individual sales associate. Hint: use \"IF\" statement to complete this question. sales wdddddd ddddddd m\" Sharo11 --- _E_E-_E__ 25 (18 points}. You are saving for your dream house. You are going to contribute the same amount of money to the dream house fund at the end of each year. Your goal is to end up with 3 100,000. You are not quite sure about the annual investment returns of the fund, but they should range from 4 percent through 15 percent. You are also not quite sure about the number of years you will invest into the dream house fund. But the number of years investing should vary from 5- 15 years. Please perform the following analysis: 1. Use a two-way data table to determine how your required annual contribution is going to change as annual investment returns change (with 1 percent increment) and as years investing change (with 1 year increment). 2. Use scenario managers to produce a scenario summary report to show how your required annual contribution is going to change as scenario changes. The four scenarios have been provided in the table below: Hi-h returns Ion time Low returns short time Hih returns short time Low returns lon time Hint: use the PMT function to calculate your required annual contribution. Name your worksheets as \"Q5 data table\" and \"Q5 scenario summary\
