Question

In: Statistics and Probability

In its continuing study of the 3-For-All subscription solicitation process, a marketing department team wants to...

In its continuing study of the 3-For-All subscription solicitation process, a marketing department team wants to test the effects of two types of structured sales presentations (personal formal and personal informal) and the number of hours spent on telemarketing on the number of new subscriptions. The staff has recorded these data for the past 24 weeks in AMS14. Analyze these data and develop a multiple regression model to predict the number of new subscriptions for a week, based on the number of hours spent on telemarketing and the sales presentation type. Write a report, giving detailed findings concerning the regression model used. (Using Excel PHSTAT)

Week New Subscription Hours Presentation

1

1256 282 Formal
2 1405 336 Formal
3 1104 232 Formal
4 1333 321 Informal
5 975 261 Informal
6 769 212 Formal
7 585 162 Formal
8 923 266 Informal
9 1118 269 Formal
10 567 185 Informal
11 808 191 Formal
12 1005 226 Formal
13 1366 331 Informal
14 1180 311 Informal
15 851 222 Formal
16 848 227 Informal
17 1033 257 Formal
18 666 193 Formal
19 1289 325 Formal
20 840 216 Informal
21 995 251 Formal
22 1437 345 Informal
23 1133 286 Informal
24 1228 263 Formal

Solutions

Expert Solution

SUMMARY OUTPUT

Regression Statistics

Multiple R 0.959782095

R Square 0.921181669

Adjusted R Square 0.913675162

Standard Error 74.89636127

Observations 24

ANOVA

df SS MS F Significance F

Regression 2 1376761.736 688380.8682 122.7177417 2.59768E-12

Residual 21 117798.7636 5609.464931

Total 23 1494560.5

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%

Intercept -277.0200768 89.06006307 -3.110485971 0.005293533 -462.2306169 -91.8095366 -462.2306169 -91.8095366

Hours 4.864387329 0.312306521 15.57568289 5.19292E-13 4.214910365 5.513864293 4.214910365 5.513864293

Presentation' 96.37228728 32.4439516 2.97042384 0.007298234 28.90139636 163.8431782 28.90139636 163.8431782

1) So the equation of the regression is

New subscriptions = -277.02 + 4.86*Hours + 96.37*Presentation

Presentation = 1 if Formal otherwise 0

2) Coefficient of determination R^2 = 92.11%. So 92.11% of the variation in the dependent variable is explained by the variation in Hours and Presentation.

3) The formal presentation has 96.37 subscriptions more when the presentation is informal.

4) For every one hour increase, new subscriptions also increase by 4.86


Related Solutions

In its continuing study of the 3-For-All subscription solicitation process, a marketing department team wants to...
In its continuing study of the 3-For-All subscription solicitation process, a marketing department team wants to test the effects of two types of structured sales presentations (personal formal and personal informal) and the number of hours spent on telemarketing on the number of new subscriptions. The staff has recorded these data for the past 24 weeks in AMS14. Analyze these data and develop a multiple regression model to predict the number of new subscriptions for a week, based on the...
A brewery wants to conduct a Marketing campaign. Therefore the marketing department is interested in the...
A brewery wants to conduct a Marketing campaign. Therefore the marketing department is interested in the unknown Proportion of college students that buy beer. 425 customers were asked, and 351 of them where college students. a) Calculate the 99% Confidence Interval for the unknown proportion of buyers that are college students b) In order to conduct the campaign, the executive board demands, that more than 85% of the customers are college students. Test if this level is fulfilled up until...
Lowes, a home improvement retailer, has authorized its marketing research department to make a study of...
Lowes, a home improvement retailer, has authorized its marketing research department to make a study of customers who have been issued a Lowes charge card. The marketing research department hopes to identify the significant variables that explain the variation in purchases. Once these variables are determined, the department intends to try to attract new customers who would be predicted to make a high volume of purchases. Twenty-five customers were selected at random, and values for the following variables were recorded:...
Managing Ashland MultiComm ServicesThe Ashland MultiComm Services (AMS) marketing department wants to increase subscriptions for its...
Managing Ashland MultiComm ServicesThe Ashland MultiComm Services (AMS) marketing department wants to increase subscriptions for its 3-For-All telephone, cable, and Internet combined service. AMS marketing has been conducting an aggressive direct-marketing campaign that includes postal and electronic mailings and telephone solicitations. Feedback from these efforts indicates that including premium channels in this combined service is a very important factor for both current and prospective subscribers. After several brainstorming sessions, the marketing department has decided to add premium cable channels as...
The marketing team at an internet music site wants a better understanding of who their customers...
The marketing team at an internet music site wants a better understanding of who their customers are. They send out a survey to 25 customers​ (and use an incentive of​ $50 worth of downloads to guarantee a high response​ rate) asking for demographic information. One of the variables is the​ customer's age. For the 25​ customers, the ages are shown to the right. Complete parts​ a) through​ d). a) Find the quartiles using technology.
The marketing team at an internet music site wants a better understanding of who their customers...
The marketing team at an internet music site wants a better understanding of who their customers are. They send out a survey to 25 customers​ (and use an incentive of​ $50 worth of downloads to guarantee a high response​ rate) asking for demographic information. One of the variables is the​ customer's age. For the 25​ customers, the ages are shown to the below. Complete parts​ a) through​ d). 19 , 30 , 39 , 26 , 36 , 32 ,...
In a marketing study, the researcher wants to minimize the cost of interviewing. These interviews will...
In a marketing study, the researcher wants to minimize the cost of interviewing. These interviews will be done to households with children, without children, and to individuals during the day and during the night. The cost for each type of interview is presented in the following table: Category Cost per day Cost per night With children $1500 $1900 Without children $1200 $1550 Individual $1100 $1250 The sample size is 800 people. At least there must be 400 households with children....
Mini-Case Study: Team Building at Global Green Books Publishing Global Green Books Publishing is continuing to...
Mini-Case Study: Team Building at Global Green Books Publishing Global Green Books Publishing is continuing to grow. As their eBook business continues to drive that growth, they now are continuing to add staff to be able to keep up with customer demand. Most all of the new people and many of the eBook staff have not worked together in the original print-based business area of the company, and indeed are new to the company and its culture. These new employees...
A team wants to improve a process but only if a real improvement can be verified...
A team wants to improve a process but only if a real improvement can be verified because the cost to change is very expensive. Given the current process data and the new process data, what decision should be made? Use Minitab and an alpha level of 0.01 to make the decision. Current 5 New 5 98.1 100.9 102.3 101.1 98.5 103.4 101.6 85.0 97.7 103.4 100.0 103.6 103.1 100.0 99.1 99.7 97.7 106.4 98.5 101.2
The research team in your marketing department has some preliminary results for the upcoming launch of...
The research team in your marketing department has some preliminary results for the upcoming launch of your new product. They believe that there is a 90% chance that the launch of your new product will be successful if the state of the economy is in good health. Conversely, they believe that there is only a 30% chance that the launch will be successful if the economy is not in good health. Past indicators suggest that the probability that the economy...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT