Name your dependent variable here 1 3 name your

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.