1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
kkurt [141]
3 years ago
11

A sales manager collected data on annual sales for new customer accounts and the number of years of experience for a sample of 1

0 salespersons. In the Microsoft Excel Online file below you will find a sample of data on years of experience of the salesperson and annual sales. Conduct a regression analysis to explore the relationship between these two variables and then answer the following questions.
Open spreadsheet
Compute b1 and b0 (to 1 decimal).
b1 =
b0 =
Complete the estimated regression equation (to 1 decimal).
= + x
According to this model, what is the change in annual sales ($1000s) for every year of experience (to 1 decimal)?
Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1.
r2 =
What percentage of the variation in annual sales ($1000s) can be explained by the years of experience of the salesperson (to 1 decimal)?
%
A new salesperson joins the team with 8 years of experience. What is the estimated annual sales ($1000s) for the new salesperson (to the nearest whole number)?
1 1 85
2 3 97
3 3 95
4 5 97
5 7 105
6 8 106
7 10 122
8 10 120
9 12 113
10 12 134
Mathematics
1 answer:
Nadya [2.5K]3 years ago
4 0

Answer:

Kindly check explanation

Step-by-step explanation:

Given :

Years of experience (X) :

1

3

3

5

7

8

10

10

12

12

Annual sales (Y) :

85

97

95

97

105

106

122

120

113

134

The estimated regression equation obtained is :

y = b0 + b1x

b0 = 82.82967

b1 = 3.46061

ŷ = 3.46061X + 82.82967

The change in annual sales for every year of experience is given by the slope value, b1 = 3.46061 = 3.5 (1 decimal place)

The Coefficient of determination R² = 0.8477 = 0.848 ( 3 decimal place).

The Coefficient of determination gives the proportion of explained variance.

About 84.8% percent variation in annual sales can be explained by years of experience of the sales person.

Using the regression equation :

ŷ = 3.46061X + 82.82967

Years of experience, x = 8

ŷ = 3.46061(8) + 82.82967 = 110.514

111 = (to the nearest whole number)

You might be interested in
Shop is giving 10% discount on each item the mark price of an item is $60 so the discount amount should be​
maxonik [38]
<h3>Answer:  $6</h3>

Explanation:

To take 10% of anything, move the decimal point 1 spot to the left.

The number 60.0 will become 6.00 or simply 6.

In other words, we chop off the 0 at the end go from 60 to 6.

6 0
2 years ago
Arianna claims that the rectangles shown below are similar, while Miguel claims that they are not similar.
yaroslaw [1]

Answer:

D

Step-by-step explanation:

5 0
3 years ago
I have hours looking for a tutor, help me please
elena-s [515]

This statement is A. True

3 0
1 year ago
Read 2 more answers
Evaluate C(6, 6).<br><br> A. Undefined <br><br> B. 0<br><br> C. 1
3241004551 [841]

I believe the answer is A. Undefined

5 0
3 years ago
Read 2 more answers
What is 5/12 of 2/5 i need help
Marianna [84]

Answer:10/60

If need to  simply it is 1/6.

Step-by-step explanation: Mutiply 5/12 by 2/5 .

5 0
3 years ago
Other questions:
  • Mr. Thompson took his 5 children
    11·2 answers
  • How do you solve -3=1+5v+1
    12·2 answers
  • Two rectangles have the same area of 24cm².The second rectangle is 4cm shorter and 1cm wider than the first.What is the length a
    13·1 answer
  • . On a school field trip, the school requires that there are 6 teachers for every 90 students. If 135 students attend the trip h
    10·1 answer
  • Use cross products to determine whether the pair of ratios 4/6 and 14/21 form a proportion. Write yes or no. *SHOW WORK*
    7·1 answer
  • 1/4 divided by 2 and 1/4 divided by 3
    11·2 answers
  • A school reserved a banquet hall for the spring dance. In addition to a $100 deposit, each couple must pay $20. If the total cos
    13·1 answer
  • Write the slope-intercept form of the equation of each line given the slope and y-intercept.
    15·1 answer
  • Brady recorded the number and color of cars in the parking lot. 45% of the cars in the parking lot were white. If Brady counted
    9·2 answers
  • Please solve this. i need help
    7·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!