# College+Data+Analysis+in+Excel-2015+-+Part+IIC (1) - Last...

• Test Prep
• 15

This preview shows page 1 - 3 out of 15 pages.

Last Name: First Name: A. Source Data B. Grading Components - Part II Points Part 2F 1A. Display the relevant column(s) of data. 2 1B. Sort the data by public/private. 2 6 2B1. Display your Excel output below. 4 3. Place your responses here: Null Hypothesis: 2 Alternative Hypothesis: 2 Alpha Level: 2 t Stat: 2 t Critical one-tail: 2 Decision to Reject/Fail to Reject and justify with regard to the critical value: 2 Conclusion in words: 2 Part 2G Points 1. Display the relevant columns of data. 2 2. Name your dependent variable here: 2 3. Name your independent variable here: 2 4. Display your ANOVA table below. 2 5. Based on your data, write out what the regression equation is here: 4 2 4 8. State the F statistic here: 2 9. 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 your data below. 4 2. Display your ANOVA table below. 4 3. State the null hypothesis here: 2 4. State the alternative hypothesis here: 2 5. State the F statistic here: 2 6. Using the p-value approach, interpret the F statistic here: 4 Part 2I From your College Data Set, propose a question to be analyzed. Points 1. Pose the question here: 6 2. Display the relevant column(s) of data below. 4 3. Show the relevant statistical analysis below. 6 4. Include an overall summary statement here: 4 Part 1J Format appropriately as follows. Points 1. Use this template, including your name, course #, section, etc. 1 2 3. Include commas/two decimal places in your data and Excel output. 2 1 Total Points Possible 100 Max Points Deducted Points Earned The data set for this assignment consists of a sample of colleges and universities. Points Lost Sort your data (Public/Private and SAT Math scores) by public/private. Statistically, is the mean SAT Math score for public colleges/universities higher than for private colleges/universities? α = 0.05. 2A. For this study, invoke one of the following functions 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. Check the Normal Probability Plot Box. Points Lost 6. State the R 2 here: 7. Interpret the R 2 value here: Statistically is there a difference in average in-state tuition for your states 1, 2, 3 and 4? Points Lost Points Lost Points Lost 2. Miscellaneous: spelling, labeling, addressing Excel comments in the first worksheet 4. Label all new tabs/worksheets and sequence with their related tabs/worksheets. Pareto Analysis on Travel Problems Your Na me ' s P ie Cha rt <
State Birmingham-Southern College AL 2 575 525 805 588 1376 \$ 11,660 \$ 11,660 74 14.0 72 Spring Hill College AL 2 525 480 773 694 942 \$ 11,478 \$ 11,478 80 14.4 70 Huntingdon College AL 2 513 446 608 520 538 \$ 8,080 \$ 8,080 63 11.4 44 Auburn University-Main Campus AL 1 575 501 7548 6791 16262 \$ 2,100 \$ 6,300 85 16.7 69 University of Alabama at Huntsville AL 1 542 468 1376 957 2727 \$ 2,480 \$ 4,960 83 12.7 38 Troy State University at Troy AL 1