Reference no: EM13850325

1. 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, and appropriate lables.

2. Using the file "nfl-yards-points.xlsx,"
a. create a scatter chart to display the ‘Yards/Game' as the x-axis and the ‘Points/Game' as the y-axis,
b. display a trendline on the chart (black, 1pt, solid line),
c. display the ‘equation' on the chart - format 12pt,
d. display the ‘R-squared' on the chart - format 12pt,
e. Use the ‘Style 7' design,
f. The x-axis should range from 200 to 450, and the y-axis should range from 10 to 40,
g. 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-axis values.

3. Using the file "cities-unemp-living.xlsx, "

a. "create a bubble chart to display the ‘Unemployment' as the x-axis, ‘Cost of Living' as the y-axis, and ‘Population' as the bubble size,
b. Display the ‘State' as a data label that is centered inside the bubble,
c. The x-axis should range from 0% to 7%, and the y-axis should range from 80 to 140,
d. Use the ‘Style 5' design,
e. Make sure that your chart has a 20pt title and appropriate 14pt x-axis and 14pt y-axis values and titles.

 

Attachment:- New WinRAR archive.rar