Submit one excel file. Put each problem result on a separate sheet in your file.

Submit one excel file. Put each problem result on a separate sheet in your file. Please show all work/formulas. 
10.11 An important feature of tablets is battery life, the number of hours before the battery needs to be recharged. The file Tablets(attached)  battery life of 12 WiFi-only and 7 3G/4G/WiFi 9- through 12-inch tablets. (Data extracted from “Ratings and recommendations: Tablets,” Consumer Reports, August 2013, p. 24.)
a. Assuming that the population variances from both types of tablets are equal, is there evidence of a difference in the mean battery life between the two types of tablets? 1Use a=0.05.2
b. Determine the p-value in (a) and interpret its meaning.
c. Assuming that the population variances from both types of tablets are equal, construct and interpret a 95% confidence interval estimate of the difference between the population mean battery life of the two types of tablets.
10.23 What motivates employees? The Great Place to Work Institute evaluated nonfinancial factors both globally and in the United States. (Data extracted from L. Petrecca, “Tech Companies Top List of Great Workplaces, USA Today October 31, 2011, p7B.) The results, which indicate the importance rating of each factor, are stored in Motivation (attached). 
a. At the 0.05 level of significance, is there evidence of a difference in the mean rating between global and U.S. employees?
b. What assumption is necessary about the population distribution in order to perform this test?
c. Use a graphical method to evaluate the validity of the assumption in (b).
Attachment 1
Attachment 2
WiFi Only 3G/4G+WiFi12.411.710.611.411.510.712.611.5811.310.911.611.68.91010.98.99.510.5 10.11 An important feature of tablets is battery liTablets(attached) battery life of 12…

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now