Which of the following statements defines an unbiased statistic? ...

[Jipu 123]

Which of the following statements defines an unbiased statistic?
 a. An unbiased statistic is a sample statistic whose sampling distribution has a mean value equal to the value of the population parameter being estimated.
 
  b. An unbiased statistic is a sample mean that equals the value of the population parameter being estimated.
 
  c. An unbiased statistic always equals the population parameter being estimated.
 
  d. An unbiased statistic is a sample statistic whose standard error is maximized.

Question 2

ABC Manufacturing has 1630 employees. Each employee should have a distinct employee identification number. How would you suggest verifying this if all employee information, including identification number, are currently stored in a single spreadsheet?

[aadams68]

Answer to Question 1

a

Answer to Question 2

Sort on the worker identification column. Once they are sorted, use IF, THEN statement to determine if any adjacent cells are the same. For example, =IF(B3=B2,1,0). Next, sum the column to find if and how many duplicates exist. Search in that sum column by using the Find' command to identify those with duplicate i.d. numbers.

[Jipu 123]

Gracias!

[ryansturges]

Thanks for the timely response, appreciate it