I am having problems calculating the population variance. I am okay for the first 4 steps in the procedure to finding the population variance and the population standard deviation. i get getting the incorrect answer when i try to divide by "N" to get the variance. it is not a problem in the textbook but it is problem in ConnectMath.

A consumer advocacy group is doing a large study on car rental practices. Among other things, the consumer group would like to do a statistical test regarding the mean monthly mileage, u, of cars rented in the U.S. this year. The consumer group has reason to believe that the mean monthly mileage of cars rented in the U.S. this year is different from last year's mean, which was 2750 miles. The group plans to do a statistical test regarding the value of u. It chooses a random sample of monthly mileages and computes the mean of the sample to be 2900miles and the standard deviation to be 800 miles. Based on this information, answer the questions below. What are the null hypothesis (H,) and the alternative hypothesis (H,) that should be used for the test? Ho H is? u is ? In the context of this test, what is a Type II error? A Type II error is ? the hypothesis that u is ? when, in fact, u is ? Suppose that the group decides to reject the null hypothesis. What sort of error might it be…

How do I use Excel to calculate the SAMPLE STD DEVIATION of a column?

Pls help ASAP