Excel Assignment Samsung manufactures cellphone with an average standby time of 10 hours between charges. The standby time of the cellphone is normally distributed. During the design stage, the quality engineering staff recorded 18 observations of the standby time of the cellphone. Using the observations below, is there evidence that the average standby time of a Samsung cellphones is not 10 hours? Use a level of significance of .05 Observation Observations 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Time 10.85 11.4 10.81 10.24 10.23 9.49 9.89 10.11 10.57 11.21 10.1 11.22 10.31 11.24 9.51 10.52 9.92 8.33 Answer the following question: 1. What is the null and alternative hypothesis to the case above? 2. Copy the data into excel and do an analysis to test the hypothesis Upload the excel file with the your assignment submission Hint: (watch the module 3 videos) 3. What is the conclusion of your analysis? (try to state it in terms of the original problem or question) As a director of your HR department you want to see if there is a difference in salary based on gender in your industry. You take a sample of the salaries of males and females from 22 different companies in your industry. Using the observations below, is there evidence that the average salary between males and female are different? Use a level of significance of .05 FEMALE Company MALES S 1 34.5 33.9 2 30.5 31.2 3 35.1 35 4 35.7 34.2 5 31.5 32.4 6 34.4 34.1 7 32.1 32.7 8 30.7 29.9 9 33.7 31.2 10 35.3 35.5 11 30.7 30.2 12 34.2 34.8 13 39.6 38.7 14 30.5 30 15 33.8 33.8 16 31.7 32.4 17 32.8 31.7 18 38.5 38.9 19 40.5 41.2 20 25.3 25.5 21 28.6 28 22 35.8 35.1 4. What is the null and alternative hypothesis to the case above? 5. Copy the data into excel and do an analysis to test the hypothesis Upload the excel file with the your assignment submission 6. What is the conclusion of your analysis? (try to state it in terms of the original problem or question) Upload both the excel file and a word file with answers to the above questions to blackboard. Include your name in the file