Question

A business is evaluating their advertising budget, and wishes to determine the relationship between advertising dollars...

A business is evaluating their advertising budget, and wishes to determine the relationship between advertising dollars spent and changes in revenue. Below is the output from their regression.

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.95

R Square

0.90

Adjusted R Square

0.82

Standard Error

0.82

Observations

8

ANOVA

df

SS

MS

F

Significance F

Regression

3

23.188

7.729

11.505

0.020

Residual

4

2.687

0.672

Total

7

25.875

Coefficients

Std Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

83.91

2.03

41.36

0.00

78.28

89.54

TV ($k)

1.96

0.48

4.10

0.01

0.63

3.29

Radio ($k)

0.76

0.47

1.64

0.18

-0.53

2.05

Newspaper ($k)

1.76

1.93

0.91

0.41

-3.60

7.11


What advertising method provides the most additional revenue per dollar spent?

Select one:

a. Multiple R

b. TV

c. Radio

d. Newspaper

e. Regression

f. Residual

Homework Answers

Answer #1

Solution:

Here we have to find the advertising method provides the most additional revenue per dollar spent?

Here we know that the multiple linear regression is like

Y = a + b1 * x1 + b2 * x2 + b3 * x3

If there are three variables

Where b1 : additional revenue per dollar spent by TV

b2 : additional revenue per dollar spent by rafir

b3 : additional revenue per dollar spent by newspaper

The most affect on factor on revenue is b1 because coefficient of x1( i.e. b1 = 1.96 ) is more than others

Therefore option TV is correct

Answer: b. TV

Thank You..!!

please like it...

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
PLEASE ANSWER ALL QUESTIONS ! 1. The following sample observations were randomly selected (numbers may be...
PLEASE ANSWER ALL QUESTIONS ! 1. The following sample observations were randomly selected (numbers may be different from previous problems): X Y 4 4 5 6 3 5 6 7 10 7 What is the slope of the regression equation? Select one: a. 5.6 b. 0.36 c. 1.56 d. 5.8 2. A business is evaluating their advertising budget, and wishes to determine the relationship between advertising dollars spent and changes in revenue. Below is the output from their regression. SUMMARY...
QUESTION 3 The managing director of a real estate company investigated how advertising budget (in $000s)...
QUESTION 3 The managing director of a real estate company investigated how advertising budget (in $000s) and number of agents affected annual sales ($ million). He used data from 15 offices, and obtained the following regression output: SUMMARY OUTPUT Regression Statistics Multiple R 0.72 R Square 0.52 Adjusted R Square 0.44 Standard Error 7.36 Observations 15 ANOVA df SS MS F Significance Regression 2 716.58 358.29 6.61 0.01 Residual 12 650.35 54.20 Total 14 1366.93 Coefficients Standard Error t Stat...
A manager at a company analyzed the relationship between the weekly record sales and factors affecting...
A manager at a company analyzed the relationship between the weekly record sales and factors affecting its sales with a sample of 200 records. The independent variables included in the regression model are as follows: x1: Advertising budget (thousands of dollars), x2: No. of plays on radio per week, x3: Attractiveness of band, The following ANOVA summarizes the regression results. Table 1: ANOVA Source of Variation df Source of Squares Mean Square F R Squared Regression 861377.418 0.665 Residual or...
In models B through D, what seems to be the relationship between the burglary rate and...
In models B through D, what seems to be the relationship between the burglary rate and the percent of the 18-64 population who are young adults (18-24)? Select one: a. It is difficult to describe the relationship; the young adult variables were all significant at 5% in models B, C, and D, but the signs and sizes of the coefficients were very different between models. b. Conclusions about the relationship between young adults and the burglary rate are difficult to...
A regression analysis relating a company’s sales, their advertising expenditure, price, and time resulted in the...
A regression analysis relating a company’s sales, their advertising expenditure, price, and time resulted in the following. Regression Statistics Multiple R 0.8800 R Square 0.7744 Adjusted R Square 0.7560 Standard Error 232.29 Observations 25 ANOVA df SS MS F Significance F Regression 3 53184931.86 17728310.62 328.56 0.0000 Residual 21 1133108.30 53957.54 Total 24 54318040.16 Coefficients Standard Error t Stat P-value Intercept 927.23 1229.86 0.75 0.4593 Advertising (X1) 1.02 3.09 0.33 0.7450 Price (X2) 15.61 5.62 2.78 0.0112 Time (X3) 170.53...
Research into the relationship between hours of study and grades show widely different conclusions. A recent...
Research into the relationship between hours of study and grades show widely different conclusions. A recent survey of graduates who wrote the Graduate Management Admissions Test (GMAT) had the following results. Hours Studied Average Score (Midpoint) 64 350 72 450 79 550 106 650 99 750 The Excel output for this regression is as following SUMMART OUTPUT ____________________________    Regression Statistics ____________________________ Multiple R 0.919958 R Square 0.846322 Adjusted R Square 0.795097 Standard Error 71.57225 Observations 5 Anova ___________________________________________________________________________________________   ...
A real estate builder wishes to determine how house size (House) is influenced by family income...
A real estate builder wishes to determine how house size (House) is influenced by family income (Income), family size (Size), and education of the head of household (School). House size is measured in hundreds of square feet, income is measured in thousands of dollars, and education is in years. The builder randomly selected 50 families and ran the multiple regression. Microsoft Excel output is provided below: SUMMARY OUTPUT             Regression Statistics Multiple R                         0.865 R Square                           0.748 Adjusted R Square            0.726 Standard Error                  5.195 Observations                     50...
A sales manager for an advertising agency believes there is a relationship between the number of...
A sales manager for an advertising agency believes there is a relationship between the number of contacts that a salesperson makes and the amount of sales dollars earned. A regression analysis shows the following results: Coefficients Standard Error t Stat p value Intercept −12.201 6.560 −1.860 0.100 Number of contacts 2.195 0.176 12.505 0.000 ANOVA df SS MS F Significance F Regression 1.00 13555.42 13555.42 156.38 0.00 Residual 8.00 693.48 86.68 Total 9.00 14248.90 Additional information needed to perform the...
Statistical Methods of Business II – Case Study – Indiana Real Estate Ann Perkins, a realtor...
Statistical Methods of Business II – Case Study – Indiana Real Estate Ann Perkins, a realtor in Brownsburg, Indiana, would like to use estimates from a multiple regression model to help prospective sellers determine a reasonable asking price for their homes. She believes that the following four factors influence the asking price (Price) of a house: The square footage of the house (SQFT) The number of bedrooms (Bed) The number of bathrooms (Bath) The lot size (LTSZ) in acres She...
2: A real estate agent is interested in what factors determine the selling price of homes...
2: A real estate agent is interested in what factors determine the selling price of homes in Northwest Arkansas. She takes a random sample of 20 homes, and conducts a multiple regression analysis. The dependent variable is price of the home (in thousands of dollars), the square footage of the home, and whether the home is located in a new subdivision (0 = no; 1 = yes). The results of the multiple regression analysis are shown below. Answer the following...