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 b 1 and b 0 (to 1 decimal) b 1 fill in the blank 2 b 0 fill in the blank 3 Complete the estimated regression equation (to 1 decimal) fill in the blank 4 fill in the blank 5 x According to this model, what is the change in annual sales ($1000s) for every year of experience (to 1 decimal) fill in the blank 6 Compute the coefficient of determination (to 3 decimals) Note report r 2 between 0 and 1 r 2 fill in the blank 7 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 8 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 9 Chrome File Edit View History Bookmarks Profiles Tab Window Help Fri Dec 17 12 08 PM Mail Bresemann, James L ( ) Course 21FM Stats for Busine MindTap Cengage Learning X Excel Online Student Work X Reserves and Monetary Policy X c o about blank Excel template Saved Search Dption File Home Insert Daw , PAJ Layout Formula nala Review View Help Editing Comments Aria 10 B CO General Merge Sv Conditional Formatting styles Formats Table Iov E19 D F G H I K L M N 0 P 0 R S T A 1 Selesperson 2 4 B C Years of Experience Annual $10000) 1 1 81 2 2 99 3 3 93 4 4 102 5 5 105 6 R 413 7 114 12 8 10 124 9 11 118 10 14 130 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 22 24 25 26 27 28 29 30 31 32 33 34 35 mn8888 38 10 Sheet1 Calculator Mode Automatic Worcbook Statistics Give Feedback to Microsoft 100 DEC 17 A YA PRO OP

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 30, 2024

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.

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 b ₁ and b ₀ (to 1 decimal).

b ₁ = fill in the blank 2

b ₀ = fill in the blank 3

Complete the estimated regression equation (to 1 decimal).

= fill in the blank 4 + fill in the blank 5 x
According to this model, what is the change in annual sales ($1000s) for every year of experience (to 1 decimal)?

fill in the blank 6
Compute the coefficient of determination (to 3 decimals). Note: report r ² between 0 and 1.

r ² = fill in the blank 7

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 8 %
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 9

image text in transcribed

Chrome File Edit View History Bookmarks Profiles Tab Window Help Fri Dec 17 12:08 PM ... Mail - Bresemann, James L. -( * ) Course: 21FM Stats for Busine: * | * MindTap - Cengage Learning X Excel Online Student Work X Reserves and Monetary Policy X + + c o about:blank * * : Excel template Saved - Search Dption File Home Insert Daw , PAJ Layout Formula nala Review View Help Editing Comments Aria 10 B CO General Merge Sv Conditional Formatting styles Formats Table Iov E19 D F G H I ] K L M N 0 P 0 R S T A 1 Selesperson 2 4. B C Years of Experience Annual $10000) 1 1 81 2 2 99 3 3 93 4 4 102 5 5 105 6 R 413 7 114 12 8 10 124 9 11 118 10 14 130 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 22 24 25 26 27 28 29 30 31 32 33 34 35 mn8888 38 10 = Sheet1 Calculator Mode: Automatic Worcbook Statistics Give Feedback to Microsoft 100% + DEC 17 A YA PRO OP