college data 2 (1) - Last Name First Name A Source Data The...

This preview shows page 1 - 2 out of 42 pages.

442174631753dd68948902037e38fb8577ce8a5b.xlsx 12/06/2016 Last Name: First Name: A. Source Data B. Grading Components - Part 2 Points Part 2F 1A. Display only the relevant column(s) of data, with column headings. 1 1B. Sort the data by public/private. 1 4 2A2 - Justify your selection for 2A1 here. 4 2A3. Display your Excel output. 2 3. Place your responses as follows: 3A. Null Hypothesis: 2 3B. Alternative Hypothesis: 2 3C. Alpha Level: 2 3D. Critical Value(s): 2 3E. Test Statistic(s): 2 3F. Decision to Reject/Fail to Reject and justify with regard to the critical value(s): 2 3G. Justify the answer to 3F with regard to the critical value(s): 2 3G. Conclusion in words. 2 Part 2G Points 1. Display only the relevant column(s) of data, with column headings. 2 2. Name your dependent variable here:2 3. Name your independent variable here:2 4. Display your Excel output 1 5. Based on your specific data set, write out what the regression equation is here: 4 2 4 8. State the alpha value here. 1 9A. State the Significance F (p-value) here: 1 9B. Interpret the Significance F (p-value) here: 4 10A. Display the Normal Probability Box below. 2 10B. Is the data normal or not? Bold Yes or No.1 10C. Justify the decision in 10B here: 1 Part 2H Points 1. Display only the relevant column(s) of data, with column headings. 1 2. Display your Excel output. 2 3. State the null hypothesis here: 2 4. State the alternative hypothesis here: 2 5. State the alpha value here: 2 6. State the F-critical value here: 2 7. Decision to Reject/Fail to Reject: 2 8. Conclusion in words and justify with regard to the F critical value: 2 Part 2I Points 1. Pose the question here: 6 2. Display only the relevant column(s) of data, with column headings. 2 3. Show the relevant statistical analysis below. 6 4. Substantiate your answer here: 6 Part 1J Format appropriately as follows. Points 1. Use this template, including your name, course #, section, etc. 2 3 3. Include commas/two decimal places in all Excel output. 3 2 Total Points Possible 100 Max Points Deducted Points Deducted for Lateness; please check Drop Box for late submissions. -5 Miscellaneous Points Earned The data set for this assignment consists of a sample of colleges and universities. Font 10 or higher is required. Points Lost Statistically, 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 Means t-Test: Two Sample Assuming Equal Variances t-Test: Two Sample Assuming Unequal Variances z-Test: Two Sample for Means Regress 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.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture