Question: I need to use Excel when I solve these questions. 1)ProvidedN(0,1)and without using the LSND program, findP(-2

I need to use Excel when I solve these questions.

1)ProvidedN(0,1)and without using theLSNDprogram, findP(-2

The answer is not 0.9545

2)Provided N(0,1) and without using theLSNDprogram, findP (Z<-3).

The answer is not 0.0013

3)ProvidedN(0,1) and without using theLSNDprogram, findP(-3Z<-2).

The answer is not 0.0214

4)ProvidedN(0,1)and without using theLSNDprogram, findP(Z<-1ORZ>1).

The answer is not 0.3173

5)According to a medical study, it takes about 46.3 hrs, on average, for Roseola virus to fade away in infected patients (children). Assuming that the fading times of Roseola virus in infected patients are normally distributed with standard deviation 0.55, what's the probability of having a random case where the fading time of the virus in an infected patient is more than 47.95 hours? Find the answerwithoutusing theLSNDprogram.

the answer is not 0.0013499

6) Salaries for senior Civil engineers per year have known mean of 80 K dollars and standard deviation 3.3 K dollars. Provided that the salaries per year for senior Civil engineers are normally distributed, what's the probability of finding a Civil engineer whose salary is between 73.4 K and 83.3 K dollars? Find the answerwithoutusing theLSNDprogram.

the answer is not 0.819

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 Mathematics Questions!