Refer to the word document for instructions. Complete the actual assignment on the excel spreadsheet document.
Module 6 NxCombinationPermutation Module 6147 Module 9 npxCumulative? tc={64CAF0AE-7C92-43B1-8ECC-2080AB44E93E}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Cumulative TRUE means that we are finding the probability of x or smaller while FALSE means to find the probability of x exactlyP(x)E(x)Var(x)StDev(x) Module 9.1100.408FALSE µxCumulative? tc={36EDC040-E604-4316-AAB8-45F1484BE065}: [Threaded comment] Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924 Comment: Cumulative TRUE means that we are finding the probability of x or smaller while FALSE means to find the probability of x exactlyP(x)E(x)Var(x)StDev(x) Module 9.21521TRUE abx1x2f(x)P(x1<>
<=x) p(x="">=x)AnswerE(x)Var(x)StDev(x) Module 9.41813< module="" 10="" µ="" σ="" x="" z-score="" from="" data=""><=z) z-score="" from=""><=z)><=x) e(x)="" var(x)="" stdev(x)="" module="" 10="" 90="" 13.50="" 54.9="" mngt="" 368="" –="" business="" statistics="" unit="" 2="" review="" project="" instructions="" the="" file="" “module="" 11="" unit="" 2="" review="" project="" template.xlsx”="" contains="" a="" handful="" of="" data="" sets="" on="" separate="" worksheets;="" use="" these="" data="" sets="" while="" you="" complete="" the="" problems="" below.="" for="" each="" module,="" you="" will="" see="" a="" brief="" introduction="" to="" the="" problem="" and="" then="" a="" list="" of="" instructions,="" labeled="" in="" italics="" e.g.="" module="" 6.1.="" note="" that="" all="" of="" your="" work="" should="" lie="" inside="" of="" the="" gray-shaded="" cells.="" also,="" make="" sure="" you="" read="" the="" problem="" thoroughly="" and="" complete="" all="" of="" the="" instructions="" for="" each="" module="" before="" moving="" on="" to="" the="" next="" module.="" lastly,="" be="" aware="" that="" hard-coding="" (typing="" numbers="" directly="" into="" cells="" or="" formulas)="" will="" result="" in="" zero="" credit="" for="" the="" question.="" recall="" that="" the="" unit="" 1="" review="" project="" prompt="" had="" several="" tips="" for="" how="" certain="" formulas="" work,="" how="" to="" select="" data,="" and="" so="" on.="" if="" anything="" seems="" unclear,="" look="" back="" at="" the="" prompt="" to="" review="" those="" instructions.="" module="" 6="" data="" on="" the="" “module="" 6”="" worksheet="" contains="" data="" for="" you="" to="" use="" to="" compute="" combinations="" and="" permutations.="" module="" 6.1="" the="" table="" contains="" information="" on="" an="" example="" problem="" including="" sample="" size="" and="" value="" of="" interest="" for="" which="" you="" should="" calculate="" a="" combination="" and="" permutation="" in="" the="" gray-shaded="" cells.="" use="" the="" functions="" combin()="" and="" permut()="" to="" compute="" these="" values;="" if="" done="" correctly="" everything="" will="" update="" and="" recalculate="" as="" the="" input="" data="" changes.="" remember,="" don’t="" just="" type="" the="" values="" from="" columns="" c="" and="" d="" into="" the="" formula,="" use="" references="" or="" else="" your="" formulas="" won’t="" work!="" module="" 9="" use="" the="" data="" on="" the="" “module="" 9”="" worksheet="" to="" compute="" key="" characteristics="" for="" the="" distributions="" covered="" in="" module="" 9.="" as="" in="" module="" 6,="" your="" formulas="" should="" work="" for="" any="" set="" of="" data="" that="" appears.="" for="" each="" distribution,="" compute="" the="" probability="" of="" x,="" the="" expected="" value="" of="" x,="" the="" variance="" of="" x,="" and="" the="" standard="" deviation="" of="" x.="" module="" 9.1="" the="" first="" table="" contains="" information="" useful="" in="" calculating="" characteristics="" for="" the="" binomial="" distribution.="" hint:="" use="" binom.dist()="" to="" compute="" the="" probability="" of="" x,="" where="" “number_s”="" (the="" first="" argument)="" is="" the="" number="" of="" successes="" and="" “probability_s”="" (the="" third="" argument)="" is="" the="" probability="" of="" success.="" module="" 9.2="" the="" second="" table="" contains="" information="" useful="" in="" calculating="" characteristics="" for="" the="" poisson="" distribution.="" column="" e="" has="" data="" for="" whether="" the="" search="" is="" p(x="x)" or=""><=x), which="" is="" to="" say="" whether="" you="" are="" looking="" for="" the="" probability="" of="" x="" taking="" on="" an="" exact="" value="" or="" if="" it="" is="" that="" value="" and="" everything="" lower="" than="" it.="" fortunately,="" the="" poisson.dist()="" function="" has="" an="" argument="" built="" in="" for="" this="" parameter,="" and="" in="" fact="" the="" function="" requires="" it.="" module="" 9.3="" the="" third="" table="" contains="" information="" useful="" in="" calculating="" characteristics="" for="" the="" continuous="" uniform="" distribution.="" first="" compute="" f(x),="" then="" use="" that="" information="" to="" compute="" the="" probability="" of="" x="" falling="" between="" x1="" and="" x2.="" from="" there,="" compute="" the="" standard="" distribution="" characteristics.="" hint:="" consult="" chapter="" 6a="" slides="" 7-8="" for="" the="" relevant="" formulas.="" module="" 9.4="" the="" fourth="" table="" contains="" information="" useful="" in="" calculating="" characteristics="" for="" the="" exponential="" distribution.="" you="" will="" want="" to="" use="" the="" expon.dist()="" function,="" but="" there="" are="" three="" important="" details="" here:="" 1)="" as="" a="" continuous="" distribution,="" the="" exponential="" distribution="" should="" always="" be="" used="" to="" calculate="" the="" value="" of="" x="" taking="" on="" a="" value="" in="" some="" interval,="" so="" for="" the="" sake="" of="" this="" assignment,="" we="" will="" only="" be="" using="" the="" cumulative="" form="" of="" the="" function,="" thus="" you="" should="" enter="" true="" into="" the="" last="" argument="" of="" the="" expon.dist()="" function.="" 2)="" the="" definition="" that="" we="" have="" used="" in="" class="" for="" the="" exponential="" distribution="" is="" actually="" not="" the="" formal="" definition.="" rather="" than="" µ,="" the="" exponential="" distribution="" is="" defined="" by="" a="" parameter="" λ="" (lambda),="" which="" is="" simply="" λ="1/µ." so,="" when="" the="" function="" prompts="" you="" to="" enter="" lambda,="" enter="" 1/µ.="" 3)="" the="" standard="" form="" of="" the="" exponential="" distribution="" assumes="" that="" we="" are="" interested="" in="" the="" probability="" that="" the="" random="" variable="" takes="" on="" a="" value="" less="" than="" or="" equal="" to="" the="" value="" of="" interest,="" i.e.=""><=x), but="" sometimes="" we="" are="" interested="" in="" the="" probability="" that="" the="" random="" variable="" takes="" on="" a="" value="" greater="" than="" or="" equal="" to="" the="" value="" of="" interest,="" i.e.="" p(x="">=x). Column E in the fourth table contains a symbol for one of these two search directions. So, in Columns F or G, compute the labeled probability for each of the two search directions. In column H, you will need to use an IF() function to determine which of the two search directions are appropriate for this problem. Hint: if you are unfamiliar with IF() functions, check out this tutorial from YouTube. Once you have done the hard work of computing columns F-H, compute the standard distribution characteristics in columns I-K. Hint: consult Chapter 6a slides 15 for the relevant formulas. Module 11 Use the data on the “Module 10” worksheet to compute the specified measures. Module 10.1 Use the mean, standard deviation, and x information to compute the relevant Z-Score. Hint: you can use the STANDARDIZE function or just enter the formula, either is fine. Module 10.2 Use the NORM.S.DIST() function to convert the z-score you calculated into a probability. For this and all similar functions in this Module, enter “TRUE” without the quotes into the “cumulative” argument. Module 10.3 Reverse the calculation with the NORM.S.INV() function (you should end up with the same result in column H as you have in column F). Module 10.4 Use the NORM.DIST() function with the data in columns C:E to compute P(X<=x). module 10.5 compute the remaining characteristics of the distribution in columns j:l. module="" 10.5="" compute="" the="" remaining="" characteristics="" of="" the="" distribution="" in="" columns="">