NEED QUALITY ANSWER FOR THUMBS UP Make up your own dataset, this can be about an
ID: 3272831 • Letter: N
Question
NEED QUALITY ANSWER FOR THUMBS UP
Make up your own dataset, this can be about anything you find interesting, So it could be about businesses, customers, students athletes, cats, monkeys, AYTHING AT ALL.
Your dataset must have the following properties. It must be have at least 5 rows (observations) it must have at least 2 variables, (note that the name of each thing in the data set is NOT a variable). At least one of the variables must be categorical.
Pick two of the variables (make sure one of the variables is categorical) and summarize the variables with a suitable pivot table in 500 words.
Explanation / Answer
Dataset should have 5 observations , two variables and one variable categorical.
Below is the hypothetical data prepared .
The above data is the annual income of 5 people and there educational qualification .
Here we can see that educaltional qualification is nomial variable i.e it has numeric values of 5 different people and educational qualification is a categorical variable . Educational variable has 3 categories , namely - 12th grade , Graduate and Post Graduate . The data shows what is the annual income for people with higher educational qualification. When we observe the data we can see the minimum annual income is for 12th grade i.e 120000. After that the next minimum is for Graduate people i.e 450000 and 600000 and the maximum annual income is for post graduate i.e 750000. So we can observe that as the eduational qualification increases the annual income increases of the person . So the eduactional qualification and annual income are correlated with each other . Also we give codes to categories of educational qualification i.e 12th grade - 1 , graduate - 2 , post graduate - 3 . By observation we can say that annual income and educaional qualification are positively correlated with each other. If your educational qualification increases your annual income will increase too .
Pivot table :
Pivot table is simple cross sectional count of two variables .
Serial Number Annual Income Education Qualification 1 350000 Graduate 2 600,000 Post Graduate 3 120000 12th Grade 4 450000 Graduate 5 750000 Post GraduateRelated Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.