Information about multiple regression in excel

Reference no: EM1396284

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?

Reference no: EM1396284

Questions Cloud

Discuss a better method than using average demand for jenn : Discuss a better method than using average demand for Jenn to more accurately assess the ER's capacity requirements. Note: It may come from a previous chapter.

Point estimatation of the population mean : Find a point estimate of the population mean. Find the 95% confidence interval of the population mean. Assume the variable is normally distributed.

Explain leadership styles of presidents dwight eisenhower : What estimation can be made of leadership styles Presidents Dwight Eisenhower and John Kennedy which made them effective or inhibited their effectiveness?

Determine the least square trend equation : Determine the least square trend equation. Estimate the number of employees in 2008. By how much the number of employees decreases (or increases) per year on the average?

Information about multiple regression in excel : 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.

Data collection methods and instruments : Provide examples of a different data collection method and a data collection instrument used in managerial research. Why is it important to ensure that these data collection methods and instruments are both reliable and valid?

Write the structural formula for isoamyl alcohol : The hypothetical OxyA protein is a surface protein that may have a role in attachment to the surface of the intestinal epithelium but there is evidence that it has a role in invasion. Write the structural formula for isoamyl alcohol.

Explain retaliation in legal and employment sense : Explain "retaliation" in legal, employment sense - and describe when it is illegal. What can an employee do when they think they have been retaliated against

Explain how large a rebate should the industry offer : Explain how large a rebate should the industry offer the buyer in order to maximize its revenue?

User Account

All Pages