Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In cell L2 type =if(the cell location of the first value in the list you are interested in. Then type < or > and the
- In cell L2 type =if(the cell location of the first value in the list you are interested in.
- Then type < or > and the value of interest for your empirical probability.
- After the value type ,1,0). [Note: 1=success, 0=failure.]
- Auto fill down until column L is as long as the column containing the variable in question.
- In the G16 type =COUNTIF(L:L,1). [Note: this will count the number of successes.]
- Determine the empirical probability:
- In H16 type =(G16/F16).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started