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.
orchestra answered 2 years agoRelated 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
Latest Questions
- Write a program that computes the tax and tip on a restaurant bill for a patron...
- clear all close all % %*******Parameter Settings******** %********************************* Fs=8192; %Sampling frequency (MATLAB's default) Ts=1/Fs; %Sampling time...
- Name a business that you believe has experienced declining costs attributable to computerization. Were variable costs...
- With C++, 1. Assume we use two linked lists that represent Set A and Set B...
- A beam of light shines on an equilateral glass prism at an angle of 45∘ to...
- This is an intro to python question. #Write a function called search_for_string() that takes two #parameters,...
- C++ Give an example of overloading by implementing a function square(x), which calculates the square of...
ADVERTISEMENT