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

  People walk related to their cholesterol levels

A health researcher is interested in determining whether or not the speed at which people walk is related to their cholesterol levels. He picks 100 adult volunteers at random, checks their cholesterol levels, and then times each one while they wal..

  Find the probability of correctly answering the first

Find the probability of correctly answering the first 2 questions on a multiple choice test if random guesses are made and each question has 3 possible answers.

  Find probability that sales selected day are of given value

Would that daily sales figure be considered a potential outlier? why or why not? e) Find the probability that sales on a randomly selected day are at most $3445.

  1on november 26 1995 the minneapolis tribune ran an article

1.on november 26 1995 the minneapolis tribune ran an article on gender differences in shopping behavior. when 400 women

  A surgical technique is performed on seven patients you

a surgical technique is performed on seven patients. you are told there is a 70 chance of success. find the probability

  Te name of each contestant is written on a separate card

the name of each contestant is written on a separate card the cards are placed in a bag and three names are picked

  Two sides dice are let a represent the set of tosses for

two sides dice are .let a represent the set of tosses for which the sum of dice is even b be the set of tosses for

  Test of hypothesis-academic approach

Reis, Inc., a New York real estate research firm, tracks the cost of apartment rentals in the United States. In mid-2002, the nationwide mean apartment rental rate was $895 per month

  To test the independence of attributes

Sample data are reported for 50 employees of small companies, 75 employees of medium companies, and 100 employees of large companies.

  Central limit theorem and poisson distribution

A business has 5 telephone lines. The first rings every minute on the average, the second every ½ minute, the third every 2 minutes, the fourth every 5 minutes,

  For a sample of 20 tires of a particular brand the average

for a sample of 20 tires of a particular brand the average tread life was 65000 miles with a standard deviation of

  Confidence interval estimation and anova

The American Sugar Producers Association wants to estimate the mean yearly sugar consumption. A sample of 16 people reveals the mean yearly consumption to be 60 pounds with a standard deviation of 20 pounds.

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