Two computer users were discussing tablet computers. A higher proportion of people ages 16 to 29 use tablets than the proportion of people age 30 and older. The table below details the number of tablet owners for each age group. Test at the 1% level of significance IN EXCEL SHOW WORK.
16–29 year olds | 30 years old and older | |
Own a Tablet | 69 | 231 |
Sample Size | 628 | 2,309 |
========================================
p1 = Popoulation proportion of age group 16 -29 (Using tablets)
p2 = Popoulation proportion of age group >=30 (Using tablets)
For p-value the function is used is =1-NORMSDIST(z)
Conclusion = P-value is greater than 0.01 so, fail to reject the null hypothesis, We have enough evidence to conclude that the proportion are equal
Get Answers For Free
Most questions answered within 1 hours.