Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

University of Cincinnati BANA 2082 BUS

Business Jul 21, 2021

University of Cincinnati

BANA 2082

BUS. ANALYTICS II (BANA 2082)

Spring 2019

Quiz 1A

1)Data dashboards are a type of                                    analytics.

 

  1.                               analytics are techniques that use models, constructed from past data, to predict the future or to ascertain the impact of one variable on another.

 

  1.                                       analytics use techniques that take input data and yield a best course of action.

 

 

Quiz 1B

  1. Corporate-level managers use              to summarize sales by region, current inventory levels, and other company-wide metrics all in a single screen.

 

  1. A forecast that helps direct police officers to areas where crimes are likely to occur based on past data is an example of

 

  1. The company identified in Chapter 3, Analytics in Action, is

 

 

  1. The Analytics in Action example in Chapter 3 concerned

 

  1. Chapter 3 focuses on

Quiz 1C

  1. Data-ink is the ink used in a table or chart that

 

  1. The ratio of the amount of ink used in a table or chart that is necessary to convey information to the total amount of ink used in the table and chart is known as data-ink ratio. Using additional ink that is not necessary to convey information has what effect on the data-ink ratio?

 

  1. Deleting the grid lines in a table and the horizontal lines in a chart

 

 

  1. In many cases, white space in a chart can improve
  2. Tables should be used instead of charts when

 

 

  1. Which one of the following statements is not true concerning PivotTables in Excel?

 

  1. Fields may be chosen to represent all of the following except                           in the body of a PivotTable

 

  1. The software package most commonly used for creating simple charts is

 

 

  1. In the file, MajorSalary, data have been collected from 111 College of Business graduates on their monthly starting salaries. Create a PivotTable. Which major has the greatest number of graduates?

 

  1. Using a PivotTable and the MajorSalary data, determine the average starting salary of management majors. Round your answer to two decimal places and do not include a dollar sign.

 

  1. Using a PivotTable and the MajorSalary data, determine the highest starting salary for Info Systems majors. Round your answer to two decimal places and do not include a dollar sign.

 

  1. The attached file shows the number of U.S. locations for the top 20 U.S. franchises. Create a PivotTable and group the number of locations starting at zero, ending at 39,999 by 10,000. How many franchises are in the 0 to 9999 category?

 

 

 

 

 

 

 

 

 

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment