please read and do the followings

Get perfect grades by consistently using www.college-experts.com. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

Please submit the Excel file and Word file at the same link where you downloaded the assignment document.

Assignment 1 problems

  • A human resources manager at Beta Technologies, Inc., has collected current annual salary figures and related data for 52 of the company’s full-time employees. The data are in the file Ass1-1.xlsx. In particular, these data include each selected employee’s gender, age, number of years of relevant work experience prior to employment at Beta, the number of years of employment at Beta, the number of years of post-secondary education, and annual salary.
    • Indicate the type of data for each of the six variables included in this set.
    • Use the frequency array function to form a frequency table for Beta Experience, grouping the variable into 5 equal classes beginning at 0.
    • Using StatTools, construct a frequency table and histogram with 9 classes for the ages of the employees included in this sample. Is the distribution symmetrical or skewed to the left or right?
    • Using Vlookup, recode the age variable into a new variable REC-AGE in column G, with employees younger than 30 recoded as “Young”, those from 30 to younger than 50, “Experienced”, and those 50 or above, “Mature”. Print the first 5 rows of the results.
Writerbay.net

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper