Question
NOTE: I AM SEEKING HELP WITH MICROSOFT EXCEL 2016. For the textbook: Business Analytics: Data Analysis & Decision Making (6th Edition) by Albright and Winston
NOTE: I AM SEEKING HELP WITH MICROSOFT EXCEL 2016.
For the textbook: Business Analytics: Data Analysis & Decision Making (6th Edition) by Albright and Winston - Question: chapter 8, problem 29 - I am trying to follow the instructions, however I believe the instructions provided are for an older version of Excel. I have Excel 2016 - can you please provide updated instructions for Excel 2016? I am able to follow through the pivot table but after that the Stattools instructions don't translate. I do not have a preference to use Stattools if there is another way to solve this problem. Please include any values that I can use along the way to check my work.
The question is as follows:
TABLE CREATED THROUGH PIVOT TABLE FUNCTION FROM THE DATA SET:
Count of Gender | Column Labels | ||
Row Labels | F | M | Grand Total |
Competing brand | 90 | 26 | 116 |
Our brand | 94 | 40 | 134 |
Grand Total | 184 | 66 | 250 |
NOTE: THE ANSWER THAT CHEGG PROVIDES IS AS FOLLOWS: Lower Limit: -0.233, Upper Limit 0.043 . when I attempted to solve this problem the answers I produced are: Lower Limit: -0.043, Upper Limit 0.233 . In addition, I previously posted this problem and someone did the math with a paper and pen and got the same answer as me.... I wonder if it's possible that the answer posted on the Textbook's Chegg page is incorrect?
29. A market research consultant hired by a leading soft-drink company is interested in estimating the difference between the proportions of female and male consumers who favor the company's low-calorie brand over the leading competitor's low-calorie brand in a particular geographical region. A random sample of 250 consumers from the market under investigation is provided in the file P08_18.xlsx. After separat- ing the 250 randomly selected consumers by gender, calculate a 95% confidence interval for the difference between these two proportions. Of what value might this interval estimate be to marketing managers at the companyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started