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 |
orchestra answered 2 years agoRelated 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
Latest Questions
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
- X Company is considering the purchase of a new processor that costs $200,000. Shipping and setup...
- There are a large number of tasks involved in information technology and programming, and many of...
- Using one quantitative and one qualitative health policy research method described in this chapter, design a...
- What is the Rawls' solution to the age-old question of social (economic / distributive) justice?...
- St. Johns River Shipyards' welding machine is 15 years old, fully depreciated, and has no salvage...
ADVERTISEMENT