Please refer to the instructions in part 1 and the attached excel template in part 2.

Hi, I need someone to complete this Statistics assignment for me. It is 4 questions which are multipart questions. I need it by Wednesday, May 12th, by 8:00 pm (EST). I am attaching the assignment below. The assignment does require the use of Statkey, a graphing website.

Question 1Fifty chief executive officers of small to medium-sized companies were classified according to their gender and functional background as shown in the table below: Functional Background Male Female Total Marketing 4 10 14 Finance 11 5 16 Operations 17 3 20 Total 32 18 50 If a chief executive is randomly selected from this group what is the probability that the executive is a Male? What is the probability that a randomly selected executive from this group is a male whose functional background is Finance? Assume that an executive is selected and you are told that the executive’s functional background was in operations. What is the probability that his executive is a male? Assume that an executive is selected and you are told that the executive is female. What is the probability the executive’s functional area is marketing? Are gender and functional background independent for this set of executives? Question 2 A manufacturing firm has two suppliers for an electrical component used in its process: one in Mexico and one in China. The supplier in Mexico ships 82% of all the electrical components used by the firm and has a defect rate of 6%. The Chinese supplier ships 18% of the electrical components used by the firm and has a defect rate of 4%. a. Draw a tree diagram for this question. b. Calculate the probability that an electrical component is defective. c. Suppose an electrical component is defective. What is the probability that component was shipped from Mexico? Question 3 Given the following discrete probability distribution. X P(x) 50 0.2 65 0.15 70 0.25 75 0.05 90 ? Calculate the expected value of x. Calculate the variance of x Calculate the standard deviation of x. Question 4 A survey by KRC Research for US News reported that 30% of people plan to spend more on eating out after they retire. If ten people are randomly selected, then determine the Expected number of people who plan to spend more on eating out after they retire. Standard deviation of the individuals who plan to spend more on eating out after they retire. c. Probability that two or fewer in the sample indicate that they actually plan to spend more on eating out after retirement. Question 5 A global financial institution transfers a large data file every evening from offices around the world to its London headquarters. Once the file is received, it must be cleaned and partitioned before being stored in the company’s data warehouse. Each file is the same size and the time required to transfer, clean, and partition a file is normally distributed, with mean of 1.5 hours and a standard deviation of 15 minutes. a. If one file is selected at random, what is the probability that it will take longer than 1 hour and 45 minutes to transfer, clean, and partition the file? b. If a manager must be present until 90% of the files are transferred, cleaned, and partitioned, how long will the manager need to be there? c. What percentage of the data files will take between 70 minutes and 110 minutes to be transferred, cleaned, and partitioned? Question 6 When only the value-added time is considered, the time it takes to build a laser printer is thought to be uniformly distributed between 8 and 15 hours. What are the chances that it will take more than 10 value-added hours to build a printer? How likely is it that a printer will require less than 9 value-added hours? c. Suppose a single customer orders two printers. Determine the probability that the first and second printer each will require less than 9 value-added hours to complete.