Question 1.

Create a bubble chart in a separate worksheet for the following five colleges for which the x-axis is the top 10% HS, y-axis is acceptance rate, and bubbles represent the expenditures per student.

Question 2

(1) Apply three different colors of data bars to lunch, dinner, and delivery sales in the following data to visualize the relative amounts of sales. Then sort the data by the day of the week beginning on Sunday. Compare the non sorted data with the sorted data and comment on the information content of the visualizations.

(2) Create a useful dashboard for the data in the Excel file Restaurant Sales. Use appropriate charts and layouts and other visualization tools that help to convey the information. Explain why you chose the elements of the dashboard and how a manager might use them.

Last Completed Projects