18 Feb 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.
