sta hw need help

In what follows use any of the following tests/procedures: Regression, confidence intervals, onesided t-test, or two-sided t-test. All the procedures should be done with 5% P-value or 95%
confidence interval.
Open Hospital_HW13 data. Test if Hospital 1 has more patients who attempted suicide than
Hospital 3 on average. (Pick the closest answer)
1. What test did you perform? (4 points)
•
a. Regression
•
b. Confidence Interval
•
c. Two sided t-test
•
d. One sided t-test
2. What is the P-value/margin of error? (4 points)
•
a. #DIV/0!
•
b. 0.048098
•
c. 0.096197
•
d. None of these
3. What is the Statistical interpretation? (4 points)
•
a. The P-value is smaller than 5% thus the result is inconclusive.
•
b. The P-value is smaller than 5% thus we are confident to confirm the claim.
•
c. The P-value is too large to have a conclusive answer.
•
d. Average of data is inconsistent with the claim.
•
e. None of the above.
4. What is the conclusion? (4 points)
•
a. Statistics confirms that Hospital 1 has more patients than Hospital 3.
•
b. We can claim Hospital 1 has more patients who have made suicide attempt than
Hospital 3.
•
c. We cannot claim that Hospital 1 has more patients who have made suicide attempt
than Hospital 3.
•
d. None of these.
5. What test did you perform? (4 points)
•
a. Regression
•
b. Two sided t-test
•
c. One sided t-test
•
d. Confidence Interval
6. What is the P-value/margin of error? (4 points)
•
a. 1.856912
•
b. 9.688328
•
c. 170.3271
•
d. None of these
7. What is the Statistical interpretation? (4 points)
•
a. The P-value is larger than 5% thus the result is conclusive.
•
b. The P-value is too large to have a conclusive answer.
•
c. Average of data is inconsistent with the claim.
•
d. The prediction interval for the true average number of Hospital 3 patients who
suffered car accident injuries is [168.471, 172.184].
•
e. None of the above.
8. What is the conclusion? (4 points)
•
a. Statistics confirms that Hospital 3 has many patients who have had a car accident.
•
b. We are confident to say that Hospital 3 has more than 150 patients who have
suffered car accident injuries on average.
•
c. We cannot claim that Hospital 3 has more than 150 patients who have suffered car
accident injuries on average.
•
d. None of these.
9. What test did you perform? (4 points)
•
a. Regression
•
b. Confidence Interval
•
c. Two sided t-test
•
d. One sided t-test
10. What is the P-value/margin of error? (4 points)
•
a. 3.23187E-39
•
b. 6.46374E-39
•
c. 0.234217
•
d. 4.02183E-44
•
e. None of these
11. What is the Statistical interpretation? (4 points)
•
a. The P-value is smaller than 5% thus the result is inconclusive.
•
b. The P-value is smaller than 5% thus we are confident to confirm the claim.
•
c. The P-value is too large to have a conclusive answer.
•
d. Average of data is inconsistent with the claim.
•
e. None of the above.
12. What is the conclusion? (4 points)
•
a. Statistics confirms that Hospital 1 has many patients who have had heart attack.
•
b. We can claim that Hospital 1 has more patients who have had heart attack than
patients who have made suicide attempt.
•
c. We cannot claim that Hospital 1 has more patients who have had heart attack than
patients who have made suicide attempt.
•
d. None of these.
13. What test/procedure did you perform? (4 points)
•
a. One sided t-test
•
b. Two sided t-test
•
c. Regression
•
d. Confidence Interval
14. What would be the correct Null-Hypothesis? (4 points)
•
a. The population averages are equal.
•
b. The slope of the regression line is equal to zero.
•
c. Age and wages should not be related.
•
d. Age and wages should be related.
15. What is the P-value/margin of error and what can be statistically concluded based on
the Null Hypothesis? (4 points)
•
a. 3.92E-05 and we accept the Null Hypothesis
•
b. 1.1525E-243 and we reject the Null Hypothesis
•
c. 2.305E-243 and we do not reject the Null Hypothesis
•
d. 3.92E-05 and we reject the Null Hypothesis
16. What is the Statistical interpretation? (4 points)
•
a. The P-value is much smaller than 5% thus the test result is inconclusive.
•
b. The P-value is much smaller than 5% thus we are confident that the slope is not
zero.
•
c. The P-value is greater than 5% thus we can claim that age is related to wage.
•
d. None of these.
17. What is the conclusion? (4 points)
•
a. We are confident that age and wage are not related.
•
b. We are confident that age and wage are negatively related, older people earn lesser
wages on average.
•
c. We cannot be confident that older people earn higher average wages than do
younger people.
•
d. None of these.
Upload the WagesHW12, use the wage column to make the histogram
(start the bin column from 0 and choose bin size=4) and answer the
questions:
18. The chart you created resembles which of the shape above? (4
points)
a. Bell shape
b. Double-Bell shape
c. Right-Skewed shape
d. Left-Skewed shape
19. For this data which of the following is true? (4 points)
a. StDev < Median < Average b. Average < StDev < Median c. Median < Average < StDev d. StDev < Average < Median e. None of these 20. Which class (interval) has the highest frequency? (4 points) a. 0-4 b. 4-8 c. 8-12 d. 12-16 Upload the Hospitals_HW13, use the Suicide Attempt column to make the histogram (start the bin column from 0 and choose bin size=10) and answer the questions: 21. The chart you created resembles? (4 points) a. Bell shape b. Double-Bell shape c. Right-Skewed shape d. Left-Skewed shape 22. For this data which of the following is true? (Enter the letter that corresponds to your answer in the fourth blank below) (4 points) a. StDev < Median < Average b. Average < StDev < Median c. Median < Average < StDev d. StDev < Average < Median e. None of these Your health insurance company has converge for three types of medical treatment. The annual cost for each type of treatment can be modeled using Gaussian (Normal) distribution, with the following parameters: • Treatment 1: Mean=$1600 and Standard Deviation=$120 • Treatment 2: Mean=$1500 and Standard Deviation=$95 • Treatment 3: Mean=$1200 and Standard Deviation=$70 Use Random number generator and simulate 1000 long columns, for each of the three cases. Example: for the Treatment 1, use Number of variables=1, Number of random numbers=1000, Distribution=Normal, Mean=1600 and Standard deviation=120, and leave random Seed empty. Next: use either sorting or construct the appropriate histogram or rule of thumb to answer the questions: 23. What is approximate probability that Treatment 3 has annual cost less than $1150? (4 points) • a. Between 20% and 30% • b. Between 30% and 70% • c. Between 70% and 85% • d. None of these 24. Which of the three treatment is most likely to cost between $1200 and $1300? (4 points) • a. Treatment 1 • b. Treatment 2 • c. Treatment 3 25. For which of the three treatments we expect that (approximately) 95% of cases will be between $1300 and $1700? (4 points) • a. Treatment 1 • b. Treatment 2 • c. Treatment 3 Her is Hospital_HW13 Hospital attempt 1 84 1 90 1 96 1 92 1 82 1 81 car accidents domestic accident 134 93 108 126 109 61 38 21 27 30 12 31 53 58 51 55 52 52 Heart attack Suicide 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 93 93 74 94 98 87 91 89 80 102 97 89 92 90 105 90 91 90 91 91 91 58 70 93 96 79 92 78 79 95 85 94 94 84 87 96 101 96 101 88 89 81 84 92 102 113 88 62 97 89 70 97 101 77 111 89 99 60 113 78 81 109 59 69 97 100 98 141 103 88 107 124 101 55 72 81 61 109 72 77 88 97 68 103 88 20 100 90 123 95 75 128 108 126 120 97 108 66 120 93 98 140 176 115 57 131 93 81 99 84 115 101 103 97 56 51 51 49 53 47 42 51 44 51 46 51 53 55 52 44 45 49 62 55 55 53 62 52 49 54 52 53 51 49 46 44 45 55 50 49 51 45 45 51 42 53 43 51 50 48 49 51 51 43 56 57 60 43 50 55 49 37 13 41 45 25 29 18 40 31 30 31 22 23 42 35 26 14 26 46 39 21 35 33 29 42 33 24 51 12 38 28 30 37 38 29 23 32 26 26 21 34 16 29 34 37 31 16 32 26 34 7 28 28 25 43 26 33 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 101 97 84 91 76 95 73 93 90 82 95 104 88 94 90 96 93 93 83 85 95 93 89 146 116 133 121 139 127 137 131 152 114 127 128 130 123 124 136 124 136 145 137 133 122 126 126 140 129 130 141 126 125 125 119 143 125 128 85 91 59 60 70 48 89 79 83 133 93 68 101 93 92 99 117 74 112 80 108 79 157 131 159 126 167 132 139 154 205 125 166 112 147 119 156 189 127 154 158 151 140 93 124 143 156 158 156 183 161 192 136 139 148 160 41 57 54 50 53 50 54 48 52 54 52 53 51 52 53 44 47 50 43 45 57 39 43 50 60 46 53 50 47 47 52 51 54 60 52 48 47 53 54 48 47 52 59 48 55 46 51 47 44 51 47 43 53 51 51 63 53 29 34 41 32 34 23 24 28 33 22 25 19 33 16 35 47 38 20 40 23 34 1 26 25 29 25 24 37 33 28 10 50 48 21 47 36 42 26 23 38 35 33 35 35 27 39 28 41 19 25 22 21 19 18 21 20 18 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 127 123 148 129 124 130 123 135 114 132 138 125 129 127 120 138 136 118 125 130 135 133 131 112 116 126 123 134 117 123 120 120 145 143 135 135 125 133 115 135 130 126 106 141 114 124 131 123 129 112 136 133 130 136 141 133 133 121 163 147 160 152 152 166 170 123 119 153 150 149 162 117 176 149 128 141 140 157 123 140 113 129 160 159 158 125 146 119 120 215 190 147 131 152 138 105 153 163 138 123 194 121 179 177 168 118 127 112 147 148 130 196 147 151 55 49 54 47 62 55 55 48 52 41 49 48 56 46 43 54 51 52 51 42 53 48 57 44 55 39 46 49 54 56 52 59 45 57 57 46 51 47 41 56 44 54 53 44 53 50 50 52 49 55 46 52 52 44 54 49 57 23 38 28 23 40 35 18 16 51 19 1 32 29 27 35 31 22 43 30 33 16 37 30 28 41 38 17 8 16 38 22 29 44 8 30 19 32 36 27 26 21 15 49 19 20 45 28 13 46 23 38 25 33 43 43 30 13 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 128 114 130 151 145 124 121 124 136 129 130 102 103 123 142 142 161 164 156 173 147 173 166 168 182 168 170 169 161 180 172 169 167 162 157 159 157 194 174 169 148 155 172 168 174 163 180 164 162 174 169 164 165 161 168 172 173 145 68 169 177 191 141 148 122 163 139 104 93 118 123 180 155 216 222 187 214 162 211 197 193 231 197 236 192 175 202 231 205 181 184 197 181 164 227 162 200 161 166 212 186 198 183 205 198 199 201 208 200 207 159 222 203 205 51 54 59 52 53 42 54 54 51 50 41 50 53 54 50 47 49 47 52 56 47 60 47 44 54 51 56 49 44 50 49 51 51 47 54 45 48 47 53 41 46 45 52 50 60 46 49 53 51 51 52 44 50 47 52 44 38 39 18 30 14 17 15 37 28 38 35 37 32 40 20 26 51 50 46 29 34 31 40 16 26 36 23 33 20 47 28 34 29 18 42 32 43 34 35 35 37 31 34 27 37 38 38 28 32 17 10 32 28 51 18 20 46 27 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 184 162 148 176 170 161 167 174 182 159 170 167 169 155 182 183 169 175 165 179 156 193 153 166 183 166 169 170 185 170 153 180 163 174 182 179 172 180 143 173 169 191 181 162 164 176 155 177 171 162 164 182 175 166 167 174 165 255 170 173 222 204 183 193 213 199 158 198 162 170 169 210 197 171 164 211 188 193 197 183 225 192 194 204 178 214 221 180 238 155 163 222 206 169 202 191 184 177 223 181 173 203 210 232 167 196 190 231 222 243 224 196 179 203 47 49 44 47 60 56 50 40 58 48 51 45 55 48 50 49 51 53 54 53 42 49 45 59 49 48 49 51 44 49 49 51 51 47 51 51 56 61 49 50 50 52 43 49 50 50 51 51 53 46 56 53 51 41 56 48 47 44 14 39 12 34 28 24 29 34 13 22 40 27 45 40 28 41 58 30 18 31 31 23 22 50 43 29 33 26 29 26 17 34 41 28 36 19 22 22 32 26 19 27 14 44 57 23 40 27 32 31 43 48 30 43 25 29 3 3 3 3 3 3 3 3 3 166 169 179 176 175 173 164 175 183 209 244 200 249 210 217 209 207 222 53 53 51 52 45 48 51 51 53 39 25 40 27 27 35 39 43 18