In: Statistics and Probability
How do I create a histogram for the following set of data?
Legend:
Result (1-100)
Age and gender are self explanatory
Relationship (are you in a romantic relationship?)
Medu (Mothers highest lvl of education. 1= year 10; 2= year 12;
3=bachelor; 4= post grad
Lectures (how many lectures missed)
Tutorials (How many tutorials missed)
RESULT | Gender | Age | Medu | Relationship | Lectures | Tutorials |
55 | F | 20 | 4 | NO | 4 | 3 |
55 | F | 19 | 1 | NO | 2 | 3 |
65 | M | 18 | 4 | NO | 6 | 4 |
65 | M | 18 | 2 | NO | 0 | 0 |
65 | F | 18 | 3 | NO | 0 | 1 |
Note : The method to create the histogram has been shown in the answer. You need to put the actual data and follow the steps.
Sample data for 25 observation has been created as shown below.
Find the histogram for results.
The result range from 1-100, hence we shall have 5 intervals with a
width of 20.
We shall find the number of observation that find in each interval and put in the table as shown below.
Next we plot the graph using the insert graph option in excel as shown.
This method can be used for age, Lectures and Tutorials.
Finding the histogram for gender.
Count the number of males and Female and put them in table.
Next we plot the histogram using this data as shown.