If I am trying to find P(z < 2.5), what is the Excel command? a. =NORMDIST(2.5,0,1,1)...
If I am trying to find P(z < 2.5), what is the Excel command?
| a. |
=NORMDIST(2.5,0,1,1) |
|
| b. |
1-NORMDIST(2.5,0,1,1) |
|
| c. |
=NORMDIST(2.5,0,1,1)-.5 |
|
| d. |
=NORMDIST(2.5,1,0,1) |
Homework Answers
Solution. In the Excel for less than we use cumulative distribution function is give by NORMDIST(2.5 ,MEAN,SD, CUMULATIVE) SO THE Option (a) correct. = NORMDIST (2.5,0,1,1) . THANK YOU
Add Answer to:
If I am trying to find P(z < 2.5), what is the Excel
command?
a.
=NORMDIST(2.5,0,1,1)...
f I want to find P(Z > -1.85), what is the Excel command? a. NORMDIST(-1.85,0,1,1) -...
f I want to find P(Z > -1.85), what is the Excel command? a. NORMDIST(-1.85,0,1,1) - 1 b. 1-NORMDIST(-1.85,0,1,1) c. =NORMDIST(-1.85,0,1,1) d. NORMDIST(-1.85,0,1,1) - .5
For a standard normal distribution, find: P(z > -0.78) I am using excel for this problem.
For a standard normal distribution, find: P(z > -0.78) I am using excel for this problem.
having trouble with this. i am trying to use excel, so if you can, use the...
having trouble with this. i am trying to use excel, so if you
can, use the excel functiona as much as possible. thanks!
8.45 (a) Find P(T < 2.365) when v 7. (b) Find P(T> 1.318) when v = 24. (c) Find P(-1.356 < T < 2.179) when v 12. (d) Find P(T> -2.567) whenv = 17.
Find the p-value of an f-statistic using excel? Hello, I am trying to understand how to...
Find the p-value of an f-statistic using excel? Hello, I am trying to understand how to compute the p-value of an f-statistic using excel using the data below I have found the f-statistic to be : 45.9210236 Jensen Tire & Auto is in the process of deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly...
I am trying to add a string command to my code. what am i doing wrong?...
I am trying to add a string command to my code. what am i doing wrong? #define _CRT_SECURE_NO_WARNINGS #define _USE_MATH_DEFINES #include <stdio.h> #include <string.h> #include <math.h> int main(void) { int i, j; int rowA, colA, rowB, colB; int A[10][10], B[10][10]; int sum[10][10]; char str1[10]; printf("This is a matrix calculator\n"); //read in size from user MATRIX A printf("Enter in matrix A....\n"); printf("\t#row = "); scanf("%d", &rowA); printf("\t#col = "); ...
I am trying to use the PMT formula on excel to create an amortization for 15...
I am trying to use the PMT formula on excel to create an amortization for 15 and 30 years respectively. the loan 220,000. interest rate 15 years 3.125 and 20years 3.625.' every time I am using the excel the data is not accurate . Please show me how to use PMT for amortization
In trying to apply my knowledge in the real world, I am trying to create a...
In trying to apply my knowledge in the real world, I am trying to create a realistic retirement schedule. However, I am running into difficulties using both a financial calculator as well as our equations from class in doing this. I am trying to do the following: plan a retirement schedule between the ages of 25 and 70, in which I would deposit 20% of my income each year. The income starts at 80,000 with an annual growth rate of...
3. Using the norm.s.dist() command, for the standard normal random variable z find the following: (a)...
3. Using the norm.s.dist() command, for the standard normal random variable z find the following: (a) P(-1 <zcl )= (b) P(-222)- (c) P(-33)-
4. Using the norm.s.inv() command, for the standard normal random variable z find b such that:...
4. Using the norm.s.inv() command, for the standard normal random variable z find b such that: (a) P(z<b)=0.05, (b) P(z<b)=0.025, (c) P(z-b)-0.005, b= b= b-
(COMMAND LINE) I have a file, abc.csv and I am interested in a command line solution...
(COMMAND LINE) I have a file, abc.csv and I am interested in a command line solution (not something like C coding) for the following: In which zip code was the highest number of narcotic/drug offenses. ZIP_CODE and ABC_CODE are the relevant headings but there are many headings and many records within the file. Within ABC_CODE, 35A and 35B are narcotic and drug offenses. So, I want to find out which zip code has the highest number of narcotic/drug offenses, which...
having trouble with this. i am trying to use excel, so if you
can, use the excel functiona as much as possible. thanks!
8.45 (a) Find P(T < 2.365) when v 7. (b) Find P(T> 1.318) when v = 24. (c) Find P(-1.356 < T < 2.179) when v 12. (d) Find P(T> -2.567) whenv = 17.
3. Using the norm.s.dist() command, for the standard normal random variable z find the following: (a) P(-1 <zcl )= (b) P(-222)- (c) P(-33)-
4. Using the norm.s.inv() command, for the standard normal random variable z find b such that: (a) P(z<b)=0.05, (b) P(z<b)=0.025, (c) P(z-b)-0.005, b= b= b-
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago