Question

In: Statistics and Probability

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 and the amount of the sales. To verify this belief, the following data was collected: For each sales contact a particular person makes, the amount of sales is expected to: Select one: a. Decrease by 2.195 thousand units b. Increase by 2.195 thousand units c. Decrease by 12.201 thousand units d. Increase by 12.201 thousand units

Solutions

Expert Solution

Data is not given but i have taken as bellow,

Here we have to do regression analysis. Independent variable (X) : Number of contacts

Dependent variable: Sales (Y)

Following is the output of regression analysis generated by excel:

SUMMARY OUTPUT
Regression Statistics
Multiple R 0.975362147
R Square 0.951331317
Adjusted R Square 0.945247731
Standard Error 9.31044574
Observations 10
ANOVA
df SS MS F Significance F
Regression 1 13555.4248 13555.4248 156.3767508 1.56492E-06
Residual 8 693.475199 86.68439987
Total 9 14248.9
Coefficients Standard Error t Stat P-value Lower 95% Upper 95%
Intercept -12.20103752 6.559575958 -1.86003449 0.099925317 -27.32744679 2.92537175
Number Of Contacts 2.194641842 0.175500178 12.50506901 1.56492E-06 1.789937705 2.599345979

Slope of least sqaure regression line:

Slope: 2.195

Intercept: -12.201

Since slope is positive so for each unit increase in independent variable, dependent variable increased by 2.195 units. Hence, option b is correct.


Related Solutions

A sales manager is interested in determining the relationship between the amount spent on advertising and...
A sales manager is interested in determining the relationship between the amount spent on advertising and total sales. the manger collects data for the past  months and runs a regression of sales on advertising expenditures. The results wıth some missing values are presented below. Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.492 0.242 0.208 40.975 ANOVA df SS MS F Significance Regression Residual Total 1 Coefficients Standard Error t Stat P-value Constant Advertising To test the...
Consider the agency relationship between a corporate financial manager and the shareholders of the corporation.
Consider the agency relationship between a corporate financial manager and the shareholders of the corporation. As a corporate financial manager, you have the opportunity to manage the company's cash on behalf of its owners (shareholders).In the second half of your paper, imagine yourself in the role of Apple's financial management team. Describe what types of measures you would take to ensure that any decisions made with regards to the company's cash faithfully represent the wishes of the shareholders.
A sociologist believes that there is a relationship between number of friends an elderly person has...
A sociologist believes that there is a relationship between number of friends an elderly person has and their perceived level of stress. Participant # of Friends (Y) Stress Level (X) A 10 1 B 3 7 C 12 2 D 11 3 E 6 5 F 8 4 G 14 1 H 9 2 I 10 3 J 2 10 *higher scores of the measure of stress (from 1 to 10) indicate more stress. Use this information to answer questions...
A sociologist believes that there is a relationship between number of friends an elderly person has...
A sociologist believes that there is a relationship between number of friends an elderly person has and their perceived level of stress. Participant # of Friends (Y) Stress Level (X) A 10 1 B 3 7 C 12 2 D 11 3 E 6 5 F 8 4 G 14 1 H 9 2 I 10 3 J 2 10 *higher scores of the measure of stress (from 1 to 10) indicate more stress. Use this information to answer questions...
(Use Excel) The quality manager believes there may be a relationship between the experience level of...
(Use Excel) The quality manager believes there may be a relationship between the experience level of an inspector and whether a product passes or fails inspection. Inspection records were reviewed for 628 units of a particular product, and the number of units which passed and failed inspection was determined based on three inspector experience levels. The results are shown in the following table. Decision Experience Level Low (under 2 years) Medium (2-8 years) High (over 8 years) Pass 152 286...
question13: TABLE 14-1 A manager of a product sales group believes the number of sales made...
question13: TABLE 14-1 A manager of a product sales group believes the number of sales made by an employee ( Y) depends on how many years that employee has been with the company ( X 1) and how he/she scored on a business aptitude test ( X 2). A random sample of 8 employees provides the following: Employee Y X1 X2 1 100 10 7 2 90 3 10 3 80 8 9 4 70 5 4 5 60 5...
Consider the following sample data for the relationship between advertising budget and sales for Product A:...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 50,000 60,000 60,000 70,000 70,000 80,000 90,000 90,000 100,000 110,000 Sales ($) 299,001 371,000 364,000 430,000 440,000 485,000 535,000 546,000 595,000 675,000 What is the predicted sales quantity for an advertising budget of $76,000? Please round your answer to the nearest integer.
Consider the following sample data for the relationship between advertising budget and sales for Product A:...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 50,000 60,000 60,000 70,000 70,000 80,000 90,000 90,000 100,000 110,000 Sales ($) 299,001 371,000 364,000 430,000 440,000 485,000 535,000 546,000 595,000 675,000 What is the correlation value for the relationship between advertising and sales? Please round your answer to the nearest hundredth.
Consider the following sample data for the relationship between advertising budget and sales for Product A:...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 50,000 60,000 60,000 70,000 70,000 80,000 90,000 90,000 100,000 110,000 Sales ($) 299,001 371,000 364,000 430,000 440,000 485,000 535,000 546,000 595,000 675,000 What is the predicted sales quantity for an advertising budget of $76,000? Please round your answer to the nearest integer. Note that the correct answer will be evaluated based...
Consider the following sample data for the relationship between advertising budget and sales for Product A:...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 100,000 110,000 110,000 120,000 130,000 130,000 140,000 150,000 150,000 160,000 Sales ($) 603,000 676,000 655,000 748,000 796,000 785,000 858,000 891,000 935,000 980,000 What is the slope of the "least-squares" best-fit regression line? Please round your answer to the nearest hundredth.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT