Download Frequency Distribution Table in Excel and more Study notes Teaching method in PDF only on Docsity!
Frequency Distribution Table in Excel
A frequency distribution table in Excel gives you a snapshot of how your data is spread out. It’s usual to pair a frequency distribution table with a histogram. A histogram gives you a graph to go with the table. Sample Problem: Make a frequency distribution table in Excel. Use the following IQ scores: 99, 101, 121, 132, 140, 155, 98, 90, 100, 111, 115, 116, 121, 124. Step 1: Type your data into a worksheet. Make sure you put your data into columns. Use column headers. For this example, type “IQ Scores” into cell A1. Then type the IQ scores into cells A2 to A15. Note: Column headers will become the labels on the histogram. Step 2: Type the upper levels for your BINs into a separate column. For this sample problem, type 99, 109, 119, 129, 139, and 149 as your upper limits into column C. Note that I “missed” the top value of 155. You’ll see what Excel does with with “ outlier ” in the last step.
Step3: Make a column of labels
Microsoft Excel includes a number of statistical functions, including the ability to figure the mean, median and mode of a data sample. While mean, the average of a group of numbers, and median, the midpoint number of a data group, are used more often, mode, the most frequently appearing number in a data group, can be useful as well, such as using the most frequent numeric grade score to provide feedback on the effectiveness of a teaching method. Here's how to calculate mode using Excel.
Calculating the Mean
1. Use the "AVERAGE" function in Excel to find the mean of a set of numbers. Enter the range of numbers in your Excel spreadsheet. Click where you want the mean (Average).
5. The mean (average) for the list will appear in the cell you selected.
Calculating the Standard Deviation
- Use the STDEV function to compute the standard deviation. Place your cursor where you wish to have it appear. 2. Click on "Formulas" and select the "Insert Function" ( fx ) tab again.
- The standard deviation will appear in the cell you selected.
Bubble sort
Bubble sort, sometimes referred to as sinking sort, is a simple sorting algorithm that repeatedly steps through the list to be sorted, compares each pair of adjacent items and swaps them if they are in the wrong order. The pass through the list is repeated until no swaps are needed, which indicates that the list is sorted. The algorithm, which is a comparison sort, is named for the way smaller or larger elements "bubble" to the top of the list. Although the algorithm is simple, it is too slow and impractical for most problems even when compared to insertion sort. It can be practical if the input is usually in sorted order but may occasionally have some out-of-order elements nearly in position.
Bubble Sort is the simplest sorting algorithm that works by repeatedly swapping the adjacent elements if they are in wrong order.
Example:
First Pass:
( 5 1 4 2 8 ) – > ( 1 5 4 2 8 ), Here, algorithm compares the first two elements, and swaps since 5 > 1.
( 1 5 4 2 8 ) – > ( 1 4 5 2 8 ), Swap since 5 > 4
( 1 4 5 2 8 ) – > ( 1 4 2 5 8 ), Swap since 5 > 2
( 1 4 2 5 8 ) – > ( 1 4 2 5 8 ), Now, since these elements are already in order (8 > 5), algorithm does not swap them.
Second Pass:
( 1 4 2 5 8 ) – > ( 1 4 2 5 8 )
( 1 4 2 5 8 ) – > ( 1 2 4 5 8 ), Swap since 4 > 2
( 1 2 4 5 8 ) – > ( 1 2 4 5 8 )
( 1 2 4 5 8 ) – > ( 1 2 4 5 8 )
Now, the array is already sorted, but our algorithm does not know if it is completed. The algorithm needs one whole pass without any swap to know it is sorted.
