Assignment 3

MGMT635 Assignment 3 (20 points)
1. Using the One-Way Frequencies Task to Produce a Grouped Report (3 points)

a. Use the data set MGMT635.employee_organization and the One-Way Frequencies task to
analyze Job_Title, grouped by Department. Include only frequencies and percentages.
b. Exclude the distribution plots from the results.
c. Click Run and analyze the results. Save the report as a pdf document named Problem1.pdf and
use complete sentences to describe the frequency distribution of Job_Title for any of the three
departments in your output.
In the Accounts department, the Job_Title with the most frequency is Accountant I with 4
frequency and 23.53%. In the Administration department, the Job_Title with the most
frequency is Security Guard II with 4 frequency and 11.76%. In the Engineering department, the
Job_Title with the most frequency is Electrician II with 2 frequency and 22.22%.
2. Creating a Summary Report of Salary by Department (2 points)

Use the data set MGMT635.employee_master and the Summary Statistics task to generate a report
analyzing the salaries of all employees by department.
a. Use the Summary Statistics task to generate a report on the Salary column by Department.
b. Include the mean, minimum, maximum, and median salary for each group.
c. Create an output SAS data set named salary_summary that includes the calculated statistics.
d. Run the task and view the report. Provide the screenshot of the report and use complete sentences
to describe the results in the report.
Executives is the Department with highest mean salary with $288331.5, and the same Department
has the highest maximum with $433800.
e. Save the task as Salary by Dept Summary. The type should be SAS Studio Task Template
(*.CTK).
f. Export the output data to an Excel file named Salary_Summary.csv.
3. Creating a Summary Report of Salary by Department and State (2 points)

a. Use the data set MGMT635.employee_master and the Summary Statistics task to summarize
Salary by Department first, and then by State.
b. Include the mean, minimum, maximum, and median salary for each group.
c. Run the task and view the report. Provide the screenshot of the output and use complete sentences
to describe the output.
Executives department has the highest mean salary in FL with $338495.0 and has the highest paid
employee with $433800.0.
d. Save the task as Salary by Dept/State Summary.
3
Partial Results
4. Modifying the default Summary Statistics Task to Include an Additional Statistic (2 points)
a. Use the data set MGMT635.employee_master and the Summary Statistics to summarize Salary
by Country.
b. Include the mean, minimum, maximum, and median salary for each group, and create a
histogram.
c. Within the Summary Statistics task, on the OPTIONS tab, expand Additional Statistics. Select
the Skewness box. Click Run.
 Skewness is a measure that indicates to what degree the distribution of data values has a
longer tail to the left or to the right. For the Salary distribution for both US and AU,
there are a few extreme values at the high end and a concentration of values at the low
end of the distribution, so the right tail of the distribution curve is longer (right-skewed).
For such data, the skewness statistic is greater than zero. If the data are left-skewed, the
skewness statistic is less than zero.
d. Examine the output and verify that the additional skewness statistic is added to the results.
Provide the screenshot of the report and use complete sentences to describe the skewness of
salary in the report.
AU had a right skewness of 5.0654 and EU has a right skewness of 6.1804.

5. Using the Filter Data Task to Display San Diego Employees (2 points)
Partial Results
a. Select the MGMT635.EMPLOYEE_ADDRESSES data set and use the Filter Data task so that
only San Diego employees are included in the report.
b. Save the output data set as FILTER_ADDRESS_SD.
c. Click Run.
d. Select Tasks  Data  List Data. Use the filtered data set and include the following variables:
Employee_ID, Employee_Name, Street_Number, Street_Name, and Postal_Code.
e. Click Run
f. Save the project as output_SanDiego.
g. Provide screenshot of the SAS output from parts c and e.
5
6. Creating a Grouped List Report for All Employees from Australia (2 points)
a. Select the MGMT635.EMPLOYEE_ADDRESSES data set and use the Filter Data task so that
all employees from Australia are included in the report.
 Include all variations of AU.
b. Save the output data set as FILTER_ADDRESS_AU.
c. Click Run.
d. Select Tasks  Data  List Data. Use the filtered output data set, filter_address_au, and
include the following variables: Employee_ID, Employee_Name, Street_Number,
Street_Name, and Postal_Code.
e. Click Run.
f. Save the project as output_AU.
g. Provide screenshot of the SAS output from parts c and e.
7
7. Creating a Vertical Bar Chart That Graphs Total Salary for Each City (2 points)
a. Use the Bar Chart task and select MGMT635.EMPLOYEE_DETAIL as the data set to analyze.
b. Create a vertical bar chart that shows the sum of Salary for each value of City.
c. Change the following options:
1) Title the graph Total Salary for Each City and change Data skin to Matte.
2) Show data labels at the top of each bar with the sum of Salary.
3) Label the bar height (vertical) axis as Total Salary.
d. Run the task and review the results. Provide the screenshot of the bar chart and use complete
sentences to analyze the distribution of total salary across different cities.
The city with the highest total salary is Miami-Dade with $4,771,000.00. The city with the least
total salary is Melbourne with $1,215,850.00.
8. Creating a Two-Dimensional Scatter Plot (3 points)

Management wants to see how an employee's birthdate relates to his or her hire date. Produce a report
that addresses this request.
a. Use the Scatter Plot task and select MGMT635.EMPLOYEE_PAYROLL as the data set to
analyze.
b. Create a scatter plot that shows Employee_Hire_Date and Birth_Date.
c. Add a linear regression interpolation line to the graph.
d. Name the scatter plot Hiring Trends.
e. Select Run and analyze the results.
f. Are there any trends or changes in the hiring practices of the company? Provide the screenshot of
the scatter plot and use complete sentences to answer this question.
Most of the data falls close to the regression line, which means that older employees where higher
before younger employees.
9. Using the Pie Chart Task to Analyze Salary by Department (2 points)
a. Use the Pie Chart task and select MGMT635.EMPLOYEE_DETAIL as the data set to analyze.
The slices should represent the sum of Salary for each department.
b. Show the department name and salary total outside each slice.
c. Change the title to Total Salary by Department and run the task.
d. Select Run.
9
e. Provide the screen shot of the pie chart and use complete sentences to analyze the salary across
different departments.
The department with the highest total salary is the Sales department with $5,528,115.0.
Deliverables:
Include all your answers to problems 1 to 9 in Microsoft Word and turn-in the word document, Problem1.pdf and
Salary_Summary.csv via Learn.

Assignment 3

Uploaded by

Copyright:

Available Formats

Assignment 3

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Assignment 3

Uploaded by

Copyright:

Available Formats

MGMT635 Assignment 3 (20 points)

1. Using the One-Way Frequencies Task to Produce a Grouped Report (3 points)

2. Creating a Summary Report of Salary by Department (2 points)

3. Creating a Summary Report of Salary by Department and State (2 points)

AU had a right skewness of 5.0654 and EU has a right skewness of 6.1804.

8. Creating a Two-Dimensional Scatter Plot (3 points)

You might also like