You are looking for a new apartment and decided to go through a realtor instead of shopping for the apartment through advertisements. Cain Realty provided you with the following list of 7 available apartments in the area you specified. The apartments have been evaluated by Cain Realty using 12 different criteria. Assignment #2 ? Data Analysis Problem 5-14 Modified You are looking for a new apartment and decided to go through a realtor instead of shopping for the apartment through advertisements. Cain Realty provided you with the following list of 7 available apartments in the area you specified. The apartments have been evaluated by Cain Realty using 12 different criteria (listed as 2?13 on the spreadsheet in Figure 5.16). Complete the following steps for Part 1 and Part 2: 1. Use an Excel workbook to design a decision aid to choose an apartment. 2. Use the appropriate factors in Part 1 and Part 2. 3. Decide how much decision weight you want to assign to each factor relative to the other factors. 4. Distribute the decision weights so that they add up to 100 (i.e., 100%). 5. Justify your decisions about factors and weights. 6. Select an apartment and provide the reason for your decision. Part 1 a. Use the 12 factors shown in Figure 5.16 for your decision model. b. Complete the steps listed above. Part 2 a. Choose a situation that would require a decision. [Example: selecting a new car] b. Select 10 factors for your decision model. [Example: price, mpg, and safety] c. Indicate potential sources from the internet for your decision factors. [Example: Kelly Blue Book(prices) and Edmund (car reviews)] d. Set up a Table of Data in the same format as Figure 5.16 e. Populate the table with response to the factors. (This data can be fictitious. You do not have to research the criteria.) f. Complete the steps listed above.