Purchase Solution

Excel Functions

Not what you're looking for?

Ask Custom Question

Could you please explain in words how you figure out deciles, quartiles, kurtosis, skewness in Excel? How do you find the sum count, largest, and smallest in Excel?

Purchase this Solution
Solution Summary

The expert explains how one would figure out deciles, quartiles, kurtosis and skewness in Excel.

Solution Preview

To find the count, the sum, the largest, and the smallest in Excel, you type in the following:

=COUNT()
=SUM()
=MAX()
=MIN()

Click between the parentheses and highlight the data you're interested in.

To find the quartiles by hand, sort the data from smallest to largest. If you divide the list in half, the middle number is the median (the second quartile). If you divide the list in ...

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Exponential and logarithmic functionss

    An example of a logarithmic function is y = ln (x), which is plotted in the Excel file. The expert examines exponential and logarithmic functions.

  • Using EXCEL for Standard Normal Distribution Probabilities

    You can use EXCEL functions the same way you would use calculator functions when working with a standard normal probability distribution, eliminating the need to use the Z tables.

  • MS Excel and Quattro Pro Application

    In Excel 2007, every functions of the previous versions are still there, but many features have been added.

  • Cost Functions

    Hello Please see the excel file for 1. Cost functions in mathematical form 2. Values for each functions 3. Graph (Note that graph of AFC is very close of x-axis as the values for other cost functions are very high).

  • Chi-square distribution: Probabilities and percentiles

    How to find probabilities and percentiles of a chi-square distribution using EXCEL functions.

  • Transportation :SUMIF and SUMPRODUCT functions

    Thank you Excel file contains solution of transportation problem using solver tool and SUMIF and SUMPRODUCT functions..

  • Lines Excel

    650292 Lines Excel This problem has you compare various linear functions. a) Enter formulas for the 5 different linear functions which can be filled down that will output the appropriate y-value for the given x-values.

  • Fit three possible statistical cost functions to the data

    394368 Fit three possible statistical cost functions to the data Please provide attached Excel document for problem with formulas for reference. 1. Fit three possible statistical cost functions to the data.

  • Excel spreadsheet applications and identify

    Focus on using the language of MS Excel as described in the course to highlight features, functions and formulas used in your sample report.

  • MS Excel

    These items when learned will build interest to my coworkers to learn Excel and experiment with the other advanced features and functions of the spreadsheet.

View More Related Solutions