This assignment is Statistics homework done in excel

Open Tornadoes-HW6 data. Test if there is a significant difference between the number of tornadoes in August and the number of tornadoes in October on average. Answer questions 1 to 4.(Pick the closest answer)

1. What test did you perform? (6.25 points)

a. Simple Regression
b. Multiple Regression
c. Two sided t-test
d. None of these

2. What is the P-value? (6.25 points)

a. 3.50471E-10
b. 7.00942E-10
c. 6.23E-05
d. None of these

3. What is the Statistical interpretation? (6.25 points)

a. The P-value is too small to have a conclusive answer.
b. The P-value is greater than 5% thus the answer is inconclusive
c. The P-value is much smaller than 5% thus we are confident that the averages are significantly different.
d. The P-value is greater than 5% thus we are very certain that the averages are significantly different.
e. None of these

4. What is the conclusion? (6.25 points)

a. The test is inconclusive and more data is needed.
b. We can claim that there is a significant difference between the number of tornadoes in August and the number of tornadoes in October on average.
c. We cannot claim that there is a significant difference between number of tornadoes in August and number of tornadoes in October on average.
d. Since the test is inconclusive the conclusion is inconclusive as well.
e. None of these

Homework 9 / Task 2

Task 1 Task 3

Open Wages-HW9 data. Test if people with 16 years of EDUCATION and people with 12 years of EDUCATION have wages that are significantly different on average. Answer questions 5 to 8.

5. What test did you perform? (6.25 points)

a. Simple Regression
b. Multiple Regression
c. Two sided t-test
d. None of these

6. What is the P-value? (6.25 points)

a. 0.008181
b. 0.016362
c. 6.23E-05
d. None of these

7. What is the Statistical interpretation? (6.25 points)

a. The P-value is too small to have a conclusive answer.
b. The P-value is greater than 5% thus the answer is inconclusive
c. The P-value is greater than 5% thus we are very certain that the averages are significantly different.
d. The P-value is smaller than 5% thus we are confident that the averages are significantly different.
e. None of these

8. What is the conclusion? (6.25 points)

a. The test is inconclusive and more data is needed.
b. Since the test is inconclusive the conclusion is inconclusive as well.
c. We can claim that people with 16 years of EDUCATION and people with 12 years of EDUCATION have wages that are significantly different on average.
d. We cannot claim that people with 16 years of EDUCATION and people with 12 years of EDUCATION have wages that are significantly different on average
e. None of these

Homework 9 / Task 3

Task 2 Task 4

Open Wages-HW9 data. Test if more years of EDUCATION lead to higher wages on average. Answer questions 9 to 12.

9. What test did you perform? (6.25 points)

a. Simple Regression
b. Multiple Regression
c. Two sided t-test
d. None of these

10. What is the P-value? (6.25 points)

a. 3.05442E-22
b. 1.5272E-22
c. 5.47E-20
d. None of these

11. What is the Statistical interpretation? (6.25 points)

a. The P-value is too small to have a conclusive answer.
b. The P-value is greater than 5% thus we are very certain that the averages are significantly different.
c. The P-value is greater than 5% thus the answer is inconclusive
d. The P-value is smaller than 5% thus we are confident that the slope is not zero.

12. What is the conclusion? (6.25 points)

a. The test is inconclusive and more data is needed.
b. Since the test is inconclusive the conclusion is inconclusive as well.
c. We can claim that more years of EDUCATION lead to higher wages.
d. We cannot claim that more years of EDUCATION lead to higher wages
e. None of these

Homework 9 / Task 4

Task 3

Open Brains data. Test if the weight of people with Brain Volume = 1100 or more and the weight of people with Brain Volume less than 1100 are significantly different on average. Answer questions 13 to 16.

13. What test did you perform? (6.25 points)

a. Simple Regression
b. Multiple Regression
c. Two sided t-test
d. None of these

14. What is the P-value? (6.25 points)

a. 0.932448
b. 0.000826
c. 0.379046
d. None of these

15. What is the Statistical interpretation? (6.25 points)

a. The P-value is too large to have a conclusive answer.
b. The P-value is greater than 5% thus we are very certain that the averages are significantly different.
c. The P-value is greater than 5% we are not confident that the slope is not zero.
d. The P-value is smaller than 5% thus we are very certain that the averages are significantly different.
d. None of these

16. What is the conclusion? (6.25 points)

a. Since the test is inconclusive the conclusion is inconclusive as well.
b. The test is inconclusive and more data is needed.
c. We can claim that the weight of people with Brain Volume = 1100 or more and the weight of people with Brain Volume less than 1100 are significantly different on average.
d. We cannot claim that the weight of people with Brain Volume = 1100 or more and the weight of people with Brain Volume less than 1100 are significantly different on average.
e. None of these

Homework 10 / Task 1

Task 2

Read the options to question 1 carefully and choose the correct choice.

1. Which of the following is false? (4 points)

a. We use two sided t-test when we are checking if the averages of the two variables are different, with no prior assertion on which is larger of the two.
b. We use one sided t-test when we are checking if the averages of the two variables are different, but now we are more specific. We want to show that X has a significantly larger/smaller average than Y.
c. We need to perform the averages of the two variables data set when one sided t-test is chosen in order to see if the averages are consistent with the claim.
d. The one sided t-test and two sided t-test performed on the same data sets should return the same P-value.
e. The P-value excel returns on a one sided t-test is incorrect and meaningless if the averages computed on the data sets are inconsistent with the claim.

Homework 10 / Task 2

Task 1 Task 3

Open Wages-HW9 data. Test if there is a significant difference between men’s and women’s wages. Answer questions 2 to 5. (Pick the closest answer)

2. What test did you perform? (4 points)

a. Regression
b. Two sided t-test
c. One sided t-test

3. What is the P-value? (4 points)

a. 8.51633E-07
b. 1.3694E-06
c. 6.84701E-07
d. None of these

4. What is the Statistical interpretation? (4 points)

a. The P-value is much smaller than 5% thus we are very certain that the averages are significantly different.
b. The P-value is too small to have a conclusive answer.
c. The P-value is greater than 5% thus the answer is inconclusive.
d. The P-value is greater than 5% thus we are we are very certain that the averages are significantly different.
e. None of these.

5. What is the conclusion? (4 points)

a. The test is inconclusive and more data is needed.
b. Statistical interpretation agrees with the intuition that men earn more than women on average.
c. Statistical interpretation does not agree with the intuition that men earn more than women on average.
d. Since the test is inconclusive the conclusion is inconclusive as well.
e. None of these.

Task 1

Open US_Crime-HW7 data. Test if Florida has more robberies than assaults on average. Answer questions 6 to 9. (Pick the closest answer)

6. What test did you perform? (4 points)

a. Regression
b. Two sided t-test
c. One sided t-test

7. What is the P-value? (4 points)

a. #DIV/0!
b. 2.2906E-06
c. 1.1453E-06
d. None of these

8. What is the Statistical interpretation? (4 points)

a. The P-value is too large to have a conclusive answer.
b. The P-value is smaller than 5% thus it is conclusive.
c. The P-value is too small to have a conclusive answer.
d. Average of data is inconsistent with the claim.

9. What is the conclusion? (4 points)

a. Statistics confirms that Florida has more robberies than assaults per year on average.
b. We can claim that Florida has more assaults than robberies per year on average.
c. We cannot claim Florida has more robberies than assaults per year on average.
d. None of these.

Open US_Crime-HW7 data. Test if West Virginia’s vehicle thefts are lower than Nebraska’s vehicle thefts on average. Answer questions 10 to 13. (Pick the closest answer)

10. What test did you perform? (4 points)

a. Regression
b. Two sided t-test
c. One sided t-test

11. What is the P-value? (4 points)

a. #DIV/0!
b. 1.2979E-05
c. 6.48948E-06
d. None of these

12. What is the Statistical interpretation? (4 points)

a. The P-value is too large to have a conclusive answer.
b. The P-value is too small to have a conclusive answer.
c. The P-value is smaller than 5% thus it is conclusive.
d. Average of data is inconsistent with the claim.
e. None of the above.

13. What is the conclusion? (4 points)

a. We cannot confirm the assertion that West Virginia’s vehicle thefts are lower than Nebraska’s vehicle thefts on average.
b. We can confirm the assertion that West Virginia’s vehicle thefts are lower than Nebraska’s vehicle thefts on average.
c. None of these.

Open Wages-HW9 data. Test if unmarried women’s wages is greater than married women’s wages on average. Answer questions 14 to 17. (Pick the closest answer)

14. What test did you perform? (4 points)

a. Regression
b. Two sided t-test
c. One sided t-test

15. What is the P-value? (4 points)

a. 0.440486
b. 0.220243
c. 0.18358
d. None of these

16. What is the Statistical interpretation? (4 points)

a. The P-value is smaller than 5% thus it is conclusive.
b. Average of data is inconsistent with the claim.
c. The P-value is too large to have a conclusive answer.
d. The P-value is too small to have a conclusive answer.
e. None of the above.

17. What is the conclusion? (4 points)

a. We can confirm the assertion that unmarried women’s wages is greater than married women’s wages on average.
b. We cannot confirm the assertion that unmarried women’s wages is greater than married women’s wages on average.
c. None of these.

Open House_Price5Variables data. Test if older houses are cheaper to buy. Answer questions 18 to 21:

18. What test did you perform? (4 points)

a. Simple Regression
b. Multiple Regression
c. Two sided t-test
d. None of these

19. What is the P-value? (4 points)

a. 7.431032E-12
b. 0.074143
c. 8.47E-20
d. None of these

20. What is the Statistical interpretation? (4 points)

a. The P-value is too small to have a conclusive answer.
b. The P-value is greater than 5% thus we are very certain that the averages are significantly different.
c. The P-value is greater than 5% we are not confident that the slope is not zero.
d. The P-value is smaller than 5% thus we are confident that the slope is not zero.

21. What is the conclusion? (4 points)

a. Since the test is inconclusive the conclusion is inconclusive as well.
b. The test is inconclusive and more data is needed.
c. We can claim that older houses are cheaper to buy.
d. We cannot claim that older houses are cheaper to buy.
e. None of these.

Open US_Crime-HW7 data. Test if the more assaults occur in New York the more murders are expected in New York. Answer questions 22 to 25. (Pick the closest answer)

22. What test did you perform? (4 points)

a. Regression
b. Two sided t-test
c. One sided t-test

23. What is the P-value? (4 points)

a. 2.88987E-18
b. 5.77973E-18
c. 5.58E-13
d. None of these

24. What is the Statistical interpretation? (4 points)

a. The P-value is smaller than 5% thus it is inconclusive.
b. Average of data is inconsistent with the claim.
c. The P-value is too large to have a conclusive answer.
d. The P-value is smaller than 5% thus we are confident to say that the slope is not zero.
e. None of the above.

25. What is the conclusion? (4 points)

a. Since the test is inconclusive the conclusion is inconclusive as well.
b. We can confirm that if the more assaults occur in New York the more murders are expected in New York.
c. We cannot confirm if more assaults occur in New York more murders are expected in New York.