Mat HW4 A,B

profilefoooq55
MAT243FA17_EXa_Name.xlsx
Home>Mathematics homework help>Mat HW4 A,B

Start Here

There are 200 examination points on this test, worth 20 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. Consequently, it is in your best interests to let me look at your file before you submit it if you have any questions at all, including its filename. 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 est interests for me to look at your file. 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 two or more worksheets, then you will likely 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 TUESDAY, 11/28/17

EX-1 50

Action Result
Result Unknown Reset
Fault Reset Continue Enter Data Reset
Initiating Action Log In Log In Continue
Log Out Enter Data Fault
Enter Data Log Out Reset
Unknown Enter Data Fault
Log Out Fault
Enter Data Fault
Log In Reset
Probabilities Enter Data Fault
Result Enter Data Reset
Fault Reset Continue Log Out Continue
Initiating Action Log In Enter Data Fault
Log Out Enter Data Reset
Enter Data Enter Data Continue
Unknown Enter Data Fault
Log In Fault
Log Out Continue
Enter Data Fault
Log In Continue
Log In Fault
Log In Reset
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

(c)2016 Second WInd Productions, LLC

(c)2016 Second WInd Productions, LLC

(20 pts) Similar to what we performed on HW3, you are going to use COUNTIFS to count the number of Action-Result pairs indicated in the table at the right  as well as the column, row, and grand totals. (20 pts) Next, determine the probabilities for each action-result pair; report each value as a percentage to one decimal place. (10 BL Pts) You may use the array functionality demonstrated in the solution video; if you do so, make sure to correctly perform it. (5 pts each) Briefly answer the following two questions based on your results at the right: Which Action-Result pair(s) has/have the greatest probability of occurring? Answer Here  Which result(s) does the Initiating action, "Unknown," produce? Answer Here 

EX-2 50

Logic Boolean Values ® ® ®
w x y z w x y z -x -y w5 g = z - x h = w5 + z - y f = gh
TRUE TRUE TRUE TRUE 1. What is the probability that f is TRUE?
TRUE TRUE TRUE FALSE
TRUE TRUE FALSE TRUE Answer =
TRUE TRUE FALSE FALSE
TRUE FALSE TRUE TRUE 2. What is the probability that g has a value of 0?
TRUE FALSE TRUE FALSE
TRUE FALSE FALSE TRUE Answer =
TRUE FALSE FALSE FALSE
FALSE TRUE TRUE TRUE 3. What is the probability that f is TRUE given that w is also TRUE?
FALSE TRUE TRUE FALSE
FALSE TRUE FALSE TRUE Answer =
FALSE TRUE FALSE FALSE
FALSE FALSE TRUE TRUE 4. What is the probability that g has a value of 0 given that y has a value of 1?
FALSE FALSE TRUE FALSE
FALSE FALSE FALSE TRUE Answer =
FALSE FALSE FALSE FALSE

There are two parts to this worksheet. The first part is worth 30 exam points, the second part is worth 20 exam points. The first part has you start with the given TRUE/FALSE sequences below, converting them through Excel into Boolean values. Then finish filling in the columns as we did in HW2. After that, look to the right for the next text box . . .

Now calculate the following probabilities (5 pts each) by using the COUNTIF and COUNTIFS functionality as applicable. You may type in the following values as needed to support your calculations: 0, 1, 8, 16. Report all probabilities to 4 decimal placxes.

BL 20

#Empty Set 1 cells #Empty Set 2 cells Difference
CX122

(c)2016 Second WInd Productions, LLC

(c)2016 Second WInd Productions, LLC

Also similar to the HW, we are going to have you determine how many blank cells there are in two worksheets. (5 pts) Do this as we did on HW3, entering the counts where indicated at the right  Then use Excel to calculate the difference in the counts between the two worksheets. DO NOT JUST TYPE IN THIS VALUE! You will lose all points here if you do! Now, just answer the following questions; do NOT elaborate! Use the method we discussed in class (11/16/17) to search for whichever cell(s) is/are not blank. Make a note of the cell location(s) and anything entered in it/them. (5 pts) Type in below the name of worksheet that fewer empty cells. Answer Here  (5 pts) Type in below the cell location(s) of any non-empty cells. Answer Here  (5 pts) In sequence, as applicable, type in below what is in that/those non-empty cell(s). Answer Here  Save!

Set1

(c)2016 Second WInd Productions, LLC

(c)2016 Second WInd Productions, LLC

Set2

FOUND
THEM

(c)2016 Second WInd Productions, LLC

(c)2016 Second WInd Productions, LLC