QSO 510 Data Set Homework Guidelines
QSO 510 Data Set Homework Guidelines and Rubric
Two data sets are used during this course for three homework assignments:
Module Two, Descriptive Statistics: Data set 1 presents a sample of annual salaries for recently hired plant operators at a chemical manufacturing
company. Use Excel’s ToolPak (or any statistical package that you are comfortable with) to compute descriptive statistics for the data. Submit your
statistical output from Excel, which should include values for the mean, median, mode, sample variance, and sample standard deviation.
Module Four, Correlation and Regression: Data set 2 presents a sample of the number of defective flash drives produced by a small manufacturing
company over the last 30 weeks. Use Excel’s Analysis ToolPak (or any statistical package that you are comfortable with) to compute the regression
equation for predicting the number of defective flash drives over time (in weeks), the correlation coefficient r, and the coefficient of determination R2
.
Submit your statistical output from Excel, which should include values for the slope, y-intercept, regression equation, r, and R2
.
Module Six, Hypothesis Testing: Data set 2 presents a sample of the number of defective flash drives produced by a small manufacturing company over
the last 30 weeks. The company’s operations manager believes that the number of defects produced by the process is less than seven defective flash
drives per week. Use this online calculator (or any statistical package that you are comfortable with) to construct a hypothesis test to verify the
operations manager’s claim. Your hypothesis test should include null and alternative hypotheses, a t test statistic value, a p-value, a decision, and a
conclusion. Submit a Word file that includes the hypothesis test.
Specifically, the following critical elements must be addressed:
I. Methodology
II. Analysis
Guidelines for Submission: For the Modules Two and Four assignments, submit both a 1-page Word document and an Excel spreadsheet. For the Module 6
assignment, submit only a 1-page Word document.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
