Question
1) A financial analyst wanted to examine the relationship between salary (in $1,000) and 4 variables: age ( X 1 = Age), experience in the
1) A financial analyst wanted to examine the relationship between salary (in $1,000) and 4 variables: age ( X 1= Age), experience in the field ( X 2= Exper), number of degrees ( X 3= Degrees), and number of previous jobs in the field ( X 4= Prevjobs). He took a sample of 20 employees and obtained the following Microsoft Excel output:
SUMMARY | OUTPUT ? | ? | ? | ? | ? |
Regression | Statistics | ? | ? | ? | ? |
Multiple R | ? | 0.992 | ? | ? | ? |
R Square | ? | 0.984 | ? | ? | ? |
Adj. R Square | ? | 0.979 | ? | ? | ? |
Std. Error | ? | 2.26743 | ? | ? | ? |
Observations | ? | 20 | ? | ? | ? |
? | ? | ? | ? | ? | ? |
ANOVA | ? | ? | ? | ? | ? |
? | df | SS | MS | F | Signif F |
Regression | 4 | 4609.83164 | 1152.45791 | 224.160 | 0.0001 |
Residual | 15 | 77.11836 | 5.14122 | ? | ? |
Total | 19 | 4686.95000 | ? | ? | ? |
? | ? | ? | ? | ? | ? |
? | Coeff | StdError | t Stat | P-Value | ? |
Intercept | -9.611198 | 2.77988638 | -3.457 | 0.0035 | ? |
Age | 1.327695 | 0.11491930 | 11.553 | 0.0001 | ? |
Exper | -0.106705 | 0.14265559 | -0.748 | 0.4660 | ? |
Degrees | 7.311332 | 0.80324187 | 9.102 | 0.0001 | ? |
Prevjobs | -0.504168 | 0.44771573 | -1.126 | 0.2778 | ? |
Note: Adj. R Square= Adjusted R Square; Std. Error= Standard Error Referring to the information above, the p-value of the Ftest for the significance of the entire regression is ________ (to 4 d.p.)
2) The number of cases of merlot wine sold by a Barossa Valley Winery in an 8-year period follows.
Year Cases of Wine 2003 270 2004 356 2005 398 2006 456 2007 358 2008 500 2009 410 201 0 376Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started