BUS 210, Exam #1, Part I, Fall 2017 Name _________________________________
Instructions: This exam is in two parts: Part I is to be completed partly at home using the materials posted on Blackboard for Part I and you will answer questions about that work in class below; Part II is to be completed entirely in class. You may not use cell phones, and you may only access internet resources you are specifically directed to use.
Part I: At home, open the data file entitled 210exam1part1data.xlsx posted in Blackboard. Complete the calculations noted below. You will be asked for additional analysis and interpretation of this data in the in-class portion of the test. Bring the file with you on a flash drive, or upload to Exam #1, Part I in Blackboard (this submission will not be graded: the file will need to be reuploaded to Blackboard as part of the complete exam; it’s just for you to have access to your calculations during the test).
The data represents SAT scores in the US in a 2009 year by state. Create the following graphs:
- A histogram of “Percent Taking” percentages. Your histogram should have 8 bins. Label the graph appropriately.
- Create a scatterplot of “Percent Taking” vs. “Combined” scores. Adjust the axes to the range 0% to 92% for the x-axis, and 1350 to 1850 in the vertical axis. Label the graph appropriately.
- Calculate the mean and standard deviation for Percent Taking.
- Calculate the 5-number summary and the upper and lower fences for Combined Score.