Purchase Solution

Excel charts and measurements of dispersion

Not what you're looking for?

Ask Custom Question

Can someone please provide some assistance with these questions. It's for an MBA course. The MAXIMUM number of characters it can be is 60,000 for each question. There are two questions. The questions are: List the different types of charts available in Excel, and explain characteristics of data sets that make each chart most appropriate to use.? What statistical measures are used for describing dispersion in data? How do they differ from one another? Thank you so much for all your help. I really appreciate it.

Purchase this Solution

Solution Summary

Explanations of Excel charts and Measurements of dispersion.

Solution Preview

List the different types of charts available in Excel, and explain characteristics of data sets that make each chart most appropriate to use.?
Bar/Colum: used to compare data and values from all measurement types. Nominal, ordinal, interval, and ratio
Pie Charts: compare categories of information, larger vs smaller comparisons
Line Charts: This often is used to track over time, different data points. It can also be used to track increases or decreases of other things like sales or wages
Area charts: work the same as line charts with added pie chart, but uses a line under the charts values to show how much or little change there has been.
Scatter: Again uses data ...

Purchase this Solution


Free BrainMass Quizzes
Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Operations Management

This quiz tests a student's knowledge about Operations Management

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.