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:

NOTE: I AM SEEKING HELP WITH MICROSOFT EXCEL 2016. For the textbook:

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 company

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!