Use the table to answer the question below. Education level/Current Salary Range Below $50K Between 50K and 100K Above 100K Total 12 years or less 220 80 10 310 13 to 16 years 150 90 40 280 More than 16 years 100 70 90 260 Total 470 240 140 850 a. Complete the table below using the table above. The first cell is done for you. Work out another one by hand and then use the Chi2 sheet to get all the percentages. These percentages start in cell R5 of the Chi2 sheet. Education level/Salary Range Below $50K Between 50K and 100K Above 100K Total 12 years or less Percent of “12 years or less” that make Below 50K= 220/310 = 70.97% Percent of “12 years or less” that make 50K to 100K= Percent of “12 years or less” that make Above 50K= 275 13 to 16 years Percent of “13 to 16” that make Below 50K= Percent of “13 to 16” that make 50K to 100K = Percent of “13 to 16” that make Above 100K 290 More than 16 years Percent of “More than 16” that make Below 50K= Percent of “More than 16” that make 50K to 100K Percent of “More than 16” that make Above 100K= 565 Total b. Using the first table, run the appropriate test to determine if a person’s Salary Range is independent of their Years of Education. Copy and Paste important information from the ESP5 worksheet that you used, such as p-value, test statistic and critical value. Does the second table tend to support your answer to part b? If so, why? c. How many Two-P tests need to be run to find all the Salary Ranges and Years of Education that have significant result? Be careful. You have to think about the significant differences in percentages of people in each Salary group, but also each Years of Education group. For example, for the 50K group, we have to compare the percentage of “12 years or less” education with “13 to 16 years of education”. We will have two more Two-P tests for just the 50K group. d. If the alpha level of the original test was 0.05, what does the Bonferroni Adjustment tell us the alpha level should be on all the post-hoc tests? e. Run as many two-tailed Two-P tests as needed to determine all the Salary levels in which there are significant differences in the percentages between each pair of Education level. Give the results of each test that gave a significant result. You do not need to copy and paste anything here. Just give each pair that had significant differences in percentages with the p-value for each Two-P test that had significant differences.
Unitary Method
The word “unitary” comes from the word “unit”, which means a single and complete entity. In this method, we find the value of a unit product from the given number of products, and then we solve for the other number of products.
Speed, Time, and Distance
Imagine you and 3 of your friends are planning to go to the playground at 6 in the evening. Your house is one mile away from the playground and one of your friends named Jim must start at 5 pm to reach the playground by walk. The other two friends are 3 miles away.
Profit and Loss
The amount earned or lost on the sale of one or more items is referred to as the profit or loss on that item.
Units and Measurements
Measurements and comparisons are the foundation of science and engineering. We, therefore, need rules that tell us how things are measured and compared. For these measurements and comparisons, we perform certain experiments, and we will need the experiments to set up the devices.
Use the table to answer the question below.
Education level/Current Salary |
Below $50K |
Between 50K and 100K |
Above 100K |
Total |
12 years or less |
220 |
80 |
10 |
310 |
13 to 16 years |
150 |
90 |
40 |
280 |
More than 16 years |
100 |
70 |
90 |
260 |
Total |
470 |
240 |
140 |
850 |
a. Complete the table below using the table above. The first cell is done for you. Work out another one by hand and then use the Chi2 sheet to get all the percentages. These percentages start in cell R5 of the Chi2 sheet.
Education level/Salary Range |
Below $50K |
Between 50K and 100K |
Above 100K |
Total |
12 years or less |
Percent of “12 years or less” that make Below 50K= 220/310 = 70.97% |
Percent of “12 years or less” that make 50K to 100K= |
Percent of “12 years or less” that make Above 50K= |
275 |
13 to 16 years |
Percent of “13 to 16” that make Below 50K= |
Percent of “13 to 16” that make 50K to 100K = |
Percent of “13 to 16” that make Above 100K |
290 |
More than 16 years |
Percent of “More than 16” that make Below 50K= |
Percent of “More than 16” that make 50K to 100K |
Percent of “More than 16” that make Above 100K= |
565 |
Total |
|
|
|
|
b. Using the first table, run the appropriate test to determine if a person’s Salary Range is independent of their Years of Education. Copy and Paste important information from the ESP5 worksheet that you used, such as p-value, test statistic and critical value.
Does the second table tend to support your answer to part b? If so, why?
c. How many Two-P tests need to be run to find all the Salary Ranges and Years of Education that have significant result? Be careful. You have to think about the significant differences in percentages of people in each Salary group, but also each Years of Education group. For example, for the 50K group, we have to compare the percentage of “12 years or less” education with “13 to 16 years of education”. We will have two more Two-P tests for just the 50K group.
d. If the alpha level of the original test was 0.05, what does the Bonferroni Adjustment tell us the alpha level should be on all the post-hoc tests?
e. Run as many two-tailed Two-P tests as needed to determine all the Salary levels in which there are significant differences in the percentages between each pair of Education level. Give the results of each test that gave a significant result. You do not need to copy and paste anything here. Just give each pair that had significant differences in percentages with the p-value for each Two-P test that had significant differences.
Step by step
Solved in 2 steps