Answer:
NORMDIST(RAND(),50,5)
Step-by-step explanation:
NORMDIST(RAND(),50,5) returns the random value from a normal distribution. The second space is meant for Mean and the third space is meant for standard deviation.
Answer:
51+x-5+y-6=180
x+y=180-51+5+6
X+y=140
Answer x=77 y=63
(those 2 lines with the arrows are perpendicular so their angles are the same 72° and (x-5)=77-5= 72°)
Answer:
0.677
Step-by-step explanation:Add up the values in the plan A column. There are 10+12+16 = 38 people who prefer plan A.
Add up the values in the "40-49" row to find that 16+8 = 24 people are ages 40 to 49.
We have 38+24-16 = 46 people who either prefer plan A, are aged 40-49, or fit both descriptions. I subtracted off 16 because those 16 people were counted twice when adding 38 and 24.
An alternative way to get this value of 46 is to add up everything that is in column1 or row 3 (or both). So that would get 10+12+16+8 = 46.
Now add up everything in the table to find out how many people were surveyed total. That would be 10+7+12+15+16+8 = 68 people overall.
The probability of someone liking plan A, or being age 40-49, or both is 46/68 = 0.6765 approximately. Rounding to 3 decimal places gives 0.677
3 is correct. 4 is yes. 5 is no.
5. 6/10-2/10=4/10 or 2/5 or 1/2.5
6. 4/5-1/5=3/5 or 1.5/2.5
7. 3/4-2/4=1/4 or .5/2
8. 4/6-2/6=2/6 or 1/3 or .5/1.5
