Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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:

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Healthcare Fraud Auditing And Detection Guide

Authors: Rebecca S. Busch

2nd Edition

978-1118179802

More Books

Students also viewed these Accounting questions