Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I solve for complement rule of P(X > or = 4.0) in excel?
Suppose that the lifetimes of TV tubes are normally distributed with a
standard deviation of 1.1 years. Suppose also that exactly 30% of the tubes die before 4 years. Find the mean lifetime of TV tubes. Carry your intermediate computations to at least four decimal places. Round your answer to at least one decimal place. My question is: (a) how do you solve in excel for complement rule of P(X or = 4.0). (b) How do you solve a z-score of -0.2533 to produce a mean of 4.7787 in excel? I have tried to find a function or formula that I can use to determine similar outcomes. Okonita I am a student taking a statistics class and I have this homeworks problems to solve and I'll love to use excel to do this but don't know how? |
#2
|
|||
|
|||
Other than to do mutiplication, Excel is not needed to solve this problem.
First get a standard Z table and lookup either 30% or 70 % - doesn't matter which since they are the same distance (in years) from the mean. Should be something like .525?? Then multiply by the standard deviation to get the distance (in years) to the mean. Call this distance Y. The mean is then 4+Y. -- Gary's Student "OKONITA" wrote: Suppose that the lifetimes of TV tubes are normally distributed with a standard deviation of 1.1 years. Suppose also that exactly 30% of the tubes die before 4 years. Find the mean lifetime of TV tubes. Carry your intermediate computations to at least four decimal places. Round your answer to at least one decimal place. My question is: (a) how do you solve in excel for complement rule of P(X or = 4.0). (b) How do you solve a z-score of -0.2533 to produce a mean of 4.7787 in excel? I have tried to find a function or formula that I can use to determine similar outcomes. Okonita I am a student taking a statistics class and I have this homeworks problems to solve and I'll love to use excel to do this but don't know how? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you use solver to solve a polynomial | Excel Discussion (Misc queries) | |||
Will an OLAP cube or Pivot Table (or something else) solve my prob | Excel Discussion (Misc queries) | |||
How to solve problem (equal to 0) with unknown value | Excel Discussion (Misc queries) | |||
solve quadratic equation system | Excel Worksheet Functions | |||
How can I solve for multiple unknown variables in Excel? | Excel Discussion (Misc queries) |