table 6.23 shows the salary structure of two departments in a hypothetical university. Using the table, answer the following questions using a microsoft excel spreadsheet. Show formulas used in the spreadsheet!a) what is the average (mean) salary of the professors? of the women professors? of the men?b) answer the same questions for the median. c) answer the same questions for the mode.d) convince someone in a few sentences that men are paid better than women. now convince someone in a few sentences that women are paid better than men. what is the contradiction? **Table 6.23: Salary Structure at a University**This table illustrates the salary distribution among professors in two departments: Physics and English, differentiated by gender.| | Physics | | English | ||--------------------------|--------------------|------------------|-------------------|------------------|| | Professors | Salary | Professors | Salary || **Women** | 1 | $100K | 8 | $50K || **Men** | 9 | $90K | 2 | $40K |**Description:**- **Physics Department:** - *Women:* 1 professor earning $100,000. - *Men:* 9 professors earning $90,000 each.- **English Department:** - *Women:* 8 professors earning $50,000 each. - *Men:* 2 professors earning $40,000 each.This table provides insight into gender distribution and salary differences within the academic departments of a university.

Given: Total women professors = 1+8 =9 Total men professors = 9+2 = 11 1 woman professor has a…

Answered: Using the table, answer the following…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

table 6.23 shows the salary structure of two departments in a hypothetical university.

Using the table, answer the following questions using a microsoft excel spreadsheet. Show formulas used in the spreadsheet!

a) what is the average (mean) salary of the professors? of the women professors? of the men?

b) answer the same questions for the median.

c) answer the same questions for the mode.

d) convince someone in a few sentences that men are paid better than women. now convince someone in a few sentences that women are paid better than men. what is the contradiction?

**Table 6.23: Salary Structure at a University**

This table illustrates the salary distribution among professors in two departments: Physics and English, differentiated by gender.

| | Physics | | English | |
|--------------------------|--------------------|------------------|-------------------|------------------|
| | Professors | Salary | Professors | Salary |
| **Women** | 1 | $100K | 8 | $50K |
| **Men** | 9 | $90K | 2 | $40K |

**Description:**

- **Physics Department:**
- *Women:* 1 professor earning $100,000.
- *Men:* 9 professors earning $90,000 each.

- **English Department:**
- *Women:* 8 professors earning $50,000 each.
- *Men:* 2 professors earning $40,000 each.

This table provides insight into gender distribution and salary differences within the academic departments of a university.

Definition Definition Measure of central tendency that is the value that occurs most frequently in a data set. A data set may have more than one mode if multiple categories repeat an equal number of times. For example, in a data set with five item—3, 5, 5, 29, 473—the mode is 5 because it occurs twice and no other value occurs more than once. On a histogram or bar chart, the element with the highest bar represents the mode. Therefore, the mode is sometimes considered the most popular option. The mode is useful for nominal or categorical data (e.g., the most common color car that users purchase), but it is problematic for continuous data because it is more likely not to have any value that is more frequent than the other.

Expert Solution