## You have been asked to develop a Regression Analysis for XYZ Mart in order to develop an Artificial Intelligence model to determine vegan shoppers.

1. You have been asked to develop a Regression Analysis for XYZ Mart in order to develop an Artificial Intelligence model to determine vegan shoppers.  (10 points)
1. Tell me for what reason you would use each of the following parts of the Solver window for this Regression Analysis if you were to use Linear Regression:
1. Set Objective:
1. By Changing Variable Cells:
1. Subject to the Constraints:
1. Select a Solving Method:
1. Tell me why you would recommend using Logistic Regression instead of Linear Regression for this problem?
1. Explain what is meant by “training” the data for this type of model.
1. How is the “test set” of data different from the “training set” of data?
• The trust office at XYZ National Bank needs to determine how to invest \$100,000 in bonds to maximize the annual return. The options are:

Bond                Annual Return          Maturity   Risk          Tax-Free

A                      9.5%                         Long         High         Yes
B                      8.0%                         Short        Low          Yes
C                      9.0%                         Long         Low          No
D                      9.0%                         Long         High         Yes
E                      9.0%                         Short        High         No

The office wants to invest at least 50% of the money in short term issues and no more than 50% in high-risk issues. At least 30% of the funds should go in tax-free investments and at least 40% of the total return should be tax free.

Use the following Excel Optimization Analysis Spreadsheet solution for the above problem for the questions that follow the spreadsheet.  (10 points)

A                       B           C          D            E                  F                G                H             I

1. Tell me which cells (AND why you indicate those cells) would in each of the following parts of the Solver window for this Optimization Analysis:
1. Set Objective:
1. By Changing Variable Cells:
1. Subject to the Constraints:
1. Tell me what role “Minimax” played in this analysis.
1. Explain what criteria other than minimax can be used to create a more “robust” optimization model than the one above.  These are things that you would suggest to the trust office and MAY NOT be shown on the spreadsheet above.  There are at least two that should be mentioned.

### JOURNALISTIC BEAT

This assignment is an academic essay in which you will choose either one media outlet, one journalistic beat or one specific journalist or group of journalists. Your piece will chronicle….

### Sociology and the Real World Paper

3.13. ASSESSMENT: Sociology and the Real World PaperDue Dec 8 by 11:59pm Points 80 Submitting a file upload File Types doc., docx, and pdf Available after Aug 30 at 12amYou….

### What is Quantitative Easing? What are its objectives? How successful has it been in meeting its objectives?

1. What are the key arguments in favour and against inflation targeting and central bank independence?2. What is Quantitative Easing? What are its objectives? How successful has it been in….