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:

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

EBK 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

An Arts group holds a raffle. Each raffle ticket costs $2 and the raffle consists of 2500 tickets. The prize is a vacation worth $3,000. a. Determine your expected value if you buy one ticket. b. Determine your expected value if you buy five tickets. How much will the Arts group gain or lose if they sell all the tickets?

Please show as much work as possible to clearly show the steps you used to find each solution. If you plan to use a calculator, please be sure to clearly indicate your strategy. Consider the following game. It costs $3 each time you roll a six-sided number cube. If you roll a 6 you win $15. If you roll any other number, you receive nothing. a) Find the expected value of the game. b) If you play this game many times, will you expect to gain or lose money?

= 12:02 WeBWorK / 2024 Fall Rafeek MTH23 D02 / 9.2 Testing the Mean mu / 3 38 WEBWORK Previous Problem Problem List Next Problem 9.2 Testing the Mean mu: Problem 3 (1 point) Test the claim that the population of sophomore college students has a mean grade point average greater than 2.2. Sample statistics include n = 71, x = 2.44, and s = 0.9. Use a significance level of a = 0.01. The test statistic is The P-Value is between : The final conclusion is < P-value < A. There is sufficient evidence to support the claim that the mean grade point average is greater than 2.2. ○ B. There is not sufficient evidence to support the claim that the mean grade point average is greater than 2.2. Note: You can earn partial credit on this problem. Note: You are in the Reduced Scoring Period. All work counts for 50% of the original. Preview My Answers Submit Answers You have attempted this problem 0 times. You have unlimited attempts remaining. . Oli wwm01.bcc.cuny.edu

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:

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

EBK 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:

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

EBK 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:

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

EBK 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:

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

EBK 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:

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

EBK 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:

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

EBK 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