I need expert to answer below: I need the formula to solve this: (a) Summarize income based on age Group(multiples of 10), Gender and Marital status - Calculate Total Income and No of Population for each group (a) Split the data based on Education and copy into new work sheets for each Education category (b) Split the data based on Education and store the data in separate excel files for each Education category ... View more

2. Using the file “wages” (http://lib.stat.cmu.edu/datasets/CPS_85_Wages ) or ftp://rcom.univie.ac.at/mirrors/lib.stat.cm​u.edu/datasets/.index.html Please: a. Identify (by visualization and by analytics) which variable: education, experience or age impacts the most the variable wage. b. Male workers have higher salary than female counterparts. Do you agree or disagree, please provide supporting analysis and comments. c. Select the random sample of 5 records by EDUCATION. 3. Please explain, population, sample size and what are the circumstances that sampling is in inevitable ... View more

Hi team,   i need help to solve below calculation   Using the file “sleep” (http://www.statsci.org/data/general/sleep.txt and http://www.statsci.org/data/general/sleep.html) Please: Calculate percentile (P84, P95, P97.5 and P99.85) and sigma limits (Mean + SD, Mean + 2*SD and Mean +3*SD) of total sleep by overall danger index before and after the 5% outliers removal, and comment on the observations. ... View more