Question

In: Statistics and Probability

Complete the following four hypotheses, using α = 0.05 for each. The week 5 spreadsheet can...

Complete the following four hypotheses, using α = 0.05 for each. The week 5 spreadsheet can be used in these analyses.

1. Mean sales per week exceed 42.5 per salesperson

2. Proportion receiving online training is less than 55%

3 Mean calls made among those with no training is at least 145

4. Mean time per call is 14.7 minutes

Using the same data set from part A, perform the hypothesis test for each speculation in order to see if there is evidence to support the manager's belief. Use the Eight Steps of a Test of Hypothesis from Section 9.1 of your text book as a guide. You can use either the p-value or the critical values to draw conclusions. Be sure to explain your conclusion and interpret that to the claim in simple terms

Compute 99% confidence intervals for the variables used in each hypothesis test, and interpret these intervals.

Write a report about the results, distilling down the results in a way that would be understandable to someone who does not know statistics. Clear explanations and interpretations are critical.

Summary Report (about one paragraph on each of the four speculations)

Appendix with the calculations of the Eight Elements of a Test of Hypothesis, the p-values, and the confidence intervals. Include the Excel formulas or spreadsheet screen shots used in the calculations. 40 144 17.4 0.00 NONE 46 145 16.8 0.00 ONLINE 37 152 19.8 0.00 NONE 47 164 15.3 0.00 ONLINE 42 135 16.1 0.00 NONE 44 169 8.9 0.00 ONLINE 52 173 18.6 0.00 ONLINE 53 184 15.2 0.00 ONLINE 49 152 22.3 0.00 ONLINE 49 166 16.2 0.00 ONLINE 45 185 13.3 1.00 ONLINE 47 157 14.3 1.00 GROUP 42 148 16.9 1.00 NONE 43 131 18.5 1.00 NONE 44 150 18.4 1.00 NONE 43 148 15.9 1.00 ONLINE 55 189 12 1.00 ONLINE 49 188 20.4 1.00 NONE 51 190 11.3 1.00 ONLINE 37 137 18.1 1.00 ONLINE 51 167 16.2 1.00 ONLINE 37 130 15.6 1.00 GROUP 37 142 18.5 1.00 NONE 46 153 14.1 1.00 ONLINE 39 149 18.8 1.00 GROUP 46 151 16 1.00 GROUP 45 158 13.9 1.00 ONLINE 46 172 12.5 1.00 ONLINE 47 188 16.3 1.00 NONE 37 148 16.2 1.00 GROUP 46 162 12.1 1.00 GROUP 52 177 14.5 1.00 ONLINE 48 175 13.7 1.00 ONLINE 40 150 10.8 1.00 GROUP 53 182 10.5 1.00 ONLINE 54 197 11.8 1.00 ONLINE 46 148 13.1 1.00 GROUP 41 153 14.7 1.00 GROUP 44 169 13.6 1.00 ONLINE 47 176 14.1 2.00 ONLINE 47 183 12.8 2.00 ONLINE 48 136 14.1 2.00 ONLINE 52 197 13.9 2.00 ONLINE 37 120 12 2.00 NONE 49 184 16.7 2.00 ONLINE 43 173 19.8 2.00 ONLINE 42 153 15.5 2.00 GROUP 37 133 19.8 2.00 NONE 42 154 14.8 2.00 ONLINE 53 178 13.2 2.00 ONLINE 45 138 18.9 2.00 NONE 42 167 18 2.00 NONE 48 171 13 2.00 GROUP 46 162 16.2 2.00 ONLINE 49 149 21.1 2.00 GROUP 48 174 18.6 2.00 GROUP 45 173 17.6 2.00 ONLINE 45 155 18.9 2.00 GROUP 44 159 18.1 2.00 ONLINE 54 174 10.8 2.00 NONE 44 139 15.2 2.00 NONE 41 158 19.3 2.00 ONLINE 43 145 18.6 2.00 NONE 47 193 13.5 2.00 ONLINE 38 145 17.1 2.00 NONE 50 184 15.6 2.00 ONLINE 41 128 15.5 2.00 NONE 45 177 14.2 2.00 GROUP 49 170 16.1 3.00 NONE 38 122 19.3 3.00 GROUP 46 171 13.6 3.00 GROUP 37 148 15.7 3.00 GROUP 42 167 17.7 3.00 ONLINE 44 148 13.5 3.00 GROUP 45 164 16.7 3.00 NONE 45 146 12 3.00 GROUP 48 177 13.9 3.00 ONLINE 49 160 13.6 3.00 GROUP 46 149 17.8 3.00 NONE 45 140 11 3.00 GROUP 45 130 20.6 3.00 GROUP 43 166 17.6 3.00 ONLINE 44 188 12.9 3.00 GROUP 41 157 11.5 3.00 ONLINE 41 155 13.6 3.00 GROUP 43 153 15.2 3.00 GROUP 37 145 18 3.00 NONE 34 133 15.2 4.00 GROUP 51 177 11.4 4.00 NONE 43 169 13.3 4.00 NONE 39 156 13.3 4.00 NONE 40 125 12.2 5.00 NONE 44 182 15.5 5.00 NONE 48 156 15.1 4.00 ONLINE 43 148 14.5 4.00 ONLINE 39 138 17.7 4.00 GROUP 42 160 10.6 4.00 NONE 54 180 11.8 5.00 GROUP 51 167 12.6 6.00 ONLINE 48 165 19.8 6.00 ONLINE and i have answered from Q1 to Q4 SO i need the rest


