Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started