Purchase Solution

Simple Statistical Excel Functions and Formulas

Not what you're looking for?

Ask Custom Question

Let's say I have two columns of numbers (5 in each column).
1/ Pls. advise of the following functions' FORMULA in excell:
percentile
range
rank
weighted average
confidence
correlation
forecast

2/ and elaborate as to WHAT that function is telling me (how is it useful)?

Purchase this Solution
Solution Summary

The solution addresses the function of a formula.

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

  • 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.

  • Finance: Taussig Technologies, Upton Company growth rate, capital gains, dividend yield

    Please show all calculator keystrokes AND formulas in MS word so that I know how to work it. The answers MUST match in the attached answer sheet. NO EXCEL acceptable.

  • Cost Curve Anaylsis

    Use straight-line, quadratic, and cubic formulas. 2: discuss the statistical results you obtained in question 1. Include in your discussion R^2 , the coefficients, and the statistical significance of the coefficients.

  • QMTH 205Lab 3:Probability Distribution & Interval Estimation

    QMTH 205 Lab 3: Probability Distribution and Interval Estimation Purpose: Students will learn (1) how to make a table of standard normal distribution; (2) how to use Excel to select a simple random sample; (3) how to use Excel built-in functions and

  • Regression Analysis Of Drinking And Tennis Watching Data

    No excel, just formulas**. 20) A marketing research firm wished to study the relationship between wine consumption and whether a person likes to watch professional tennis on television.

  • Confidence interval and t-tests for M&M's claims

    Utilizing the data contained in the "WA4_M&Ms" Excel file and using the Excel statistical functions and formulas do the following: "WA4_M&Ms" see file is attached 1.

  • Excel Payroll Spreadsheet

    To view these instructions while working in Excel, print these instructions or move back and forth between your browser and Excel. 1.The Orange colored cells on the worksheet indicate places where you will put in the formulas and functions. 2.

  • Building a Frequency Distribution in Excel

    You can usually calculate the mean and standard deviation using the Excel functions (=AVERAGE) and (=STDEV).

  • MS Excel

    Explain to your mother-in-law the difference between formulas and functions, and then give her one example of how she might use each in her budget. Hi, In Excel, the user can use formulas and functions to manipulate numerical data.

View More Related Solutions