Question

In: Statistics and Probability

The annual profits for a company are given in the following table. Write the linear regression...

The annual profits for a company are given in the following table. Write the linear regression equation that represents this set of data, rounding all coefficients to the nearest ten-thousandth. Using this equation, estimate the year in which the profits would reach 413 thousand dollars.

Year (x)                Profits (y)

(in thousands of dollars)

1999 112

2000 160

2001 160

2002 173

2003 226

Can you please show step by step solution thanks.

Solutions

Expert Solution

Solution :

X Y X*Y X*X
1999 112 223888 3996001
2000 160 320000 4000000
2001 160 320160 4004001
2002 173 346346 4008004
2003 226 452678 4012009


Related Solutions

Find the linear regression line for the following table of values. You will need to use...
Find the linear regression line for the following table of values. You will need to use a calculator, spreadsheet, or statistical software. Enter your answer in the form y=mx+b, with m and b both rounded to two decimal places. x y 3 6.03 4 9.65 5 11.49 6 11.57 7 12.96 8 14.97 9 16.31 10 17.43 11 18.55
The following table of values gives a company's annual profits in millions of dollars. Rescale the...
The following table of values gives a company's annual profits in millions of dollars. Rescale the data so that the year 2005 corresponds to  x=1 . Year 2005 2006 2007 2008 2009 2010 Profits (in millions of dollars) 51.8 63.4 66.3 65.8 62.1 63.8 Use the power regression model to predict the company's profits in 2012. a) $70.2 million b) $68.6 million c) $71.5 million d) $67.7 million e) $66.6 million f) None of the above
Find the linear regression line for the following table of values, where x represents the number...
Find the linear regression line for the following table of values, where x represents the number of employees a manager supervises and y represents average percentage of incomplete tasks. You will need to use a calculator, spreadsheet, or statistical software. Round your final answers to two decimal places.
write a report in the following topic: Simple linear regression and correlation Hint: It recommended to...
write a report in the following topic: Simple linear regression and correlation Hint: It recommended to include the following topics (as much as possible): Introduction Simple linear model Random Error Method of least square Analysis of variance Testing the usefulness of the model F test Measuring the strength of the relationship Interpreting a significant regression Checking the regression assumption Diagnostic tool Residuals Estimation and prediction (it is important to include an example in the report, in addition to that it...
You are given the following payoff table with profits (in $). Decision Alternative States of Nature...
You are given the following payoff table with profits (in $). Decision Alternative States of Nature s1 s2 d1 1000 3000 d2 4000 500 Assume the following probability information is given, where I1 and I2 are the outcomes of the sample information available: P(s1) = 0.45; P(I1 | s1) = 0.7; P(I2 | s1) = 0.3 P(s2) = 0.55; P(I1 | s2) = 0.6; P(I2 | s2) = 0.4 [2] Find the values of P(I1) and P(I2). [2] Determine the...
Below is the ANOVA table for a linear regression analysis: Source SS df MS Lin Regression...
Below is the ANOVA table for a linear regression analysis: Source SS df MS Lin Regression 75 1 75 Residual 1500 60 25 Total 1575 61 (a) How many people were tested? N = ________ (b) What are the tabled (α = .05) and calculated F-values? Ftabled = ___________ Fcalc = ___________ (c) What are the two possible values for the product moment correlation (r)? r = _______ or _______ (d) Without calculating the interval, will the 95% confidence interval...
Given The following results from LINEAR REGRESSION Analysis for the variables X and Y Slope= 12.7...
Given The following results from LINEAR REGRESSION Analysis for the variables X and Y Slope= 12.7 y-intercept =3.2 n=10 SE=4.3 The equation of the regression line is …… and 95% confidence interval for the slope is…. (A)Y=3.2+12.7X, and (3.675,12.768) (B)Y=12.7+3.2X, and (2.784,12.745) (C)Y=3.2+12.7X, and (2.784,22.616)
Complete the following answers to the ANOVA summary table for a simple linear regression. SSError=120, SST=480,...
Complete the following answers to the ANOVA summary table for a simple linear regression. SSError=120, SST=480, and dfT=7. Source SS df MS F Regression              Error 120 Total 480 7 SSRegression=? dfRegression=? dfError=? MSRegression=? MSError=? F=? What proportion of variation is accounted for by the simple linear regression?
Annual net profits at a facility are shown in the table below. Total capital for the...
Annual net profits at a facility are shown in the table below. Total capital for the facility investment is known to be $ 140 000. Linear as the depreciation method in profitability calculations depreciation will be accepted. Interest type compound interest and cash flows are separated. It indicated. In case the minimum acceptable turning speed is 15%, a) Net return method, b) Investigate whether the investment is profitable using the net present value method. Years Net profits, $ / year...
In a normal simple linear regression model you are given that the variance of the error...
In a normal simple linear regression model you are given that the variance of the error term is 4. Four observations are taken, in which the X values are X=-2,1,2,3. Calculate the variance in the estimate for the slope coefficient.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT