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...


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



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

Extracted text: 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

Jun 03, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here