The file P02_45.xlsx contains the salaries of 30 business school professors at a (fictional) large state university.If you increased every professor's salary by $1,000, what would happen to the mean and median salary? IncreaseMean$Median$If you increased every professor's salary by $1,000, what would happen to the standard deviation of the salaries? If your answer is zero, enter "0". IncreaseStd. Dev.$If you increased every professor's salary by 5%, what would happen to the standard deviation of the salaries? If your answer is zero, enter "0". IncreaseStd. Dev. % AВC1ProfessorSalary$190,000$126,000$152,000$166,000$146,000$168,000$156,000$160,000$152,000$198,00021324345787810911101211$120,0001312$134,0001413$134,0001514$190,0001615$140,0001716$146,0001817$112,0001918$174,0002019$142,0002120$156,0002221$140,0002322$138,0002423$130,00025$130,000$152,000$182,000$180,000$182,000$138,000$102,00024262527262827292830293130323334LO

Name: The file P02_45.xlsx contains the salaries of 30 business school profe
Uploaded: 2024-03-20T07:06:16.000Z
Channel: Bartleby
Description: The file P02_45.xlsx contains the salaries of 30 business school professors at a (fictional) large state university.If you increased every professor's salary by $1,000, what would happen to the mean and median salary? IncreaseMean$Median$If you incre

The mean for a data set is computed by dividing the sum of the observations by total number of…

Answered: The file P02_45.xlsx contains the…

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

Concept explainers

Topic Video

Question

The file P02_45.xlsx contains the salaries of 30 business school professors at a (fictional) large state university.

If you increased every professor's salary by $1,000, what would happen to the mean and median salary?

Increase

Mean $

Median $

If you increased every professor's salary by $1,000, what would happen to the standard deviation of the salaries? If your answer is zero, enter "0".

Increase

Std. Dev. $

If you increased every professor's salary by 5%, what would happen to the standard deviation of the salaries? If your answer is zero, enter "0".

Increase

Std. Dev. %

A
В
C
1
Professor
Salary
$190,000
$126,000
$152,000
$166,000
$146,000
$168,000
$156,000
$160,000
$152,000
$198,000
2
1
3
2
4
3
4
5
7
8
7
8
10
9
11
10
12
11
$120,000
13
12
$134,000
14
13
$134,000
15
14
$190,000
16
15
$140,000
17
16
$146,000
18
17
$112,000
19
18
$174,000
20
19
$142,000
21
20
$156,000
22
21
$140,000
23
22
$138,000
24
23
$130,000
25
$130,000
$152,000
$182,000
$180,000
$182,000
$138,000
$102,000
24
26
25
27
26
28
27
29
28
30
29
31
30
32
33
34
LO

Definition Definition Middle value of a data set. The median divides a data set into two halves, and it also called the 50th percentile. The median is much less affected by outliers and skewed data than the mean. If the number of elements in a dataset is odd, then the middlemost element of the data arranged in ascending or descending order is the median. If the number of elements in the dataset is even, the average of the two central elements of the arranged data is the median of the set. For example, if a dataset has five items—12, 13, 21, 27, 31—the median is the third item in ascending order, or 21. If a dataset has six items—12, 13, 21, 27, 31, 33—the median is the average of the third (21) and fourth (27) items. It is calculated as follows: (21 + 27) / 2 = 24.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Centre, Spread, and Shape of a Distribution$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions