Answer:
a
The null hypothesis is
![H_o : \mu = 180](https://img.qammunity.org/2021/formulas/mathematics/college/c0otgpkxc5454rju7xrqykxxo25hi9vkn2.png)
The alternative hypothesis is
![H_a : \mu < 180](https://img.qammunity.org/2021/formulas/mathematics/college/ifqmur6msfuxk5jd43yy65zett3j7sgmck.png)
b
The decision rule is fail to reject the null hypothesis
The conclusion
There no sufficient evidence to support the vendor claim that the warehouse management system reduces the average pick, pack, and ship time to below 3 minutes(180 seconds) per order through bin location and routing optimization
Explanation:
From the question we are told that
The population mean is
![\mu = 3 \ minutes = 180 \ seconds](https://img.qammunity.org/2021/formulas/mathematics/college/lgzkf28ipapj6ov0v5s38f409zal4pvmj7.png)
The sample size is n = 25
The excel sheet is show on the first uploaded image
The level of significance is
![\alpha = 0.05](https://img.qammunity.org/2021/formulas/mathematics/college/445n2djo6b5zbv5df68kz5tjhh2puf9bol.png)
The null hypothesis is
![H_o : \mu = 180](https://img.qammunity.org/2021/formulas/mathematics/college/c0otgpkxc5454rju7xrqykxxo25hi9vkn2.png)
The alternative hypothesis is
![H_a : \mu < 180](https://img.qammunity.org/2021/formulas/mathematics/college/ifqmur6msfuxk5jd43yy65zett3j7sgmck.png)
Generally the sample mean is mathematically represented as
![\= x = (156 + 136 + \cdots + 181)/(25)](https://img.qammunity.org/2021/formulas/mathematics/college/1863s37ln83b34d3jq6sp9k7m5erj8cvz2.png)
=>
![\= x = 173.2](https://img.qammunity.org/2021/formulas/mathematics/college/sk7k33vjwh6p7a7shtdsptph6adfmyod8t.png)
Generally the standard deviation is mathematically represented as
![\sigma = \sqrt{(\sum (x_i - \= x )^2 )/(n) }](https://img.qammunity.org/2021/formulas/mathematics/college/x4fq20cmelsp94jhh54hkp3gk7916dfwvd.png)
=>
![\sigma = \sqrt{( (156 - 173.2 )^2 + (136 - 173.2 )^2 + \cdots + (181- 173.2 )^2 )/(25) }](https://img.qammunity.org/2021/formulas/mathematics/college/crdafsryprwt00v0l5cetiut9ydlr9edvg.png)
=>
Generally the test statistics is mathematically represented as
![t = (\= x - \mu )/((\sigma)/(√(n) ) )](https://img.qammunity.org/2021/formulas/mathematics/college/kttmz2n4ts5f5m0qekziw18ccw1971gsk1.png)
=>
![t = (173.2 - 180 )/((24.261)/(√(25) ) )](https://img.qammunity.org/2021/formulas/mathematics/college/yvyxo5s7unwrnfd9yq7u6bio517tfe2x4j.png)
=>
Generally p-value is mathematically represented as
![p-value = P(Z < z)](https://img.qammunity.org/2021/formulas/mathematics/college/1o38jtt7yainyoyaoghrwzi885qpmtcine.png)
=>
![p-value = P(Z < -1.40)](https://img.qammunity.org/2021/formulas/mathematics/college/4g07s9g9e3wr73xsthfa75igzjl1mtlxsh.png)
From the z-table
![P(Z < -1.40) = 0.080757](https://img.qammunity.org/2021/formulas/mathematics/college/3p16x1bfoo9bf6uhckflqvs2otrj923d13.png)
=>
![p-value = 0.080757](https://img.qammunity.org/2021/formulas/mathematics/college/gtuzsuso98q3gfz7qoa5cyq603t0bcznim.png)
From the obtained value we that
The decision rule is fail to reject the null hypothesis
The conclusion
There no sufficient evidence to support the vendor claim that the warehouse management system reduces the average pick, pack, and ship time to below 3 minutes(180 seconds) per order through bin location and routing optimization