Explain the procedure for constructing frequency distribution for categorical data

aortiH 2021-10-20 Answered
Explain the procedure for constructing frequency distribution for categorical data using Excel.
Explain the procedure for constructing frequency distributions for numerical data using Excel.

Expert Community at Your Service

  • Live experts 24/7
  • Questions are typically answered in as fast as 30 minutes
  • Personalized clear answers
Learn more

Plainmath recommends

  • Ask your own question for free.
  • Get a detailed answer even on the hardest topics.
  • Ask an expert for a step-by-step guidance to learn to do it yourself.
Ask Question

Expert Answer

Demi-Leigh Barrera
Answered 2021-10-21 Author has 15378 answers
Constructing frequency distributions for categorical data:
The number of observation for each of the category can be counted using the function COUNTIF in Excel.
The function is given in Excel as, COUNTIF (Range, cell reference.) Under the 'Range' enter the range of data from which the frequency has to be counted. Under 'cell reference' enter the cell position that contains the categoty name for counting.
Constructing frequency distributions for numerical data:
If the data set consists of small number of values then the function COUNTIF in Excel can be used for creating frequency distributions for numerical data.
When the dataset is large, then the following procedure has to be followed in excel for constructing frequency distribution.
Step-by-step software procedure to obtain frequency distribution using EXCEL is as follows:
- Open an EXCEL file.
- Choose Date>Data Analysis>Histogram
- Enter Input range of the data
- Specify the required Bin Range
- Click Ok
Have a similar question?
Ask An Expert
0
 

Expert Community at Your Service

  • Live experts 24/7
  • Questions are typically answered in as fast as 30 minutes
  • Personalized clear answers
Learn more

Relevant Questions

asked 2021-10-28
To explain: The benefits of representing the data sets using frequency distributions.
To explain: The benefits of representing the data sets using graphs of frequency.
asked 2021-09-29
To determine and explain: Which data entries are unusual and very unusual.
Given info:
The mean speed and standard deviation for a sample of vehicles along a stretch of highway are 67 miles per hour and 4 miles per hour, respectively. Also, the speeds for eight vehicles are as follows:
70,78,62,71,65,76,82,64
asked 2021-09-24
a. Organize costs as an ordered array.
b. Construct the frequency distribution and percentage distribution for the given data.
c. Explain that the basketball game is concentrated around which class group.
asked 2021-09-16

Fill in the missing value for the following percent frequency distribution.
\(\begin{array}{|c|c|} \hline \text{Annual Salaries} & \text{Percent Frequency}\\ \hline Under\ $30,000&10\\ \hline $30,000-49,999&35\\ \hline $50,000-69,999&24\\ \hline $70,000-89,999&\\ \hline $90,000\ \text{and over}&5\\ \hline \end{array}\)

asked 2021-09-20
Solve the following
1. If the joint probability distribution of X and Y is given by
\(\displaystyle{f}{\left({x},{y}\right)}={\frac{{{x}+{y}}}{{{30}}}}\) for \(\displaystyle{x}={0},{2},{3}\); \(\displaystyle{y}={0},{1},{2}\)
Find
a. \(\displaystyle{P}{\left({X}\leq{2},{Y}={1}\right)}\)
b. \(\displaystyle{P}{\left({X}{>}{2},{Y}\leq{1}\right)}\)
c. \(\displaystyle{P}{\left({X}{>}{Y}\right)}\)
asked 2021-09-18
What is the second name for a two-way frequency table of categorical data?
a. a two-way by two-way table
b. a multiple-treatment table
c. an equal probability table
d. a contingency table
asked 2021-10-23
Answer true or false to each of the statements in parts (a) and (b), and explain your reasoning.
a. Two data sets that have identical frequency distributions have identical relative-frequency distributions.
b. Two data sets that have identical relative-frequency distributions have identical frequency distributions.
c. Use your answers to parts (a) and (b) to explain why relativefrequency distributions are better than frequency distributions for comparing two data sets.

Plainmath recommends

  • Ask your own question for free.
  • Get a detailed answer even on the hardest topics.
  • Ask an expert for a step-by-step guidance to learn to do it yourself.
Ask Question
...