Probability on Excel

[swazination]

[TABLE="width: 729"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD="colspan: 7"]1.1 The average number of deer seen per hour 3.6. [/TD]
[/TR]
[TR]
[TD="colspan: 5"]Calculate the probability of observing 0, 1, 2, …. 10+ below[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Number of Deer Seen

1
2
3
4
5
6
7
8
9
10+

How would i solve this on excel?[/TD]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[shg]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

mean​

[/td][td]

3.6​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td="bgcolor:#F3F3F3"]

Seen​

[/td][td="bgcolor:#F3F3F3"]

Prob​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]

0​

[/td][td="bgcolor:#CCFFCC"]

2.73%​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

1​

[/td][td="bgcolor:#CCFFCC"]

9.84%​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]

2​

[/td][td="bgcolor:#CCFFCC"]

17.71%​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]

3​

[/td][td="bgcolor:#CCFFCC"]

21.25%​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]

4​

[/td][td="bgcolor:#CCFFCC"]

19.12%​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td]

5​

[/td][td="bgcolor:#CCFFCC"]

13.77%​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

9​

[/td][td]

6​

[/td][td="bgcolor:#CCFFCC"]

8.26%​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

10​

[/td][td]

7​

[/td][td="bgcolor:#CCFFCC"]

4.25%​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

11​

[/td][td]

8​

[/td][td="bgcolor:#CCFFCC"]

1.91%​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

12​

[/td][td]

9​

[/td][td="bgcolor:#CCFFCC"]

0.76%​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

13​

[/td][td]

10+​

[/td][td="bgcolor:#CCFFFF"]

0.40%​

[/td][/tr]
[/table]

 

[Joe4]

Take a look at the Poisson probability.

That makes some assumptions which I am not sure would be appropriate here, such as:

• The occurrence of one event does not affect the probability that a second event will occur. That is, events occur independently.
• The rate at which events occur is constant. The rate cannot be higher in some intervals and lower in other intervals.

(from: https://en.wikipedia.org/wiki/Poisson_distribution)

As an outdoor enthusiast, I know for a fact that:
- deer seldom travel alone
- deer are much more active at night (especially dusk and dawn) than during the day

So I would argue that this may not be the best fit for a Poisson distribution, but perhaps your teacher doesn't know that much about deer!

Without some assumptions (or the standard deviation), it is tough to say exactly what method they expect you to use. What kind of stuff have they been teaching lately? It probably falls into one of those categories. If they have been teaching Poisson distribution, I would probably go with that (even though it is not really a good fit).

 

[shg]

Reckon it depends on whether this is a class for math or wildlife management.

 

[Joe4]

Reckon it depends on whether this is a class for math or wildlife management.

Kind of reminds of a funny saying I came across years ago.
You might be an engineer if you ever have assumed that a horse is a sphere to make the math easier!