Purchase Solution

Construct Hypothesis Tests in Excel for Employees

Not what you're looking for?

Ask Custom Question

Please help setting up and solving the following problem in Excel. The problem with all necessary data are contained in the attached excel spread sheet.

MegaStat or similar excel add-in program may be used for the solution.

INSTRUCTIONS:
StatPro [or other excel statistics program] generates new sheets for each problem and deletes previous sheets with the same name. If you want to keep a sheet for your solution, then rename it immediately by prefixing the problem number. You may need suffix numbers to keep the names unique.

FACTS:
The data in the file P11_3.XLS - as set forth below - consist of 25 subsamples of 6 observations each on the fill weights of cans of paint. The ideal weight of these paint cans is 20 pounds.

PROBLEM:

(a) Using Excel - Generate and interpret ¯X and R charts for the given data. (i) Which control limits do you believe are most appropriate? Explain. (ii) Does this filing process appear to be in control now? (iii) Does this filing process appear to be in control now?

(b) Are there any other indications that the given process may be out of control now? If so, explain.

(c) What advise would you give to the operators of the filing process based on your analysis of the latest sample information?

Attachments
Purchase this Solution
Solution Summary

The solution constructs X(Bar) and R charts in Excel for given data.

Purchase this Solution
Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

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

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.

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

  • Construct hypothesis tests in Excel for employee's

    213968 Construct hypothesis tests in Excel for employee's Use alpha = 0.05 unless specified otherwise. For each hypothesis test state HA (the research hypothesis) and H0 (the null hypothesis) using the proper symbols.

  • One sample t test for checking quality of motors

    The group then calculates and records the miles per gallon for each year. The data in the attached excel spreadsheet portray the results of the tests. Questions 1.

  • Correlation and Regression

    At .05 level of significance, test the null hypothesis that the population correlation coefficient is 0. Please see attachment for comlete questions. Please provide detailed responses in excel.

  • TESTS OF THE EQUALITY OF TWO NORMAL DISTRIBUTIONS

    d) I don't know how to do this in Excel, but here's the general idea: for each sample, find the 1st and 3rd quartiles and make a box (using the 3rd quartile as the top of the box and the 1st quartile as the bottom of the box), draw the median as a horizontal

  • Stem Cell Transplant & Worker Motivation Problems

    Calculations are done in Excel. The solution provides step by step method for the calculation of test statistic . Formula for the calculation and Interpretations of the results are also included.

  • Hypothesis Testing Paper

    In the original paper, a one-sample was used, a one-tailed z-test to compare the mean benefits for the employees of a company to the amount $327.

  • One sample Z test

    A random sample of 90 employees from 280 total showed turnover of 12 employees in average so far. Should we reject the null hypothesis that the population mean is 20? Use significance level of 0.08 to construct the 5 step hypothesis test.

  • Hypothesis population proportion

    In addition to the testing of applicants, Fashion Industries randomly tests its employees throughout the year. Last year in the 400 random tests conducted, 14 employees failed the test.

  • Statistics Project

    Hypothesis Test: _ Construct at least one hypothesis test for your data set _ Construct and formally state H0 and Ha _ State your p-value and defend your choice _ Complete your hypothesis test reporting key parameters (t-value, ...

View More Related Solutions