Math Discrete 3

profileHema.700
MAT243SP19_EXa_Name.xlsx
Home>Mathematics homework help>Math Discrete 3

Start Here

There are 250 examination points on this test, worth 25 CPs. This part of the exam is worth 100 exam points, or 10 CPs. There are extra credit opportunities on this test. Make sure to appropriately rename the workbook file by replacing Name in the filename with your last name plus immediate first initial. However, unlike other assignments, if you do not appropriately rename the file, I will still accept it for grading but you will automatically lose 15% of your points. Make sure to also follow my formatting instructions. As stated in the GEN101 activities and documents:  If you correctly format the cells but have a wrong answer, some partial credit is likely, but  If you incorrectly format the cells, then it won't matter whether you performed the calculations correctly: It's wrong! Again, feel free to email should you have any questions; please remember to identify your course in the email subject line, and to also attach a current copy of your examination. You may ONLY use the methods that I have taught you throughout the term. If you use an unauthorized macro/process, then you will receive no points for that applicable worksheet. Again, it is in your best interests for me to look at your file before you submit. Make sure to NOT type in any values where calculations are required, which is just about everywhere. I will let you know when you may type in a value, if applicable.  IF you type a value directly into any cell not authorized by me, then you will lose ALL points for that worksheet; however . . .  If you do this on both worksheets, then you may receive a zero for the entire examination. Again, if you are unsure about this or anything else anywhere in the examination, email me. DUE BY 2359 HOURS ON WEDNESDAY, 04/17/2019

EX-1 50

Action Reaction
Reaction Unknown Reset
Enter Data Reset
(Initiating) Action Log In Continue
Enter Data Fault
Log Out Reset
Enter Data Fault
Log Out Fault
Enter Data Fault
Log In Reset
Probabilities Enter Data Fault
Reaction Enter Data Reset
Log Out Continue
(Initiating) Action Enter Data Fault
Enter Data Reset
Enter Data Continue
Enter Data Fault
Log In Fault
Log Out Continue
Action Reaction Enter Data Fault
Log In Continue Log In Continue
Enter Data Fault Log In Fault
Log Out Reset Log In Reset
Unknown Enter Data Fault
Log Out Continue
Enter Data Reset
Log Out Fault
Enter Data Continue
Log In Fault
Unknown Reset
Enter Data Reset
Enter Data Reset
Enter Data Continue
Enter Data Continue
Enter Data Continue
Enter Data Fault
Enter Data Continue
Log In Continue
Enter Data Fault
Log In Continue
Log In Reset
Enter Data Continue
Log In Fault
Enter Data Fault
Enter Data Continue
Enter Data Fault
Log In Continue
Log In Continue
Log In Fault
Log In Fault
Enter Data Reset
Log In Reset
Enter Data Reset
Enter Data Continue
Log Out Continue
Unknown Reset
Enter Data Continue
Enter Data Fault
Log In Continue
Log Out Fault
Enter Data Fault
Log In Continue
Log In Continue
Enter Data Reset
Log In Continue
Enter Data Fault
Log In Fault
Log In Reset
Enter Data Fault
Enter Data Continue
Enter Data Reset
Log In Fault
Enter Data Fault
Enter Data Continue
Log Out Reset
Log In Continue
Enter Data Fault
Enter Data Fault
Log In Continue
Log Out Fault
Log In Continue
Log Out Fault
Log In Fault
Enter Data Continue
Enter Data Fault
Enter Data Reset
Enter Data Continue
Log In Fault
Enter Data Fault
Log In Reset
Log In Reset
Log Out Continue
Log In Fault
Log In Fault
Enter Data Continue
Enter Data Fault
Enter Data Continue
Enter Data Reset
Log In Continue
Log Out Continue
Log Out Fault
Enter Data Reset
Enter Data Continue
Enter Data Fault
Enter Data Fault
Enter Data Continue
Log In Fault
Enter Data Continue
Log In Fault
Enter Data Reset
Enter Data Fault
Enter Data Continue
Log In Continue
Log In Reset
Enter Data Reset
Log In Fault
Enter Data Reset
Log In Fault
Enter Data Fault
Log Out Continue
Enter Data Fault
Enter Data Reset
Log In Fault
Enter Data Fault
Enter Data Fault
Log In Fault
Log In Fault
Enter Data Fault
Enter Data Fault
Log In Reset
Enter Data Continue
Enter Data Continue
Unknown Reset
Enter Data Continue
Unknown Reset
Enter Data Reset
Log In Reset
Unknown Reset
Enter Data Fault
Log In Fault
Log In Continue
Enter Data Fault
Log In Continue
Enter Data Continue
Enter Data Reset
Log In Continue
Log In Continue
Log In Continue
Log In Continue
Log In Continue
Enter Data Fault
Log In Continue
Enter Data Continue
Enter Data Fault
Log In Continue
Log In Reset
Log In Continue
Log In Fault
Enter Data Reset
Log In Continue
Log Out Continue
Log Out Continue
Enter Data Fault
Log In Continue
Log Out Continue
Log In Continue
Unknown Reset
Enter Data Fault
Enter Data Fault
Unknown Reset
Log In Continue
Enter Data Continue
Log In Reset
Log In Continue
Enter Data Fault
Log In Reset
Log In Fault
Enter Data Continue
Log In Fault
Log In Continue
Log In Continue
Enter Data Fault
Enter Data Continue
Enter Data Fault
Log In Fault
Enter Data Reset
Log In Reset
Enter Data Fault
Enter Data Continue
Enter Data Fault
Enter Data Continue
Enter Data Fault
Log In Fault

Do not sort Columns O & P! You will lose all points here if you do! (10 pts) Similar to what we previously performed, you are going to use a macro to count the number of Action-Result pairs indicated in the table at the right  Also complete the column, row, and grand totals. Start by transferring (via using the = sign) the header values from Columns J & K (below right) into the top and left headers in the upper table. Note: You are permitted to use array functionality if you so elect. (15 pts) Then fill in the table. Make sure to be efficient! (10 pts) Next, determine the probabilities for each action-result pair; report each value as a percentage to one decimal place. (5 BL pts each) You may use the array functionality demonstrated in the practice activity and solution videos for the upper and lower table bodies. You do not have to do this for both tables to receive some extra credit. (5 pts each) Briefly answer the following questions based on your results in the second table: Which Action-Reaction pair(s) has/have the greatest probability of occurring? Answer Here  The initiating action "Unknown" most probably produces which reaction(s)? Answer Here 

EX-2 50

¯ Logic Values ¯ ¯ Only Boolean Values here ¯ ¯ ¯ ¯ ¯ ¯ ¯ ¯ 1. (5 pts) What is the probability that f is 'TRUE'?
w x y z w x y z -x -y g = w - x h = z - y j = h - g f = g2hj
TRUE TRUE TRUE TRUE Answer =
TRUE TRUE TRUE FALSE
TRUE TRUE FALSE TRUE 2. (5 pts) What is the probability that f has a value of 0?
TRUE TRUE FALSE FALSE There are two ways to do this; you may type in a 1 for one of the ways.
TRUE FALSE TRUE TRUE
TRUE FALSE TRUE FALSE Answer =
TRUE FALSE FALSE TRUE
TRUE FALSE FALSE FALSE 3. (10 pts) What is the probability that f is 'TRUE' given that w is also 'TRUE'?
FALSE TRUE TRUE TRUE
FALSE TRUE TRUE FALSE Answer =
FALSE TRUE FALSE TRUE
FALSE TRUE FALSE FALSE 4. (10 pts) What is the probability that g has a value of 0 given that y has a value of 1?
FALSE FALSE TRUE TRUE
FALSE FALSE TRUE FALSE Answer =
FALSE FALSE FALSE TRUE
FALSE FALSE FALSE FALSE

There are two parts to this worksheet. This part is worth 20 examination points. This first part has you start with given TRUE/FALSE sequences below, converting them through Excel into their respective Boolean equivalents. Do not just type in the values! Convert the values in Columns C-F using the process defined in PA 1.3. After that, look to the right for the next part (worth 30 examination points) . . .

Now calculate the following probabilities by using the COUNT, COUNTIF, COUNTIFS macros, as applicable. Make sure to select all values as found on this worksheet, unless the instructions permit you to type in a value. Report all probabilities to 4 decimal places.