Purchase Solution

Estimate on Quick brews weekly advertising expenditure

Not what you're looking for?

Ask Custom Question

Coffee Times weekly advertising expenditure, Coffee Times weekly advertising expenditure (lagged), Coffee Times price index, Coffee Times price index (Lagged), and Estimate on Quick brews weekly advertising expenditure (lagged).
The equation we have developed to predict effects on revenue when one or more of the independent variables is increased or decreased is:

Y = 246,491.990 + 4.556X1 - 699.171X2 + 5.719X4 - 624.925X5 - 1.729X6
Y = Predicted weekly revenue
X1 = Coffee Times weekly advertising expenditure
X2 = Coffee Times price index
X4 = Coffee Times weekly advertising expenditure (lagged)
X5 = Coffee Times price index (Lagged)
X6 = Estimate on Quick brews weekly advertising expenditure (lagged)

The local management can now use this model to make decisions regarding advertising and pricing while better understanding how Quick Brew's advertising expenditures will impact CoffeeTime revenues.

The analysis showed that the correlation between Coffee Times weekly advertising expenditure (lagged) and the Estimate on Quick brews weekly advertising expenditure (lagged) was fairly high at 0.65. However, since we determined to base our decision to remove any independent variables with correlations higher than 0.70, we will not remove any of them.
Before launching any type of product, it is extremely beneficial for businesses to find out if there is a need or a want for the product. Since Coffee Time's successful launch of their Coffee shop in India, they have decided to introduce a new product to increase sales and profits and would like to establish a want of 30% or more for the product to make it cost effective to launch.
In order to determine if 30% of India's population proportion would like the new sandwich, CoffeeTime has used a hypothesis and a Z-test to resolve this argument. Below you will find the hypothesis used, and other variables,
Ho: P≤0.30 Level of significance: 20% or 0.20
H1: P>0.30 Type of test: Z-test / one tailed test
Sample size: 160 Z= -1.656
Critical Value Z= .84 Accept the null hypothesis

What can be determined from this hypothesis?

Purchase this Solution
Solution Summary

The solution estimates the quick brews weekly advertising expenditures for Coffee Time. The solution uses an equation developed to predict effects on revenues when one or more independent variables are increased or decreased.

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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.

Measures of Central Tendency

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

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.

View More Free Quizzes
Related BrainMass Solutions

  • Coffee Time Case Study: Type I and Type II Errors

    The analysis showed that the correlation between Coffee Times weekly advertising expenditure (lagged) and the Estimate on Quick brews weekly advertising expenditure (lagged) was fairly high at 0.65.

  • Statistcal Analysis of the CoffeTime Company

    expenditure, CoffeeTime's price index, and the acquired estimate on Quick Brew's weekly advertising expenditure).

  • Applied Problems

    advertising expenditure have a statistically significant effect on sales of Bright Side detergent?

  • Multiple Regression - Vanguard Corporation

    The marketing director collects 36 weekly observations on S,A, and R to estimate the following multiple regression equation: S = a + bA+cR Where S,A and R are measured in dollars per week.

  • Demand function - regression

    The sales manager collected 48 weekly observations on S, A, and C to estimate the following regression: S = a + bA + cC; where S, A, and C are measured in thousands of dollars per week.

  • Multiple Regression for Vanguard Corp

    The marketing director collects 36 weekly observations on S, A, and R to estimate the following multiple regression equation: S= a + bA + cR where S, A and R are measured in dollars per week, Vanguard;s marketing director is comfortable using parameter

  • Econometrics - Regression Analysis

    The marketing director collects 36 weekly observations on S,A, and R to estimate the following multiple regression equation: S = a + bA + cR Where S, A, and R are measured in dollars per week.

  • Managerial Economics: Appalachian Coal Mining, Vanguard Corp

    The marketing director collects 36 weekly observations on S, A, and R to estimate the following multiple regression equation: S= a + bA + cR Where S, A and R are measured in dollars per week.

  • Multiple regression in Excel

    e- What is the estimate of weekly gross revenues for a week when $3500 is spent on television advertising and $1800 is spent on newspaper advertising?

View More Related Solutions