Can you pleas answer it on excel! Thank you! SAMS-Project 2 NOTE: Answers only w
ID: 3179841 • Letter: C
Question
Can you pleas answer it on excel!
Thank you! SAMS-Project 2 NOTE: Answers only will earn you a very minimal grade. Please type a formal report with your findings with clear and complete interpretations of your results. in decimal format and not percentage) Round all answers to four decimal places (I San Antonio MultiComm Services (SAMS) provides high quality communications networks in the Greater San Antonio area. SAMS offers subscription-based services for digital cable video programming, local and long-distance telephone SAMS services and high speed internet access. Recently, SAMS is facing competition from other network providers that have expanded in the San Antonio Area. SAMS marketing department wants to increase subscriptions for its Three-For All telephone, cable, and Internet combined services. SAMS marketing has been conducting an aggressive direct-marketing campaign that includes postal and electronic mailings and telephone solicitations. Feedback from these efforts indicates that including premium channels in this combined service is a very important factor for both current and prospective subscribers. After several brainstorming sessions, the marketing department has decided to add premium cable channels as a no-cost benefit of subscribing to the Three-For-All service. You plan to conduct a survey among prospective customersto determine how many premium channels need to be added to the Three-For-All servicein order to generate a subscription to the service. Based on past campaigns and on industry-wide data, you estimate the following. Number of Free Premium Channels Probability of Subscriptions 0.02 0.04 0.06 0.07 0.08 0.085 Questions 1,2&3Hint Distribution: They subscribe or they don't 1. If a sample of 50 prospective customers is selected and no free premium channels are included in the Three-For-All service offer, what is the probability that fewer than 3 customers will subscribe? What is the probability that more than 4 customers will subscribe? 2. Instead of offering no premium free channels, suppose that two free premium channels are included. What is the probability that fewer than 3 customers will subscribe? What is the probability that more than 4 customers will subscribe? 3. Compare your answers from questions a1 and #2 and interpret the meaning of the results.
Explanation / Answer
1. There are two outcomes-success (subscribe) or failure (do not subscribe). The number of independent, random trials are denoted by n=50, and probability of success, p=0.02. The specific number of success is denoted by r in n trials. This accounts for binomial distribution.
P(X<3)=P(X<=2)
The syntax for computing therequired probability in Excel is as follows:
=BINOMDIST(2,50,0.02,TRUE), where, r=2, n=50, p=0.02, and TRUE is typed for computing cumulative probability.
=0.9216 (ans)
P(X>4)=1-P(X<=4)=1-BINOMDIST(4,50,0.02, TRUE)
=0.0032 (ans)
2. The syntax is as follows:
=BINOMDIST(2,50,0.06,TRUE)
=0.4162 (ans)
P(X>4)=1-P(X<=4)=1-BINOMDIST(4,50,0.06,TRUE)
=0.1794 (ans)