Please provide the name of the software that can be used to solve this problem and also the step by step solution.For Example, StatDisk, StatCrunch, Excel, ETC.Thank you! **7.2.13-T**A clinical trial was conducted to test the effectiveness of a drug for treating insomnia in older subjects. Before treatment, 14 subjects had a mean wake time of 100.0 minutes. After treatment, the 14 subjects had a mean wake time of 93.6 minutes with a standard deviation of 23.9 minutes. Assume that the 14 sample values appear to be from a normally distributed population and construct a 95% confidence interval estimate of the mean wake time for a population with drug treatments. What does the result suggest about the mean wake time of 100.0 minutes before the treatment? Does the drug appear to be effective?---**Construct the 95% confidence interval estimate of the mean wake time for a population with the treatment.**\[ 79.8 \text{ min} < \mu < 107.4 \text{ min} \] (Round to one decimal place as needed.)---**What does the result suggest about the mean wake time of 100.0 minutes before the treatment? Does the drug appear to be effective?**- The confidence interval [select option] the mean wake time of 100.0 minutes before the treatment, so the means before and after the treatment [select option]. - This result suggests that the drug treatment [select option] a significant effect.

Since population standard deviation is unknown, Use t-distribution to find t-critical value. Find the t-critical value: Refer t-distribution table and look for t value corresponding to degrees of freedom=10 & confidence level of 95% for the two-tail test. OR Use excel function "=T.INV.2T(0.05,12)" to find the critical value of "t" for the two-tail test. Therefore, the t-critical value:Plug in all the values in the formula, we get Therefore, Does the drug appear to be effective?You can use excel to solve this question. https://drive.google.com/file/d/1Nu4iQm7a40mJ6-m8r8A2-cQgxnzm2Auf/view?usp=sharing