Order Number 45471455714
Type of Paper
Essay Writer Classification Level
Undergraduate
Style of Writing
MLA/APA/CHICAGO/
Sources and References 5
Number of Pages
4
Paper Instructions
Unit 5, Chapter 5 Lab
Complete all problems using Excelwhen appropriate as explained. These exercises are intended for you to learn how to use the Excel to compute Binomial and Poisson probabilities and to also understand how the cumulative function works. You are to submit one file with each answer on a separate tab as defined below (therefore you will have four separate tabs). Your Excel file should be saved using file naming convention as last name first initial Unit 5 Lab. Proper naming format is also as part of your lab grade.
Problem 1, tab 1. Construct Binomial probability in Excel for Martin Cloths.Using the probability equation;=BINOM.DIST(number success, Trials, Probability, cumulative), where number successes = the # successes for the problem, Trials = n, Probability = p, and cumulative where using T means show the cumulative probability for the value of x or fewer, and F means probability of exactly x successes. Note, the sum of F will equal 1 and T values will be cumulative with the last value equal to 1.
You will create a table as shown below using x values 0 – 3 to represent the number of customers that we are interested in determining the probability of a sale. For this problem, n = 3 and p = .30 which means there are three trials with a probability of success 30%. The table will include using cumulative of False in one column and True in the other, to help learning the differences between the two functions. You will also calculate E(x), Var, and StdDev using np for E(x), np(1-p) for Variance and SQRT of Var respectively. Youranswer in the False column should be the same as the chapter notes we discussed and as shown in table 5.13.
Problem 2, tab 2. Construct Poisson Excelformula, =Poisson(x, mean, cumulative) for cars arriving at drive-up window. The average number of cards arriving in any 15-minute period = 10, therefore u = 10.This is a problem we did manually in the lecture where we solved for x of 5. However, for this lab assignment you will find Poisson for x from 0-20, meaning your column will showx values for arrivals listed 0 – 20 and calculate the Poisson for each these arrival times. In this table you want to determine the probability of arrival times for each arrival time. Based on this objective, determine whether you should use cumulative of True or False with the answers and explain your reason. Also include a 2-D column chart of the data.
Problem 3, tab 3. A Randstad/Harris interactive survey reported that 25% of employees said that theircompany is loyal to them (USA Today, November 11, 2009).Suppose 10 employees
are selected randomly and will be interviewed about company loyalty.Note, this is a binomial problem because it is asking to determine the number of successes. Answer the following and use Excel binomial equationwhere appropriate.=Binom.Dist(number_s, trials, probability_s, cumulative) where number_s = number of successes, trials = n, probability_s = probability, cumulative = either True or False.
(a) Is the selection of 10 employees a binomial experiment (does it meet the conditions for a binomial probability)? Explain.
(b) What is the probability that none of the 10 employees will say their company is
loyal to them?
(c) What is the probability that 4 of the 10 employees will say their company is loyal
to them?
(d) What is the probability that at least 2 of the 10 employees will say their company
is loyal to them? Remember from problem we did in class, with “at least” we manually calculated the cumulative value and subtract the sum from 1. This will provide the difference between all probabilities (sum = 1) and the cumulative “at least” quantities. So, in this case you want the cumulative values for 0 and 1 subtracted from 1 to show 2 of the 10. Therefore, for this problem you will use =1-Binom.Dist(number_s, trials, probability_s,cumulative)
(e) What is the expected number of employees (out of 10 employees) who will say
their company is loyal to them?
(f) What is the variance on the number of employees (out of 10 employees) who will
say their company is loyal to them?
Problem 4, tab 4. More than 50 million guests stay at bed and breakfast (B&Bs) each year. The website for the Bed and Breakfast Inns of North America, which averages seven visitors per
minute, enables many B&Bs to attract guests. Use Excel equations to complete all questions where appropriate. Poisson calculation in Excel is =Poisson.Dist(x,mean, cumulative) where x = the number of occurrences, mean = self-explanatory, may be shown as u, cumulative = either True or False.
(a) Compute the probability of no website visitors in a one-minute period.
(b) Compute the probability of two or more website visitors in a one-minute period. You should follow the same logic used in 3d by finding >. Therefore use =1-=Poisson.Dist(x,mean,cumulative)
(c) Compute the expected number of website visitors in a one-minute period.
(d) Compute the variance of the number of website visitors in a one-minute period. Recall in the lecture and PowerPoint notes regarding the mean and variance for Poisson distributions.
Distinguished (100%)
Proficient (85%)
Basic (70%)
Below Expectations (50%)
Non-Performance (0%)
Thesis Statement Raises the strongest objection to the thesis presented in the assignment. The objection is strongly grounded in research and logical reasoning. Raises a plausible objection to the thesis presented in the assignment. The objection is mostly grounded in research and logical reasoning.
Raises an objection to the thesis presented in the assignment. The objection is somewhat grounded in research and logical reasoning. Attempts to raise an objection to the thesis presented in the assignment. The objection is minimally grounded in research and logical reasoning.
The objection to the thesis is either nonexistent or lacks the components described in the assignment instructions. Counter Argument Provides a strong, thorough rebuttal to the objection. The rebuttal effectively demonstrates that the thesis can withstand the objection and applies the principles of charity and accuracy.
Provides a rebuttal to the objection. The rebuttal mostly demonstrates that the thesis can withstand the objection and mostly applies the principles of charity and accuracy.
Provides a limited rebuttal to the objection. The rebuttal somewhat demonstrates that the thesis can withstand the objection and somewhat applies the principles of charity and accuracy.
Attempts to provide a rebuttal to the objection; however, the rebuttal minimally demonstrates that the thesis can withstand the objection and does not apply the principles of charity and accuracy.
The rebuttal is either nonexistent or lacks the components described in the assignment instructions. Conclusion Provides clear and concise closing remarks that comprehensively summarize the essay. The remarks consider the broader controversy and/or further research that could offer additional insight into the moral solution of the business problem.
Provides closing remarks that summarize the essay. The remarks mostly consider the broader controversy and/or further research that could offer additional insight into the moral solution of the business problem. The closing remarks are somewhat unclear.
Provides closing remarks that minimally summarizes the essay. The remarks minimally consider the broader controversy and/or further research that could offer additional insight into the moral solution of the business problems. The closing remarks are unclear and/or vague.
Attempts to provide closing remarks that summarize the essay; however, the remarks do not consider the broader controversy and/or further research that could offer additional insight into the moral solution of the business problem. The closing remarks are unclear and vague. The closing remarks are either nonexistent or lack the components described in the assignment instructions.
Written Communication: Context of and Purpose for Writing
Demonstrates methodical application of organization and presentation of content. The purpose of the writing is evident and easy to understand. Summaries, quotes, and/or paraphrases fit naturally into the sentences and paragraphs. Paper flows smoothly.
Demonstrates sufficient application of organization and presentation of content. The purpose of the writing is, for the most part, clear and easy to understand. There are some problems with the blending of summaries, paraphrases, and quotes. Paper flows somewhat smoothly. Demonstrates a limited understanding of organization and presentation of content in written work. The purpose of the writing is somewhat evident but may not be integrated throughout the assignment. There are many problems with the blending of summaries, paraphrases, and quotes. Paper does not flow smoothly in all sections.
Organization and presentation of content are extremely limited. The purpose of the writing is unclear. There is little or no blending of summaries, paraphrases, and quotes. Paper does not flow smoothly when read.
The assignment is either nonexistent or lacks the components described in the instructions.
Written Communication: Control of Syntax and Mechanics
– Displays meticulous comprehension and organization of syntax and mechanics, such as spelling and grammar. Written work contains no errors and is very easy to understand.
Displays comprehension and organization of syntax and mechanics, such as spelling and grammar. Written work contains only a few minor errors and is mostly easy to understand Displays basic comprehension of syntax and mechanics, such as spelling and grammar. Written work contains a few errors which may slightly distract the reader.
Fails to display basic comprehension of syntax or mechanics, such as spelling and grammar. Written work contains major errors which distract the reader.
The assignment is either nonexistent or lacks the components described in the instructions.
Written Communication: Required Formatting
Accurately uses required formatting consistently throughout the paper, title page, and reference page.
Exhibits required formatting throughout the paper. However, layout contains a few minor errors. Exhibits limited knowledge of required formatting throughout the paper. However, layout does not meet all requirements.
Fails to exhibit basic knowledge of required formatting. There are frequent errors, making the layout difficult to distinguish as required style.
The assignment is either nonexistent or lacks the components described in the instructions.
Written Communication: Word Requirement
The length of the paper is equivalent to the required number of words. The length of the paper is nearly equivalent to the required number of words.
The length of the paper is equivalent to at least three quarters of the required number of words. The length of the paper is equivalent to at least one half of the required number of words.
The assignment is either nonexistent or lacks the components described in the instructions.
Written Communication: Resource Requirement Uses more than the required number of scholarly sources, providing compelling evidence to support ideas. All sources on the reference page are used and cited correctly within the body of the assignment.
Uses the required number of scholarly sources to support ideas. All sources on the reference page are used and cited correctly within the body of the assignment.
Uses less than the required number of sources to support ideas. Some sources may not be scholarly. Most sources on the reference page are used within the body of the assignment. Citations may not be formatted correctly. Uses an inadequate number of sources that provide little or no support for ideas. Sources used may not be scholarly. Most sources on the reference page are not used within the body of the assignment. Citations are not formatted correctly.
The assignment is either nonexistent or lacks the components described in the instructions.