Purchase Solution

Measuring the Media using Statistics

Not what you're looking for?

Ask Custom Question

Table:
Sales RadioTV Newspaper
973 0 40
1119 0 40
875 25 25
625 25 25
910 30 30
971 30 30
931 35 35
1177 35 35
882 40 25
982 40 25
1628 45 45
1577 45 45
1044 50 0
914 50 0
1329 55 25
1330 55 25
1405 60 30
1436 60 30
1521 65 35
1741 65 35
1866 70 40
1717 70 40

A large consumer product company wants to measure the effectiveness of different types of advertising media in the promotion of its products. Specifically, two types of advertising media are to be considered: radio/TV advertising and newspaper advertising (including the cost of discount coupons). The sales of product (in thousands of dollars) and also the levels of media expenditure (in thousands of dollars) during the test month are recorded in ADRADTV.XLS (from the CD). Let X1 and X2 be the dollar amount of radio/TV ads and newspaper ads, respectively. Using EXCEL or PHStat2, answer the following:

What is SSR(X1 and X2)?
a) 2028032.69
b) 632259.45
c) 1395773.24

What is the F-value for X1 when used the partial F test criterion for determining the contribution of X1?
a) 55.28
b) 32.12
c) 43.81

What is the F-value for X2 when used the partial F test criterion for determining the contribution of X2?
a) 55.28
b) 32.12
c) 43.81

Determine which explanatory variable has a significant relationship with sales (Y) using the 5% significance level.
a) Radio/TV only
b) Newspaper only
c) Both Radio/TV and Newspaper.

Purchase this Solution
Solution Summary

The solution assists with measuring the media using statistics.

Solution Preview

See the attachment.

I've included my ANOVA output in Excel (view attachment). Based on this output,

For question ...

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Earned or paid media within an organization

    Measuring using the media impact model allows the organization to track coverage against sales over time in different markets.

  • Using Chi--Square Statistics

    263262 Using Chi--Square Statistics Why do you use the chi-square statistic? What are the major considerations? Chi-Square Statistics The Chi-square statistic can be used in several ways.

  • Mobile Marketing: Burberry

    The media is incompatible with the image of Burberry. Step 3 With increasing popularity of mobile media and social media, I would recommend Burberry to use mobile media and social media for advertising.

  • Social Media Analysis

    322130 I found a few statistics that were surprising in this social media revolution. The first one was in reference to the Wikipedia statistics that stated that the information found on that site is more accurate than Encyclopedia Britannica.

  • Analysis of a Bogus Statement Pertaining to Measurement

    439539 Statistics Measurement Error And Data Representation 1.

  • Measuring Public Relations

    Among them are using sales models to evaluate the success of media relations campaigns.

  • Measuring the Dosage of Amoxicillin

    is divided into 12-hour period, the single dosage should be equal to: The expert examines measuring the dosage of amoxicillin.

  • Reading Crime Statistics

    The use of the words, "according to statistics" is one way experts and media use to focus attention on troubling news. It is a Pavlov's dog type of reaction to the words.

  • Validity and reliability in statistics

    In the same way, a reliable measure may not be valid - you may use a ruler to measure people's shoe size and find that each time you measure it you get the same size, but using shoe size to predict intelligence wouldn't be a valid approach.

View More Related Solutions