The proportion of people attending in NYU that report having a close friend who is a diligent student is 0.30.An investigator randomly samples students at SUNY New Paltz and finds that 20 out of 100 people report having a friend who is a diligent student. Can he confirm that the proportion of workaholics at SUNY New Paltz is different than NYU.

Does this data support the investigator's prediction? Use an alpha level of .05.

Test the above claim using single sample hypothesis testing (alpha = 0.05)

Test the above claim using single sample hypothesis testing (alpha = 0.05)

- Calculate test statistic of proportion (Z or t)

- State null and alternative hypothesis

- State Conclusion

Please Upload a single excel file for the following calculations, see excel file attached:

1. Calculate test statistic for a single sample using example with data in Excel and interpret (upload excel file) Here's the data for your calculations:

Single Sample t Test unknown sigma

5 7 8 9 10 11 12 13 14 n = 9sigma = ? test u = 8 alpha = .05

1. Using excel, Calculate test statistic for two sample (comparing Males and Females using pooled SD (lab example)

Here's the data for your calculations:

Practice - Two Sample Hypothesis Test (equal variances)

Males----------Females

6--------------------6

7--------------------10

8--------------------6

9--------------------8

10--------------------7

11---------------------5

12--------------------11

13--------------------7

14--------------------8

- Calculate pooled Standard deviation

- Calculate t

- Calculate degrees of freedom

- Using your t table state your conclusion, is there a statistically significant difference between males and females?