Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Use = .01 to test the hypotheses for the model y = 0 + 11 + 22 + , where:

H0: 1 = 2 = 0

Ha: 1 and/or 2 0

Compute the F test statistic (to 2 decimals).

What is the p-value?

What is your conclusion?

Use = .05 to test the significance of 1. Compute the t test statistic (to 2 decimals).

Weekly Gross Revenue (1000s) Television Advertising ($1000s) Newspaper Advertising ($1000s)
96 5 1.5
91 2 2
96 5 1.5
93 2.5 2.5
96 4 3.3
94 3.5 2.3
95 2.5 4.2
95 4 2.5
Predicted Revenue
4.8 3.6

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

Geometry, Its Elements And Structure

Authors: Alfred S Posamentier, Robert L Bannister

2nd Edition

0486782166, 9780486782164

More Books

Students also viewed these Mathematics questions