Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i need the aswers in excel , please The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function

i need the aswers in excel , please

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

follow. Weekly Gross Revenue Television Advertising

($1,000s) Newspaper Advertising ($1,000s) ($1,000s) 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) Develop an estimated regression

equation with the amount of television advertising as the

independent variable. (Round your numerical values to two

decimal places. Let x, represent the amount of television

advertising in $1,000s and y represent the weekly gross

revenue in $1,000s.) (b) Develop an estimated regression

equation with both television advertising and newspaper

advertising as the independent variables. (Round your

numerical values to two decimal places. Let x, represent the

amount of television advertising in $1,000s, X2 represent the

amount of newspaper advertising in $1,000s, and y represent

the weekly gross revenue in $1,000s.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra And Trigonometry, Enhanced

Authors: Cynthia Y Young

4th Edition

1119320860, 9781119320869

More Books

Students also viewed these Mathematics questions

Question

Draft a proposal for a risk assessment exercise.

Answered: 1 week ago