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.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.