Premium Essay

Mgq 301

In: Business and Management

Submitted By kclark1
Words 269
Pages 2
EXCEL FORMULA SHEET DISTRIBTIONS Binomial Distributions
For an EXACT probability =BINOMDIST(x,n,p,false) For less than or equal to x (at most x) =BINOMDIST(x, n, p, true) For less than x =BINOMDIST((x-1), n, p, true) For greater than x =1-BINOMDIST(x, n, p, true) For greater than or equal to x (at least x) =1-BINOMDIST((x-1), n, p, true)

Normal Distributions
To find the probability of a z-score (instead of using the Standard Normal Table!!) =NORMSDIST(z) * (used for P(z < ?)) =1-NORMSDIST(z) *(used for P(z > ?)) =NORMSDIST(z1) – NORMSDIST(z2) *(used for “between” probabilities) For an EXACT probability
*You will not be given “exact” probabilities because these are continuous distributions and exact values cannot be measured.

For probability less than or equal to x (at most x) =NORMDIST(x, mean, stddev, true) For probability less than x *same as above since Normal Distributions are continuous! For probability greater than x =1-NORMDIST(x,mean, stddev, true) For probability greater than or equal to x (at least x) *same as above since Normal Distributions are continuous! Given the percentile (probability) with objective to find the data value (x-value) =NORMINV(percentile, mean, stddev) If SAMPLING….with intent to determine the probability of the AVERAGE (mean) of the SAMPLE =NORMDIST(sample MEAN, population MEAN, STDERROR, true) *where STDERROR of the MEAN is:

**IF given a FINITE population and n/N > 5% apply the “Finite Correction Factor”

IF computing the STDERROR of a PROPORTION instead of the Mean: Compute the Z-score and use =NORMSDIST(z)

(π = Population %, p = sample %)

Similar Documents

Free Essay

Info Request on John Molson Sb

...RAM RAMESH Office: Residence: Department of Management Science & Systems 82 Prestonwood Lane School of Management, SUNY at Buffalo East Amherst, NY 14051 Buffalo, New York 14260 Ph: (716) 688-6360 Ph: (716) 645-3258 Fax: (716)645-6117 E-Mail: rramesh@acsu.buffalo.edu Web: http://mgt.buffalo.edu/faculty/academic/systems/faculty/rramesh Education Ph.D. Industrial Engineering (Operations Research) (1985) State University of New York at Buffalo (GPA: 4.0. Awarded Ph.D with Distinction) Advisors: Mark H. Karwan and Stanley Zionts M.Tech. Industrial Engineering (1977) Indian Institute of Technology, Madras B.Tech. Chemical Engineering (1975) Indian Institute of Technology, Madras Research Streams • • • • Economics of IT – MSP and Cloud Computing Markets Conceptual Modeling and Ontologies Database Systems and Distributed Computing Supply Chains & Decision Analysis Employment Professor Department of Management Science & Systems School of Management State University of New York at Buffalo (September 1998 - ) Associate Professor Department of Management Science & Systems State University of New York at Buffalo (September, 1990 – September 1998) Assistant Professor Department of Management Science & Systems State University of New York at Buffalo (September, 1984 - September, 1990) 1 Research and Teaching Assistant Doctoral Program in Operations Research Department of Industrial Engineering State University of New York at Buffalo (January, 1981 - September, 1984) Entrepreneur...

Words: 7611 - Pages: 31

Free Essay

Man Power Planing & Hrm

