The total of all numeric values in a group The standard deviation for a group of numbers based on a sample The result of multiplying all the values in a range of cell locations The number that appears most frequently in a group of numbers The lowest numeric value in a group of numbers The middle number in a group of numbers (half the numbers in the group are higher than the median and half the numbers in the group are lower than the median) The highest numeric value in a group of numbers The number of cell locations in a range that contain a text or numeric character The number of cell locations in a range that contain a numeric character The average or arithmetic mean for a group of numbers Table 2.4 Commonly Used Statistical Functions Function In addition to demonstrating functions, this section also reviews percent of total calculations and the use of absolute references. This section demonstrates a variety of statistical functions that we will add to the Personal Budget workbook. However, when you use a function, you can highlight all the cells that contain values you wish to sum in just one step. This can be very time-consuming if you have to add the values in a few hundred cell locations. If you use a formula to add the values in a range of cells, you would have to add each cell location to the formula one at a time. Functions are more efficient than formulas when you are applying a mathematical process to a group of cells. A list of commonly used statistical functions is shown in Table 2.4. For example, the SUM function is used to add the values contained in a range of cells. Statistical functions apply a mathematical process to a group of cells in a worksheet. In addition to formulas, another way to conduct mathematical computations in Excel is through functions. Learn how to set a multiple level sort sequence for data sets that have duplicate values or outputs.Learn how to copy and paste formulas without formats applied to a cell location.Use the MAX and MIN functions to find the highest and lowest values in a range of cells.Use the AVERAGE function to calculate the arithmetic mean.Use the COUNT function to count cell locations with numerical values.Use absolute references to calculate percent of totals.Use the SUM function to calculate totals.Statistical functions QUARTILE(q1), MIN, MEDIAN, MAX and QUARTILE(q3) Check the box for summary statistics and hit enter! Enter the data cell range and for input just put a cell where you want the top line to appear. Under Data select data analysis, descriptive statistics.Select the Data Analysis Tool Pack and add it in! Go to the file Button (top left hand corner), Excel Options, Add-Ins.There is an easier way to get the above information and more! Try using the function button to access the functions instead of typing them out. The functions you’ll need are the average( cell range), median (cell range), mode (cell range), max(cell range), min(cell range), stdev(cell range), Quartile (cell range, quartile number). Use the appropriate decimals button to reduce all answers to at most 3 decimals. If you choose to work with a partner put the second name in Cell A2 and only submit one worksheet between you. Put your name (first and last) in Cell A1. Open a new Excel worksheet and save as Lab1.xls – I’d like the finished version submitted to the Blackboard site digital drop box.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |