XLMiner Analysis ToolPakAВDGKMNP1 SalespersonYears of Experience Annual Sales ($1000s)78SUMMARY OUTPUT23Anova: Single FactorRegression StatisticsMultiple RR SquareAdjusted R SquareStandard Error3396435880.907961759Anova: Two-Factor With Replication441070.8243945556561050.802443875Anova: Two-Factor Without Replication771168.0727551398710123Observations10Correlation98117Covariance10910122ANOVA111014139dfSSMSFSignificance FRegressionDescriptive Statistics1212447.544996 2447.544996 37.55667406 0.00028058213Residual8 521.3550043 65.16937553Total92968.9Exponential Smoothing1415F-Test Two-Sample for Variances16Coefficients Standard Error t StatP-valueLower 95%Upper 95%Lower 95% Upper 95%InterceptYears of Experience 4.575705731 0.746645624 6.128350028 0.000280582 2.853937836 6.297473627 2.853937836 6.2974736271776.61248931 5.883832818 13.02084741 1.14813E-06 63.04434651 90.18063211 63.04434651 90.18063211Fourier Analysis1819Histogram2021Linear Regression222324Input Y Range: $C$1:SCS1125Input X Range: $B$1:$B$112627V Labels28Constant is Zero2930V Confidence Level: 95 %3132Output Range: SJS3333O Residuals3435O Residual Plots36Standardized Residuals37O Line Fit Plots38O Normal Probability Plots3940окO 0000 VideoA 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 asample 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 spreadsheeta. Compute b; and bo (to 1 decimal).b =bo =Complete the estimated regression equation (to 1 decimal).b. According to this model, what is the change in annual sales ($1000s) for every year of experience (to 1 decimal)?c. Compute the coefficient of determination (to 3 decimals). Note: report r2 between 0 and 1.12 =What percentage of the variation in annual sales ($1000s) can be explained by the years of experience of the salesperson (to 1 decimal)?%d. A new salesperson joins the team with 6 years of experience. What is the estimated annual sales ($1000s) for the new salesperson (to the nearest whole number)?$

We have used the excel data analysis tool to run the regression analysis.

a. Compute b; and bo (to 1 decimal). b = bo = Complete the estimated regression equation (to 1 decimal). = b. According to this model, what is the change in annual sales ($1000s) for every year of experience (to 1 decimal)? c. Compute the coefficient of determination (to 3 decimals). Note: report r2 between o and 1. What percentage of the variation in annual sales ($1000s) can be explained by the years of experience of the salesperson (to 1 decimal)? d. A new salesperson joins the team with 6 years of experience. What is the estimated annual sales ($1000s) for the new salesperson (to the nearest whole number)?

a. Compute b; and bo (to 1 decimal). b = bo = Complete the estimated regression equation (to 1 decimal). = b. According to this model, what is the change in annual sales ($1000s) for every year of experience (to 1 decimal)? c. Compute the coefficient of determination (to 3 decimals). Note: report r2 between o and 1. What percentage of the variation in annual sales ($1000s) can be explained by the years of experience of the salesperson (to 1 decimal)? d. A new salesperson joins the team with 6 years of experience. What is the estimated annual sales ($1000s) for the new salesperson (to the nearest whole number)?

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Consider the following regression equation: y = -5.3 + 8.8x.What does 8.8 depict in the regression equation above? a. None of the options. b. The direction of the line. c. The point where x = 0. d. The y-intercept.
You make the bold assumption that there is a linear relationship between number of ads and sales revenues. Find the intercept, b0, and the slope, b1, of the estimated regression equation that will minimize the sum of square residuals.
2. The table below lists the annual land-line phone cost per costumer: Year 2012 2013 2014 2015 Cost ($) a. 692 610 Find a linear regression model for this data b. Interpret the slope of the model 580 C. Predict the annual land-line phone cost per customer in 2022 495 2016 434
A set of X and Y scores has SSX = 26, SSY = 10, and SP = 42. What is the slope for the regression equation? Round your answer to 2 decimal places.
Q11. If r = 0.8, then r2 = 0.64, which means that 64% of the total variation in y is explained by regression line.a. Trueb. False
d. Using the regression results reported above, please calculate and interpret the separate effects of being an athlete on college GPA for men and women.
Given r2=0.9316, SSE=60.55 and the slope of the regression equation is positive.Compute: SST= Round to 4 decimal places. SSR= Round to 4 decimal places. r= Round to 4 decimal places.
For each of the following data sets: plot the data, determine the regression equation, and add the graph of the regression to the graph.
Using the regression to model annual income, a variable for years of education has a slope = 2000. This means that the model predicts each additional year of education will yield an extra 2,000 for the average person's salary, regardless of how many total years of education a person has. A. True B. False
How many independent variables are involved in a multiple regression equation? a. One b. Zero c. Two or more d. At least three
consider the following points (1.3,2.4) (2.5,2.4) (3.3,2) (4.2,1.8) (5.1,1.6) find the equation of the regression line (round the values 2 decimal placed.
The number of banks in a country has been dropping steadily since 1984, and the trend in recent years has been roughly linear. The annual data for the years 1999 through 2008 can be summarized as follows, where x represents the years since 1990 and y the number of banks, in thousands. n=10 Ex-235 ²-5605 Ey-77.564 Ey²=603.80424 Exy-1810.155 a. Find an equation for the least squares line. b. Use your result from part a to predict the number of banks in the year 2020. c. If this trend continues linearly, in what year will the number of banks drop below 6200? d. Find and interpret the correlation coefficient.