Purchase Solution

Is Regression a Good Model Here?

Not what you're looking for?

Ask Custom Question

Gallop Marketing has been gathering data on people's television viewing habits in smaller metropolitan areas. Radhika Nanda, an analyst at Gallop, is trying to predict the number of households that tune in to a given television station at any time during a given calendar week. She has gathered data for 25 different stations/broadcast areas, and has run a simple linear regression model, where the number of households that tune in to a station (in 10,000s) sometime during the week is the dependent variable. The independent variable that she has used is the number of households (in 10,000s) with televisions in the broadcast area. The resulting regression model output appears below. Radhika has looked at the output and is discouraged with the results.

(a) Based on the above regression output, why might this regression not be a good model.

Radhika has decided to give her factors some more thought, and has come upon the idea that the number of households who tune in to a particular station during the week might also depend on whether or not the station's channel is VHF or UHF. For example, most VHF stations are major networks (like ABC, CBS, or NBC), which are viewed more often regardless of the size of the broadcast area. Radhika therefore has included a dummy variable for whether a station broadcasts on VHF (VHF = 1, UHF = 0).

The results of her multiple linear regression are as follows:

(b) Write a complete equation for the multiple linear regression that incorporates the estimated coefficients provided by the second regression output.Define in words all the variables used in the equation. Do the signs of the regression coefficients make sense? Why or why not?

(c) What are the degrees of freedom of the second regression model? Compute the 98% confidence interval for its "Number of Households" and "UHF/VHF" coefficients.

(d) Below are residual plots that Radhika has produced based on the second regression model. Do you see any problems with the model based on looking these plots? Why or why not?

(e) Radhika has computed the sample correlation of the data for "Number of Households" and "UHF/VHF" data. The results of Radhika's correlation computations are shown below.

Number of Households (10,000s) UHF, VHF
Number of Households (10,000s) 1.0000
UHF, VHF 0.0730 1.0000

Do these numbers indicate any possible problems with the regression? Why or why not? In order to check to validity of the second regression model, describe what additional test you would perform, and why.

See attached file for full problem description.

Attachments
Purchase this Solution
Solution Summary

Word document to work out regression-centered problems for Gallop Marketing and evaluate a model based on prepared residual plots.

Solution Preview

Please see the attached file.

Problem 6.
Gallop Marketing has been gathering data on people's television viewing habits in smaller metropolitan areas. Radhika Nanda, an analyst at Gallop, is trying to predict the number of households that tune in to a given television station at any time during a given calendar week. She has gathered data for 25 different stations/broadcast areas, and has run a simple linear regression model, where the number of households that tune in to a station (in 10,000s) sometime during the week is the dependent variable. The independent variable that she has used is the number of households (in 10,000s) with televisions in the broadcast area. The resulting regression model output appears below. Radhika has looked at the output and is discouraged with the results.

(a) Based on the above regression output, why might this regression not be a good model?

Solution:

R Square is the value that defines what percentage of dependent variable is explained by the independent variable. Here it is 0.1862 or 18.62 percent. We could say that 18.62 percent effect of independent variable is on the dependent variable, which is very less. So we confirm that this regression model is not a good model.

Radhika has decided to give her factors some more thought, and has come upon the idea that the number of households who tune in to a particular station during the week might also depend on whether or not the station's channel is VHF or UHF. For example, most VHF stations are major networks (like ABC, CBS, or NBC), which are viewed ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

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

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.

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

  • Linear Regression Analysis

    Did the estimated regression equation provide a good fit? The strength of regression model is good as indicated by the high value of F.

  • Forecasting using Excel

    Thus the suggested regression model is able to explain a good portion of the variability in the dependent variable.

  • Multiple regression: City MPG

    Thus the suggested simple model is able to explain a good portion of the variability in the dependent variable.

  • Multiple Regression Model for a Real Estsate Broker

    The model adequacy is measured using the R^2 value. Here R^2 = 0.8976. Thus 89.8% variability in the Appraised value can be explained by the regression model.

  • Statistics Problem Set: U.S. Energy Information

    This suggests that the regression model is a very good one.

  • Regression Analysis

    30.85555797 6.260594952 4.928534462 4.73248E-06 Answers a) How good a model is this? Explain. Model adequacy is given by R2.Here R2=0.6050. Thus 60.5% variability in house price can be explained by the regression model.

  • Regression Analysis - Using PHStat or Excel

    The model adequacy is measured using the R2 value. Here R2 = 0.9188. Thus 91.88% variability in MPG can be explained by the quadratic model. Thus the suggested model is able to explain a good portion of the variability in the dependent variable.

  • Regression, Outliers, P-value, R

    There are some outliers in the data because the points are scattered here and there and they are not on a straight line.   b. Fit a linear regression model for y1 against x1. Do you think this is a model with a good fit? Why?

  • Multiple Regression Analysis..

    The model adequacy is measured using the R2 value. Here R2 = 0.083. Thus only 8.3% variability in the child regression can be explained by the regression model. Mediating vs. moderating variable? Reference: Lewis-Beck MS, (1993).

View More Related Solutions