Data Analytics Assignment

3/18/2020 Solved: A local beer producer sells two types of beer, a regula… | Chegg.com

https://www.chegg.com/homework-help/business-analytics-5th-edition-chapter-4-problem-8p-solution-9781285965529?trackid=f19d957256bc&stracki… 1/4

home / study / math / statistics and probability / statistics and probability solutions manuals / business analytics / 5th edition / chapter 4 / problem 8p

Business Analytics (5th Edition) See this solution in the app

Problem

A local beer producer sells two types of beer, a regular brand and a light brand with 30% fewer calories. The company’s marketing department wants to verify that its traditional approach of appealing to local whitecollar workers with light beer commercials and appealing to local blue- collar workers with regular beer commercials is indeed a good strategy. A randomly selected group of 400 local workers are questioned about their beer-drinking preferences, and the data in the file P04_08.xlsx are obtained.

a. If a blue-collar worker is chosen at random from this group, what is the probability that he/she prefers light beer (to regular beer or no beer at all)?

b. If a white-collar worker is chosen at random from this group, what is the probability that he/she prefers light beer (to regular beer or no beer at all)?

c. If you restrict your attention to workers who like to drink beer, what is the probability that a randomly selected blue-collar worker prefers to drink light beer?

d. If you restrict your attention to workers who like to drink beer, what is the probability that a randomly selected white-collar worker prefers to drink light beer?

e. Does the company’s marketing strategy appear to be appropriate? Explain why or why not.

Step-by-step solution

The data for survey of local workers with regard to beer-drinking preferences is given below.

Comment

Here ‘W’ denotes white-collar workers and ‘B’ denotes blue-collar worker in ‘Type’ column. In ‘Preference’ column, ‘L’ denotes those workers who prefer to drink light beer, ‘R’ denotes those workers who prefer to drink regular beer and ‘N’ denotes those workers who prefer not to drink beer.

Comment

Step 1 of 8

Step 2 of 8

My Textbook Solutions

Business Analytics 5th Edition

Business Analytics 5th Edition

Business Analytics:… 5th Edition

View all solutions

Post a question Answers from our experts for your tough homework questions

Enter question

Continue to post 20 questions remaining

Statistics Chegg tutors who can help right now

Ashish Indian Institute of F… 185

Varun Université de Genève 59

Fabio Scuola Normale Su… 38

Find me a tutor

1 Bookmark Show all steps:Chapter 4, Problem 8P ON

  Textbook Solutions Expert Q&A Study Pack Practice NEW!

Search 

 

 

3/18/2020 Solved: A local beer producer sells two types of beer, a regula… | Chegg.com

https://www.chegg.com/homework-help/business-analytics-5th-edition-chapter-4-problem-8p-solution-9781285965529?trackid=f19d957256bc&stracki… 2/4

A pivot table has been created to show the counts of worker type for different drinking preferences of workers where the total number of workers surveyed is 400. The screenshot of the pivot table is given below.

Comment

a. From the pivot table given above the number of blue collar workers that prefer light beer is 111 and the total number of blue collar workers is 250. So the probability E of a randomly chosen blue collar worker that prefers light beer is given by,

Comment

b. From the pivot table given above the number of white collar workers that prefer light beer is 79 and the total number of white collar workers is 150. So the probability F of a randomly chosen white collar worker that prefers light beer is given by,

Comment

c. From the pivot table given above the number of blue collar workers that prefer light beer is 111 and the number of worker that drink beer is 371. So the probability G of a randomly chosen beer drinking worker being a blue collar worker that prefers light beer is given by,

Step 3 of 8

Step 4 of 8

Step 5 of 8

Step 6 of 8

1 Bookmark Show all steps:Chapter 4, Problem 8P ON

  Textbook Solutions Expert Q&A Study Pack Practice NEW!

Search 

 

 

3/18/2020 Solved: A local beer producer sells two types of beer, a regula… | Chegg.com

https://www.chegg.com/homework-help/business-analytics-5th-edition-chapter-4-problem-8p-solution-9781285965529?trackid=f19d957256bc&stracki… 3/4

Recommended solutions for you in Chapter 4

Was this solution helpful?

Comments (3)

d. From the pivot table given above the number of white collar workers that prefer light beer is 79 and the number of worker that drink beer is 371. So the probability H of a randomly chosen beer drinking worker being a white collar worker that prefers light beer is given by,

Comments (2)

e. The company’s marketing strategy to target blue collar workers who drink regular beer and white collar worker who drink light beer is most appropriate, since these two type of workers comprise the largest segment in their two respective subgroups.

Comment

Step 7 of 8

Step 8 of 8

10 0

Chapter 4, Problem 28P

Consider the probability distribution of the weekly demand for copier paper (in hundreds of reams) used in a corporation’s duplicating center, as shown in the file P04_27.xlsx. a. Use simulation to generate 500 values of this random…

See solution

Chapter 4, Problem 3P

The publisher of a popular financial periodical has decided to undertake a campaign in an effort to attract new subscribers. Market research analysts in this company believe that there is a 1 in 4 chance that the increase in the number of new…

See solution

ABOUT CHEGG

LEGAL & POLICIES

CHEGG PRODUCTS AND SERVICES

CHEGG NETWORK

CUSTOMER SERVICE

1 Bookmark Show all steps:Chapter 4, Problem 8P ON

  Textbook Solutions Expert Q&A Study Pack Practice NEW!

Search 

 

 

3/18/2020 Solved: A local beer producer sells two types of beer, a regula… | Chegg.com

https://www.chegg.com/homework-help/business-analytics-5th-edition-chapter-4-problem-8p-solution-9781285965529?trackid=f19d957256bc&stracki… 4/4

 

© 2003-2020 Chegg Inc. All rights reserved. 1 Bookmark Show all steps:Chapter 4, Problem 8P ON

  Textbook Solutions Expert Q&A Study Pack Practice NEW!

Search 