Discrete Probabilty Distribution

Discrete Probabilty Distribution

I need the following calculated and answered in an Excel Spreadsheet

1: 

The director of admissions at Kinzua University in Nova Scotia estimated the distribution of student admissions for the fall semester on the basis of past experience.

Admissions Probability
1,010     0.6    
1,380     0.3    
1,600     0.1    

 

1.

What is the expected number of admissions for the fall semester?

 Expected number of admissions  

 

2.

Compute the variance and the standard deviation of the number of admissions. (Round your standard deviation to 2 decimal places.)

 Variance
   Standard deviation
 


 

2:  It is reported that 22% of American households use a cell phone exclusively for their telephone service. In a sample of seventeen households, find the probability that:

a.

No household uses a cell phone as their exclusive telephone service. (Round your answer to 4 decimal places.)

 Probability  

 

b.

Exactly 10 households exclusively use a cell phone for telephone service. (Round your answer to 4 decimal places.)

 Probability  

 

c.

Find the mean number of households exclusively using cell phones. (Round your answer to 4 decimal places.)

 Mean
  

11

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.


Discount Code: CIPD30


Click ORDER NOW..

order custom paper