The business problem facing a consumer products company is to measures the effectiveness of difference types of advertising media in the promotion of its products. Specifically, the company is interested in the effectiveness of ratio advertising and newspaper advertising (including the cost of discount coupons). During a one-month test period, data were collected from a sample of 22 cities with approximately equal populations. Each city is allocated a specific expenditure level for radio advertising and for newspaper advertising. The sales of the product (in thousands of dollars) and also the levels of media expenditure (in thousands of dollars) during the test month are recorded and stored a Advertise. a. Using all the data as the training sample, develop a regression tree model to predict the sales of the product. b. What conclusions can you reach about the sales of the product?

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 17, Problem 1PS

The business problem facing a consumer products company is to measures the effectiveness of difference types of advertising media in the promotion of its products. Specifically, the company is interested in the effectiveness of ratio advertising and newspaper advertising (including the cost of discount coupons). During a one-month test period, data were collected from a sample of 22 cities with approximately equal populations. Each city is allocated a specific expenditure level for radio advertising and for newspaper advertising. The sales of the product (in thousands of dollars) and also the levels of media expenditure (in thousands of dollars) during the test month are recorded and stored a Advertise.

a. Using all the data as the training sample, develop a regression tree model to predict the sales of the product.

b. What conclusions can you reach about the sales of the product?

a.

Expert Solution

To determine

Develop a regression tree model to predict the sales of product.

Explanation of Solution

Use JMP to develop a regression tree model.

Software procedure:

Step by step by procedure to develop regression tree is given below:

Open Advertise file in JMP.

Select Analyze > Predictive Modelling > Partition.

Drag Sales to the Y, Response box.

Drag Radio to the X, Factor box.

Drag Newspaper to the X, Factor box.

Click Ok.

Click Split. Repeat this step until clicking Split no longer has any effect on the tree diagram.

The JMP result is shown below:

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 1

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 2

b.

Expert Solution

To determine

Write conclusion about the sales of product.

Explanation of Solution

The tree model contains two splits and an AICc value is 293.653.

At the root node, the data has been split based on whether the radio expenditure is less than 45000 dollars or not. The subset less than 45000 dollars has a count of 10 cities with mean sales of 944.5 thousand dollars, which is less than the other subset having a count of 12 cities with mean 1459 thousand dollars.

The subset radio expenditure greater than 45000 dollars has been further split into two based on whether the newspaper expenditure is less than 35000 dollars or not and each further split has a count of 6 cities. The mean sales of newspaper expenditure less than 35000 dollars is less than the newspaper expenditure of 35000 or more.

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

In a classic study, Shrauger (1972) examined the effect of an audience on performance for two groups of participants: high self-esteem and low self-esteem individuals. The participants in the study were given a problem-solving task with half of the individuals in each group working alone and a half working with an audience. Performance on the problem-solving task was measured for each individual. The results showed that the presence of an audience had little effect on high self-esteem participants but significantly lowered the performance for the low self-esteem participants. a. How many factors does this study have? What are they? b. Describe this study using the notation system that indicates factors and numbers of levels of each factor.

The administrator of Hope Hospital has been asked to perform an activity analysis of the emergency room (ER). The ER activities include cost of quality and other patient care activities. The lab tests and transportation are hospital services external to the ER for determining external failure costs. The result of the activity analysis is summarized as follows: Activities Activity Cost Patient registration $6,400 Verifying patient information 9,600 Assignment patients 12,800 Searching/waiting for doctor 8,000 Doctor exam 4,800 Waiting for transport 17,600 Transporting patients 16,000 Verifying lab orders 14,400 Searching for equipment 8,000 Incorrect labs 12,800 Lab tests 17,600 Counting supplies 19,200 Looking for supplies 8,000 Staff training 4,800 Total 160,000 Problem 2 Instructions Prepare a Pareto chart of the ER activities. Classify the activities into…

In the book Business Research Methods (5th ed.), Donald R. Cooper and C. William Emory discuss studying the relationship between on-the-job accidents and smoking. Cooper and Emory describe the study as follows: Suppose a manager implementing a smoke-free workplace policy is interested in whether smoking affects worker accidents. Since the company has complete reports of on-the-job accidents, she draws a sample of names of workers who were involved in accidents during the last year. A similar sample from among workers who had no reported accidents in the last year is drawn. She interviews members of both groups to determine if they are smokers or not. The sample results are given in the following table. On-the-Job Accident Smoker Yes No Row Total Heavy 12 5 17 Moderate 9 10 19 Nonsmoker 13 17 30 Column total 34 32 66 Expected counts are below observed counts Accident No Accident Total Heavy 12 5 17 8.76 8.24…

Answer 2

Textbook Question

Chapter 17, Problem 1PS

The business problem facing a consumer products company is to measures the effectiveness of difference types of advertising media in the promotion of its products. Specifically, the company is interested in the effectiveness of ratio advertising and newspaper advertising (including the cost of discount coupons). During a one-month test period, data were collected from a sample of 22 cities with approximately equal populations. Each city is allocated a specific expenditure level for radio advertising and for newspaper advertising. The sales of the product (in thousands of dollars) and also the levels of media expenditure (in thousands of dollars) during the test month are recorded and stored a Advertise.

a. Using all the data as the training sample, develop a regression tree model to predict the sales of the product.

b. What conclusions can you reach about the sales of the product?

a.

Expert Solution

To determine

Develop a regression tree model to predict the sales of product.

Explanation of Solution

Use JMP to develop a regression tree model.

Software procedure:

Step by step by procedure to develop regression tree is given below:

Open Advertise file in JMP.

Select Analyze > Predictive Modelling > Partition.

Drag Sales to the Y, Response box.

Drag Radio to the X, Factor box.

Drag Newspaper to the X, Factor box.

Click Ok.

Click Split. Repeat this step until clicking Split no longer has any effect on the tree diagram.

The JMP result is shown below:

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 1

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 2

b.

Expert Solution

To determine

Write conclusion about the sales of product.

Explanation of Solution

The tree model contains two splits and an AICc value is 293.653.

At the root node, the data has been split based on whether the radio expenditure is less than 45000 dollars or not. The subset less than 45000 dollars has a count of 10 cities with mean sales of 944.5 thousand dollars, which is less than the other subset having a count of 12 cities with mean 1459 thousand dollars.

The subset radio expenditure greater than 45000 dollars has been further split into two based on whether the newspaper expenditure is less than 35000 dollars or not and each further split has a count of 6 cities. The mean sales of newspaper expenditure less than 35000 dollars is less than the newspaper expenditure of 35000 or more.

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!

Answer 3

Textbook Question

Chapter 17, Problem 1PS

The business problem facing a consumer products company is to measures the effectiveness of difference types of advertising media in the promotion of its products. Specifically, the company is interested in the effectiveness of ratio advertising and newspaper advertising (including the cost of discount coupons). During a one-month test period, data were collected from a sample of 22 cities with approximately equal populations. Each city is allocated a specific expenditure level for radio advertising and for newspaper advertising. The sales of the product (in thousands of dollars) and also the levels of media expenditure (in thousands of dollars) during the test month are recorded and stored a Advertise.

a. Using all the data as the training sample, develop a regression tree model to predict the sales of the product.

b. What conclusions can you reach about the sales of the product?

a.

Expert Solution

To determine

Develop a regression tree model to predict the sales of product.

Explanation of Solution

Use JMP to develop a regression tree model.

Software procedure:

Step by step by procedure to develop regression tree is given below:

Open Advertise file in JMP.

Select Analyze > Predictive Modelling > Partition.

Drag Sales to the Y, Response box.

Drag Radio to the X, Factor box.

Drag Newspaper to the X, Factor box.

Click Ok.

Click Split. Repeat this step until clicking Split no longer has any effect on the tree diagram.

The JMP result is shown below:

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 1

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 2

b.

Expert Solution

To determine

Write conclusion about the sales of product.

Explanation of Solution

The tree model contains two splits and an AICc value is 293.653.

At the root node, the data has been split based on whether the radio expenditure is less than 45000 dollars or not. The subset less than 45000 dollars has a count of 10 cities with mean sales of 944.5 thousand dollars, which is less than the other subset having a count of 12 cities with mean 1459 thousand dollars.

The subset radio expenditure greater than 45000 dollars has been further split into two based on whether the newspaper expenditure is less than 35000 dollars or not and each further split has a count of 6 cities. The mean sales of newspaper expenditure less than 35000 dollars is less than the newspaper expenditure of 35000 or more.

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!

Answer 4

Textbook Question

Chapter 17, Problem 1PS

The business problem facing a consumer products company is to measures the effectiveness of difference types of advertising media in the promotion of its products. Specifically, the company is interested in the effectiveness of ratio advertising and newspaper advertising (including the cost of discount coupons). During a one-month test period, data were collected from a sample of 22 cities with approximately equal populations. Each city is allocated a specific expenditure level for radio advertising and for newspaper advertising. The sales of the product (in thousands of dollars) and also the levels of media expenditure (in thousands of dollars) during the test month are recorded and stored a Advertise.

a. Using all the data as the training sample, develop a regression tree model to predict the sales of the product.

b. What conclusions can you reach about the sales of the product?

a.

Expert Solution

To determine

Develop a regression tree model to predict the sales of product.

Explanation of Solution

Use JMP to develop a regression tree model.

Software procedure:

Step by step by procedure to develop regression tree is given below:

Open Advertise file in JMP.

Select Analyze > Predictive Modelling > Partition.

Drag Sales to the Y, Response box.

Drag Radio to the X, Factor box.

Drag Newspaper to the X, Factor box.

Click Ok.

Click Split. Repeat this step until clicking Split no longer has any effect on the tree diagram.

The JMP result is shown below:

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 1

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 2

b.

Expert Solution

To determine

Write conclusion about the sales of product.

Explanation of Solution

The tree model contains two splits and an AICc value is 293.653.

At the root node, the data has been split based on whether the radio expenditure is less than 45000 dollars or not. The subset less than 45000 dollars has a count of 10 cities with mean sales of 944.5 thousand dollars, which is less than the other subset having a count of 12 cities with mean 1459 thousand dollars.

The subset radio expenditure greater than 45000 dollars has been further split into two based on whether the newspaper expenditure is less than 35000 dollars or not and each further split has a count of 6 cities. The mean sales of newspaper expenditure less than 35000 dollars is less than the newspaper expenditure of 35000 or more.

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!

Answer 5

Textbook Question

Answer 6

Textbook Question

Answer 7

a.

Expert Solution

To determine

Develop a regression tree model to predict the sales of product.

Explanation of Solution

Use JMP to develop a regression tree model.

Software procedure:

Step by step by procedure to develop regression tree is given below:

Open Advertise file in JMP.

Select Analyze > Predictive Modelling > Partition.

Drag Sales to the Y, Response box.

Drag Radio to the X, Factor box.

Drag Newspaper to the X, Factor box.

Click Ok.

Click Split. Repeat this step until clicking Split no longer has any effect on the tree diagram.

The JMP result is shown below:

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 1

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 2

b.

Expert Solution

To determine

Write conclusion about the sales of product.

Explanation of Solution

The tree model contains two splits and an AICc value is 293.653.

At the root node, the data has been split based on whether the radio expenditure is less than 45000 dollars or not. The subset less than 45000 dollars has a count of 10 cities with mean sales of 944.5 thousand dollars, which is less than the other subset having a count of 12 cities with mean 1459 thousand dollars.

The subset radio expenditure greater than 45000 dollars has been further split into two based on whether the newspaper expenditure is less than 35000 dollars or not and each further split has a count of 6 cities. The mean sales of newspaper expenditure less than 35000 dollars is less than the newspaper expenditure of 35000 or more.

Answer 8

a.

Expert Solution

To determine

Develop a regression tree model to predict the sales of product.

Explanation of Solution

Use JMP to develop a regression tree model.

Software procedure:

Step by step by procedure to develop regression tree is given below:

Open Advertise file in JMP.

Select Analyze > Predictive Modelling > Partition.

Drag Sales to the Y, Response box.

Drag Radio to the X, Factor box.

Drag Newspaper to the X, Factor box.

Click Ok.

Click Split. Repeat this step until clicking Split no longer has any effect on the tree diagram.

The JMP result is shown below:

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 1

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 2

Answer 9

a.

Expert Solution

Answer 10

a.

Expert Solution

Answer 11

Expert Solution

Answer 12

To determine

Develop a regression tree model to predict the sales of product.

Answer 13

Explanation of Solution

Use JMP to develop a regression tree model.

Software procedure:

Step by step by procedure to develop regression tree is given below:

Open Advertise file in JMP.

Select Analyze > Predictive Modelling > Partition.

Drag Sales to the Y, Response box.

Drag Radio to the X, Factor box.

Drag Newspaper to the X, Factor box.

Click Ok.

Click Split. Repeat this step until clicking Split no longer has any effect on the tree diagram.

The JMP result is shown below:

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 1

BASIC BUSINESS STATISTICS, Chapter 17, Problem 1PS , additional homework tip 2

Answer 14

b.

Expert Solution

To determine

Write conclusion about the sales of product.

Explanation of Solution

The tree model contains two splits and an AICc value is 293.653.

At the root node, the data has been split based on whether the radio expenditure is less than 45000 dollars or not. The subset less than 45000 dollars has a count of 10 cities with mean sales of 944.5 thousand dollars, which is less than the other subset having a count of 12 cities with mean 1459 thousand dollars.

The subset radio expenditure greater than 45000 dollars has been further split into two based on whether the newspaper expenditure is less than 35000 dollars or not and each further split has a count of 6 cities. The mean sales of newspaper expenditure less than 35000 dollars is less than the newspaper expenditure of 35000 or more.

Answer 15

b.

Expert Solution

Answer 16

b.

Expert Solution

Answer 17

Expert Solution

Answer 18

To determine

Write conclusion about the sales of product.

Answer 19

Explanation of Solution

The tree model contains two splits and an AICc value is 293.653.

At the root node, the data has been split based on whether the radio expenditure is less than 45000 dollars or not. The subset less than 45000 dollars has a count of 10 cities with mean sales of 944.5 thousand dollars, which is less than the other subset having a count of 12 cities with mean 1459 thousand dollars.

The subset radio expenditure greater than 45000 dollars has been further split into two based on whether the newspaper expenditure is less than 35000 dollars or not and each further split has a count of 6 cities. The mean sales of newspaper expenditure less than 35000 dollars is less than the newspaper expenditure of 35000 or more.

Answer 20

Ch. 17 - The business problem facing a consumer products...Ch. 17 - Prob. 2PS Ch. 17 - Prob. 3PS Ch. 17 - The owner of a moving company typically has his...Ch. 17 - A hotel has designed a new system for room service...Ch. 17 - A marketing manager wants to predict customers...Ch. 17 - An automotive insurance company wants to predict...Ch. 17 - Undergraduate students at Miami University in...Ch. 17 - Prob. 9PS Ch. 17 - The file Cereals contains the calories,...

Videos

Explanation of Solution

Explanation of Solution

Want to see more full solutions like this?

Chapter 17 Solutions