Go to cell D$2$ on the Rescue Cats and Dogs worksheet.

Calculate the probability of rescuing any cat or dog being rescued in a week. You will divide the frequency $($cell C$1)$ by the total number of weeks in a year $($cell C$16).$ Make sure that you use an absolute reference for the total number of weeks in the year.

In cell E$2,$ calculate the mean of the number of cats and dogs rescued for the frequency by multiplying the number of cats and dogs rescued $($B$2)$ by the probability $($cell D$2).$

In cell F$2,$ enter the following formula: $=($B$2-$$E$$16)^2.$

In cell G$2,$ enter the following formula: $=$F$2*$D$2.$

Complete the cells in range D$3$:G$12$ by using the drag and drop fill option in Excel.

The mean in cell K$2$ should be $5\mathrm{.}52$ and the variance in cell K$3$ should be $7\mathrm{.}25.$ Please note this is the actual number rounded to two decimal spaces.

Calculate the standard deviation in cell K$4$ by entering the following formula: $=$SQRT$($K$3).$

Save your work so far and move to Step $4.$