Purchase Solution

Excel functions for use in statistics

Not what you're looking for?

Ask Custom Question

See attached files.

The questions and solutions are attached for a group of problems, but I don't know how to work them in Excel. All references in the questions are also attached. Please assist with the Excel commands.

Attachments
Purchase this Solution
Solution Summary

The attached Excel has all problems worked out.

The same spreadsheet is in two versions. Once it is zipped up and includes images of the problem side-by-side for comparison. The other is a much smaller file and not compressed since it contains no images.

The last two questions are in their own spreadsheets: Fresh15.xls and Movies.xls. Between the three spreadsheets, all solutions are in Excel. Be sure to place your cursor in the answer cells to see the Excel formula commands used in each case.

Here are the Excel Commands used in the solutions:

Group 1 #15: NORMDIST()
Group 1 #25: NORMINV()
Group 1 #27: NORMINV() and NORMDIST()
Group 1 #30: NORMINV()
Group 1 #31: NORMDIST()

Group 2 #9: SUM() and MEDIAN()
Group 2 #10: SUM(), VAR(), SQRT(), STDEVP(), and MEDIAN()
Group 2 #11: SUM(), VAR(), and VARP()
Group 2 #12: AVERAGE(), SUM()

Group 3 #9: NORMDIST()
Group 3 #11: NORMDIST()
Group 3 #21: BINOMDIST()

Group 4 #27: BINOMDIST()

Group 5 #9: AVERAGE(), STDEV(), SERIES(), Scatter Plot

Fresh 15: TINV(), SQRT(), STDEV(), COUNT(), SUM()
MOVIES.XLS: Excel Regression Add-In

Solution Preview

See attached files.

The attached Excel has all worked out, including the last in Group 5 where I typed in all the data for you.

The same spreadsheet is attached twice. Once it is zipped up and includes images of the problem side-by-side for comparison. The other is a much smaller file and not ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

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

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.

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.

View More Free Quizzes
Related BrainMass Solutions

  • Finding descriptive sample statistics

    For instance, if we want to compute the range of the data: weights. Then we can use the functions MAX and MIN (both can be found in Excel). Here ate the steps: Step 1: Find ''formula'' in the top menu.

  • MGMT 650 Q2 Descriptive Statistics Excel

    4) What is the difference between the Excel functions, STDEV.P and STDEV.S? (Hint: Use the Excel help files.) 5) What is the variance? What is the standard deviation?

  • Building a Frequency Distribution in Excel

    Type 'standard deviation' in the box, click Go and in the lower box you see alternative functions to use. Choose STDEV (this is the one you will most often use for standard deviation) and another box opens.

  • Hypothesis Testing: t-test for a population mean

    This is done in rows 12 through 17 of the sheet. To see how the statistics were calculated. Click on a yellow cell and see the worksheet function or functions used to get the statistics in the bar at the top of the sheet.

  • Descriptive statistics

    c) Copy and paste the data from this document to Excel. Use functions in Excel to compute the mean, population standard deviation and sample standard deviation. Copy and paste your spreadsheet work into this Word document.

  • Distribution of Temperatures - Descriptive and General Statistics

    Use functions in Excel to compute the mean, population standard deviation and sample standard deviation. Copy and paste your spreadsheet work into this Word document.

  • Examining Data in Excel

    Hint: Use Excel functions for each part of the 5 number summary, not the Descriptive Statistics command under the Data Analysis Toolpak.

  • Presentation on definitions, and uses of statistics

    You can find the formula for all these functions in any spreadsheet program. In MS Excel, you may have to load the "Data Analysis ToolPak". To do this follow these steps: o Click on the Microsoft Office Button in the far upper left.

  • Descriptive Statistics

    Calculate the (A) mean, (b) median (c) mode and (d) Range and (e) Standard Deviation for the data below. You may use full functions of Excel. Hint. Copy and paste the data into an Excel spread sheet.

  • Probability and Descriptive Statistics

    527134 Probability and Descriptive Statistics Questions should be solved on excel file using excel functions. 1) Probabilities. A fair coin was tossed 3 times. Calculate the probabilities of the following 6 events. 1.

View More Related Solutions