Questions from Business Analytics

Q: A new graduate has taken a job with an annual salary of

A new graduate has taken a job with an annual salary of $60,000. She expects her salary to go up by 2.5% each year for the first five years. Her starting salary is stored in cell A4 of an Excel worksh...

Q: Create box-and-whisker charts for each type of expense

Create box-and-whisker charts for each type of expense in the Excel file Budget Forecasting.

Q: A survey was conducted to identify the type of movies watched by

A survey was conducted to identify the type of movies watched by 15 people in the past two weeks. If the type of movie watched by one person is different from the others, then the code 1 will be assig...

Q: A shirt manufacturer needs to supply invoices to customers based on data

A shirt manufacturer needs to supply invoices to customers based on data from the Shirt Production Excel file, which indicates the costs (in £) and sizes. Modify the file to use the VLOOKUP function t...

Q: The Excel file S&P 500 provides open, high,

The Excel file S&P 500 provides open, high, low, and close values for the S&P 500 index over a period of time. a. Enter any date (using the format month/day/year) within the range of the data in cell...

Q: The Financial Forecasts database shows estimated variable and fixed expenses of a

The Financial Forecasts database shows estimated variable and fixed expenses of a firm for the first nine months of the coming year. Define range names for each month and the type of expense. Then use...

Q: Convert the Hospital Claim database to an Excel table. Use the

Convert the Hospital Claim database to an Excel table. Use the techniques to find: a. the total number of claims. b. the total number of outpatient claims. c. the total number of claims in January.

Q: Convert the Order Specifications database to an Excel table. Use the

Convert the Order Specifications database to an Excel table. Use the techniques to find: a. the total cost of all orders. b. the total cost of all orders placed with Multipurpose Fasteners. c. the to...

Q: The Excel file Stationary provides the sales data for a stationary company

The Excel file Stationary provides the sales data for a stationary company, and each row represents an order for its products. Convert these data into an Excel table and filter the central region for...

Q: The Excel file Global Industry Default and Rating summarizes financial information for

The Excel file Global Industry Default and Rating summarizes financial information for 32 European firms, in the manufacturing and services industries, and their perceived risk of default. Convert the...