Statistics help 9*****do not reply if you have few or no

Don't use plagiarized sources. Get Your Assignment on
Statistics help 9*****do not reply if you have few or no
Just from $13/Page
Order Now

Create the project described below for the attached sample data.

Must be completed in excel no later than 8AM EST on 10/23/2015

 

Final Project

               

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****************

 

Calculate your paper price
Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

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.

Affordable Prices

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.

On-Time delivery

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.

100% Originality

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: support@myhomeworkwriters.com.

Try it now!

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00

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.

Essays

Essay Writing Services

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.

Admissions

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

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.

Coursework

Technical papers

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.