Sales (Y) Calls (X1) Time (X2) Years (X3) Type
21 116 19.9 3 NONE
21 116 18.0 2 GROUP
31 118 19.4 4 ONLINE
33 125 16.9 2 ONLINE
32 129 18.5 2 GROUP
29 131 14.6 1 GROUP
33 131 10.0 0 GROUP
42 131 19.4 5 GROUP
40 132 18.5 1 GROUP
33 135 15.3 2 GROUP
33 136 16.9 4 ONLINE
41 136 19.3 3 ONLINE
45 137 15.7 1 GROUP
42 139 12.4 1 GROUP
33 140 17.5 2 GROUP
41 140 13.9 3 NONE
42 141 12.2 3 NONE
42 142 17.0 3 ONLINE
35 143 17.7 3 NONE
40 143 18.3 2 NONE
32 146 15.4 3 GROUP
34 146 15.8 1 GROUP
40 146 18.2 2 NONE
43 146 16.4 0 ONLINE
44 146 16.5 1 NONE
45 146 15.6 3 ONLINE
41 147 18.5 3 GROUP
42 147 13.2 3 GROUP
42 148 10.5 2 GROUP
40 149 14.2 4 ONLINE
41 149 13.2 3 GROUP
43 149 12.7 1 GROUP
32 150 19.4 0 GROUP
43 150 17.4 3 GROUP
46 150 20.7 2 GROUP
41 151 18.0 1 NONE
43 151 14.3 1 GROUP
44 151 15.2 2 GROUP
43 152 17.2 1 GROUP
44 152 16.0 2 ONLINE
43 153 13.2 3 GROUP
46 153 22.0 0 ONLINE
40 154 16.4 3 GROUP
41 154 14.5 4 NONE
43 154 15.3 1 ONLINE
43 155 11.2 3 ONLINE
42 156 18.6 2 GROUP
43 156 20.5 2 ONLINE
45 157 16.3 4 ONLINE
46 157 19.3 2 ONLINE
44 158 13.9 1 GROUP
44 158 11.8 3 ONLINE
42 159 13.6 4 GROUP
48 160 15.8 2 ONLINE
46 161 13.2 3 GROUP
46 162 15.7 3 NONE
47 162 16.4 3 ONLINE
43 163 11.7 1 GROUP
45 164 17.2 3 ONLINE
44 165 17.4 3 ONLINE
44 165 15.0 0 ONLINE
44 165 19.2 2 NONE
45 166 19.5 5 NONE
45 167 14.5 4 GROUP
46 167 10.1 0 ONLINE
46 167 14.8 1 ONLINE
46 167 15.8 0 ONLINE
48 168 12.3 5 ONLINE
48 168 15.9 5 ONLINE
46 169 14.8 3 GROUP
48 170 12.1 1 ONLINE
45 171 19.4 2 ONLINE
47 171 17.3 2 ONLINE
45 172 12.6 3 GROUP
50 173 13.3 1 ONLINE
49 174 18.3 0 ONLINE
45 175 18.3 2 GROUP
47 175 13.9 2 GROUP
50 175 15.1 3 ONLINE
51 175 12.0 2 ONLINE
54 175 14.2 1 ONLINE
44 177 15.3 3 ONLINE
48 178 12.6 4 ONLINE
50 179 12.8 3 ONLINE
46 180 15.1 4 NONE
49 181 12.4 2 ONLINE
51 181 11.4 4 GROUP
51 182 17.9 2 ONLINE
47 183 13.0 3 ONLINE
50 183 11.7 1 GROUP
47 185 15.2 2 ONLINE
50 185 16.4 0 ONLINE
46 186 14.1 3 GROUP
49 186 17.5 1 GROUP
53 188 11.0 2 ONLINE
46 189 20.0 1 GROUP
52 190 13.2 3 ONLINE
49 191 13.1 2 GROUP
54 195 15.2 2 ONLINE
51 198 13.0 1 ONLINE

