2. Name your dependent variable here:1 3. Name your independent variable here:1 4. Display your Excel output 1 5. Based on your specific data set, write out what the regression equation is here: 3 1 2 8. State the alpha value here: 1 9A. State the Significance F (p-value) here: 1 9B. Interpret the Significance F (p-value) here: 2 10A. Display the Normal Probability Box below. 1 1 10C. Justify the decision in 10B here: 2 19 Part 8 Statistically is there a difference in average in-state tuition for your states 1, 2, 3 and 4? α = 0.10. Points 1. Display only the relevant column(s) of data, with column headings. 1 2. Display your Excel output. 1 3. State the null hypothesis here: 2 4. State the alternative hypothesis here: 2 5. State the alpha value here: 1 6. State the F-critical value here: 1 7. Decision to Reject/Fail to Reject: 1 8. Conclusion in words and justify with regard to the F critical value: 2 11 Part 9 Format your submission appropriately as follows. Points 1. Use this template, including your name, course #, section, etc. 1 2. Miscellaneous: spelling, labeling, addressing Excel comments in the first worksheet; label all new tabs/worksheets. 2 3. Include commas/two decimal places in all Excel output (not input). 2 5 Points Total Points Possible 100 100 Max Points Deducted Points Deducted for Lateness; please check Drop Box for late submissions. -5 Miscellaneous Points Earned Please backup your files! Due Date: Please post on Sakai's Assignment Folder 0.5 hours before class. For formatting and to facilitate grading, please print preview. No paper copy should be submitted. Font 12 or higher is required. The data set for this assignment consists of a sample of colleges and universities. Points Lost Four states have been randomly assigned from the college data set (blue worksheet/tab ) to each student. These state assignments are found on Sakai under Resources in the same subfolder as this file. - Copy paste all the college data (rows and columns) from the Source Data Set into this spreadsheet, along with the column headings. - There should be no spaces between states, which would be four tables; it is one data file. - Please remember to address the Formatting of Excel results in Part 9. This is your personal data set for this assignment. (Please see the Tutorial PPTs in Sakai under Resources under College Data Analysis.) Backup this dataset. Charting - Identify each state # with its 2-digit abbreviation. Use the summary data (in yellow) for each of the charts. Label appropriate axes. Points Lost Calculate Descriptive Statistics, with a 99% confidence interval from Data Analysis, for the in-state tuition for your combined data. For your four states combined, display the full set of Data/Data Analysis/Descriptive Statistics below, with one aggregate + 99% confidence level value for your four states combined.
You've reached the end of your free preview.
Want to read all 75 pages?
- Spring '08
- The Land, National Association of Independent Colleges and Universities, Sarah Lawrence College, Council of Independent Colleges