1.12 Using the Excel Spreadsheet - Frequency Table Only

Last updated
Save as PDF

Page ID: 19721

\( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

Frequency Table Only

To download the Excel Workbook click on the link below.

https://drive.google.com/uc?id=1KTtNFg9NW6x14EWI79uerZ4Oet1LHaet&export=download

Tab Frequency Table only in the Excel Spreadsheet below computes the frequency table for summary data. In the Excel spreadsheet below, you will enter or delete data in the spreadsheet one cell at a time. There will be instructions on how to create the frequency table. The Excel spreadsheet is colored. Blue cells for values you can enter and Green cells for calculated fields.

Suppose you wanted to create a frequency table of the age of students within an Introductory Business Statistics class. Given the data in the table below, enter the data and complete the frequency table.

Ages	No. of students
15-18	3
19-22	3
23-26	9
27-30	5
31-34	7
35-38	7

Make the following entries. Enter 15-18 in cell A2; 19-22 in cell A3; 23-26 in cell A4; 27-30 in cell A5; 31-34 in cell A6; and 35-38 in cell A7. Next, enter the frequency values: 3 in cell B2, 3 in cell B3, 9 in cell B4, 5 in cell B5, 7 in cell B6, and 7 in cell B6.

Cumulative Frequency (Cum. Freq.) is a running total of the frequency values.

Relative Frequency (Rel. Freq.) is the frequency value divided by the total frequency.

Cumulative Relative Frequency (Cum. Rel. Freq) is the cumulative frequency divided by the total frequency.

Ages	No. of students	Cum. Freq.	Rel. Freq.	Cum. Rel. Freq
15-18	3	3	=3/34 0.0882	=3/34=0.0882
19-22	3	=3+3 = 6	=3/34 =0.0882	=6/34=0.1765
23-26	9	=6 + 9 =15	=9/34 0.2647	=15/34=0.4412
27-30	5	=15+5 = 20	=5/34 0.1471	=20/34=0.5882
31-34	7	=20+7 = 27	=7/34 0.2059	=27/34=0.7941
35-38	7	=27+7 = 34	=7/34 0.2059	=34/34=1
	34

Were there are blue cells in the Excel spreadsheet, enter the information above.