Solved

A Survey Conducted by a Research Team Was to Investigate

Question 52

Essay

A survey conducted by a research team was to investigate how the education level, tenure in current employment, and age, are related to annual income. A sample 20 employees is selected and the data is given below.  Education (No. of  years)  Length of tenure in  current employment  (No. of years)  Age (No. of years)  Annual income ($) 17840124,00012124130,00020944193,0001444288,0001211927,0001492843,0001284396,000181037110,00016123688,0001173936,00016143681,0001242238,000161745140,0001374211,0001161821,00020440151,00019735124,00016123848,0001221926,00010644124,000\begin{array}{|c|c|c|c|}\hline\begin{array}{c}\text { Education (No. of } \\\text { years) }\end{array} & \begin{array}{c}\text { Length of tenure in } \\\text { current employment } \\\text { (No. of years) }\end{array} & \text { Age (No. of years) } & \text { Annual income (\$) } \\\hline 17 & 8 & 40 & 124,000 \\\hline 12 & 12 & 41 & 30,000 \\\hline 20 & 9 & 44 & 193,000 \\\hline 14 & 4 & 42 & 88,000 \\\hline 12 & 1 & 19 & 27,000 \\\hline 14 & 9 & 28 & 43,000 \\\hline 12 & 8 & 43 & 96,000 \\\hline 18 & 10 & 37 & 110,000 \\\hline 16 & 12 & 36 & 88,000 \\\hline 11 & 7 & 39 & 36,000 \\\hline 16 & 14 & 36 & 81,000 \\\hline 12 & 4 & 22 & 38,000 \\\hline 16 & 17 & 45 & 140,000 \\\hline 13 & 7 & 42 & 11,000 \\\hline 11 & 6 & 18 & 21,000 \\\hline 20 & 4 & 40 & 151,000 \\\hline 19 & 7 & 35 & 124,000 \\\hline 16 & 12 & 38 & 48,000 \\\hline 12 & 2 & 19 & 26,000 \\\hline 10 & 6 &44& 124,000 \\\hline\end{array}
a. Check if the F test leads to conclude that an overall regression relationship exists. If yes, use the t test to
determine the significance of each independent variable. What is the conclusion for each test at the 0.05 level of significance?
b. Remove all independent variables that are not significant at the 0.05 level of significance from the estimated
regression equation. What is your estimated regression equation in this case?

Correct Answer:

verifed

Verified

a. Using the following Excel output, we ...

View Answer

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents