= use the information as a guide

= please use this data to answer the questions below.

= The question

Chapter 19 Problem 36 Similar to the previous problem, you must copy/paste to rearrange the data like the following. We are not given any information about the cost of using Firm 1 versus Firm 2, nor the costs of the four types of media. We are using ANOVA to test an initial presumption of sameness in increase in sales in the entire population of such data and not just this small sample. And, if we do not end up rejecting this presumed sameness, then we might choose to select the firm and/or choice of media that is the lowest cost or the most convenient to use. If, however, we end up rejecting the presumed overall sameness of the two firms and/or the four types of media, then you would decide that in fact they are different in their effectiveness and you would decide based on the largest sample mean sales increase, either by firm and/or by media type, regardless of their cost. But you would not want to waste the firm's money if the observed sample differences are just random results from overall populations that are, in fact, the same level of effectiveness! You will select ANOVA two factor with replication from the Data Analysis Toolpak add-in. A replication is simply more than one sample data value with the same two factor levels. In this data, you have 5 replications of observed sample data for each combination of the factor levels (media type and firm). Executive summary - provide a very brief overview of the problem and the findings. The boss might just read this summary, so be sure and include a brief statement of the overall recommendations. Problem description - provide a more detailed description of the problem being addressed Data description - describe the data being used to solve the problem. If the data set is large, include only a small excerpt as needed to describe it. Statistical methodology - describe what statistical methods have been used and why. Results and conclusions - include any charts and tabular results here, and describe the output of any statistical analyses and what the conclusions are. You conclusions should not just say reject or not reject whatever. The boss will get irritated! Tell the boss whether the factors matter or not, and if so, what your specific recommendations are about choice of media or firm to use. Chapter 19 Problem 36 Similar to the previous problem, you must copy/paste to rearrange the data like the following. We are not given any information about the cost of using Firm 1 versus Firm 2, nor the costs of the four types of media. We are using ANOVA to test an initial presumption of sameness in increase in sales in the entire population of such data and not just this small sample. And, if we do not end up rejecting this presumed sameness, then we might choose to select the firm and/or choice of media that is the lowest cost or the most convenient to use. If, however, we end up rejecting the presumed overall sameness of the two firms and/or the four types of media, then you would decide that in fact they are different in their effectiveness and you would decide based on the largest sample mean sales increase, either by firm and/or by media type, regardless of their cost. But you would not want to waste the firm's money if the observed sample differences are just random results from overall populations that are, in fact, the same level of effectiveness! You will select ANOVA two factor with replication from the Data Analysis Toolpak add-in. A replication is simply more than one sample data value with the same two factor levels. In this data, you have 5 replications of observed sample data for each combination of the factor levels (media type and firm). Executive summary - provide a very brief overview of the problem and the findings. The boss might just read this summary, so be sure and include a brief statement of the overall recommendations. Problem description - provide a more detailed description of the problem being addressed Data description - describe the data being used to solve the problem. If the data set is large, include only a small excerpt as needed to describe it. Statistical methodology - describe what statistical methods have been used and why. Results and conclusions - include any charts and tabular results here, and describe the output of any statistical analyses and what the conclusions are. You conclusions should not just say reject or not reject whatever. The boss will get irritated! Tell the boss whether the factors matter or not, and if so, what your specific recommendations are about choice of media or firm to use