100%(2)2 out of 2 people found this document helpful
This preview shows page 1 - 2 out of 52 pages.
a3e60dfaafd03b92917149e67512696019c935c5.xlsxThere are 2 parts to this Excel assignment. The file names include Part I and Part II.Please backup your files!All shaded background cells must be answered in the space provided.Work is independent. The rubric will be used to grade your submission.Please refer to the Tutorial for College Data Analysis PPTs for illustrations.Neither Apple's StatPlus nor open software can be used. This is an Excel assignment.Last Name:First Name: A. Source DataB. Grading Components - Part I.PointsPoints LostPart 1A4Part 1BCalculate Descriptive Statistics from Data Analysis for the in-state tuition for each of your four states. PointsPoints Lost1. Display the relevant column(s) of data.243A. Calculate a Coefficient of Variation (CV) for each of the 4 states in the table provided (in yellow).43B. Interpret the 4 CVs here:6Part 1CPointsPoints Lost1. Display the relevant column(s) of data.12. Produce one pie chart on the number of applications received by state, with appropriate title.23. Produce one bar chart on the number of applications accepted by state, with title and labeled axes.44. Produce a different chart on the calculated acceptance rate (%) by state, with title and labeled axes.6Part IDPoints Lost1. Display the relevant column(s) of data.2444. Summarize the confidence interval in words here:4Part IEPointsPoints Lost1. Three variables are selected.32. Metric (counts, averages, etc.) are appropriate.63.
Does the chart make sense?64. Include appropriate title/labels.2Part 1FPointsPoints Lost1. Display the relevant column(s) of data. 22A. Plot the data as one combined scatter diagram reflecting the four states.42B. Include the title, and label both axes.23. Please include your Excel full correlation matrix. 44A. Quantify the size of the correlation here:44B. Comment on the size of this correlation here: 4Part 1GTo avoid losing points, please format your Excel output appropriately as follows.PointsPoints Lost1. On every page, please use the four-line template above, including your name, course #, section, etc.32. Miscellaneous: Have no spelling, grammar, labeling, wrapping, spacing, proofreading, etc. errors.554. Label all new tabs/worksheets, and sequence with their related tabs/worksheets.3Total Points Possible100Max Points DeductedPointed Deducted for LatenessPoints EarnedDue Date: Please post on Sakai's Assignments Folder 0.5 hours before class. For formatting and to facilitate grading, please print preview. No paper copy should be submitted.The data set for this assignment consists of a sample of colleges and universities.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.