![subject](/tpl/images/cats/mat.png)
Mathematics, 18.03.2021 01:20 justyne2004
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 =
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
![ansver](/tpl/images/cats/User.png)
Answers: 3
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Other questions on the subject: Mathematics
![image](/tpl/images/cats/mat.png)
![image](/tpl/images/cats/mat.png)
![image](/tpl/images/cats/mat.png)
![image](/tpl/images/cats/mat.png)
Mathematics, 21.06.2019 22:30, student176
Acampus club held a bake sale as a fund raiser, selling coffee, muffins, and bacon and eggs sandwiches. the club members charged $1 for a cup of coffee, 3$ for a muffin , and $4 for a back. and egg sandwich. they sold a total of 55 items , easing $119. of the club members sold 5 more muffins than cups of coffee, how many bacon and egg sandwiches he’s did they sell
Answers: 1
You know the right answer?
A sales manager collected data on annual sales for new customer accounts and the number of years of...
Questions in other subjects:
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 19.11.2020 02:20
![Konu](/tpl/images/cats/fizika.png)
Physics, 19.11.2020 02:30
![Konu](/tpl/images/cats/mat.png)
Mathematics, 19.11.2020 02:30
![Konu](/tpl/images/cats/mat.png)
Mathematics, 19.11.2020 02:30
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/obshestvoznanie.png)
Social Studies, 19.11.2020 02:30
![Konu](/tpl/images/cats/health.png)
Health, 19.11.2020 02:30
![Konu](/tpl/images/cats/geografiya.png)
![Konu](/tpl/images/cats/health.png)
Health, 19.11.2020 02:30