A large firm employing tens of thousands of workers has been accused of discriminating against its
female managers. The accusation is based on a random sample of 40 managers. The mean annual salary of the 20 female managers is $79,500 while the mean annual salary of the 20 male managers is $103,250. The president of the firm points out that the company has a strict policy of equal pay for equal work and that the difference may be due to other variables. Accordingly, he found and recorded the number of years of education and the number of years of experience for each of the 40 managers in the sample. Also recorded are the salary and gender (1 = female and 0 = male). The data are in attached Excel document. The president wanted to know whether a regression analysis would shed some light on the issue.
Use Microsoft Excel to run a regression of annual salary on years of education, years of experience, and gender and round up numbers in your regression results to 2 decimal points. Please use the level of significance of 10 percent (i.e. α = 0.10). On the basis of your Excel results answer following questions.
. At 10 percent level of significance, determine whether each explanatory variable
makes a contribution to the regression model. Show your work.
|
Annual Salary(in $1000.00) |
Education(in years) |
Experience(in years) |
Gender |
|
130 |
20 |
18 |
0 |
|
80 |
19 |
16 |
1 |
|
62 |
18 |
8 |
1 |
|
176 |
18 |
30 |
0 |
|
44 |
14 |
9 |
1 |
|
139 |
16 |
22 |
0 |
|
165 |
18 |
27 |
0 |
|
112 |
19 |
20 |
1 |
|
92 |
16 |
17 |
1 |
|
84 |
18 |
13 |
1 |
|
106 |
14 |
17 |
0 |
|
103 |
22 |
24 |
1 |
|
98 |
16 |
18 |
0 |
|
93 |
17 |
14 |
1 |
|
79 |
16 |
14 |
1 |
|
92 |
16 |
14 |
0 |
|
79 |
14 |
16 |
0 |
|
98 |
20 |
18 |
1 |
|
111 |
19 |
25 |
1 |
|
45 |
15 |
10 |
0 |
|
82 |
16 |
13 |
0 |
|
100 |
19 |
21 |
1 |
|
88 |
15 |
15 |
0 |
|
76 |
18 |
13 |
1 |
|
123 |
16 |
21 |
0 |
|
120 |
17 |
22 |
0 |
|
50 |
18 |
7 |
1 |
|
30 |
17 |
4 |
1 |
|
135 |
16 |
19 |
0 |
|
84 |
14 |
17 |
0 |
|
50 |
16 |
6 |
1 |
|
65 |
15 |
9 |
0 |
|
83 |
17 |
12 |
1 |
|
105 |
21 |
21 |
1 |
|
70 |
17 |
10 |
1 |
|
99 |
15 |
12 |
0 |
|
89 |
18 |
8 |
0 |
|
93 |
15 |
14 |
0 |
|
68 |
17 |
11 |
1 |
|
57 |
15 |
10 |
0 |
In: Statistics and Probability
A large firm employing tens of thousands of workers has been accused of discriminating against its female managers. The accusation is based on a random sample of 40 managers. The mean annual salary of the 20 female managers is $79,500 while the mean annual salary of the 20 male managers is $103,250. The president of the firm points out that the company has a strict policy of equal pay for equal work and that the difference may be due to other variables. Accordingly, he found and recorded the number of years of education and the number of years of experience for each of the 40 managers in the sample. Also recorded are the salary and gender (1 = female and 0 = male). The data are in attached Excel document. The president wanted to know whether a regression analysis would shed some light on the issue.
Use Microsoft Excel to run a regression of annual salary on years of education, years of experience, and gender and round up numbers in your regression results to 2 decimal points. Please use the level of significance of 10 percent (i.e. α = 0.10). On the basis of your Excel results answer following questions.
. Clearly interpret the numerical values of estimated coefficients of our explanatory
variables which are years of education, years of experience and gender.
|
Annual Salary(in $1000.00) |
Education(in years) |
Experience(in years) |
Gender |
|
130 |
20 |
18 |
0 |
|
80 |
19 |
16 |
1 |
|
62 |
18 |
8 |
1 |
|
176 |
18 |
30 |
0 |
|
44 |
14 |
9 |
1 |
|
139 |
16 |
22 |
0 |
|
165 |
18 |
27 |
0 |
|
112 |
19 |
20 |
1 |
|
92 |
16 |
17 |
1 |
|
84 |
18 |
13 |
1 |
|
106 |
14 |
17 |
0 |
|
103 |
22 |
24 |
1 |
|
98 |
16 |
18 |
0 |
|
93 |
17 |
14 |
1 |
|
79 |
16 |
14 |
1 |
|
92 |
16 |
14 |
0 |
|
79 |
14 |
16 |
0 |
|
98 |
20 |
18 |
1 |
|
111 |
19 |
25 |
1 |
|
45 |
15 |
10 |
0 |
|
82 |
16 |
13 |
0 |
|
100 |
19 |
21 |
1 |
|
88 |
15 |
15 |
0 |
|
76 |
18 |
13 |
1 |
|
123 |
16 |
21 |
0 |
|
120 |
17 |
22 |
0 |
|
50 |
18 |
7 |
1 |
|
30 |
17 |
4 |
1 |
|
135 |
16 |
19 |
0 |
|
84 |
14 |
17 |
0 |
|
50 |
16 |
6 |
1 |
|
65 |
15 |
9 |
0 |
|
83 |
17 |
12 |
1 |
|
105 |
21 |
21 |
1 |
|
70 |
17 |
10 |
1 |
|
99 |
15 |
12 |
0 |
|
89 |
18 |
8 |
0 |
|
93 |
15 |
14 |
0 |
|
68 |
17 |
11 |
1 |
|
57 |
15 |
10 |
0 |
In: Statistics and Probability
A car company wishes to test the claim that at an average of 55 mph, the stopping distance for auto brakes is 130 ft. In a random sample of 21 individuals that were tested for their breaking distance were recorded, a sample mean of 114 ft. and with a standard deviation is recorded as 20 ft. At the 5% level of significance, test the claim that the stopping distance for a car traveling at 55 mph is less than the stated 130 ft.
What is the Null hypothesis (H0); Alternate hypothesis (H1); and the direction of the test? [ Select ] ["mu=130; mu>130; left tail Test", "mu=130; mu<130; two tail Test", "mu=130; mu<130; left tail Test", "mu=130; mu<130; right tail Test"]
Which distribution is used in this case? [ Select ] ["t with 20 d.f", "t with 21 d.f", "z", "Both"]
What is the critical value? [ Select ] ["-1.7247", "1.645 and -1.645", "2.58", "1.645"]
What is the Test Statistic Value? [ Select ] ["-1", "-3.67", "-3.87", "3.67"]
What is the P-value? [ Select ] ["0.5", "0.001<pvalue<0.01", "0.001", "0.0005<pvalue<0.005"]
What is the conclusion of the test? [ Select ] ["Test is Significantly Sufficient", "Test is Incomplete", "Test is Insignificant", "Test is Significant"]
PreviousNext
In: Statistics and Probability
A car company wishes to test the claim that at an average of 55 mph, the stopping distance for auto brakes is 130 ft. In a random sample of 12 individuals that were tested for their breaking distance were recorded, a sample mean of 114 ft. Based on the previous records, the standard deviation is recorded as 20 ft. At the 10% level of significance, test the claim that the stopping distance for a car traveling at 55 mph is less than the stated 130 ft.
What is the Null hypothesis (H0); Alternate hypothesis (H1); and the direction of the test? [ Select ] ["mu=130; mu<130; right tail Test", "mu=130; mu>130; left tail Test", "mu=130; mu<130; left tail Test", "mu=130; mu<130; two tail Test"]
Which distribution is used in this case? [ Select ] ["t with 10 d.f", "z", "t with 11 d.f", "Both"]
What is the critical value? [ Select ] ["1.28 and -1.28", "1.28", "2.58", "-1.28"]
What is the Test Statistic Value? [ Select ] ["-2.77", "3.32", "1", "2.77"]
What is the P-value? [ Select ] ["0.001<pvalue<0.01", "0.0029", "0.001", "0.05"]
What is the conclusion of the test? [ Select ] ["Test is Incomplete", "Test is Significant", "Test is Insignificant", "Test is Significantly Sufficient"]
In: Statistics and Probability
Write a function called is_valid_phone_number matches that takes two int arrays and their respective sizes, and returns the number of consecutive values that match between the two arrays starting at index 0. Suppose the two arrays are {3, 2, 5, 6, 1, 3} and {3, 2, 5, 2, 6, 1, 3} then the function should return 3 since the consecutive matches are for values 3, 2, and 5.
in C++ with explanations
In: Computer Science
There are certain number of balls and they are painted
with following conditions:
1. Every two colours appear on exactly one ball.
2. Every two balls have exactly one colour in common.
3. There are 4 colours such that any three of them appear on one
ball.
4. Each ball has 3 colours.
Find number of balls and number of colours used.
(Answer: 7 balls and 7 colours)
In: Advanced Math
two-question survey of 80 of its customers, who the management of the chain believe are representative of all of their shoppers. The first question on the survey asked the shoppers to estimate their average weekly expenditures ,The resulting responses were normally distributed with a mean of $40 and a standard deviation of $8. Because the chain is considering implementing a grocery delivery service, the second question on the survey asked whether or not the respondent would be interested in using such a service. 28 of the 80 respondents said that they would like to use a delivery service and the rest said that they would not. Customers' interest in using a delivery service and their weekly spending appear to be independent of one another.
Q1. : Provide the upper bound of a 90% confidence interval for the average weekly expenditure for the chain's entire population of shoppers.
Q2.: Provide the upper bound of a 90% confidence interval for the proportion of the chain's entire population of shoppers who would be likely to use a grocery delivery service
Q3.what is the estimated proportion of the chain's customers who are both interested in home deliveries and spend at least $50 per week at the stores?
Q4.: If we know that a customer who was not surveyed spends less than $40 per week at the chain, what is the estimated probability that this customer will be interested in home delivery, based on the estimates provided by this sample
Q5. Using the estimates provided by this sample, what is our best guess as to the percentage of the chain's customers who spend between $40 and $60 per week at the chain?
In: Statistics and Probability
Consider the following two variables:
| x | y |
| 45 | 10 |
| 23 | 30 |
| 17 | 48 |
| 19 | 45 |
| 41 | 34 |
| 13 | 27 |
| 39 | 26 |
| 37 | 31 |
| 24 | 38 |
| 12 | 44 |
What is the correlation between these two variables? Use Pearson's r, and take your answer to two decimal places.
To what two-tailed critical value of Pearson's r would you compare this? Use the provided tables, assume alpha, = 0.05, and express your answer as an absolute value. Round to two decimal places.
If you were to use x to predict y, what would the unstandardized slope of the regression line be (take your answer to two decimal places)?
If you were to use x to predict y, what would the intercept of the regression line be (take your answer to two decimal places)?
| Answer Key: -0.72|-0.62, 0.63, -0.71|-0.51, 49.59|49.89 |
can some one plz explain how we get those answers.
In: Statistics and Probability
A researcher is interested in whether technology has changed people’s preferences in leisurely activities based on their age range. She chooses the concept of using eBooks as a replacement for physical books. She gathers a group of 10 individuals in each of the following age groups: 10-year-olds, 30-year-olds, 50-year-olds, and 70-year-olds. For each group she has them rate on a scale of 1-10 how much they prefer an eBook compared to a physical book. The data for this study is presented below: 10-year-olds 30-year-olds 50-year-olds 70-year-olds 8 7 5 4 7 6 4 6 9 5 6 3 10 7 9 4 5 5 10 6 6 4 4 5 7 9 3 4 9 10 5 7 8 4 4 2 9 8 7 3 For this assignment you will: State populations and hypotheses Conduct a One-way ANOVA in SPSS Report the results using proper APA format If there was a significant result, conduct post-hoc tests Describe the results to this study What are the implications of this study What are the strengths and weaknesses of this ANOVA *Be sure to include your SPSS output.
In: Statistics and Probability
A researcher is interested in whether technology has changed people’s preferences in leisurely activities based on their age range. She chooses the concept of using eBooks as a replacement for physical books. She gathers a group of 10 individuals in each of the following age groups: 10-year-olds, 30-year-olds, 50-year-olds, and 70-year-olds. For each group she has them rate on a scale of 1-10 how much they prefer an eBook compared to a physical book. The data for this study is presented below: 10-year-olds 30-year-olds 50-year-olds 70-year-olds 8 7 5 4 7 6 4 6 9 5 6 3 10 7 9 4 5 5 10 6 6 4 4 5 7 9 3 4 9 10 5 7 8 4 4 2 9 8 7 3 For this assignment you will: State populations and hypotheses Conduct a One-way ANOVA in SPSS Report the results using proper APA format If there was a significant result, conduct post-hoc tests Describe the results to this study What are the implications of this study What are the strengths and weaknesses of this ANOVA *Be sure to include your SPSS output.
In: Statistics and Probability