Module 1 Assignment (MBA 550 Decisions Support Systems)

profileprettyldy26
HomeworkreminderandHintsforModule1.docx

H/W Reminder and Hints for Module 1

Dear students,

If you have not used Excel before, I recommend you Google and search for an introductory tutorial, or YouTube video. You may use keywords like:

Create your first Excel 2016 workbook.

Visit Microsoft website for tutorials and hints on Excel.

The following exercises are due for Module 1:

Management Science (CH1) – Exc# 2 and 4

Probability and Statistics (CH 11) Exc# 10, 12, and 14

Note: Chapter # for the Probability and Statistics will depend on whether you are using the custom textbook (CH2) or the original textbook (CH 11)

For each of these exercises, please submit one Excel file containing two worksheets (tabs):

· Chapter 1 - one worksheet per exercise showing calculations using Excel

· Chapter 11 - one worksheet per exercise showing calculations using Excel

This H/W must be submitted by uploading the file/s by clicking on Module 1 Assignment tab in Module 1 in D2L course.

This H/W must be submitted on or before Sunday (midnight – Eastern Time) by the due date shown in the Module.

In addition to the Homework reminder and Hints file, I am also attaching the following files:

1. Tutorial_M1.docx

2. Chapter 1 exercise 1 (Excel file - sample solution to EXC #1).

3. Chapter 11 exercise 11 (sample solution to Exercise #11. This EXC is also used in the AVP).

IMPORTANT NOTE: Before starting the homework, please ensure that you:

(a). Complete the Excel tutorial by using the attached word file: Tutorial_M1.docx. It contains instructions on how to create an Excel file, enter data, and perform calculations using the formulas. Please print this file and follow the instructions. This tutorial will help you in using Excel especially for those of you who are not using Excel regularly. The attached Excel file: Chapter 1 exercise #1 shows the completed Excel solution for the tutorial. It will also help you with chapter 1 homework.

(b). View the AVP for module 1. It is an introduction to Excel particularly how to use formulas and functions in Excel as well as the use of Bayesian equation.

Hints for chapter 1

You can use the layout in the attached sample solution for exercise #1 from chapter #1 as a template. Look carefully at the formula in cell B15 for calculating the break-even volume (V). This is the same file that you have created in the tutorial.

Exercise #2 – it is identical to the sample solution for exercise #1.

Exercise #4 – Use formula similar to cell B15 in exercise #1.

Hints for chapter 11 - Probability and Statistics

I have attached solution to exercise #11 from chapter #11 as a sample solution. I recommend that when performing calculations for exercise 10, 12, 14 you show your results to three decimal places for better precision. I strongly recommend that you try to solve exercise #11 yourself for practice and use the sample solution to check your answers or if you are struck. This will be an excellent preparation for the H/W assignments for this chapter. All H/W assignments for this chapter are very similar to exercise #11.

Exercise #10 - This exercise requires the use of Bayesian formula to calculate posterior probability. See part C (rows 55-80) of the sample file exercise #11 for chapter 11. Note how I have used the Bayesian formula in cell B80.

In exercise #10, you are given:

P(S) = 0.23, P(NS) = 1 – 0.23 = 0.77;

P(I|S) = 0.18, P(I|NS) = 0.06.

You are required to calculate P(S/I). Just try to relate this to the Bayesian formula under Bayesian Analysis section in the textbook.

Hint: you may relate smokers and non-smokers to Olson and Abercrombie respectively, and winning to illness in the attached sample solution for EXC #11.

Exercise # 12 and #14 – These exercises are very similar to Figure 7 (for part a of #14) and Table 1 (for part b of #14) shown in the section: Depending Events in the textbook. You can use these as a guide for layout. You are given marginal probabilities and conditional probabilities in both exercises. From this data calculate joint probabilities. Read the problem and identify marginal probability P(B) and conditional probability P(A|B) for each event, then multiply them together to calculate the joint probability using the following equation:

P(AB) = P(A|B) * P(B)

In exercise #12 you are given the marginal probability of Democrats P(D) = 0.66 and marginal probability of Republicans P(R) = 0.34 in the Senate. Start probability tree with these marginal probabilities. You are also given the conditional probabilities whether they will vote in favor or against the bill depending on the party they belong. For example, you are given that 35% of democrats’ favor (this also mean 65% do not favor the bill). This is called conditional probability P(F|D) since 35% senators who favor the bill belong to the Democratic party. You are also given the conditional probability of Republicans who favor/against the bill.

Use part a and b of the sample solution file for exercise #11 to solve this problem. Calculate the joint probability who favors the bill from both parties (similar to cell B41 in the sample solution, where I have calculated the total joint probability of winning the case by both firms). For simple majority if it is 50% or higher then the bill will pass.

In exercise # 14 you are given three marginal probabilities of students living in each district (North, South, and Central). These are 25%, 40% and 35% in the North, Central, and South districts respectively. You are also given the conditional probabilities of failing and passing (passing = 1-failing) in each region. For example, conditional probability of students who failed the test from North district P(F|N) = 0.1 or 10%. From this information you can also compute the conditional probability of students who passed from the North district is 90% (100-10) or 0.9. You are given similar data for other two districts.

For the H/W exercises in chapter 11, important thing is to determine the marginal and conditional probabilities. As you can see from the example in the Dependent Events section, the marginal probabilities are the probabilities of getting a head P(H) or a tail P(T) by tossing a coin. These probabilities are used to draw the probability tree in figure 7. Since the probability of drawing a red or white ball depends whether you got head or tail when the coin was tossed, so these are called conditional probabilities and are written as P(R|H), P(R|T) etc.

How to draw arrows? Word and Excel have a drawing button under the INSERT tab. In Excel, to draw arrows for the probability tree, click on Insert tab, then in the Illustrations group click on (drop-down arrow) of Shapes You can select number of shapes including arrows.

.Final Note: This course is numerical in nature. Since H/W is part of the overall grade, please do not ask me to check your answer/s prior to submitting the H/W. I do not provide feedback before the final submission and grading. However, if you have question/s regarding the material you have read; sample solution files I have supplied; examples in the textbook; or exercises at the back of each chapter that are not part of the graded H/W, please let me know. I will be happy to help.

Have a great week

Dr. Bal

Dr. B. Bal Page 3