answersLogoWhite

0

To construct a frequency distribution you can use pivot tables and easily create a frequency distribution in Excel. You can also use the Analysis Toolpak to create a histogram. The first step is to insert a pivot table. Next, drag the following fields to the different areas: Amount Field to the Row Labels area and amount Field (or any other field) to the Values area. Next, click any cell inside the Amount column then right click and click on Group. Enter 0 for Starting at, 10000 for Ending at, and 1000 for By followed by clicking OK. To easily compare these numbers, create a pivot chart. To do this click any cell inside the pivot table. On the Insert tab, in the Charts group, click Column and select one of the subtypes. For example, Clustered Column.

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

What is derived frequency distribution?

It is derived frequency distribution. XD


How do you construct an frequency distribution table?

You carry out an experiment a number of times. You make a list of all possible outcomes and record the number of times that outcome occurred.


What is the difference of frequency distribution and relative frequency distribution?

A frequency distribution lists each value in the distribution and the number times it appears, while a relative frequency distribution reports the proportion of cases reporting each value


What is the cumulative column frequency distribution table?

Cumulative Frequency is The total of a frequency and all frequencies so far in a frequency distribution. It is the 'running total' of frequencies in the frequency distribution table.


What are the disadvantages of frequency distribution in points?

What are the disadvantages of frequency distribution tables


Can frequency distribution contain qualitative data?

frequency distribution contain qualitative data


What is the frequency of the monthly coupon distribution?

The frequency of the monthly coupon distribution is once a month.


Is the cummulative frequency distribution a relative frequency distribution expressed in absolute numbers?

in form of percent


What is the name for a relative frequency distribution shown by heights?

Are you talking about a histogram of the relative frequency distribution.


What is simple frequency distribution table?

The frequency distribution table lists all the possible events and how many times (frequency) they occurred.


What are the importance of frequency distribution tables?

What are the importance of frequency


How is a frequency distribution converted to a relative frequency distribution?

The relative frequency of a class is the frequency of the class divided by the total number of frequencies of the class and is generally expresses as a percentage.