Geography 360

Problem Set Four: Working with Probability Distributions

 

 

1)     The Wisconsin Department of Natural Resources collects data on the sightings of rare animals in the state.  Follow the link to reported Pine Martin sightings.  On pages 132 and 133 you will find a table listing sightings by county for a number of mammals.  If we assume that reported sightings were a good estimate of Pine Martin populations in each county [Why might this be a shaky assumption?], how might we determine if there is a random distribution of Pine Martin in the counties listed.  That is, which probability distribution would best simulate the expected number of sightings in each county?  How does the reported data compare to the expected data?  Can you provide justification for your results?

 

 

2)     State Street is home to numerous restaurants.  Would you expect these restaurants to be randomly distributed along the street?  A map of the Madison Central Business District (including State Street) is available at the campus information center and at several merchants along State Street.  Taking a copy of this map, divide State Street into twelve zones, either north or south of State Street and east or west of the Lake, Frances, Gilman, Gorham, Johnson, Dayton, and Mifflin Street intersections.  Hold would you provide statistical evidence of the relative randomness of restaurant locations on State Street.  Do you find the results surprising?  Why or why not?

 

 

3)     A) Geographers have been very active in the analysis of the diffusion of innovations across space.  In the most basic form, analyses suggest that each person that is introduced to an innovation (for example each farmer introduced to new cultivation methods) has a given probability of adopting.  This probability is usually taken from early introductions of the innovation in small areas.  If we found that 1 out of 3 farmers adopted a new cultivation technique upon being introduced to it, how might we calculate the expected number of adopters for an extension agent during one month (four weeks) if he meets with an average of 10 farmers per week.  Draw a distribution histogram for the probability of getting 0, 1, 2, …. 40 adopters during the month.

 

 

B) Using a die (to provide a probability of 1/3), design a method of modeling the response of 40 farmers.  How does your modeled result compare to the expected random result calculated above?

 

 

4)     A) While social characteristics of human populations are usually not randomly distributed, physical characteristics are often considered to be so.  If we take the following numbers are a random sample of heights (in cm) for five year old boys (attention: height would be a continuous variable, right?), how could we calculate the probability of a particular boy being at, above, or below a certain height?  (Hint:  Your first step would be to assume that heights are normally distributed – although there are some very small boys and some very tall boys, most are near the same height.  Second step: calculate the mean and standard deviation for the sample and standardize the respective deviations to allow comparison with the Normal Table in your text.)

 

105.9   110.0   106.7   108.5   107.7   114.3   108.6   104.6   113.7

116.7   103.5     96.1   110.8     97.2   109.6   110.5   105.9   106.2

 

 

B)  What is the probability of a five-year-old boy being taller than 108 cm?

 

 

           

C)     What is the probability of being smaller than 100 cm?

 

 

 

D)     What is the probability of being between 98 and 103 cm? 

 

 

 

E)  If another sample of 30 boys were taken, what height would you expect 28 of the boys to be smaller than?

 

 

 

F)        What would be the smallest expected height from a sample of 100 five-year-old boys?

 

 

 

 

Below, I have provided examples of Excel entries to help with calculations.  In order to use the examples, type the characters as entries in the respective cells of an Excel spreadsheet.  (The A, B, C and left column of numbers refer to the column and row designations in the spreadsheet.)  Words will appear as written.  Formulas will leave blank cells or error messages until you provide the necessary values for events and outcomes in the second row of each example.  Where I have typed etc., you should follow the pattern in the column the necessary number of times.  You can also copy (control C) a formula once entered and paste it into the necessary number of rows.

 

 

Binomial Distribution

 

            A                                  B                                                                                  C

1

Number of Events

Probability of desired outcome

Probability of all other outcomes

2

 

 

=1-B2

3

Frequency

probability of frequency

expected events of given frequency

4

0

=((FACT(A$2))*(B$2^A4)*(C$2^(A$2-A4)))/((FACT(A4)*(FACT(A$2-A4))

=A$2*B4

5

1

=((FACT(A$2))*(B$2^A5)*(C$2^(A$2-A5)))/((FACT(A5)*(FACT(A$2-A5))

=A$2*B5

6

2

etc.

etc.

7

3

 

 

8

4

 

 

 

etc.

 

 

 

 

 

 

 

Poisson Distribution

 

            A                                  B                                                          C        

1

number of events

frequency of outcomes

average frequency

2

 

 

=B2/A2

3

Frequency

probability of frequency

expected events of given frequency

4

0

=(C$2^A4)/((EXP(C$2))*(FACT(A4)))

=A$2*B4

5

1

=(C$2^A5)/((EXP(C$2))*(FACT(A5)))

=A$2*B5

6

2

etc.

etc.

7

3

 

 

8

4

 

 

 

etc.