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

Time

1

10.85

2

11.4

3

10.81

4

10.24

5

10.23

6

9.49

7

9.89

8

10.11

9

10.57

10

11.21

11

10.1

12

11.22

13

10.31

14

11.24

15

9.51

16

10.52

17

9.92

18

8.33

Answer the following questions:

What is the null and alternative hypothesis to the case above?
Copy the data into excel and do an analysis to test the hypothesis
What is the conclusion of your analysis?
Develop the 95% confidence interval.