Perform a complete regression analysis

Assignment Help Basic Statistics
Reference no: EM13925469

This problem is to be solved using Minitab.  Below are the results of an annual survey conducted by Video Board Tests, Inc., a New York ad-testing company, based on interviews with adults who were asked to name the most outstanding TV commercial they had seen, noticed, and liked. These retained impressions are listed along with company name and TV ad expenditures.  We would be interested in determining if the number of retained impressions is linearly related to the advertising expenditures (i.e. the more spent on advertising, the higher the number of retained impressions)
Variables:  

FIRM: Firm name
SPEND: TV advertising budget, 1983 ($ millions)
MILIMP: Millions of retained impressions per week

FIRM                      SPEND     MILIMP

MILLER LITE             50.1        32.1
PEPSI                      74.1        99.6
STROH'S                  19.3        11.7
FED'L EXPRESS         22.9        21.9
BURGER KING           82.4        60.8
COCO-COLA             40.1        78.6
MC DONALD'S          185.9       92.4
MCI                         26.9         50.7
DIET COLA               20.4         21.4
FORD                      166.2        40.1
LEVI'S                     27.0          40.8
BUD LITE                 45.6          10.4
ATT/BELL                 154.9        88.9
CALVIN KLEIN            5.0          12.0
WENDY'S                   50.1        29.2
POLAROID                 26.9        38.0
SHASTA                      5.0        10.0
MEOW MIX                  7.6        12.3
OSCAR MEYER             9.2       23.4
CREST                        32.4       71.1
KIBBLES 'N BITS          6.1         4.4

Perform a complete regression analysis using Minitab to determine whether or not the simple linear regression model is appropriate for this data.  Your analysis must include a written analysis (i.e. interpretation of the output) in addition to the Minitab output (this does not mean simply writing notes on the output).  For any tests, use α = 0.05.  Attach your Minitab output when handing in your assignment.

Reference no: EM13925469

Questions Cloud

Economic life to an estimated salvage value : The management of Jasper Equipment Company is planning to purchase a new milling machine that will cost $160,000 installed. The old milling machine has been fully depreciated but can be sold for $15,000. The new machine will be depreciated on a strai..
Wright company produces products : Wright Company produces products I, J, and K from a single raw material input. Budgeted data for the next month
What percentage of unexplained variance in capmmi portfolio : What is the percentage of unexplained variance in the CAPMMI portfolio? Does this portfolio qualify as highly diversified? How much would it be possible to lower the risk of the CAPMMI in a portfolio with identical factor exposures?
What is shadows cost of equity : Shadow Corp. has no debt but can borrow at 8.0 percent. The firm’s WACC is currently 9.8 percent, and the tax rate is 35 percent. What is Shadow’s cost of equity? If the firm converts to 15 percent debt, what will the company's WACC be? If the firm c..
Perform a complete regression analysis : Perform a complete regression analysis using Minitab to determine whether or not the simple linear regression model is appropriate for this data.
What is the after-tax operating cash flow expected in year : Standard Corporation is investing $400,000 of fixed capital in a project that will be depreciated straight-line to zero over its ten-year life. Annual sales are expected to be $240,000, and annual cash operating expenses are expected to be $110,000. ..
Show the effect of the above transaction on a statements : Show the effect of the above transaction on a statements model like the one shown below.
Your firm has a line of credit with your local bank : Your firm has a line of credit with your local bank for $50,000. The loan agreement calls for interest of 9% with a 5% compensating balance requirement which is based on the total amount borrowed. What is the effective interest rate if you need $42,7..
What mmi asset has the highest alpha : Excess return forecasts of zero for all other factors. Using the CAPMMI as a benchmark, what MMI asset has the highest alpha? What is its value?

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd