# Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.

42 Pages

### ch05xt

Course: MST 6020, Spring 2008
School: Utah
Rating:

Word Count: 1048

#### Document Preview

to Guide Using Excel For Basic Statistical Applications To Accompany Business Statistics: A Decision Making Approach, 6th Ed. Chapter 5: Discrete and Continuous Probability Distributions By Groebner, Shannon, Fry, &amp; Smith Prentice-Hall Publishing Company Copyright, 2005 Chapter 5 Excel Examples Binomial Mean Catalog Sales Poisson Distribution Heritage Tile More Examples Chapter 5 Excel Examples...

Register Now

#### Unformatted Document Excerpt

Coursehero >> Utah >> Utah >> MST 6020

Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.

Course Hero has millions of student submitted documents similar to the one below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
to Guide Using Excel For Basic Statistical Applications To Accompany Business Statistics: A Decision Making Approach, 6th Ed. Chapter 5: Discrete and Continuous Probability Distributions By Groebner, Shannon, Fry, & Smith Prentice-Hall Publishing Company Copyright, 2005 Chapter 5 Excel Examples Binomial Mean Catalog Sales Poisson Distribution Heritage Tile More Examples Chapter 5 Excel Examples (continued) Creating Creating Standard A Binomial Table a Poisson Table Normal Distribution State Bank and Trust More Examples Chapter 5 Excel Examples (continued) Exponential Distribution Haines Internet Services A Standard Normal Table Creating Binomial MeanCatalog Sales Issue: People who order items from catalogs can return the items for a refund. Historical return rate for one catalog has been 11 percent. Is this rate still valid? Objective: Use Excel to compute binomial probabilities based on a sample of 300 purchases. Binomial Mean Catalog Sales Situation Sample Size is n=300 p = .11 Mean = np = 300(.11) = 33 44 returns were observed P(X > 44) = 1 P(X < 43) Find P(X < 43) = ? Binomial Mean Catalog Sales Click on Function Wizard then select Statistical then Binomdist Binomial Mean Catalog Sales Binomial Probability function Binomial Probability Result Enter required values. Note, True indicates that you want the cumulative probability False would indicate that you want the exact probability. Poisson Distribution Heritage Title Issue: The distribution for the number of defects per tile made by Heritage Tile is Poisson distributed with a mean of 3 defects per tile. The manager is worried about the high variability Objective: Use Excel to generate the Poisson distribution and histogram to visually see spread in the distribution of possible defects. Poisson Distribution Heritage Tile Enter values of x ranging from 0 to 10. Poisson Distribution Heritage Tile Click on the function button, then select Statistical and Poisson. Poisson Distribution Heritage Tile Enter the value of x (located in cell a2), the value of the mean and finally false. Poisson Distribution Heritage Tile Generate the remaining probabilities, then click on the Chart Wizard button. Poisson Distribution Heritage Tile Enter the correct range of values in the chart wizard. Poisson Distribution Heritage Tile Provide a title and label the axes as desired. Poisson Distribution Heritage Tile Complete Histogram as shown in tutorials for Chapter 2. Creating A Binomial Table Issue: The binomial tables in this text contain specific probabilities for certain values of n and p. You may need to have more extensive tables. Objective: Use Excel to generate the Binomial table for n = 25 and p value of .01 to .50 in increments of .01 Creating A Binomial Table Sample size (n) in cell B1 P values in row 3 X values in column A Creating A Binomial Table P(X =0) = .777821 for n = 25, p = .01 Notice the use of absolute cell referencing this allows you to copy the function across and down to complete this section of the binomial table Creating A Binomial Table Values for X > 11 are all zero can be dropped from table to save space Creating A Binomial Table Expand the table to include more p values. Note, make sure your cell referencing is correct. then copy cells Creating A Binomial Table Continue this process for all p values. For different sample sizes, replace n in cell B1 Creating A Poisson Table Issue: The tables Poisson in this text contain specific probabilities for certain values of . You may need to have more extensive tables. t Objective: Use Excel to generate the Poisson Table table for = 6.0 to 7.0 in increments of .10 t Creating A Poisson Table values in row 2 Values of X in column A t Creating A Poisson Table P(X = 0) for = 6.0 equals .00248 Notice the use of absolute cell t referencing this allows you to copy the function across and down to complete this section of the binomial table Creating A Poisson Table Continue this process for other values as desired. As increases, t the possible values for X willt have to increase. Standard Normal DistributionState Bank and Trust Issue: State bank managers have studied the time customers spend at the bank on business. They plan to offer a gift certificate to any customer who is required to spend over 40 minutes on bank business. Objective: Use Excel to analyze to create histogram and determine the probability that a certificate will be given to any customer. The data file is State Bank.xls. Standard Normal State Bank and Trust Open Data File: State Bank.xls Standard Normal State Bank and Trust Create Bins (Upper Limits of each class) Standard Normal State Bank and Trust Click on Tools Data Analysis Histogram Standard Normal State Bank and Trust Define Data and Bin ranges and specify where you want the output to go. Check Chart Output Standard Normal State Bank and Trust Close Gaps in Histogram by selecting chart bars, right clicking and selecting Chart Object Options and then change Gap width to 0 Standard Normal State Bank and Trust Add labels and format horizontal axis. Next, determine probability of a service time exceeding 30 seconds. Standard Normal State Bank and Trust Select Function Wizard Then Click on Statistical then select Normdist function Standard Normal State Bank and Trust Enter X =30, mean = 22.14, st dev = 6.09, and True for cumulative probability P(X <30) = .9016 Exponential DistributionHaines Internet Services Issue: The time between connect ...

Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more. Course Hero has millions of course specific materials providing students with the best way to expand their education.

Below is a small sample set of documents:

Acton School of Business - ESCI - 324
week 13, Apr. 12, 14The Earth's Core: Velcoity, Density and Compositionslide 1week 13, Apr. 12, 14The Earth's Core: Velcoity, Density and Compositionslide 2Crust: Crust: Some Factsan average value of 35 km in the continents 7-8 km in the oceanic
Rose-Hulman - CSSE - 377
Reconstructing Software ArchitecturesCSSE 377 (SAD Two*) Software Architecture &amp; Design 2 Week 5, Day 2, including Ch 10 in Bass's bookWhereas this course is of *374 was SAD One Google for course SAD Two Google that, and you get this, about sad for that
Rose-Hulman - CS - 414
Team 7 Client Meeting, March 26, 2003 Agenda 1. Review agenda [1 min] a. Make modifications to this agenda b. Select a secretary for this meeting c. Select a time keeper for this meeting 2. Re-introduce team [1 min] a. Same members, slightly modified role
Rose-Hulman - CSSE - 374
Below: Someone else's version of a UML SSD for a &quot;rental&quot; in this case, for &quot;unavailable.&quot; From http:/www.tracemodeler.com/articles/a_quick_introduction_to_uml_sequence_diagrams/ .CSSE374 Iteration 3: More SSD's and ContractsSteve Chenoweth 1 Day 29, Fe
Rose-Hulman - CS - 414
CS414 Software Engineering Group 8 Union Hospital Linear Accelerator Project Client Meeting Summary The client, Hux Cancer Center at Union Hospital, uses macros written for Lotus 123 to calculate doses of radiation given to their patients. The system has
Rose-Hulman - MA - 113
MA 113-03/04 Calculus IIIPortfolio Assignment: Tire TracksImagine that while walking down a dirt path you see the following set of tire tracks that you guess were made by a bicycle. Can you determine which way the bicycle was going? (LEFT/RIGHT)Figure
Rose-Hulman - CSSE - 404
Curt CliftonCSSE404 Compiler ConstructionLanguage and Tool SelectionThis milestone is intended to start things simply and get you in the habit of working on your compiler project every week. For this milestone you will conrm that you can use the Subver
Columbia - CS - 4824
HYPERTHREADING TECHNOLOGY IN THE NETBURST MICROARCHITECTUREBY USING EXISTING PROCESSOR RESOURCES MORE EFFICIENTLY,HYPERTHREADING TECHNOLOGY IMPROVES PERFORMANCE AT LITTLE COST AND INCREASES CHIP SIZE BY LESS THAN 5 PERCENT.Hyperthreading technology, wh
Penn State - MSH - 5020
03 02 10 CONCRETE CURING MATERIALS2.10CURING MATERIALS A. Evaporation Retarder: Waterborne, monomolecular film forming, manufactured for application to fresh concrete 1. Available Products: a. Conspec Marketing &amp; Manufacturing Co., Inc., a Dayton Superi
Missouri S&T - ME - 211
BULLETIN LCM Series 8000, 9000, 14000LO-COG DC Servo MotorsPittman brand LO-COG brush-commutated DC motors offer smooth, quiet operation and long life. Armatures are skewed to minimize magnetic cogging, even at low speeds, and windings are resin impregn
Iowa State - CPRE - 308
CprE 308Practice Set 1August 25, 2006These are practice problems to brush up your C programming skills. These problems will serve as a good preparation for the next quiz. If you have any questions bring those to class for discussion. The chosen example
Penn State - BUB - 1980
Sheet1 STATE COLLEGE, PENNSYLVANIA DAILY WEATHER SUMMARY - Latest Complete Day [1200 UT - 1200 UT] -12/16/80High Temperature Low Temperature Mean Temperature Rain or Liquid Equivalent Snow and/or Ice Pellets Snow Depth: ::29 Rank (1=Warmest, 85=Coldes
UAB - CS - 401
ASSIGNMENT #4 Due Tuesday, February 17, 2004 1. Write a Lisp function (replace atom1 atom2 list) that takes two atoms, atom1 and atom2, and a list as parameters and replaces all occurrences of atom1 in the list with atom2, no matter how deeply the first a
Purdue - EE - 631
ECE631/EE631Q Lecture 32: Converter Module DesignS.D.Sudhoff Purdue UniversityEE631 Spring 20051Power State Design of CMEE631 Spring 20052Design Requirements (1) Convert 500 V dc to 420 V dc (2) Achieve an Output Power of 5 kW (3) Output voltage r
Purdue - CE - 697
CE 697R Fall 2008 Seismic Design of Steel Structures Course Design Project: Presentation Team MembersItem IntroductionCommentsPoints /5DESIGN Overview of Design (unique difficulties? Propose changes?)/ 15Description of final SLRS (locations, compone
Purdue - AAE - 450
Last Revised August 22, 2005 General Information for A&amp;AE 450 Spacecraft Design Prof. Steve Schneider Fall 2005 Catalog Description of Course: Senior students perform a team-based spacecraft design, requiring application of the education and skills develo
Purdue - EE - 631
EE631: Power Electronic Converters and Systems Formally: High Voltage DC Transmission SystemsDecember 21, 2004Objective:The objective of this course is to educate the students in issues that govern the design of highly optimal and power dense power ele
Stanford - PIXR - 1035
1 MILBERG WEISS BERSHAD &amp; SCHULMAN LLP 2 JEFF S. WESTERMAN (SBN 94559) jwesterman@milbergweiss.com 3 KAREN T. ROGERS (SBN 185465) krogers@milbergweiss.com 4 355 S. Grand Avenue, Suite 4170 Los Angeles, CA 90071-3172 5 Telephone: (213) 617-1200 Facsimile:
Stanford - LAVA - 1034
Case 3:05-cv-02394-CRBDocument 63Filed 06/21/2006Page 1 of 31 MILBERG WEISS BERSHAD &amp; SCHULMAN LLP 2 JEFF S. WESTERMAN (SBN 94559) E-mail: jwesterman@milbergweiss.com 3 KAREN T. ROGERS (SBN 185465) E-mail: krogers@milbergweiss.com 4 CHERYL A. WILLIAMS
Stanford - DITC - 1034
1 MILBERG WEISS BERSHAD &amp; SCHULMAN LLP 2 JEFF S. WESTERMAN (SBN 94559) jwesterman@milbergweiss.com 3 KAREN T. ROGERS (SBN 185465) krogers@milbergweiss.com 4 One California Plaza 300 S. Grand Avenue, Suite 3900 5 Los Angeles, CA 90071-3149 Telephone: (213)
Stanford - ERTS - 1034
Case 3:05-cv-01219-MMCDocument 69Filed 01/04/2006Page 1 of 31 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28MILBERG WEISS BERSHAD &amp; SCHULMAN LLP JEFF S. WESTERMAN (SBN 94559) KRISTEN MCCULLOCH (SBN 177558) 355 S. Grand Ave.,
Stanford - LAVA - 1034
Case 3:05-cv-02394-CRBDocument 32Filed 11/01/2005Page 1 of 41 2 3 4 5MILBERG WEISS BERSHAD &amp; SCHULMAN LLP JEFF S. WESTERMAN (SBN 94559) KAREN T. ROGERS (SBN 185465) 355 S. Grand Avenue, Suite 4170 Los Angeles, CA 90071-3172 Telephone: (213) 617-1200
Washington University in St. Louis - CS - 342
Problem Solving ApproachesCS 342: Object-Oriented Software Development LabWhy Use the Scientific Method? What is the Scientific Method? Solving Programming Problems Design Problems Debugging Problems &quot;Problems&quot;Problem Solving and ReportingDavid L. Lev
Ill. Chicago - ACTG - 594
16-321 of 1Q1a Bottles Sold Total b List Selling Price c Actual selling price d Actual selling price e Number of purchase orders f Number of sales visits g Number of deliveries h Miles traveled per delivery i Number of hot-hot runsP 50,000 \$ \$ \$ 0.60
UCCS - CS - 522
Chapter 1IntroductionUses of Computer Networks Business Applications Home Applications Mobile Users Social IssuesBusiness Applications of NetworksA network with two clients and one server.Business Applications of Networks (2)The client-server model
UCSB - BREN - 210
UCCS - CS - 522
Automatic Repeat Request (ARQ)When the receiver detects errors in a frame, how does it request the transmitter to resend the corresponding packet? The problem is that the feedback channel is error prone also! The simplest strategy is stop and wait: The s
UCSB - BREN - 210
Strategic Management and the Environment Hoffman, Chapter 5: Redefining Markets.Strategic Management and the Environment Expand the service with changes in the product or its production. Provide a bundle of services as a source of competitive advantage
Milwaukee School of Engineering - EE - 2900
Appendix BTutorial 1 - Using Quartus II CAD SoftwareQuartus II is a sophisticated CAD system. As most commercial CAD tools are continuously being improved and updated, Quartus II has gone through a number of releases. The version known as Quartus II 5.0
Wisconsin Milwaukee - STAT - 564
Stat 564 Time Series AnalysisAssignment 9 due Wed., Nov. 19 Problems 2.30, A13 ; ECR 7 (required of grad students)Fall 2003A13. Write out the equation of a mixed seasonal ARM A(2, 1) (0, 1)4 model in the form Xt = (similar to the way the text writes ou
CofC - HIST - 270
College of CharlestonSOCIAL HISTORY OF ANCIENT EGYPTDr. Peter A. Piccione Office: Maybank 313 Office Hours: M - Thur, 1:00-3:00 p.m. (or by appointment) Telephone: 953-4861 Fax: 953-6349 History 270.080 Spring 2003 E-mail: piccionep@cofc.edu Tue., Thurs
UConn - MATH - 109
Math 109Q 1. In the following questions, f (x) = x3 + 1 and g(x) = x . x-6Midterm 2 Review Sheet(a) Find (f + g)(x), (f - g)(x), (f g)(x), and (f /g)(x). (You need not simplify.) (b) Find (f g)(x) and (g f )(x). (You need not simplify.) (c) What is the
Truman State - CHEM - 121
Water Analysis Authors: D. McCurdy, J. McCormick* Background The quality of water is of vital importance to the planet. The characteristics of water that allow it to be the &quot;universal solvent&quot; also make obtaining &quot;pure&quot; water almost impossible. As water m
San Jose State - CSCE - 466
Department of Computer Science &amp; Engineering University of Nebraska-Lincoln Software Design Methodologies(CSCE 466/866 - Spring 2002)_ Course Numbers: CSCE 466/866 The call numbers are: CSCE466 2857 CSCE866 2875 Location: Ferguson 112 Time: Tuesday and
Penn State - ACF - 5033
Penn State - ACF - 5033
Wisconsin - MATH - 211
University of Texas - CS - 382
CS 382M - Prof. BurgerAssignment #4 - Cache memoriesDue Oct. 29, 2003Problem 1: (50 points)H&amp;P 3.12Problem 2: (50 points)H&amp;P 3.13Problem 3: (30 points)H&amp;P 5.3Problem 4: (75 points)H&amp;P 5.4Problem 5: (65 points)H&amp;P 5.8Problem 6: (60 points)H&amp;P
Wesleyan - GRK - 201
Please take notice of: (c)Beneke/Lagaly. Don't quote without permission. Published in: ECGA (European Clay Group Association) Newsletter No.5, July 2002, page 57-78Klaus Beneke and Gerhard Lagaly Institute of Inorganic Chemistry Christiana Albertina Univ
Hudson VCC - WHITTENBEN - 143
Chapter 15Output Design and PrototypingMcGrawHill/IrwinCopyright 2007 by The McGrawHill Companies, Inc. All rights reserved.Objectives Distinguish between internal, external, and turnaround outputs. Differentiate between detailed, summary, and except
Maryville MO - NRS - 592
April24,2009 10:3012:00 EcohydrologyReadings:FinalClass SaltMarshes:Functions,Monitoring,Restoration Guidelines: Therearenodesignatedguides.Bringinaonepagesummaryofeachpaper.Wewillhavea groupdiscussion. Odum, W.E., E. P. Odum and H.T. Odum. 1995. Nature's
Portland - SW - 510
Portland State University Graduate School of Social Work SW510/610 Poverty: Policies and Programs Course Description:Richard Hunter Spring 2006This course will examine the nature and causes of poverty and inequality in the United States and the impact o
Wisconsin Milwaukee - C - 106
Announcements Paper is due TODAY no later than 5:00 pm and can be handed in here in class. Exam score information was posted on the web. Average: 65.8 High 102 Low 22Ions Species (atoms or groups of atoms) that carry a charge are called ions. Positivel
Maryland - CBMG - 688
The subcellular localization and function of PIN2Localization The apical (upper) side of lateral root cap and epidermal cellsPresented by Jianhong Chang Feb 5 2007Function Direct the auxin flow from the root tip into the elongation zoneOverexpression
Georgia Tech - ECE - 4061
EE4061 ASSIGNMENT NO. 1DATE ASSIGNED: DATE DUE: READING: Monday, June 28, 1999 Friday, July 2, 1999 Chapter 7.PROBLEM 1.1. Consider a channel with an ideal low-pass-lter frequency response, bandlimited to |f| &lt; 2500 Hz. (a) (b) If we are to avoid ISI, w
SUNY Stony Brook - CSE - 590
IEEE TRANSACTIONS ON COMMUNICATIONS, VOL. COM-29, NO. 1 , JANUARY 198111Distributed Algorithms for Generating Loop-Free Routes in Networks with Frequently Changing TopologyELI M. GAFNI,STUDENT MEMBER, IEEE, ANDDIMITRI P. BERTSEKAS,SENIOR MEMBER, IEE
Columbia - MATH - 102
Math 102-001, Spring 2008, StolzSome recommendations on using integration techniques1. Substitution A substitution u = g(x) works best, if the derivative g (x) appears as part of the integrand (but there are exceptions). A substitution can be used to us
Stanford - MATH - 131
2Assignment 3: Assigned Thu 10/09. Due Thu 10/16Part I: 1. Section 2.3 3, 6, 7. 2. (a) Let T &gt; 0, x1 , x2 R, and a, b be two continuous functions such that a(x, t) 0 (with no assumption on b). Suppose u is a function such that ut + bux auxx &lt; 0 on the r
UNC - SOG - 0574
Property Tax Listing and Assessing in North CarolinaOctober 610, 2008Knapp-Sanders Building, School of Government, UNC-Chapel HillThis course covers the legal aspects of listing, appraising, and assessing property for taxation in North Carolina accordi
NYU - M - 117
Math 117: Quiz 3 September 21, 1999Use the space below and, if necessary, on the back of this paper to complete the following problems. Show all your work and clearly indicate your answers. No calculators or notes of any kind are allowed. Good luck!1. 2
University of Alabama in Huntsville - CHE - 294
Using Maple - A Tutorial(J. J. Weimer, May 2002) Maple is a symbolic math program that can be used to solve a wide range of mathematical problems. Computers in van Braun Research Institute, Engineering Building, Technology Hall, and Wilson Hall have Mapl
Winona - PHYSICS - 330
LF411 Low Offset, Low Drift JFET Input Operational AmplifierAugust 2000LF411 Low Offset, Low Drift JFET Input Operational AmplifierGeneral DescriptionThese devices are low cost, high speed, JFET input operational amplifiers with very low input offset
University of Alabama in Huntsville - CHE - 294
Tutorial on the Use of ExcelJeffrey J. Weimer Chemistry/Chemical &amp; Materials Engineering University of Alabama in Huntsville August 26, 2002This tutorial provides an introduction to some basic capabilities of Excel. A working knowledge of how to start u
CSU Channel Islands - PRE - 1990
Luce, R. Duncan, A Game Theoretic Analysis of Congressional Power Distributions for a Two-Party System , Behavioral Science, 1:2 (1956:Apr.) p.83
University of Montana - PH - 211
Phys 221Exam 3Fall 2007Full Name (PRINT):Signature: 1.(5)In unit-vector notation ( and k), nd the magnitude and direction of the vector b if i, j, b = 3 4k 2 . i jb=0 2.(8)The gure below shows a stable mobile of toy penguins hanging from the ceiling
University of Montana - PHYS - 112
Practice Problems for Exam #2 1. A resistor has different voltages applied to it and the corresponding currents are measured. The data are plotted in this graph. What is the resistance?Current vs. Applied Voltage120 100 Current ( Amps ) 80 60 40 20 0 0
University of Montana - PH - 211
Phys 221 Full Name (PRINT):Practice Final Exam Signature:Fall 20071.(6) Joe stands on level ground. According to Newtons 3rd Law, what is the reaction force to the normal force the ground exerts on Joe? State on what object and in what direction the re
University of Montana - PHYS - 111
Physics 121, Section 1 Exam #4 Fri. 10/26/07Name _ ID # _Please show your work (where appropriate), and draw a box around your final answer. To get full credit, you must show clearly how you obtained your answers. 1. (6) Convert the following angle meas
University of Montana - PH - 211
iclicker Question ch16-8The tension of a guitar string in increased by a factor of 9. How does the speed of a wave on the string change, if at all? A. The speed of a wave is reduced to one-ninth the value it had before the increase in tension. B. The spe
Trinity U - CS - 1323
CSCI 1323March 22, 2006Administrivia All homework should be turned in ASAP. Solutions are available for all(hardcopy only). &quot;Due date&quot; for Homework 6 (for the purpose of assessing late penalties) will be noon tomorrow. Slide 1 You can still turn in ol
Stanford - IPAS - 1033
1 2 3 4 5 6 7 8 9 10 IICOOLEY GODWARD LL P WILLIAM S . FREEMAN ( 82002 ) ( freem anws@cooley .com) MARY BETH O'CONNOR (228591 ) ( mboconnor@ cooley .com) JEFFREY M . KABAN (235743) (jkaban @ cooley.com ) Five Palo Alto Square 3000 El Camino Rea l Palo Al