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]

 

[West Man]

Without the standard deviation I don't believe it can be done.

 

[swazination]

This is what was provided, so what should i do?

 

[Fluff]

Homework?

 

[swazination]

Correct, is this not allowed to be posted? If so, you can take it down. I was just confused with the question and how to do it on excel.

 

[Fluff]

We don't prevent people from asking for help with homework, but don't expect anyone to give you the outright answer (you would only be cheating yourself).
However members may be willing to give you a nudge in the right direction.
Personally I don't think that there is sufficient information. For instance the probability of seeing a deer will depend of how long you are watching for.

 

[swazination]

I thought there was not much information as well. It says the watch time is an hour.

 

[Joe4]

I agree with West Man. I think you need to know the Standard Deviation in order to calculate the probability.

For example, let's say that the average was 5. All of the following data sets would give you an average of 5:
Data Set 1: 5, 5, 5
Data Set 2: 0, 5, 10
Date Set 3: 0, 0, 0, 0, 0, 0, 0, 0, 0, 50

Just by looking at those three data sets, do you think the odds of seeing 5 (or any number of) deer is the same for all three?
I believe the standard deviation plays a large role here.

 

[AhoyNC]

Take a look at the Poisson probability.

 

[shg]

Ahoy is spot on.