subject
Mathematics, 27.04.2021 15:50 mariahrmunoz01

A sales manager collected data on annual sales for new customer accounts and the number of years of experience for a sample of 10 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 = fill in the blank
b0 = fill in the blank
Complete the estimated regression equation (to 1 decimal).
y= + x fill in the blank 5x
According to this model, what is the change in annual sales ($1000s) for every year of experience (to 1 decimal)?
fill in the blank
Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1.
r2 = fill in the blank
What percentage of the variation in annual sales ($1000s) can be explained by the years of experience of the salesperson (to 1 decimal)?
fill in the blank %
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)?
$ fill in the blank
Salesperson Years of Experience Annual Sales ($1000s)
1 2 78
2 4 94
3 4 87
4 4 104
5 5 107
6 9 109
7 9 124
8 10 121
9 10 122
10 14 131

ansver
Answers: 2

Another question on Mathematics

question
Mathematics, 21.06.2019 17:30
The marriott family bought a new apartment three years ago for $65,000. the apartment is now worth $86,515. assuming a steady rate of growth, what was the yearly rate of appreciation? what is the percent of the yearly rate of appreciation?
Answers: 1
question
Mathematics, 21.06.2019 20:30
Arectangle has a width of 5 cm and a length of 10 cm. if the width is increased by 3, how does the perimeter change?
Answers: 1
question
Mathematics, 21.06.2019 22:30
Abucket of paint has spilled on a tile floor. the paint flow can be expressed with the function p(t) = 6(t), where t represents time in minutes and p represents how far the paint is spreading. the flowing paint is creating a circular pattern on the tile. the area of the pattern can be expressed as a(p) = 3.14(p)^2 part a: find the area of the circle of spilled paint as a function of time, or a[p(t)]. show your work. part b: how large is the area of spilled paint after 8 minutes? you may use 3.14 to approximate pi in this problem.
Answers: 2
question
Mathematics, 22.06.2019 00:30
What is the mean of the data set 125, 141, 213, 155, 281
Answers: 2
You know the right answer?
A sales manager collected data on annual sales for new customer accounts and the number of years of...
Questions
question
Mathematics, 08.11.2020 05:20
question
Business, 08.11.2020 05:20
question
Health, 08.11.2020 05:20
question
English, 08.11.2020 05:20
question
Mathematics, 08.11.2020 05:20
Questions on the website: 13722361