Can you pleas answer it on excel. Thank you. SAMS-Project 2 NOTE: Answers on wil
ID: 3179643 • Letter: C
Question
Can you pleas answer it on excel.
Thank you. SAMS-Project 2 NOTE: Answers on will earn you a very minimal grade. Please type a formal report with your findings with clear and complete interpretations of your results. e in decimal format and not percenta 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 SAMIS 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 avery 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 customers to 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 isselected 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
The question contains too many parts to be answered under one question. I am answering a few of them.
(1)
Modelling this as a Bernoulli's process with parameter p = 0.02
Let X denote the RV for number of subscribers
P(X=1) = 50C1 p1(1-p)50-1 = 50C1 * 0.021 * (1-0.02)50-1 = 0.371
P(X=2) = 50C2 p2(1-p)50-2 = 50C2 * 0.022 * (1-0.02)50-2 = 0.185
P(X=3) = 50C3 p3(1-p)50-3 = 50C3 * 0.023 * (1-0.02)50-3 = 0.060
Required probabilties:
(i)
P(X<3) = P(X=1) + P(X=2) = 0.556
(ii)
P(X>4) = 1-P(X<4) = 1 - { P(X=1) + P(X=2) + P(X=3) } = 0.384
(2)
In this case, everything is same except that p = 0.06. Thus,
Modelling this as a Bernoulli's process with parameter p = 0.06
Let X denote the RV for number of subscribers
P(X=1) = 50C1 p1(1-p)50-1 = 50C1 * 0.061 * (1-0.06)50-1 = 0.144
P(X=2) = 50C2 p2(1-p)50-2 = 50C2 * 0.062 * (1-0.06)50-2 = 0.226
P(X=3) = 50C3 p3(1-p)50-3 = 50C3 * 0.063 * (1-0.06)50-3 = 0.231
Required probabilties:
(i)
P(X<3) = P(X=1) + P(X=2) = 0.370
P(X>4) = 1-P(X<4) = 1 - { P(X=1) + P(X=2) + P(X=3) } = 0.399
(3)
Comparing the above two results, we see that adding two free premium channels inceases the chances of people subscribing to it.