Instructions:
To complete this lab, you will need to follow along the mission memo, where there are guided video tutorials
You will need the completed data from this workbook to answer question prompts in the mission memo. The answers to those question prompts will be input in your Canvas quiz.
YOU MUST SHOW YOUR WORK TO GET FULL CREDIT
Rounding rule Do not "round" any answers while performing calculations in sheets.
Rounding will occur when you take an output number from your workbook and answer a question in your memo
For example if your workbook has a number in cell E14 that is the output of a calculation. Leave it!
Refer to the cell to use the number in future calculations.
5.37
If you are asked, what is the value of E14 in your memo or quiz, THEN round your number to ONE
decimal place.... the answer is 5.4
How to get help:
1. Discussion board
> review posts before starting work, as your question might have been answered!
> post new questions there - students/TAs/instructors can all help to answer queries
> help answer other questions once you have figured out a strategy!
2. Office hours
> attend a live office hour for one-on-one assistance
> watch the recorded office hours, review the list of topics covered if you get stuck
3. Email your TA
4. If you have technical difficulties while submitting answers from your Mission Memo to the Canvas
Quiz, please use the Submission Comment box to upload a file or add a comment for your TA to
consider >>before<< the 11:59pm AZ deadline
, GOAL: determine if the umbrella tree density is different than historical densities
Plot a Frequency distribution of the historical density of trees
Historical densities of trees
(per km^2) ** suggest using 6-8 equivalently sized bins ***Lab 1 has a tutorial showing how to do this
27948 Histogram bins Frequency Bin labels min 24621
28496 24,000 0 23000-24000 max 28626
24621 25,000 2 24000-250000
26349 26000 2 25000-26000
26987 27000 13 26000-27000
28287 28000 7 28000-29000
27058 29000 7 29000-30000
26814 0
28012
28626
28042
26806
28373
27248
26907 Calculate the mean and standard deviation for the historical densities of trees
25527
27102 mean 26994
26370
26808 standard deviation 1007.940538
28259
26898
26383 probability of observing a historical density that is more extreme than the current density of 27,000 km-2
26342 0.4977655773
24866
25701
27721
26186
27426
26609
26896
27157