Question

Question # 3 Great plains Roofing and Siding Company inc. Sells roofing and siding products to...

Question # 3

Great plains Roofing and Siding Company inc. Sells roofing and siding products to home repair stores like lowes and home depot and commercial contractors. The owner is interested in studying the effects of several variables on the value of shingles sold (in thousands). The marketing manager is arguing that the company should spend more on advertising , while a market researcher suggests it should focus more on making its brand and product more distinct from its competitors.

The company has divided their target marketing area into districts. In each district , it collected information on the following variables: volume of sales (in thousands), advertising dollars (thousands), number of active accounts, number of competing brands, and a rating of the districts potential an example of the first few lines of data is below

SUMMARY OUTPUT

Regression Statistics

Multiple R

0.994565583

R Square

0.989160699

Adjusted R Square

0.98709607

Standard Error

9.604406128

Observations

26

ANOVA

df

SS

MS

F

Significance F

Regression

4

176777.1

44194.27

479.0986

2.65E-20

Residual

21

1937.137

92.24462

Total

25

178714.2

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

178.3203403

12.96032

13.75895

5.62E-12

151.3679

205.2728

Ad Dollars

1.807064337

1.081039

1.671599

0.10944

-0.44108

4.055209

Number of accounts

3.317833433

0.162892

20.36833

2.6E-15

2.979081

3.656585

Number of Competitors

-21.18498417

0.787939

-26.8866

9.41E-18

-22.8236

-19.5464

Potential

0.324512401

0.467764

0.693752

0.495441

-0.64826

1.297282

  1. Who is right? The marketing manager or The market researcher? Use this regression output to justify your answer.

Homework Answers

Answer #1

Please don't hesitate to give a "thumbs up" in case you're satisfied with the answer
The owner is interested in studying the effects of several variables on the value of shingles sold (in thousands).

The p-value of "Ad Dollars" variable of 0.10944 is more than alpha = .05, indicating that the variable is statistically insignificant

Hence, there is no statistically significant linear relation, and hence, the marketing manager' arguement that more money should be spend on advertising is wrong

While a market researcher suggests it should focus more on making its brand and product more distinct from its competitors. The p-values of "Number of competitors" and "Potential" is below .05, indicating that these are statistically significant variables

Hence the market researcher is correct

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
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...
Regression Analysis with a Minitab output Assume that your company owns multiple retail outlets in cities...
Regression Analysis with a Minitab output Assume that your company owns multiple retail outlets in cities across the United States. You conduct a study to determine if daily sales levels (in hundreds of dollars) can be predicted by the number of competitors that are located within a one-mile radius of each location and city population (in thousands of people). Therefore, the dependent variable is SALES and the two independent variables are NUMBER OF COMPETITORS and CITY POPULATION. Your research team...
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...
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...
E-Bags, Inc. sells premium designer backpacks through cable TV infomercials. The head of the company’s marketing...
E-Bags, Inc. sells premium designer backpacks through cable TV infomercials. The head of the company’s marketing department wants to determine the relationship between monthly backpack sales and the number of monthly TV infomercials. The data he gathered and the corresponding regression summary output are shown below. Sales TV Ads SUMMARY OUTPUT 2.6 20 Regression Statistics 2.3 18 Multiple R 0.984 2.9 23 R Square 0.967 2.8 21 Adjusted R Square 0.965 1.5 11 Standard Error 0.145 3.4 25 Observations 15...
QUESTION 13 Below is some of the regression output from a regression of the amount various...
QUESTION 13 Below is some of the regression output from a regression of the amount various customers paid for a new car (expressed in dollars) versus the age of the customer (expressed in years), the number of previous cars the customer had purchased from the dealership in the past, a dummy variable indicating the gender of the customer (=1 for a Man and = 0 for a woman), and an interactive term the multiplies the age of the customer with...
Question 4: Analysts at a major automobile company collected data on a variety of variables for...
Question 4: Analysts at a major automobile company collected data on a variety of variables for a sample of 30 different cars and small trucks.  Included among those data were the EPA highway mileage rating and the horsepower of each vehicle.  The analysts were interested in the relationship between horsepower (x) and highway mileage (y). Given below is the Excel output from regressing starting miles per gallon (MPG) on number of horsepower for a sample of 30 students.     Note: Some of the...
Question 10 Please answer the following set of questions, based on the information provided below. The...
Question 10 Please answer the following set of questions, based on the information provided below. The data listed below give information for 10 middle-level managers at a particular company. The first column is years of experience [X] and the second column is annual salary (in thousands) [Y]. We are going to examine the relationship between salary in thousands [Y] and years of experience[X]. Below is the regression output. Manager#     (X)     (Y) 1 xx 66 2 xx 69 3...
American Express Company has long believed that its cardholders tend to travel more extensively than others-both...
American Express Company has long believed that its cardholders tend to travel more extensively than others-both on business and for pleasure. As part of a comprehensive research effort undertaken by a New York marketing research firm on behalf of American Express, a study was conducted to determine the relationship between miles traveled (x) and charges made on the American Express card (y). Eight cardholders were randomly selected and their total charges recorded for a specified period. A questionnaire was then...
Part I A firm that sells a dry skin cream exclusively through drug stores currently operates...
Part I A firm that sells a dry skin cream exclusively through drug stores currently operates in 15 marketing districts in the Midwest. As part of an expansion feasibility study, the company wants to model district sales (Y) as a function of target population (X1), per capita income (X2), and number of drug stores (X3) in the region. Data collected for each of the 15 districts were used to fit a first-order linear model. A summary of the regression results...