Please show steps or formulas in excel

Question 1: Consider a sample with a mean of 500 and a standard deviation of 100.

a.What are the z-scores for the following data values: 650, 450, and 180.

b.Comment on whether any values should be considered an outlier.

Question 2: Suppose the data have a bell-shaped distribution with a mean of 30 and a standard deviation of 5.Using the Empirical Rule, determine the percentage of data within each of the following ranges:

a.20 to 40

b.15 to 45

c.25 to 45

Question 3: The following table identifies a group of citizens by one of four hair colours, and by type of hair. Hair Type Brown Blond Black Red Totals Wavy 20 15 3 43 Straight 80 15 12 Totals 20 215 a. Complete the table. b. What is the probability that a randomly selected citizen will have wavy hair ? c. What is the probability that a randomly selected citizen will have either brown or blond hair? d. What is the probability that a randomly selected citizen will have wavy brown hair? e. Suppose A is the event of a citizen having brown hair. What is the probability of the complement of A? The End ENG W P O 9 o