1.11 Using Excel Spreadsheet Provided - Frequency Table

Last updated
Save as PDF

Page ID: 20153

\( \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}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

Frequency Table

To download the Excel Workbook click on the download icon link below.

Click on the Frequency Table tab in the Excel spreadsheet provided. Start in cell A2 and enter the data below. In this spreadsheet, you must enter the data one cell at a time. Enter the data below in cells A2 through A26. The spreadsheet will determine the number of classes based on the 2n method. The 2n process sets the number of classes to the smallest integer greater than log(n)/log(2), where n is the sample size (i. e., log(25)/log(2)).

Data

14.3 , 16.1 , 19.4 , 14.8 , 24 , 16.8 , 23.1 , 18.4 , 21.7 , 16.3 , 12.5 , 17.6 , 22.7 , 18.7 , 10.3 , 19.6 , 27.5 , 25.1 , 25.8 , 16.8 , 21.2 , 21.8 , 27.5 , 13.4 , 17.1

Entering the data in the cells.

Enter 14.3 in cell A2.
Enter 16.1 in cell A3.
Enter 19.4 in cell A4.
Enter 14.8 in cell A5.
Continue this process until you enter 17.1 in A26.

The spreadsheet will calculate part of the frequency table.

You are to complete the table based on the definition of each part in the table below. You will enter values in the blue cells. In the table below

Class	Start	End	Frequency	Cum Freq.	Rel Freq.	Cum Rel. Freq.
1	10.3	13.79	3	3	3/25 = 0.1200	3/25 = 0.1200
2	13.79	17.28	7	3+7 = 10	7/25 = 0.2800	10/25 = 0.4000
3	17.28	20.77	5	10+5 = 15	5/25 = 0.2000	15/25 = 0.6000
4	20.77	24.26	6	15+ 6 =21	6/25 = 0.2400	21/25 = 0.8400
5	24.26	27.75	4	21 + 4=25	4/25 = 0.1600	25/25 = 1.0000
		Total	25

You will complete the table by entering the following.

Enter 13.79 in cell D9.
Enter 20.77 in cell D11.
Enter 3 in cell G8.
Enter 21 in cell G11.
Enter 0.2800 in cell H9.
Enter 0.2400 in cell H11.
Enter 0.1200 in cell I9.
Enter 08400 in cell I11.