1. You have been asked to develop a Regression Analysis for XYZ Mart in order to develop an Artificial Intelligence

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)
a. 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:
i. Set Objective:
ii. By Changing Variable Cells:
iii. Subject to the Constraints:
iv. Select a Solving Method:
b. Tell me why you would recommend using Logistic Regression instead of Linear Regression for this problem?
c. Explain what is meant by “training” the data for this type of model.
d. How is the “test set” of data different from the “training set” of data?
2. 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.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

We talked to senior marketing executives from dozens of top

We talked to senior marketing executives from dozens of top brands to find out more about this question. We asked them for examples of creative marketing that went beyond ads and helped the business in a real way. Their stories, along with the five larger trends they show, show what

Readreview the following resources for this activity: Textbook: Chapters 1 2 Lesson Local newspaper APA style manual Citation and Writing

Read/review the following resources for this activity:Textbook: Chapters 1, 2LessonLocal newspaperAPA style manualCitation and Writing Assistance: Writing Papers At CU(Links to an external site.)Library Overview(Links to an external site.)How to Search for Articles – the Everything Tab(Links to an external site.)InstructionsFind an article in your local newspaper about a local

Net Income: Revenue Expenses Net Sales: Gross Sales Sales Returns and Allowances Total Inventory: Beginning Inventory Purchases Cost of Goods

Net Income: Revenue– ExpensesNet Sales: Gross Sales – Sales Returns and AllowancesTotal Inventory: Beginning Inventory + PurchasesCost of Goods Sold: Total Inventory – Ending InventoryGross Profit/Net Operating Income: (Net Sales – Cost of Goods Sold) – Total ExpensesAssets:Liabilities + EquityCalculating gross profit for an organization does not provide the complete

1. Case Study Power Point Presentation Based on your readings

1.  Case Study Power Point Presentation Based on your readings throughout the course, choose a disorder/disease from your text and develop a power point presentation. The presentation must include: An introduction, incidence, prevalence (include to a global perspective), pathophysiology of the disease/disorder to the cellular level, existing prevention and therapeutic

OBSERVE THE LEADERSHIP OF CHAIRMAN CAO and DISCUSS HIS LEADERSHIP

OBSERVE THE LEADERSHIP OF CHAIRMAN CAO and DISCUSS HIS LEADERSHIP STYLE  PLEASE USE THE MATERIAL FROM CAMERON & GREEN  and the topics we discussed in lectures CHAPTER 4 Leading change  500 words OR 1 page single spaced make citations and give reference (CAMERON & GREEN) 

Case Study – Betty’s Treasures Betty Shriver is the owner of

Case Study – Betty’s Treasures Betty Shriver is the owner of Betty’s Treasures, a small shop that sells collectible porcelain figurines and collectible pottery. Betty’s shop carries many items that she purchased from estate sales and regional auctions, but the shop also sells handcrafted items made by local artisans, including

No minimum word count

Just answer questions No minimum word count APA format   Read Chapter 12 1. What are three questions you should ask yourself when you begin your job search? 2. What are the most common mistakes people make in preparing their résumés? 3. What should you know about your prospective employer

The school nurse has a unique role in the provision

The school nurse has a unique role in the provision of school health services for children with special health needs, including children with chronic illnesses and disabilities with various degrees of severity. This case describes the role of the school nurse caring for a child with type 1 diabetes. Susan

Write a 2 to 3-page paper on the seven layers

Write a 2 to 3-page paper on the seven layers of the OSI model. Identify the 7 layers of the OSI model. Describe 2 or 3 characteristics, protocols, or functions of each layer (i.e., what happens in each layer or what it does) in 1 or 2 paragraphs each. Cite

Socioeconomic status and class Journal

1.What are the main points made in the chapter, article, class discussion, activity? 2. Does the information given match with my own experiences? 3.What information is new to me? 4.What ideas are new to me? 5.With which ideas do you agree? 6.With which ideas do you disagree? 7.What is  your

How we feel about ourselves is an inherently social process

How we feel about ourselves is an inherently social process that stems in part from whom we compare ourselves to. Provide two real-life examples of how reference groups have affected how you feel about yourself (whether fleeting or long-term). In your view, is it possible to develop a sense of

In this case study assignment, you will select a company

 In this case study assignment, you will select a company or organization of your choice that has been dealing with risk and uncertainty within the last six months. Then you will determine solutions to organizational problems that take into account principles of risk management to improve operations and profitability. Instructions Write a

Describe the specific changes that should be made and who should have

To begin this project, you will sign up for a research topic (see Research Topic Sign-Up under course menu). Choose a market scenario that you believe should be changed to protect the interests of consumers. For the paper, you will conduct research and state your issue in the form of

 Where should we place the blame?  Economists believe the Great

 Where should we place the blame?  Economists believe the Great Depression was caused by the weaknesses in the 1920s economy, but the person whose name will be forever linked to the depression is President Herbert Hoover.  Personally blaming him for the crisis, Americans started to call the shantytowns set up by unemployed