Question: 14. Use the 'Salareis' data set that shows the first 5 observations as follows. index rank discipline phd service sex salary 1 Prof B

14. Use the 'Salareis' data set that shows the first 5 observations as follows. index rank discipline phd service sex salary 1 Prof B 19 18 Male 139750 2 Prof B 20 16 Male 173200 3 AsstProf B 4 3 Male 79750 4 Prof B 5 Prof B 40 445 39 Male 115000 41 Male 141500 15. 1) Select female professors whose 'service' years is greater than 20 years 2) Sort the result of (1) in decreasing order by 'salary' 3) Calculate the average salary of the result of (1). Use 2 decimal places. 4) Calculate the average salary and standard deviation of professors' salaries by group of 'sex' and 'rank'

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

at A xy The material distorts into the dashed position shown below. a. Determine the average normal strains Ex Ey, and the shear strain b. Determine the average normal um along line BE. c. Determine...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...

14. Use the 'Salareis' data set that shows the first 5 observations as follows. 1) Select female professors whose 'service' years is greater than 20 years 2) Sort the result of (1) in decreasing...

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

413-432_CH18_Nachmias.qxd 1/17/07 3:47 PM Page 413 Chapter Index Construction and Scaling Methods INDEX CONSTRUCTION The Purpose of the Index The Sources of the Data The Base of Comparison Methods of...

ID Salary Compa- Midpoint ratio Age Performance Service Gender Rating Raise Degree Gender Grade 1 Copy Employee Data set to this page. The ongoing question that the weekly assignments will focus on...

PLEASE ANSWER ME THE QUES 7 AND 8 , THANKS VERY MUCH. NEEDING DETAILED INFORMATION. \freport high account receivable or low current liabilities segregation of duties,double checks, recheck the...

2.2 51 Summarizing Data for a Quantitative Variable Exercises Methods 11. Consider the following data. WEB 14 19 24 19 16 20 24 20 file Frequency a. b. SELF test 21 22 24 18 17 23 26 22 23 25 25 19...

COMM 215: BUSINESS STATISTICS REVIEW PROBLEMS 1 Descriptive Statistics 1. The listing below gives the service window of A&W: 4.91 0.85 0.52 2.51 1.92 2.66 1.94 5.19 2.33 3.51 2.95 2.62 service times...

(a) Draw the Lewis structures for at least four species that have the general formula where X and Y may be the same or different, and n may have a value from +1 to -2. (b) Which of the compounds is...

3. The rise of what is known as business-process outsourcing (BPO) in the Philippines has been nothing short of phenomenal. The very first calls were taken in 1997; today the sector employs 638,000...

22. Shareholder Risk (LO1) Suppose a firm's business operations are such that they mirror movements in the economy as a whole very closely; that is, the firm's asset beta is 1.0. Use the result of...

1. You are the Online Marketing Manager for a travel company that specializes in family-friendly wildlife tours within South India. You wish to run Display Ads using Google Ads to drive awareness and...

1. Define the word "TEAM" T = E = A = M = Why did you choose it? Give an example of Team Work! 2. A proposal reinforces what you will do, how and when you will do it, and the evidence you will do. A...

You are a sales manager of a retail shore and your success is judged by total revenue. can use economics to determine which items should never be placed on sale and which items can help you obtain...

R1=500 R2= 500 L=1H Find U0 A. U 0(1+) = u 0(-1) B. U( 0(1+) = 0.5V, C. U 0(1+) = 0V D. U 0(1+) = I L(1-) R 2 104. a),R, = 5000,R:= 5000, L=1H,U, b), U,>0,:. A. U1+)=uo(1-) B. Ux1+) =0. 5V C. Ux1+)...

Evaluating Positioning Strategies This activity is important because entrepreneurs and managers need to position their companies to sell in underserved and uncrowded markets. Provided that the...

The final paragraph suggests that Pasteur was mistaken about A) The chemical composition of living cells B) The possibility of life arising from nonliving matter C) When the earliest forms of life...

Which of the following sentences serves as the most effective concluding sentence for this paragraph? A) NO CHANGE B) As what Charlie Chaplin C) Than Charlie Chaplin D) As Charlie Chaplin.

Circle the correct pronoun in each sentence. The climb was much easier for Camille than it was for Jeff and (I/me/myself).

An annuity consists of quarterly payments of $950 for 8 years and 9 months. Discounting at 8% compounded quarterly, determine the present value of the annuity if the payments are made: a. At the end...

Rino has just purchased a five-year term life insurance policy. For his premium payments, Rino can choose either beginning-of-month payments of $38.50 or beginning-of-year payments of $455. In...

Other factors being equal, is the PV of an annuity due larger if the given nominal discount rate is compounded monthly instead of annually? Explain briefly.