I need help with my Statistics Maths through ExcelThis is the website https://www.limes.one/Labs/ViewLab/19?TaskId=1110user Z232696760 Pass- WasBut98Lab 7 retake, Lab 8
https://www.limes.one/Homeworks/ViewHomework/15?TaskId=58
user- Z232696760
Password- WasBut98
In what follows use any of the following tests/procedures: Regression, confidence intervals, one-sided 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.
Open Hospital_HW13 data. Test if Hospital 3 has more than 150 patients who have suffered car accident injuries on average. (Pick the closest answer)
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.
Open Hospital_HW13 data. Test if Hospital 1 has more patients who have had heart attack than patients who have made suicide attempt on average. (Pick the closest answer)
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.
Open WagesHW12 data. Is it reasonable to claim the older the people the more they earn?
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
