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.

Save your Excel files and upload them to Blackboard.

Note: you might find video tutorials on Lynda.com and the “Excellsfun” YouTube Channel as wellas information at Microsoft.comsupport.

Bubble chart help at Microsoft.com:.microsoft.com/en-us/excel-help/present-your-data-in-a-bubble-chart-HA001233749.aspx”>http://office.microsoft.com/en-us/excel-help/present-your-data- .microsoft.com/en-us/excel-help/present-your-data-in-a-bubble-chart-HA001233749.aspx”>in-a-bubble-chart-HA001233749.aspx

Adding a trendline to a Scatter Chart –help at Microsoft.com:.microsoft.com/en-us/excel-help/add-a-trendline-to-a-chart-HP005198462.aspx”>http://office.microsoft.com/en-us/excel-.microsoft.com/en-us/excel-help/add-a-trendline-to-a-chart-HP005198462.aspx”>help/add-a-trendline-to-a-chart-HP005198462.aspx

Get a 30 % discount on an order above $ 50
Use the following coupon code:
COCONUT
Order your essay today and save 30% with the discount code: COCONUTOrder Now
Positive SSL