please explain step by step on Excel!!:

1. how do i enter the data into one column?

2. Enter the class limits and Upper limits!

Transcribed Image Text:

C D E G 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, 0 11 12 13 3 and provide an appropriate label for each of the horizontal and vertical axes. 4 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. 14 15 20 23 24 25 20 27 30 31 33 34 35 x 27 30 41 42 4 44 45 47 50 51 1848RXES 52 54 57 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 Per Capita Income 37 38 39 40 41 42 43 PEREGESS 44 45 46 47 48 49 50 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 J 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,000 19.373 25,184 24,447 20,247 K L M N O P C D E G 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, 0 11 12 13 3 and provide an appropriate label for each of the horizontal and vertical axes. 4 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. 14 15 20 23 24 25 20 27 30 31 33 34 35 x 27 30 41 42 4 44 45 47 50 51 1848RXES 52 54 57 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 Per Capita Income 37 38 39 40 41 42 43 PEREGESS 44 45 46 47 48 49 50 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 J 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,000 19.373 25,184 24,447 20,247 K L M N O P

Answer rating: 100% (QA)

Solution The his toguam is 09 20 Labra 16 14 10 2 8 The Cosy Histogram 22000 per capita income 300... View the full answer