Question

In: Statistics and Probability

1. The following table shows the salaries of five managers and their years of work experience...

1. The following table shows the salaries of five managers and their years of work experience in managerial positions.

Years of Salary Experience ($1000s)

6 120

5 95

4 88

10 150

5 97

a. Use the method of Ordinary Least Square (OLS) to compute the slope

and intercept of sample regression line. You need to decide which

one is the dependent variable. In addition, write down the estimated

sample regression line.

b. Explain the meaning of each estimated coefficient (slope and

intercept) in the context of this problem and plain English.

c. Use a = 0.05 to check if β1 is statistically equal to or different from zero. What is your conclusion?

e. Use 1 -α = 0.99 to estimate a confidence interval for the salary of managers who have 8 years of experience.

Please explain steps to the best ability

Solutions

Expert Solution

ANOVA table

Source DF Sum of Square Mean Square F Statistic P-value
Regression
(between ŷiand yi)
1 2446.545455 2446.545455 55.834025 0.00496370
Residual
(between yiand ŷi)
3 131.454545 43.818182
Total(between yiand yi) 4 2578.000000 644.500000

Related Solutions

The data shown in the table were collected by surveying 100 employees with five years’ experience....
The data shown in the table were collected by surveying 100 employees with five years’ experience. Find the correlation relationship for the data. Use Microsoft Excel. Create a scatter plot. Identify and discuss the type of correlation, and whether is negative or positive, strong or weak. Create a regression line and analyze the coefficients for significance. Predict the estimates salary with 20 years of schooling. Years of schooling Total annual salary 10 $32 K 12 $33 K 13 $44.3 K...
The following table shows the means of transportation to work for the U.S. in 1990 and...
The following table shows the means of transportation to work for the U.S. in 1990 and 2000. The data values in the columns of “Percentage in 1990” and “Percentage in 2000” are the percentages of each travel mode in 1990 and in 2000 respectively using two independent and random samples. We want to do a hypothesis test and see whether the travel modes have been significantly changed from 1990 to 2000. Table: The means of transportation to work for the...
The accompanying table shows the annual​ salaries, in thousands of​ dollars, earned by a sample of...
The accompanying table shows the annual​ salaries, in thousands of​ dollars, earned by a sample of individuals who graduated with MBAs in the years 2012 and 2013. Perform a hypothesis test using α equals= 0.05 to determine if the median salary for 2012 MBA graduates is lower than 2013 MBA graduates. Salaries​ (in thousands of​ dollars) for 2012 MBA graduates 92.6 66.1 60.6 85.5 92.8 44.7 84.4 81.1 44.2 94.3 66.6 61.6 94.6 81.6 Salaries​ (in thousands of​ dollars) for...
Here is some data looking at people's salaries, their years of experience, and their average evaluation....
Here is some data looking at people's salaries, their years of experience, and their average evaluation. Please cut and paste it into excel and run the following regression: Salary = b0 + b1*Experience + b2*Eval Salary Years of experience Average evaluation $ 56,744.30 5 6.85 $ 49,875.12 0 2.92 $ 64,629.44 6 1.69 $ 53,148.67 2 1.89 $ 56,130.69 8 4.93 $ 57,246.71 4 5.87 $ 51,097.09 0 5.09 $ 50,303.00 0 6.42 $ 56,212.37 2 4.2 True/false. The eval...
Description Here is some data looking at people's salaries, their years of experience, and their average...
Description Here is some data looking at people's salaries, their years of experience, and their average evaluation. Please cut and paste it into excel and run the following regression: Salary = b0 + b1*Experience + b2*Eval Salary Years of experience Average evaluation $ 56,744.30 5 6.85 $ 49,875.12 0 2.92 $ 64,629.44 6 1.69 $ 53,148.67 2 1.89 $ 56,130.69 8 4.93 $ 57,246.71 4 5.87 $ 51,097.09 0 5.09 $ 50,303.00 0 6.42 $ 56,212.37 2 4.2 Instructions Question...
please show work on Question 3 2. The following table shows stock prices (May 1, 2017,...
please show work on Question 3 2. The following table shows stock prices (May 1, 2017, closing), EPS 2016 actual, 2017 forecast, 2018 forecast, and 2016 dividend for the three chemical companies. Stock Price EPS, 2016 Actual EPS, 2017 EPS, 2018 Dividend DuPont 79.49 2.77 3.84 4.09 1.52 Dow 62.52 3.52 4.07 4.41 1.84 PPG 109.46 5.82 6.26 6.92 1.56 Given the information above, calculate PE for the three definitions of EPS, dividend yield, and dividend payout. Price/Actual EPS Price/2017...
The following table shows the average distance, to the nearest mile, travelled per week to work...
The following table shows the average distance, to the nearest mile, travelled per week to work by a random sample of 350 commuters. Miles Travelled Frequency Midpoint Class Boundaries 6 - 11 43 12 - 17 32 18 – 23 80 24 - 29 120 30 - 35 75 (a) Complete the table above. (b) What is the mean distance travelled per week by these commuters? (c) Why is the answer for part (b) an estimate of the mean distance...
The following table shows the actual demand observed over the last 11 years
The following table shows the actual demand observed over the last 11 years Year1234567891011Demand7951013713149118This exercise contains only parts b, c, and d.b) Using the 3-year moving average, provide the forecast from periods 4 through 12 (round your responses to one decimal place). Year456789101112Forecastc) Using the 3-year weighted moving average with weights 0.20. 0.35. and 0.45. using 0.45 for the most recent period provide the forecast from periods 4 through 12.Year456789101112Forecastd) Mean absolute deviation for the forecast developed using the 3-year moving average...
The following table shows income statement and balance sheet data for five U.S. industries in 2017....
The following table shows income statement and balance sheet data for five U.S. industries in 2017. INCOME STATEMENT AND BALANCE SHEET FOR 2017 SELECTED U.S. INDUSTRIES FOR 2017 (Figures in $ billions) Food Pharmaceuticals Oil and Coal Computers and Peripherals Food Stores Income Statement Data: Sales $ 679.9 $ 440.5 $ 815.0 $ 229.0 $ 487.2 Cost of goods sold 609.1 365.4 770.8 215.7 464.0 Balance Sheet Data: Inventory $ 80.8 $ 69.8 $ 57.2 $ 24.3 $ 40.9 Accounts...
The following table shows income statement and balance sheet data for five U.S. industries in 2017....
The following table shows income statement and balance sheet data for five U.S. industries in 2017. INCOME STATEMENT AND BALANCE SHEET FOR 2017 SELECTED U.S. INDUSTRIES FOR 2017 (Figures in $ billions) Food Pharmaceuticals Oil and Coal Computers and Peripherals Food Stores Income Statement Data: Sales $ 666.9 $ 427.5 $ 802.0 $ 216.0 $ 474.2 Cost of goods sold 596.1 352.4 757.8 189.7 451.0 Balance Sheet Data: Inventory $ 67.8 $ 56.8 $ 44.2 $ 11.3 $ 27.9 Accounts...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT