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: Calculate the changes in the number of female griffs over time
number of
female griffs
Cadmian year (N)
0 2615 Change in the number of female griffs between year 0 and year 1 RATE of change in the number of female griffs between year 0 and year 1
1 2404 -211 -0.08068833652
2 1496
3 1302
4 617 Change in the number of female griffs between year 1 and year 2 RATE of change in the number of female griffs between year 1 and year 2
-908 -0.377703827
Change in the number of female griffs between year 2 and year 3 RATE of change in the number of female griffs between year 2 and year 3
-194 -0.1296791444
Change in the number of female griffs between year 3 and year 4 RATE of change in the number of female griffs between year 3 and year 4
-685 -0.5261136713
Probability that the population of Griffs will decline
mean rate of change over 5 years -0.2785462448
standard deviation of rate of change 0.2101039601
probability of observing a rate of increase that is less than zero (r<0)
0.9075394653