# Sales Experience and Performance Regression Equation Worksheet

Sales Experience and Performance. 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. 1. Develop a scatter diagram for these data with years of experience as the independent variable. 2. Develop an estimated regression equation that can be used to predict annual sales given the years of experience. 3. Use the estimated regression equation to predict annual sales for a salesperson with 9 years of experience. 4. From the Excel printout, find the values of SST, SSR, and SSE. 5. From the Excel printout, find the value of the coefficient of determination r2 6. From the ANOVA table, point out what is the test statistic of the t-test for the H0: b1 = 0. Make a conclusion of this test (alpha = 0.05). Risk of a Stroke. A 10-year study conducted by the American Heart Association provided data on how age, blood pressure, and smoking relate to the risk of strokes.

Assume that the following data are from a portion of this study. Risk is interpreted as the probability (times 100) that the patient will have a stroke over the next 10-year period. For the smoking variable, define a dummy variable with 1 indicating a smoker and 0 indicating a nonsmoker. a. Develop an estimated regression equation that relates risk of a stroke to the personâ€™s age, blood pressure, and whether the person is a smoker b. What is the r2 and adjusted r2? c. Perform a test to indicate whether smoking a significant factor in the risk of a stroke. Use alpha=0.05. State your hypotheses, test statistic, and results. d. Perform a test to indicate whether the multiple regression model is overall significant. Use alpha=0.05. State your hypotheses, test statistic, and results. e. What is the probability of a stroke over the next 10 years for Art Speen, a 68-year-old smoker who has blood pressure of 175? What action might the physician recommend for this patient?

Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at **EssayBell.com**

Do you have a similar assignment and would want someone to complete it for you? Click on the ORDER NOW option to get instant services at EssayBell.com. We assure you of a well written and plagiarism free papers delivered within your specified deadline.