...RvZxq wk¶vµg I cvV¨cy¯ZK †evW© KZ„©K 2013 wk¶vel© †_‡K beg-`kg †kªwYi cvV¨cy¯ZKi~‡c wba©vwiZ MwYZ beg-`kg †kªwY iPbvq mv‡jn gwZb W. Agj nvj`vi W. Ag~j¨ P›`ª gÊj †kL KzZzeDwÏb nvwg`v evby †eMg G. †K. Gg knx`yj-vn& †gvt kvnRvnvb wmivR m¤úv`bvq W. †gvt Ave`yj gwZb W. †gvt Avãym Qvgv` RvZxq wk¶vµg I cvV¨cy¯ZK †evW©, XvKv RvZxq wk¶vµg I cvV¨cy¯ZK †evW© 69-70, gwZwSj evwYwR¨K GjvKv, XvKv KZ©„K cÖKvwkZ [ cÖKvkK KZ©„K me©¯^Z¡ msiw¶Z ] cix¶vg~jK ms¯‹iY cÖ_g cÖKvk : A‡±vei- 2012 cvV¨cy¯—K cÖYq‡b mgš^qK †gvt bvwmi DwÏb Kw¤cDUvi K‡¤cvR †jRvi ¯‹¨vb wjwg‡UW cÖ”Q` my`k©b evQvi myRvDj Av‡e`xb wPÎv¼b †Zvn&dv G›UvicÖvBR wWRvBb RvZxq wk¶vµg I cvV¨cy¯ZK †evW© miKvi KZ©„K webvg~‡j¨ weZi‡Yi Rb¨ gy`ªY : cÖm½-K_v wk¶v RvZxq Rxe‡bi me©‡ZvgyLx Dbœq‡bi c~e©kZ©| Avi `ª“Z cwieZ©bkxj we‡k¦i P¨v‡jÄ †gvKv‡ejv K‡i evsjv‡`k‡K Dbœqb I mg„w×i w`‡K wb‡q hvIqvi Rb¨ cÖ‡qvRb mywkw¶Z Rbkw³| fvlv Av‡›`vjb I gyw³hy‡×i †PZbvq †`k Movi Rb¨ wk¶v_©xi Aš—wb©wnZ †gav I m¤¢vebvi cwic~Y© weKv‡k mvnvh¨ Kiv gva¨wgK wk¶vi Ab¨Zg j¶¨| GQvov cÖv_wgK ¯—‡i AwR©Z wk¶vi †gŠwjK Ávb I `¶Zv m¤cÖmvwiZ I mymsnZ Kivi gva¨‡g D”PZi wk¶vi †hvM¨ K‡i †ZvjvI G ¯—‡ii wk¶vi D‡Ïk¨| ÁvbvR©‡bi GB cÖwµqvi wfZi w`‡q wk¶v_©x‡K †`‡ki A_©‰bwZK, mvgvwRK, mvs¯‹…wZK I cwi‡ekMZ cUf~wgi †cÖw¶‡Z `¶ I †hvM¨ bvMwiK K‡i †ZvjvI gva¨wgK wk¶vi Ab¨Zg we‡eP¨ welq| RvZxq wk¶vbxwZ-2010 Gi j¶¨ I D‡Ïk¨‡K mvg‡b †i‡L cwigvwR©Z n‡q‡Q gva¨wgK ¯—‡ii wk¶vµg| cwigvwR©Z GB wk¶vµ‡g RvZxq Av`k©, j¶¨, D‡Ïk¨ I mgKvjxb Pvwn`vi cÖwZdjb NUv‡bv n‡q‡Q, †mB...

Words: 99399 - Pages: 398

Free Essay

Law and Enactment in Finance

...†iwR÷vW© bs wW G-1 evsjv‡`k †M‡RU AwZwi³ msL¨v KZ…©cÿ KZ…©K cÖKvwkZ e„n¯úwZevi, Ryb 30, 2011 evsjv‡`k RvZxq msm` XvKv, 30†k Ryb, 2011/16B Avlvp, 1418 msm` KZ©„K M„nxZ wbgœwjwLZ AvBbwU 30†k Ryb, 2011 (16B Avlvp, 1418) Zvwi‡L ivóªcwZi m¤§wZ jvf Kwiqv‡Q Ges GZØviv GB AvBbwU me©mvavi‡Yi AeMwZi Rb¨ cÖKvk Kiv hvB‡Z‡Q t⎯ 2011 m‡bi 12bs AvBb miKv‡ii Avw_©K cÖ¯Ívevejx Kvh©KiKiY Ges KwZcq AvBb ms‡kvabK‡í cÖYxZ AvBb †h‡nZz miKv‡ii Avw_©K cÖ¯Ívevejx Kvh©KiKiY Ges wbæewY©Z D‡Ïk¨mg~n c~iYK‡í KwZcq AvBb ms‡kvab Kiv mgxPxb I cÖ‡qvRbxq ; †m‡nZz GZ`&Øviv wbgœiƒc AvBb Kiv nBj:⎯ cÖ_g Aa¨vq cÖviw¤¢K 1| mswÿß wk‡ivbvg I cÖeZ©b|⎯(1) GB AvBb A_© AvBb, 2011 bv‡g AwfwnZ nB‡e| (2) The Provisional Collection of Taxes Act, 1931 (XVI of 1931) Gi Aaxb Rb¯^v‡_© RvixK…Z †NvlYv mv‡c‡ÿ, GB AvBb 2011 m‡bi 1 RyjvB Zvwi‡L Kvh©Ki nB‡e| ( 7677 ) g~j¨ t UvKv 44.00 7678 evsjv‡`k †M‡RU, AwZwi³, Ryb 30, 2011 wØZxq Aa¨vq The Excise & Salt Act, 1944 (I of 1944) Gi ms‡kvab Act I of 1944 Gi FIRST SCHEDULE Gi ms‡kvab |⎯The Excise & Salt Act, 1944 (I of 1944) Gi FIRST SCHEDULE Gi PART II Gi cwie‡Z© GB AvB‡bi Zdwmj-1 G ewY©Z FIRST SCHEDULE Gi PART II cÖwZ¯’vwcZ nB‡e| 2| Z…Zxq Aa¨vq Customs Act, 1969 (Act IV of 1969) Gi ms‡kvab 2K| Act IV of 1969 G section 3 Gi ms‡kvab|⎯Customs Act, 1969 (Act IV of 1969), AZtci Customs Act ewjqv DwjøwLZ, Gi section 3 Gi clause (a) Gi cwie‡Z© wbgœewY©Z clause (a) Ges clause (aa) mwbœ‡ewkZ nB‡e, h_v t⎯ Ò(a) a Chief Commissioner...

Words: 34415 - Pages: 138

Free Essay

Solution for Classical Dynamics of Particles and Systems

...CHAPTER 0 Contents Preface v vii Problems Solved in Student Solutions Manual 1 2 3 4 5 6 7 8 9 10 11 12 13 14 Matrices, Vectors, and Vector Calculus Newtonian Mechanics—Single Particle Oscillations 79 127 1 29 Nonlinear Oscillations and Chaos Gravitation 149 Some Methods in The Calculus of Variations 165 181 Hamilton’s Principle—Lagrangian and Hamiltonian Dynamics Central-Force Motion 233 277 333 Dynamics of a System of Particles Motion in a Noninertial Reference Frame Dynamics of Rigid Bodies Coupled Oscillations 397 435 461 353 Continuous Systems; Waves Special Theory of Relativity iii iv CONTENTS CHAPTER 0 Preface This Instructor’s Manual contains the solutions to all the end-of-chapter problems (but not the appendices) from Classical Dynamics of Particles and Systems, Fifth Edition, by Stephen T. Thornton and Jerry B. Marion. It is intended for use only by instructors using Classical Dynamics as a textbook, and it is not available to students in any form. A Student Solutions Manual containing solutions to about 25% of the end-of-chapter problems is available for sale to students. The problem numbers of those solutions in the Student Solutions Manual are listed on the next page. As a result of surveys received from users, I continue to add more worked out examples in the text and add additional problems. There are now 509 problems, a significant number over the 4th edition. The instructor will find a large...

Words: 97501 - Pages: 391