DIRECTIONS: Round all answers to the nearest thousandth. Two new drugs are being compared for effectiveness in lowering total cholesterol levels. On the sample of 15 subjects, drug A is found to lower total cholesterol by an average of 75 mg/dl with SS = 2025. On the sample of 10 subjects, drug B lowered the mean cholesterol level by 78 mg/dl with SS = 2005. Use a 0.01 level of significance to test the claim that the two drugs are equally effective assuming populations are normally distributed. ( Use equal variance t procedure called pooled variance t procedure)

Two of the hottest smartphones on the market are the newly released iPhone6 and the Samsung Galaxy S6. CNet.com offers online reviews of all major cell phones, including battery life tests. In a review of the iPhone6, the talk-time battery life of 35 iPhones was measured. Similarly, the talk-time battery life of 30 Galaxy S6s was measured. Two outputs are given below. Which is appropriate for analyzing the data collected? Output 1 lhi Mean of iPhone6 Hz : Mean of Galaxy S6 Sam ple Diff. Output 2 HR = mean of the paired difference between iPhone6 and Galaxy S6 Difference Std. Err. Difference Sam ple Diff. Std. Err. H1 - Hz -0.71759861 0.189403 iPhone6 - Galaxy S6 -0.754246 0.192151 Possible p-values: 0.0001, 0.0002, 0.9999 Possible p-values: 0.0002, 0.0004, 0.9998 OOutput 1 Output 2 Using the StatCrunch output chosen above, determine if there is a difference in the mean battery life for the two phones. Use a significance level of 0.01 when conducting the test. • Select the appropriate…

Please answer question 6 and show me how to do it in excel.

Please help asap