Explore BrainMass

Explore BrainMass

    Multiple Regression Analysis and Hypothesis Test

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    The Excel file contains this data on weekly gross revenues, television advertising expenditures, and newspaper advertising expenditures for Showtime Movie Theaters, all measured in thousands of dollars.

    Weekly Gross Revenue Television Advertising Newspaper Advertising
    96 5.0 1.5
    90 2.0 2.0
    95 4.0 1.5
    92 2.5 2.5
    95 3.0 3.3
    94 3.5 2.3
    94 2.5 4.2
    94 3.0 2.5

    a. Find an estimated regression equation relating weekly gross revenue to television expenditures and newspaper advertising expenditures.

    b. Using a conservative measure that compensates for the number of independent variables in the model, comment on the goodness of fit. How much variability is accounted for in this regression model?

    c. Does an overall test of significance say that the model is valid?

    d. What is the outcome of individual t-tests for significance on the two independent variables?

    e. Estimate gross revenues for Showtime given outlays of 4.5K$ for TV and 1.7K$ for newspaper advertising.

    © BrainMass Inc. brainmass.com December 24, 2021, 8:44 pm ad1c9bdddf


    Solution Summary

    The solution provides step-by-step method of performing a Multiple Regression Analysis and a Hypothesis Test. All the steps of hypothesis testing (formulation of null and alternate hypotheses, significance level, decision rule, p-value, conclusion) have been explained and the Multiple Regression Analysis has been shown in details.