DESCRIPTIVE STATISTICS LAB EMPLOYEE DATA
ID 53563633773 Type Essay Writer Level Masters Style APA Sources/References 4 Perfect Number of Pages to Order 5-10 Pages
DESCRIPTIVE STATISTICS LAB EMPLOYEE DATA
In this activity, we will be learning how to use Excel to create numerical and graphical summaries for a data set.
Stat 1400 Descriptive Statistics Activity
Descriptive Statistics on Excel
In our last activity, we analyzed the demographics of the workforce for a small manufacturing company. This week we will continue to analyze the salaries of the employees of this company.
To calculate the statistical summary for the salaries, click on the Data menu at the top of the screen
Select Data Analysis at the far right (if that function is not listed you will need to add it on—see instructions at the beginning of lab activity 1). Choose Descriptive Statistics from the drop-down menu.
Click on the box for Input Range and highlight the salaries of all employees. Click on the box before Summary Statistics then click on OK. The descriptive statistics will be formatted into a table that will be displayed on a new page of the worksheet.
The graphical user interface, and application Description automatically generated
Change the name on the table to Salaries – all employees. Click on the line between column A and column B and drag it to the right to make column A wide enough for the names of the statistics. Copy and paste the table below:
Click on the Sheet 1 tab at the bottom of the screen. Now click on column B (gender) to highlight it. Then click on Diagram Description automatically generated with medium confidence on the right side of the ribbon menu at the top of the screen when you are in the home screen and select Sort A to Z. Click on ‘Expand the selection’ then click on Sort. This will sort the rows listing the female records first followed by the male records.
Click on Data on the ribbon menu at the top of the screen then click on Data Analysis at the far right. Choose Descriptive Statistics from the drop-down menu.
Click on the box for Input Range and highlight the salaries of all the female employees. Click on the box before Summary statistics then click on OK. The descriptive statistics will be formatted into a table that will be displayed on a new page of the worksheet. Make the first column wider and change the name of the table to ‘Female Salaries’. Copy and paste the table here:
Calculate the descriptive statistics for the male salaries following the same steps, but this time highlight all the male salaries for the input range. Edit the table in the same way as before. Copy and paste the table here:
Use the tables to answer the following questions:
MEAN > MEDIAN MEAN = MEDIAN MEAN < MEDIAN
What does this tell us about the shape of the histogram for the salaries of all employees? (You made this histogram in lab activity 1.)
Type ‘Female Salaries’ in cell G1. Highlight the female salaries. Select Copy from the ribbon menu at the top of the screen. Paste the female salaries in column G starting at cell 2.
Type ‘Male Salaries’ in cell H1. Highlight the male salaries. Select Copy from the ribbon menu at the top of the screen. Paste the male salaries in column H starting at cell 2.
Now highlight the female salaries and male salaries in columns G and H including the names of the columns. Click Insert on the menu at the top of the screen. Click on the All Charts tab and select Box and Whisker. Click on OK. Give the graph an appropriate title.
Copy and paste the graph below.
Use the graph to answer the following questions.
DESCRIPTIVE STATISTICS LAB EMPLOYEE DATA SOLUTION
|Do You Have Any Other Essay/Assignment/Class Project/Homework Related to this? Click Here Now [CLICK ME] and Have It Done by Our PhD Qualified Writers!!|
Tired of getting an average grade in all your school assignments, projects, essays, and homework? Try us today for all your academic schoolwork needs. We are among the most trusted and recognized professional writing services in the market.
We provide unique, original and plagiarism-free high quality academic, homework, assignments and essay submissions for all our clients. At our company, we capitalize on producing A+ Grades for all our clients and also ensure that you have smooth academic progress in all your school term and semesters.
High-quality academic submissions, A 100% plagiarism-free submission, Meet even the most urgent deadlines, Provide our services to you at the most competitive rates in the market, Give you free revisions until you meet your desired grades and Provide you with 24/7 customer support service via calls or live chats.