Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Regression44609.831641152.45791224.1600.0001
Residual1577.118365.14122??
Total194686.95000???
??????
?

Coeff

StdError

t Stat

P-Value

?

Intercept-9.6111982.77988638-3.4570.0035?
Age1.3276950.1149193011.5530.0001?
Exper-0.1067050.14265559-0.7480.4660?
Degrees7.3113320.803241879.1020.0001?
Prevjobs-0.5041680.44771573-1.1260.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.

image text in transcribed
Year Cases of Wine 2003 270 2004 356 2005 398 2006 456 2007 358 2008 500 2009 410 201 0 376

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematics For Liberal Arts Majors

Authors: Christopher Thomas

1st Edition

0071544305, 9780071544306

More Books

Students also viewed these Mathematics questions

Question

2. Information that comes most readily to mind (availability).

Answered: 1 week ago

Question

3. An initial value (anchoring).

Answered: 1 week ago

Question

4. Similarity (representativeness).

Answered: 1 week ago