Practice Exercises

Go to the World Bank Data Catalog and find a dataset or topic that interests you, then download the Excel file. Format the data as a Data Table. Filter the data using one of the criteria. Change the Table Style. What information can be gleaned from the Data Table?

Using the data in the "mgmt_jobs" tab of the downloadable Chapter 11 data file, create a Data Table. Filter the data to find those rows that use the word “manager” and have median earnings greater than $50,000 per year.

Create a two-variable Data Table for profit for a product with a unit price of $25 and a cost per unit of $18. Investigate various levels of both the number of units sold and the price per unit.

Go to Kaggle to find a dataset that interests you. (Note: You may need to create an account.) Download the Excel file. Create the Correlation matrix for the dataset. You may need to adjust the data if nominal or ordinal data is included in the file. (Hint: Code the data using numbers.)

Using a dataset from Kaggle, get the Descriptive Statistics for the information.

Using a dataset from Kaggle, create a histogram with a chart for one of the key variables.

Using a dataset from Kaggle, use the Analyze Data tool to discover some additional ways to analyze the information.

Use Goal Seek to determine what grade you will need on a final exam in a class to get the grade you desire. You can use your grades from a class in which you are currently enrolled. You will need to know from the syllabus how your final grade is calculated.

Use the Scenario Manager to look at the different financing options for buying a car that you are interested in purchasing. Look at scenarios such as a lower interest rate or a shorter loan term. Create the summary table of the scenarios.

Using the data in the "grads" tab of the downloadable Chapter 11 data file, create a PivotTable of the information. Insert a slicer to filter the data by type of institution. Insert a calculated field to find the average number of independent and public institutions.

Go to Google Trends and choose a topic that interests you. Download a dataset and create a chart appropriate for the data.

Go to the Contextures website and scroll down to the Sample Data Files options. Download the office supply data file. Use the same dataset, use the Quick Analysis tool to add conditional formatting or sparklines to the Data Table.

Go to Google Trends and choose another topic that interests you. Download a dataset and create a chart appropriate for the data. Then, save that chart as a chart template.