Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started