All your questions can be answered using the same technique. For example, if
we have data in A1 thru A1000 and pick a sample at random:

=COUNTIF(A1:A10,"6")/1000

is the probability the value is greater than or equal to 7. Same approach
for the other cases.
--
Gary''s Student - gsnu200909


"Mr_Maruski" wrote:


-- I am working a major project in my statistics class and have hit a snag.
I have 4 questions that require me to use and show Excel functions (formulas)
in my worksheet. I can not seem to find the correct way to input formulas
for the probability of the following information:

I need to find the probability of a number greather to or equal to 7
I need to find the probability of numbers less than or equal to 50K
I need to find the probability of numbers between 150K and 250K
I need to find the probability of numbers less than 49K

I have empirical data sets for to use to find all of the above information
but can't seem to find the proper formulas. CAN ANYONE OUT THERE HELP.

--
Derrick L. Maruski
Derrick L. Maruski