Essentials of Business Analytics (MindTap Course List)
Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 6, Problem 1C

1.

To determine

Obtain the descriptive statistics for the given data.

1.

Expert Solution
Check Mark

Answer to Problem 1C

Descriptive statistics for the data is as follows:

Essentials of Business Analytics (MindTap Course List), Chapter 6, Problem 1C , additional homework tip  1

Explanation of Solution

Calculation:

The given information is about a young professional magazine. The magazine was successful in two years of publication. The magazine wants to expand the advertising base. The potential advertiser continually asks about the demographics and the interests of the subscribers to young professionals. The magazine conducts a survey to develop subscribers.

Software Procedure:

Step by step procedure to obtain the descriptive statistics using the Excel software:

  • Enter the data in Excel spread sheet.
  • Choose Data > Data Analysis > Descriptive Statistics.
  • In Input range, select the columns of Age, Investment, Transactions, and Household income.
  • Select Labels in first row check box and then select the output range.
  • Select Summary statistics check box and confidence interval for Mean check box.
  • Click OK.

Output using the Excel software is given below:

Essentials of Business Analytics (MindTap Course List), Chapter 6, Problem 1C , additional homework tip  2

2.

To determine

Find the 95% confidence interval for the mean age and household income of subscribers.

2.

Expert Solution
Check Mark

Answer to Problem 1C

There is 95% confidence that the mean of the young professional subscribers of the age between 29.722 and 30.503 and there is 95% confidence that the mean of the young professional subscribers of the household income between $71,079 and $77,840.

Explanation of Solution

From the part (a) output, Mean and Margin of error for Age is 30.1122 and 0.3907. The mean and margin error for Household is 74459.51 and 3380.257.

The 95% confidence interval for the mean age is calculated as follows:

95% CI= x¯±Margin of error=30.1122±0.3907=(30.11220.3907,30.1122+0.3907)=(29.722,30.503).

The 95% confidence interval for the mean household is calculated as follows:

95% CI= x¯±Margin of error=74459.51±3380.257=(74459.513380.257,74459.51+3380.257)=(71079,77840).

Thus, there is 95% confidence that the mean of the young professional subscribers of the age between 29.722 and 30.503. There is 95% confidence that the mean of the young professional subscribers of the household income between $71,079 and $77,840.

3.

To determine

Find the 95% confidence interval for the proportion of the subscribers who have the broadband access at home and the proportion of the subscribers who have children.

3.

Expert Solution
Check Mark

Answer to Problem 1C

There is 95% confidence that the proportion of the young professional subscribers who have the broadband access between 57.75% and 67.14%.

There is 95% confidence that the proportion of the young professional subscribers who have children between 48.45% and 58.33%.

Explanation of Solution

The proportion of the young professional subscribers who have the broadband access:

Here 256 have access out of 410 subscribers.

p¯=xn=256410=0.6244

Thus, the point estimate p¯ is 0.6244

The proportion of the young professional subscribers who have children

Here 219 have children out of 410 subscribers.

p¯=xn=219410=0.5341

Thus, the point estimate p¯ is 0.5341

Here, the level of significance is 0.05.

The level of significance or probability for two-tailed is given as α2=0.052=0.025.

The critical value is calculated by using the excel formula “=NORM.S.INV (probability)”.

Substitute the values in the excel formula: “=NORM.S.INV (0.025)”.

Thus the critical value is obtained as 1.96.

The 95% confidence that the proportion of the young professional subscribers who have the broadband access is given as:

 p¯±zα/2p¯×(1p¯)n

0.6234±1.960.6234×(10.6234)4100.6234±0.046

0.62340.046<p<0.6234+0.046           0.5774<p<0.6694

There is 95% confidence that the proportion of the young professional subscribers who have the broadband access between 57.75% and 67.14%.

The 95% confidence 95% confidence that the proportion of the young professional subscribers who have children is given as:

 p¯±zα/2p¯×(1p¯)n

0.5341±1.960.5341×(10.5341)4100.5341±0.046

0.53410.048<p<0.5341+0.048           0.4845<p<0.5833

There is 95% confidence that the proportion of the young professional subscribers who have children between 48.45% and 58.33%.

4.

To determine

Illustrate whether the young professionals are a good advertising outlet for online brokers or not. Justify with the statistical conclusion.

4.

Expert Solution
Check Mark

Answer to Problem 1C

The young professionals are the good advertising outlet for online brokers.

Explanation of Solution

From the results of Part 1, Most of the young professional subscribers have the financial investment for their home as $28,538. Some of them have the amount of investment like more than $100,000. So the mean number of transactions per year is nearly 6 per subscriber and some of the subscribers have mean number of transactions more than 6.

Since the large proportion has the broadband access that is 62.43%. It indicates that most of their subscribers likely to do business.

Thus, young professionals are the good advertising outlet for online brokers.

5.

To determine

Illustrate whether the magazine is good place for advertising companies, selling educational software, and computer games for young children.

5.

Expert Solution
Check Mark

Explanation of Solution

From the results of Part 1,

The mean age of subscribers is 30.112 years and 53.41% of the subscribers have children. The age of subscribers is reasonable to assume that their children are young age and then they can think that the young age children like about the educational software and the computer games.

Thus, it represents that the subscribers to young professional would be a good target for companies selling educational software and computer games for young children.

6.

To determine

Illustrate the types of articles that would be interested to readers of young professionals.

6.

Expert Solution
Check Mark

Explanation of Solution

By observing the results in Part 1, most of the young professionals are interested on the investment and for that the investment type of articles may be interested to the professionals. Also, the subscribers who have young children will be interested to read the parenting and child care types of articles.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
what are the three categories of business analytics
Suppose you wanted to create an index for rating the quality of colleges and universities. What are three data items that might be included in such an index?
What is ranked data?

Chapter 6 Solutions

Essentials of Business Analytics (MindTap Course List)

Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Text book image
PREALGEBRA
Algebra
ISBN:9781938168994
Author:OpenStax
Publisher:OpenStax
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Which is the best chart: Selecting among 14 types of charts Part II; Author: 365 Data Science;https://www.youtube.com/watch?v=qGaIB-bRn-A;License: Standard YouTube License, CC-BY