Solutions

Expert Solution

orchestra answered 2 years ago
Next > < Previous

Related Solutions

Complete the following four hypotheses, using α = 0.05 for each. The week 5 spreadsheet can...
Complete the following four hypotheses, using α = 0.05 for each. The week 5 spreadsheet can be used in these analyses. Using the same data set from part A, perform the hypothesis test for each speculation in order to see if there is evidence to support the manager's belief. Use the Eight Steps of a Test of Hypothesis from Section 9.1 of your text book as a guide. You can use either the p-value or the critical values to draw...
Complete the following four hypotheses, using α = 0.05 for each. The week 5 spreadsheet can...
Complete the following four hypotheses, using α = 0.05 for each. The week 5 spreadsheet can be used in these analyses. 1. Mean sales per week exceed 42.5 per salesperson 2. Proportion receiving online training is less than 55% 3 Mean calls made among those with no training is at least 145 4. Mean time per call is 14.7 minutes Using the same data set from part A, perform the hypothesis test for each speculation in order to see if...
Complete the following four hypotheses, using α = 0.05 for each. The week 5 spreadsheet can...
Complete the following four hypotheses, using α = 0.05 for each. The week 5 spreadsheet can be used in these analyses.Using the same data set from part A, perform the hypothesis test for each speculation in order to see if there is evidence to support the manager's belief. Use the Eight Steps of a Test of Hypothesis from Section 9.1 of your text book as a guide. You can use either the p-value or the critical values to draw conclusions....
Complete the following four hypotheses, using α = 0.05 for each. a. Mean sales per week...
Complete the following four hypotheses, using α = 0.05 for each. a. Mean sales per week exceeds 41.5 per salesperson b. Proportion receiving online training is less than 55% c. Mean calls made among those with no training is less than 145 d. Mean time per call is greater than 15 minutes 1. Using the same data set from part A, perform the hypothesis test for each speculation in order to see if there is evidence to support the manager's...
For questions 2-7: state the appropriate hypotheses; conduct a hypothesis test using α = 0.05 utilizing...
For questions 2-7: state the appropriate hypotheses; conduct a hypothesis test using α = 0.05 utilizing the classical approach, confidence interval approach, or p-value approach; state the decision regarding the hypotheses; and make a conclusion. 3. (15 pts) In a study of schizophrenia, researchers measured the activity of the enzyme monoamine oxidase (MAO) in the blood platelets of 18 patients. The results (expressed as nmol benzylaldehyde product per 108 platelets) were as follows: 6.8 8.4 8.7 11.9 14.2 18.8 9.9...
Consider the hypotheses shown below. Given that x overbarequals=106​, σ=27​, n=48​, α=0.05​, complete parts a and...
Consider the hypotheses shown below. Given that x overbarequals=106​, σ=27​, n=48​, α=0.05​, complete parts a and b. Upper H 0H0​: muμequals =113 Upper H 1H1​: muμnot equals ≠113 a. what is the​ z-test statistic? b. what are the critical​ z-score(s)? c. Because the test statistic _________________ ________ the null hypothesis. d. what is the p value?
To test the following hypotheses at the 0.05 level of​ significance, using a sample size of...
To test the following hypotheses at the 0.05 level of​ significance, using a sample size of nequals=15. H00 ​: sigmaσsquared2equals=0.05 HSubscript Upper AA ​: sigmaσsquared2not equals≠0.05 What is the upper tail critical​ value? Round to three decimal places as needed. A. 27.488 B. 23.685 C. 26.119 D. 24.996
Using the following output and α = 0.05, test that the mean for group 1 is...
Using the following output and α = 0.05, test that the mean for group 1 is greater than the mean for group 2.                  group               n          mean                sample std dev             1                    10        4.5                   0.9             2                    10        3.5                   0.9
For each p-value stated below, what is the decision for each if α = 0.05? What...
For each p-value stated below, what is the decision for each if α = 0.05? What is the decision for each if α = 0.01? A. For p = 0.0300, what is the decision if α = 0.05? Retain the null hypothesis. Reject the null hypothesis. For p = 0.0300, what is the decision if α = 0.01? Retain the null hypothesis. Reject the null hypothesis. B.For p = 0.1000, what is the decision if α = 0.05? Retain the...
Assume that you plan to use a significance level of α = 0.05 to test 5)...
Assume that you plan to use a significance level of α = 0.05 to test 5) the claim that p1 = p2. Use the given sample sizes and numbers of successes to find the P-value for the hypothesis test, and make a conclusion addressed to the claim. n1=100 n2=100 x1 = 38 x2 = 40
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT