Explore BrainMass
Share

Construct Hypothesis Tests in Excel for Employees

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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?

https://brainmass.com/statistics/quantative-analysis-of-data/construct-hypothesis-tests-excel-employees-213977

Solution Summary

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

\$2.19

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. (You can type mu or sigma for the corresponding symbols.) Include a "summary statement" for each hypothesis test.

A formal Summary Statement is REQUIRED as part of all solutions that include a CI or hypothesis test.

FACTS:
The managing partner of a major consulting firm is trying to assess the effectiveness of expensive computer skills training given to all new entry-level professionals. In an effort to make such an assessment, she administers a computer skills test immediately before and after the training program to each of the 40 randomly chosen employees. The pre-training and post-training scores of the 40 individuals are recorded in the data file below.

Use excel format and functions to solve the following:

(a) Using a 10% level of significance, do the given sample data support the claim that the organization's training program is increasing the new employee's working knowledge of computing?

(b) Using a 1% level of significance, do the given sample data support the claim that the organization's training program is increasing the new employee's working knowledge of computing?

View Full Posting Details