C 0 H 1 Below (in column A) are the income per capita for a sample...

Transcribed Image Text:

C 0 H 1 Below (in column A) are the income per capita for a sample of 50 different households 2 Use Excel to draw a histogram on the frequency distribution of per capita income, 3 and provide an appropriate label for each of the horizontal and vertical axes, Your first histgram bin or class (used in excel) could be 18000<22000 (You may use other consistent settings as well.) 5 Place the histogram within the highlighted box below. 1 7 . 0 10 11 13 14 15 16 17 18 19 20 21 23 24 P 27 29 30 31 32 33 M4 3 37 M 41 4 4 44 45 40 4T 48 49 50 81 12 50 54 56 M ST 54 seb 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Per Capita Income 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 27 489 28,066 19,373 25,184 24,447 20,247 1 K L M N 0 C 0 H 1 Below (in column A) are the income per capita for a sample of 50 different households 2 Use Excel to draw a histogram on the frequency distribution of per capita income, 3 and provide an appropriate label for each of the horizontal and vertical axes, Your first histgram bin or class (used in excel) could be 18000<22000 (You may use other consistent settings as well.) 5 Place the histogram within the highlighted box below. 1 7 . 0 10 11 13 14 15 16 17 18 19 20 21 23 24 P 27 29 30 31 32 33 M4 3 37 M 41 4 4 44 45 40 4T 48 49 50 81 12 50 54 56 M ST 54 seb 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 Per Capita Income 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 21,500 27 489 28,066 19,373 25,184 24,447 20,247 1 K L M N 0