1. Calculate column percentages for the table below. Once you...

1.Calculate column percentages for the table below.Once you have arrived at an answer, please write sentence or two interpreting the result.

2. Based on the column percentages, determine the direction of relationship between welfare outcome and level of education -i.e. positive relationship or negative relationship.

Welfare outcome	Education
No. H.S. Degree	H.S. Degree	Some College	Total
Low	34 ( %)	54 ( %)	78 ( %)	166 ( %)
Medium	45 ( %)	66 ( %)	63 ( %)	174 ( %)
High	65 ( %)	47 ( %)	51 ( %)	163 ( %)
Total	144 ( %)	167 ( %)	192 ( %)	503 ( %)

Question 2:

Your excel file must include the excel command/syntax and numeric answer for each question as well as a brief explanation of the logic behind the answer. So, once you have arrived at an answer for each statistic, please write sentence or two interpreting the result on the excel sheet. Please,show your work.

Consider the following values:

56, 42, 28, 23, 44, 32,33, 43, 56, 21, 21, 23, 34, 65, 52, 50, 42, 36, 57, 39, 36, 33, 33, 48.

Now, calculate the following statistics for this data-set

1. Mean
2. Median
3. Mode
4. Range
5. 66^thPercentile
6. 45th Percentile
7. Quartile 1
8. Quartile 3
9. Interquartile range
10. Sample Variance
11. Sample Standard Deviation