Question: Please do these calculations in excel and explain the process and reasoning. Managing Ashland MultiComm Services 1. If a sample of 50 prospective customers is

Please do these calculations in excel and explain the process and reasoning.

Please do these calculations in excel and explain
Managing Ashland MultiComm Services 1. If a sample of 50 prospective customers is selected and no free premium channels are included in the 3F0rAll service offer, given past results, what is the probability that: 3. Fewer than 3 customers will subscribe to the 3-F0rAll service offer? b. 0 customer or 1 customer will subscribe to the 3ForAll service offer? c. More than 4 customers will subscribe to the 3F0rAll service offer? d. Suppose that in the actual survey of 50 prospective customers, 4 customers subscribe to the 3-F0r-All offer. What does this tell you about the previous estimate of the proportion of customers who would subscribe to the 3- F orAll service offer? I 2. Instead of offering no premium free channels as in Problem I, suppose that two free premium channels are included in the 3 ForAll service offer. Given past results, what is the probability that: 3. Fewer than 3 customers will subscribe to the 3-F0r-A [Z service offer? b. 0 customer or 1 customer will subscribe to the 3F0rAll service offer? c. More than 4 customers will subscribe to the 3-F0rAll service offer? d. Compare the results of (a) through (c) to those of Problem 1. e. Suppose that in the actual survey of 50 prospective customers, 6 customers subscribe to the 3 F orAZI offer. What does this tell you about the previous estimate of the proportion of customers who would subscribe to the 3 F orAll service offer? f. What do the results in (e) tell you about the effect of offering free premium channels on the likelihood of obtaining subscriptions to the 3-F0r-All service

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!