Create the project described below for the attached sample data.
Must be completed in excel no later than 8AM EST on 10/23/2015
All projects should be submitted in Excel.
1) Test equally likeliness of random numbers.
a. Use Excel to generate 500 random digits per the instructions below.
1. Click on fx and from the Math&Trig category, choose RANDBETWEEN and click OK.
2. In the bottom of the dialog box enter 0 and in the top enter, then click OK. This tells Excel to generate digits between 0 and 9.
3. Highlight cells A1 through A500 so you get 500 digits generated.
4. You can record these results in a table such as you did previously for a histogram with the Excel “bin” feature. In column B enter the values 0-9 in
the first 10 rows. How use Histogram in Data Analysis to generate a
frequency table to better see the results.
b. Use a significance level of 0.05 to test the claim that your sample of digits come from a population where all digits are equally likely. Report on whether or not Excel is properly generating random numbers. Make sure to show all our work in the submitted spreadsheet.
2) Test for the same mean. See at the attached Words.xls data file for this part of the project.
a. Test the null hypothesis that the six samples of word counts for males (odd columns ending in M) are from a population with the same mean.
b. Test the null hypothesis that the six samples of word counts for females (even columns) are from a population with the same mean.
c. If we want to compare the number of words spoken by men to the number spoken by women, does it make sense to combine the six columns to word counts for males and the same for females before then comparing?
d. Make a report that addresses each of parts a-c above and justify your answers.
3) Testing Random Numbers by nonparametic methods.
a. Use the random numbers created in part 1) above and test for randomness using three of the methods in chapter 13. Again, show all work and report on the findings of each.
4) Quality control process testing. Again, use the RANDBETWEEN function in Excel. This time generate 200 random numbers between 1 and 100 and output it to one column. Then do the same for until you have 20 columns of which are 200 in length that all have values between 1 and 100.
a. The above generated data is to simulate 20 days of a quality control process. Consider an outcome of 1-5 to be a defect and an outcome of 6-100 to be an acceptable result. Note that this corresponds to a 5% rate of defects.
b. Construct a p chart for the proportion of defective calculators, and determine whether the process is within statistical control. The process is stable with p = 0.05 so a conclusion that it is not stable would be a type I error which means we would have a false positive signal causing use to think that the process should be adjusted when, in fact, it was fine.
c. Simulate another 10 days of manufactoring calculators (as in part a), but modify these 10 so that the defect rate is 10% instead of 5%.
d. Combine the data from parts a) an c) to represent a total of 30 days of results. Contruct a p chart for this combined sample. Is the process out of control or not? If we conclude it is not, we would make a type II error which means that we would believe the process was fine when it shoudl be adjusted to correct the 10% rate of defects.
e. Again, make all your data presentable and report on your findings.
*********Need Friday 23rd by 8am est****************
Why Choose Us
At Myhomeworkwriters.com, we always aim at 100% customer satisfaction. As such, we never compromise o the quality of our homework services. Our homework helpers ensure that they craft each paper carefully to match the requirements of the instruction form.
Professional Academic Writers
With Myhomeworkwriters.com, every student is guaranteed high-quality, professionally written papers. We ensure that we hire individuals with high academic qualifications who can maintain our quality policy. These writers undergo further training to sharpen their writing skills, making them more competent in writing academic papers.
Our company maintains a fair pricing system for all academic writing services to ensure affordability. Our pricing system generates quotations based on the properties of individual papers.
My Homework Writers guarantees all students of swift delivery of papers. We understand that time is an essential factor in the academic world. Therefore, we ensure that we deliver the paper on or before the agreed date to give students ample time for reviewing.
Myhomeworkwriters.com maintains a zero-plagiarism policy in all papers. As such, My Homework Writers professional academic writers ensure that they use the students’ instructions to deliver plagiarism-free papers. We are very keen on avoiding any chance of similarities with previous papers.
Customer Support 24/7
Our customer support works around the clock to provide students with assistance or guidance at any time of the day. Students can always communicate with us through our live chat system or our email and receive instant responses. Feel free to contact us via the Chat window or support email: email@example.com.
Try it now!
How it works?
Follow these simple steps to get your paper done
Place your order
Fill in the order form and provide all details of your assignment.
Proceed with the payment
Choose the payment system that suits you most.
Receive the final file
Once your paper is ready, we will email it to you.
Our Homework Writing Services
My Homework Writers holds a reputation for being a platform that provides high-quality homework writing services. All you need to do is provide us with all the necessary requirements of the paper and wait for quality results.
At My Homework Writers, we have highly qualified academic gurus who will offer great assistance towards completing your essays. Our homework writing service providers are well-versed with all the aspects of developing high-quality and relevant essays.
Admission and Business Papers
With Myhomeworkwriters.com, we will help you secure a position at your desired institution. Our essay writing services include the crafting of admissions papers. We will still help you climb your career ladder by helping you write the official papers that will help you secure a job. We will guide you on how to write an outstanding portfolio or resume.
Editing and Proofreading
Myhomeworkwriters.com has a professional editorial team that will help you organize your paper, paraphrase it, and eliminate any possible mistakes. Also, we will help you check on plagiarism to ensure that your final paper posses quality and originality.
My Homework Writers harbors professional academic writers from diverse academic disciplines. As such, we can develop homework writing services in all academic areas. The simplicity or complexity of the paper does not affect the quality of homework writing services.