Business, 30.05.2020 20:00 IsabelAyshi

The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks are entered into the Microsoft Excel Online file below. Use the XLMiner Analysis ToolPak to perform your regression analysis in the designated areas of the spreadsheet. Open spreadsheet Develop an estimated regression equation with the amount of television advertising as the independent variable (to 2 decimals). Revenue = + TVAdv Develop an estimated regression equation with both television advertising and newspaper advertising as the independent variables (to 2 decimals). Revenue = + TVAdv + NewsAdv Is the estimated regression equation coefficient for television advertising expenditures the same in part (a) and in part (b)? Predict weekly gross revenue for a week when $4.9 thousand is spent on television advertising and $3.9 thousand is spent on newspaper advertising (to 2 decimals)?

Answers: 1

Show answers

Another question on Business

Business, 21.06.2019 22:50

The winston company estimates that the factory overhead for the following year will be $1,250,000. the company has decided that the basis for applying factory overhead should be machine hours, which is estimated to be 50,000 hours. the total machine hours for the year were 54,300. the actual factory overhead for the year were $1,375,000. determine the over- or underapplied amount for the year.

Answers: 1

Answer

Business, 22.06.2019 10:40

You were able to purchase two tickets to an upcoming concert for $100 apiece when the concert was first announced three months ago. recently, you saw that stubhub was listing similar seats for $225 apiece. what does it cost you to attend the concert?

Answers: 1

Answer

Business, 22.06.2019 12:30

Consider a treasury bill with a rate of return of 5% and the following risky securities: security a: e(r) = .15; variance = .0400 security b: e(r) = .10; variance = .0225 security c: e(r) = .12; variance = .1000 security d: e(r) = .13; variance = .0625 the investor must develop a complete portfolio by combining the risk-free asset with one of the securities mentioned above. the security the investor should choose as part of her complete portfolio to achieve the best cal would be a. security a b. security b c. security c d. security d

Answers: 3

Answer

Business, 22.06.2019 19:20

This problem has been solved! see the answerwhich of the following statements is correct? the consumer price index is a measure of the overall level of prices, whereas the gdp deflator is not a measure of the overall level of prices. if, in the year 2011, the consumer price index has a value of 123.50, then the inflation rate for 2011 must be 23.50 percent. compared to the gdp deflator, the consumer price index is the more common gauge of inflation. the consumer price index and the gdp deflator reflect the goods and services bought by consumers equally well.

Answers: 2

Answer

You know the right answer?

The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function...

Questions