d descriptive statistics for categorical nominal variables the number
D. Descriptive Statistics for Categorical (Nominal) variables
The number of times a particular value is repeated for a variable is known as a frequency or count.
Counts are expressed as a percentage or tally (e.g., total number in each category). To determine how
many men and how many women are employed by the bank we could create a frequency table.
• Using a pivot table, create a frequency table for the variable gender (employee gender). Include
counts and percentage.
Using conditional formatting, highlight the row in which the percentage for gender is
greater than 50%.
Using a pivot table, create a frequency table for the variable jobcat (employment category).
Include counts and percentage.
o Using conditional formatting, highlight the row in which the percentage for the job
category or categories is greater than 50%.
9. What percent of the bank's employees are male?
10. Which employment category includes the most people?
*The amount will be in form of wallet points that you can redeem to pay upto 10% of the price for any assignment. **Use of solution provided by us for unfair practice like cheating will result in action from our end which may include permanent termination of the defaulter’s account.Disclaimer:The website contains certain images which are not owned by the company/ website. Such images are used for indicative purposes only and is a third-party content. All credits go to its rightful owner including its copyright owner. It is also clarified that the use of any photograph on the website including the use of any photograph of any educational institute/ university is not intended to suggest any association, relationship, or sponsorship whatsoever between the company and the said educational institute/ university. Any such use is for representative purposes only and all intellectual property rights belong to the respective owners.