DrGull3023
Ask for help,I ready can not understand!!! MISY 5380 home work I…
Ask for help,I ready can not understand!!!
MISY 5380 home work I saw someone posted but can not see pictures.
Rubric for Assignment 2 page 83 P02_03
Problem 2 (18 points): page 83 P02_03
Crosstabs: 2 points (Note: you have to do this table using Excel’s COUNTIFS function! You will redo this table with the PIVOT TABLE function in the last problem. You will not get credit if you do not do it with COUNTIFS).
Column chart: 2 points. Remember that the crosstab is a table whereas the column chart is a graph. They are not the same thing. It is very important that the percentages for either gender add to 100%.
Do the two genders differ in their opinions? 2 points.
Same as part a) but know you are looking at the relationship between Age and Opinion (6 points distributed as in part a)
Same as part a) but know you are looking at the relationship between recoded salary and Opinion (6 points distributed as in part a).
Problem 8 (18 points) p. 91 P02_07
The fastest way to do this problem is using Minitab. You need to do the recoding first and then on Minitab you can look at salaries by gender, education and age. You can also use PivotTable in Excel but you can only calculate the mean and standard deviation or you can use Tables in Excel and by using filters you can find the three measures.
Gender recoding (2 points). Mean of Males (1 point), mean of females (1 point), median of males (1 point), median of females (1 points), std. dev of males (1 points) std. dev. of females (1 points).
Education recoding (2 points). 1 point for getting the mean, median and std. dev. of new Education level 1. 1 point for getting the mean, median and std. dev. of new Education level 2. 1 point for getting the mean, median and std. dev. of new Education level 3.
Age recoding (2 points). 1 point for getting the mean, median and std. dev. of Young. 1 point for getting the mean, median and std. dev. of Middle-Aged. 1 point for getting the mean, median and std. dev. of Older.
Problem 21 (16 points): p. 103 P02_07
Table of correlations (4 points)
Which one is most highly correlated with salary? (1 point)
Create scatterplots (6 points, 2 points each scatterplot). Do not forget to label the axis.
Include a linear trend and equation in the scatterplot of the most highly correlated variable from part a)(3 points)
Interpret the equation, specifically what happens with Salary if the most highly correlated variable increases by 1? (2 points)
Problem 34: (18 points) p.126 P02_03
Here you need to provide three crosstabs and three column charts constructed with PIVOT TABLES and with the sum of the row percentages being equal to 100% (6 points). Interpret the results in terms of how the variables are related (3 point).
Then you need to provide another three crosstabs and three column charts constructed with PIVOT TABLES and with the sum of the column percentages being equal to 100% (6 points). Interpret the results in terms of how the variables are related (3 points).
