The general manager of a chain of furniture stores believes that experience is the most important factor indetermining the level of success of a salesperson. To examine this belief she records last month's sales (in$1,000s) and the years of experience of 10 randomly selected salespeople. These data are listed below.SalespersoYears ofSalesЕxperience179.31020431558186.5147122087179.2030101525Scatter plot of Sales ($1000) vs Yea rs of ex perience30-252010.1020Years at expenence What does the scatter diagram above tell you about the relationship between years of experienceand sales ($1000)?b).Determine the least squares regression line.c).Interpret the value of the slope of the regression line.d).Construct the 95% confidence interval for the slope of the population regressionequation. Does it suggest there is a linear relationship between years of experience and sales?e).about the two variables.Determine the coefficient of determination and discuss what its value tells youDiscussf).Calculate the coefficient of correlation.r =What sign does it have? Why?g).Conduct a test of the population coefficient of correlation to determine at the 5%significance level whether a linear relationship exists between years of experience and sales.

Scatter plot is used to represent the relation between two variables graphically. If the dots follows a linear trend then the relation between variables can be represented by a straight line. A least square regression line or simple linear regression equation is a linear equation with one explanatory variable and one response variable. The standard form of equation is y^=a+bx, where a is intercept and b is slope. Intercept is the value of y when the explanatory variable x is 0 and slope gives the change in response variable when explanatory variable is increased by 1 unit. Disclaimer: Since you have posted a question with multiple subparts, we will solve first three subparts for you. To get remaining subparts solved, please repost the complete question and mention the subparts to be solved.Answer (a): It can be observed from the scatter plot that the data or dots makes a straight line approximately. So it can be said that the data follows the linear trend and thus the relation between variables is linear. Answer (b): To find the regression line follow the steps given below in excel. Enter the data into 2 columns. Select the data and go to insert. Select scatter plot from different graph options. Go to quick layout. Select the layout with regression equation. This will give the following scatter plot. So the regression equation is y^=8.63+1.0817x. Answer (c): The slope of the equation is 1.0817 which gives the change in sales when year of experience is increased by 1. So if experience is increased by 1 year then sales will increased by 1.0817 (in 1000s).