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, Student Value Edition, Chapter 17, Problem 1PS , additional homework tip 1

Basic Business Statistics, Student Value Edition, 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

K The mean height of women in a country (ages 20-29) is 63.7 inches. A random sample of 65 women in this age group is selected. What is the probability that the mean height for the sample is greater than 64 inches? Assume σ = 2.68. The probability that the mean height for the sample is greater than 64 inches is (Round to four decimal places as needed.)

In a survey of a group of men, the heights in the 20-29 age group were normally distributed, with a mean of 69.6 inches and a standard deviation of 4.0 inches. A study participant is randomly selected. Complete parts (a) through (d) below. (a) Find the probability that a study participant has a height that is less than 68 inches. The probability that the study participant selected at random is less than 68 inches tall is 0.4. (Round to four decimal places as needed.) 20 2

PEER REPLY 1: Choose a classmate's Main Post and review their decision making process. 1. Choose a risk level for each of the states of nature (assign a probability value to each). 2. Explain why each risk level is chosen. 3. Which alternative do you believe would be the best based on the maximum EMV? 4. Do you feel determining the expected value with perfect information (EVWPI) is worthwhile in this situation? Why or why not?

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, Student Value Edition, Chapter 17, Problem 1PS , additional homework tip 1

Basic Business Statistics, Student Value Edition, 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, Student Value Edition, Chapter 17, Problem 1PS , additional homework tip 1

Basic Business Statistics, Student Value Edition, 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, Student Value Edition, Chapter 17, Problem 1PS , additional homework tip 1

Basic Business Statistics, Student Value Edition, 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, Student Value Edition, Chapter 17, Problem 1PS , additional homework tip 1

Basic Business Statistics, Student Value Edition, 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, Student Value Edition, Chapter 17, Problem 1PS , additional homework tip 1

Basic Business Statistics, Student Value Edition, 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, Student Value Edition, Chapter 17, Problem 1PS , additional homework tip 1

Basic Business Statistics, Student Value Edition, 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