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
Find an equation for y (in terms of β and α). Then find tan y.
dmitriy555 [2]

This can be expanded through the tangent angle addition formula:

tan(α+β)=tanα+tanβ1−tan -α + tanβ

Thus,tan(x+y)=tanx+tany1−tan x tany

Hope it helps you

7 0
3 years ago
Read 2 more answers
Please help me volume is 9881.25 but yeah please help mee
erik [133]

Answer:

20.4

Step-by-step explanation:

see image

5 0
2 years ago
A biology experiment calls for 10 milliliters of water. How much water does the experiment call for in centiliters? (a.1 (b10 (c
Tasya [4]
It will call for A: One Centiliter. It's the same terms for stuff like millimeters and centimeters, 1 cm = 10 mm, 1 cl = 10 ml
7 0
3 years ago
CAN SOMEONE HELP ME WITH THIS?
Phoenix [80]

Answer:

The answer is 938. ;}

Step-by-step explanation:

7 0
2 years ago
Read 2 more answers
Mrs. Jones has a local bakery. Last week this expression shows how many peanut butter cupcakes she baked. 5 (2x -4) + 3(3 + 4x)
3241004551 [841]

Answer:

A. 22x-11

B. 121 cupcakes

Step-by-step explanation:

Part A:

The simplified form of the expression is

5(2x-4)+3(3+4x)

(10x-20)+(9+12x)

(10x+12x)+(9-20)

22x-11

Part B:

Put x=6 in the above simplified equation to get the number of cupcakes Mrs. Jones bake last week

22x-11

22(6)-11

132-11

121 cupcakes

8 0
3 years ago
Other questions:
  • 20) What is the mode of this distribution? A) 13 B) 16 C) 18 D) 20
    7·1 answer
  • A rectangular field is 450 meters long and 400 meters wide. What is the area of the field in square kilometers?
    12·2 answers
  • What's the answer? :P idk what to do haha just some extra points 2x=9.5​
    14·2 answers
  • What is r in this equation?<br> 3 3/4 + r = 5 3/8
    5·2 answers
  • Can someone give me the answer for this one
    14·1 answer
  • A new car is purchased for 17900 dollars. The value of the car depreciates at 13% per
    9·1 answer
  • 129<br> -21x + 8<br> -9x + 13<br> -2
    5·2 answers
  • Write an equation in slope-intercept form of the line that passes through the given point and is parallel to the graph of the gi
    14·2 answers
  • PLEASE ANSWER ASAP FOR BRAINLEST!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    12·2 answers
  • Which of the following are true statements about the expression 5 + (-5)?​
    5·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!