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) |
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
If I am trying to find P(z < 2.5), what is the Excel command? a. =NORMDIST(2.5,0,1,1)...
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 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 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? #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 = "); ...
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) 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-
I am plotting a system in matlab using the command lsim(sys,u,t,x0) and trying to define my input signal as u(t)^(-2t). My question is how do I define this input signal in matlab. The matlab guides show that you use u=gensig() but beyond that I cannot understand how to define my input signal in u=gensig().
(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...
I am trying to program a dice game in Visual Studios c++ but am having trouble. The program allows the user to choose the number of rolls, not exceeding 100,000. I am trying to print out the number of times each number(1-6) was rolled, but it's not working. What am I doing wrong? The link below is a copy of my code. https://docs.google.com/document/d/1baKfnof4pjdQ4905hwXluFtbcA1Fs7QESMQKy45xdpE/edit