Question

7. A sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersonsa. Develop a scatter diagram for these data with years of experience as the independent variable. b. Develop an estimated regression equation that can be used to predict annual sales given the years of experience. c. Use the estimated regression equation to predict annual sales for a salesperson with 9 years of experience.Annual Sales ($1000s) 80 97 92 102 103 Years of SalespersonExperience ( 4. 4 6 4 6 119 A! 123 10 10 10 13 136

0 0
Add a comment Improve this question Transcribed image text
Answer #1

SolutionA:

Use R software:

plot function is to get the scatterplot

plot(x,y)

Rcode:

yearsofexperience <- c(1,3,4,4,6,8,10,10,11,13)
annualsales <- c(80,97,92,102,103,111,119,123,117,136)
plot(yearsofexperience,annualsales)

6 10 12 yearsofexperiencefrom scatterlot

we observe:

form:linear

strength:strong

direction:positive

Solutionb:

use lm function to fit a model.

model <- lm(annualsales~yearsofexperience)
coefficients(model)

Output:

(Intercept) yearsofexperience
80 4

Regression equation is

annualsales=80+4*years of experience

slope=4

y intercept=80

Solutionc:

annualsales=80+4*years of experience

we need to predict annualsales for years of experience =9

annualsales=80+4*9=116

ANSWER:$ 116000

Add a comment
Know the answer?
Add Answer to:
7. A sales manager collected the following data on annual sales for new customer accounts and...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 7. A sales manager collected the following data on annual sales for new customer accounts and...

    7. A sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. Salesperson Years of Experience 1 Annual Sales ($1000s) 80 97 92 102 103 2 3 file ales 3 4 4 6 8 10 10 11 13 6 7 8 9 10 111 119 123 117 136 a. Develop a scatter diagram for these data with years of experience as the independent variable....

  • A sales manager collected the following data on annual sales for new customer accounts and the...

    A sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. Years of Annual Sales Salesperson Experience ($1000s) 1 1 80 2 75 N 3 4 79 4 6 81 5 7 83 6 8 91 7 9 104 8 11 99 9 12 14 110 10 109 The data on y = annual sales ($1000s) for new customer accounts and 2 = number...

  • A sales manager collected the following data on annual sales for new customer accounts and the number of years of exper...

    A sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. Years of Experience Annual Sales ($1000s) Salesperson 80 100 119 138 153 166 168 171 180 194 The data on y = annual sales ($1000s) for new customer accounts and <= number of years of experience for a sample of 10 salespersons provided the estimated regression equation ý = 72.36 + 15.21x. For...

  • A sales manager collected the following data on x = years of experience and y =...

    A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is ý = 80 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 1 80 2 3 97 3 4 92 4 4 102 5 6 103 6 8 111 7 10 119 8 10 123 9 11 117 10 13 136 (a) Compute the residuals. Years of Experience Annual Sales ($1,000s) Residuals...

  • A sales manager collected the following data on x = years of experience and y =...

    A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is y = 82 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 80 97 102 107 103 101 119 o 128 11 127 10 13 136 (a) Compute the residuals. (a) Compute the residuals. Years of Experience Annual Sales ($1,000s) Residuals 102 107 103 101 119 128 127 136 Construct a residual plot....

  • A sales manager collected the following data on annual sales for new customer accounts and the...

    A sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. Annual Sales Years of Salesperson Experience ($1000) 80 76 86 81 91 115 118 127 132 10 10 a. Compute the residuals and choose a residual plot for this problem (to 1 decimal)

  • Question 1: Question 2: A statistical program is recommended. A sales manager collected the following data...

    Question 1: Question 2: A statistical program is recommended. A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is = 81 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 80 3 97 92 107 103 111 119 128 117 136 (a) Compute the residuals. Years of Experience Annual Sales ($1,000s) Residuals 107 103 111 119 128 117 136 Construct a residual...

  • A sales manager collected the following data on x = years of experience and y =...

    A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is ŷ = 80 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 1 80 2 3 97 3 4 97 4 4 102 5 6 103 6 8 101 7 10 119 8 10 118 9 11 127 10 13 136 (a) Compute SST, SSR, and SSE. SST= SSR= SSE= (b) Compute...

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

    a. Based on the Excel output, what is the Pearson correlation coefficient for the years of experience and annual  sales? Interpret this and write a conclusion about your answer. (5 points) b. Based on the Excel output, write the estimated simple linear regression equation to predict the annual sales  from the years of experience. Interpret the values of your regression coefficients. (5 points) c. Based on the Excel output, what is the coefficient of determination? Interpret this and write a conclusion  about...

  • A sales manager collected the following data on x = years of experience and y =...

    A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is ý = 81 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 107 103 101 119 8 9 10 10 11 13 123 127 136 (a) Compute SST, SSR, and SSE. SST = SSR = SSE = (b) Compute the coefficient of determination 2. (Round your answer to three decimal places.) 12...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT