Copy of College Data Analysis Pt1 (1) - There are 2 parts...

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

a3e60dfaafd03b92917149e67512696019c935c5.xlsx There 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 Data B. Grading Components - Part I. Points Points Lost Part 1A 4 Part 1B Calculate Descriptive Statistics from Data Analysis for the in-state tuition for each of your four states. Points Points Lost 1. Display the relevant column(s) of data. 2 4 3A. Calculate a Coefficient of Variation (CV) for each of the 4 states in the table provided (in yellow). 4 3B. Interpret the 4 CVs here: 6 Part 1C Points Points Lost 1. Display the relevant column(s) of data. 1 2. Produce one pie chart on the number of applications received by state, with appropriate title. 2 3. Produce one bar chart on the number of applications accepted by state, with title and labeled axes. 4 4. Produce a different chart on the calculated acceptance rate (%) by state, with title and labeled axes. 6 Part ID Points Lost 1. Display the relevant column(s) of data. 2 4 4 4. Summarize the confidence interval in words here: 4 Part IE Points Points Lost 1. Three variables are selected. 3 2. Metric (counts, averages, etc.) are appropriate. 6 3. Does the chart make sense?6 4. Include appropriate title/labels. 2 Part 1F Points Points Lost 1. Display the relevant column(s) of data. 2 2A. Plot the data as one combined scatter diagram reflecting the four states. 4 2B. Include the title, and label both axes. 2 3. Please include your Excel full correlation matrix. 4 4A. Quantify the size of the correlation here: 4 4B. Comment on the size of this correlation here: 4 Part 1G To avoid losing points, please format your Excel output appropriately as follows. Points Points Lost 1. On every page, please use the four-line template above, including your name, course #, section, etc. 3 2. Miscellaneous: Have no spelling, grammar, labeling, wrapping, spacing, proofreading, etc. errors. 5 5 4. Label all new tabs/worksheets, and sequence with their related tabs/worksheets. 3 Total Points Possible 100 Max Points Deducted Pointed Deducted for Lateness Points Earned Due 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.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture