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

  Plot the regression line on the scatter plot

Do a complete regression analysis by performing the steps below. Note: No regression should be done when r is not significant. Draw a scatter plot. Compute the correlation coefficient.

  Based on interviews with 83 sars patients researchers found

based on interviews with 83 sars patients researchers found the the mean incubation period was 4.3 days with a standard

  Find probability that company will make a profit each month

With a mean of 805 pairs of jeans and a standard deviation of 207 pairs. What is the probability that the company will make a profit each month?

  Minimum level of significance to reject null hypothesis

P-value for test statistic is .085, determine the minimum level of significance needed to reject null hypothesis?

  Let x and y be continuous random variables with the joint

let x and y be continuous random variables with the joint probability density functionfxy 6x if xgtor equals 0 ygt or

  Expected profit maximization

How many jackets should the store owner order if she wants to maximize her expected profit?

  Random variable x denotes the number of daughters in a

random variable x denotes the number of daughters in a family of 2 children. the probability of having one daughter is

  Compute the phi-coefficient for these data

Compute the phi-coefficient for these data and compare it with the result from problem 13. You should find that the sample size has no effect on the strength of the relationship.

  Calculate a 99 confidence interval for the mean surface

oil field pipes are internally coated in order to prevent corrosion. researchers at the university of louisiana

  Creating confidence interval for mean overall duration

Create a 99% confidence interval for mean overall duration of symptoms in population of individuals who used zinc lozenges.

  What are some of the flaws in observational analysis

What are some of the flaws in this observational analysis?  How might it be better designed and Explain why this is a good method

  Explain why is it important to study ethics in statistics

Why is it important to study ethics in statistics? Have you seen statistics misused? Without naming specific companies or people, can you provide examples?

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