# IDS 115 – ICA #6 Assignment 2015

January 30, 2017

Question
IDS 115 –ICA#6

Using the ‘colleges and universities file, create a bubble chart to display the first five colleges in the file – the x-axis is the ‘Top 10% of HS,’ y-axis is ‘Acceptance Rate,’ and the bubble size represents the ‘Expenditures per Student.’ Make sure that your chart has a title, axis titles, andappropriatelables.

Using the file“nfl-yards-points.xlsx,”

.05pt;’=”” lfo1;=”” level2=”” l0=”” 0pt;=”” 1.1pt;=”” 106%;=””>create a scatter chart to display the ‘Yards/Game’ as the x-axis and the ‘Points/Game’ as they-axis,

.05pt;’=”” lfo1;=”” level2=”” l0=”” 0pt;=”” 0.15pt;=””>display a trendline on the chart (black, 1pt, solidline),

.05pt;’=”” lfo1;=”” level2=”” l0=”” 0pt;=”” 1.1pt;=””>display the ‘equation’ on the chart – format12pt,

.05pt;’=”” lfo1;=”” level2=”” l0=”” 0pt;=”” 1.1pt;=””>display the ‘R-squared’ on the chart – format12pt,

.05pt;’=”” lfo1;=”” level2=”” l0=”” 0pt;=”” 0.95pt;=””>Use the ‘Style 7’design,

.05pt;’=”” lfo1;=”” level2=”” l0=”” 0pt;=”” 1.1pt;=””>The x-axis should range from 200 to 450, and the y-axis should range from 10 to40,

.05pt;’=”” lfo1;=”” level2=”” l0=”” 0pt;=”” 1.1pt;=”” 107%;=””>Make sure that your chart has a 20pt, bold title, appropriate 16pt x-axis and 16pt y-axis titles, and 11pt x-axis and y-axisvalues.

Using the file “cities-unemp-living.xlsx,“

“create a bubble chart to display the ‘Unemployment’ as the x-axis, ‘Cost of Living’ as the y-axis, and ‘Population’ as the bubblesize,

.05pt;’=”” lfo1;=”” level2=”” l0=”” 0pt;=”” 0.15pt;=””>Display the ‘State’ as a data label that is centered inside thebubble,

.05pt;’=”” lfo1;=”” level2=”” l0=”” 0pt;=”” 1.1pt;=””>The x-axis should range from 0% to 7%, and the y-axis should range from 80 to140,

.05pt;’=”” lfo1;=”” level2=”” l0=”” 0pt;=”” 1.1pt;=””>Use the ‘Style 5’design,

.05pt;’=”” lfo1;=”” level2=”” l0=”” 0pt;=”” 0.95pt;=”” 107%;=””>Make sure that your chart has a 20pt title and appropriate 14pt x-axis and 14pt y-axis values andtitles.