100%(5)5 out of 5 people found this document helpful
This preview shows page 1 - 2 out of 42 pages.
442174631753dd68948902037e38fb8577ce8a5b.xlsx12/06/2016Last Name:First Name: A. Source DataB. Grading Components - Part 2PointsPart 2F1A. Display only the relevant column(s) of data, with column headings.11B. Sort the data by public/private. 142A2 - Justify your selection for 2A1 here.42A3. Display your Excel output.23. Place your responses as follows:3A. Null Hypothesis:23B. Alternative Hypothesis:23C. Alpha Level:23D. Critical Value(s): 23E. Test Statistic(s):23F. Decision to Reject/Fail to Reject and justify with regard to the critical value(s): 23G. Justify the answer to 3F with regard to the critical value(s): 23G. Conclusion in words.2Part 2GPoints1. Display only the relevant column(s) of data, with column headings.22.
Name your dependent variable here:23.
Name your independent variable here:24. Display your Excel output15. Based on your specific data set, write out what the regression equation is here:4248. State the alpha value here.19A. State the Significance F (p-value) here:19B. Interpret the Significance F (p-value) here:410A. Display the Normal Probability Box below.210B.
Is the data normal or not? Bold Yes or No.110C. Justify the decision in 10B here:1Part 2HPoints1. Display only the relevant column(s) of data, with column headings.12. Display your Excel output.23. State the null hypothesis here:24. State the alternative hypothesis here:25. State the alpha value here:26. State the F-critical value here:27. Decision to Reject/Fail to Reject:28. Conclusion in words and justify with regard to the F critical value:2Part 2IPoints1. Pose the question here: 62. Display only the relevant column(s) of data, with column headings.23. Show the relevant statistical analysis below.64. Substantiate your answer here:6Part 1JFormat appropriately as follows.Points1. Use this template, including your name, course #, section, etc.233. Include commas/two decimal places in all Excel output.32Total Points Possible100Max Points DeductedPoints Deducted for Lateness; please check Drop Box for late submissions.-5MiscellaneousPoints EarnedThe data set for this assignment consists of a sampleof colleges and universities. Font 10 or higher is required.Points LostStatistically, is the mean SAT Math score for public colleges/universities the same than for private colleges/universities? α = 0.01.2A1. For this study, invoke the one appropriate function in Excel. Please bold and underline your selection here.t-Test: Paired Two Sample for Meanst-Test: Two Sample Assuming Equal Variancest-Test: Two Sample Assuming Unequal Variancesz-Test: Two Sample for MeansRegress one quantitative variable as a function of another quantitative variable in your data set, excluding Math and Verbal SAT scores. Check the Normal Probability Plot Box. α = 0.01.