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

orchestra answered 1 year ago

Next > < Previous

Related Solutions

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

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:...

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 ,...

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...

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....

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

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...

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...

Subjects