We will test the emprical rule on our dataset by determining the proportion of observations within one, two, and three standard deviations from the mean.\ Determine the lower and upper cutoff for the given data region. Use cell references and a formula in Excel to get exact values\ Count the number of observations between the cutoff values using any method:\ Since the data is sorted, you can look at observations numbers to determine how many are between the cutoff values\ You can select the observations that are between the cutoff values and look for the "COUNT" indicator at the bottom-right corner of Excel\ You can try using the =COUNT() or =COUNTIF() function and create a formula to count the number of observations (try searching on the internet for this!)\ Determine the proportion of observations for the region (leave as a decimal, not as a percentage)\ e) Calculate the proportion of observations that fall with one standard deviation from the mean. According to the empirical rule, this proportion should be close to 0.68.\ Cutoff values Count of observations Proportion of data\ \ x\ \ s\ =\ \ \ \ x\ +\ s\ =\