Explore BrainMass

Explore BrainMass

    Multiple regression in Excel

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

    Problem #1: The Texas Transportation institute at texas A&M university conducted a survey to determine the number of hours per year drivers wasted sitting in traffic. the table below shows the number of hours wasted per year sitting in traffic.

    Denver Miami San Francisco
    70 66 65
    62 70 62
    71 55 74
    58 65 69
    57 56 63
    66 66 75

    a- compute the sample mean hours wasted per year for each of these urban areas.
    b- using the .05% level of significance, test for significance difference between the mean wasted time for these urban areas.
    c- what is your conclusion
    d- perform all analysis using the Excel Data Analysis Tool

    Problem #2: management of showtime movie theatres inc. would like to estimate the weekly gross revenue as a function of advertising expenditures. historical data for a sample of eight weeks is presented below:

    Wkly Gross Rev. 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- estimate a regression equation with only the amount of television advertising as the independent variable.

    b- Put the results in summary form. test the significance of the estimated parameters at the .05% level of significance? how much of the variation in weekly revenue is explained by this econometric model?

    c- Estimate a regression equation with both the amount of television advertising expenditures as the independent variables (Multiple Regression)

    d- put the results in summary form. Test the significance of the estimated parameters at the .05% level of significance? Test for overall significance of the model (ANOVA) how much of the variation in weekly revenue is explained by this econometric model?

    e- What is the estimate of weekly gross revenues for a week when $3500 is spent on television advertising and $1800 is spent on newspaper advertising?

    © BrainMass Inc. brainmass.com June 3, 2020, 10:43 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/multiple-regression-in-excel-246256

    Solution Summary

    The solution provides step by step method for the calculation of multiple regression model in excel . Formula for the calculation and Interpretations of the results are also included.

    $2.19

    ADVERTISEMENT