The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Jul 2017 |
| Last Sign in: | 362 Weeks Ago, 1 Day Ago |
| Questions Answered: | 5502 |
| Tutorials Posted: | 5501 |
MBA.Graduate Psychology,PHD in HRM
Strayer,Phoniex,
Feb-1999 - Mar-2006
MBA.Graduate Psychology,PHD in HRM
Strayer,Phoniex,University of California
Feb-1999 - Mar-2006
PR Manager
LSGH LLC
Apr-2003 - Apr-2007
1. Shown below is a portion of an Excel output for a regression analysis relating Y (dependent variable) and X (independent variable).
Â
|
ANOVA |
 |
 |
 |
|
|
 |
df |
SS |
 |
|
|
Regression |
1 |
24.011 |
 |
|
|
Residual |
8 |
67.989 |
 |
|
|
 |
 |
 |
 |
|
|
 |
Coefficients |
Standard Error |
t Stat |
P-value |
|
Intercept |
11.065 |
2.043 |
 5.415 |
0.001 |
|
x |
 -0.511 |
0.304 |
-1.681 |
0.131 |
Â
1.   What is the estimated regression equation that relates y to x? (2 points)
2.   Is the regression relationship significant? Use a p-value and alpha = 0.05. (2 points)
3.   What is the estimated value of y if x = 12? (2 points)
4.   Interpret the meaning of the value of the coefficient of determination if it is 0.26 in this case. Be very specific. (2 points)
2. Salary information regarding male and female employees of a large company is shown below.
Â
|
 |
Male |
Female |
|
Sample Size |
64 |
36 |
|
Sample Mean Salary (in 1,000) |
44 |
41 |
|
Sample Standard Deviation |
128 |
72 |
Â
1.   What is the set of null and alternative hypotheses if we want to determine whether the mean salary of male and female employees is the same? (2 points)
2.   Using a level of significance of 0.05, what is the rejection rule for this test using the critical value approach if the degrees of freedom (df) for this test is given to be df = 97? (2 points)
3.   Calculate the t statistic. (2 points)
4.   Based on the above, what is the conclusion of this statistical test? (2 points)
Â
Â
Â
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l