View the step-by-step solution to:

The problems are in the EXCEL file, along with the data to analyze. For each of the 6 problems you are to do the following: A) B) C) D) E) F) G)...

I need help with this assingment. I already did number 1 on my own so i need help with only # 2-6. I will first attach the instructions in a word document and then post a reply with the excel document.

The problems are in the EXCEL file, along with the data to analyze. For each of the 6 problems you are to do the following: A) State which test you are using and why you should use that test. B) State the hypotheses (Remember to use the Greek letters, when appropriate). C) State the rejection rule for your hypothesis test based on the value of alpha. D) Calculate the test statistic based on the sample information. E) Calculate the p-value. F) State your conclusion in the context of the problem. G) State the type of error you may have made. You must place ALL of your written answers IN THE MS WORD DOCUMENT First, you should have a MS Excel file for your computer work only. This is where I will look for the proper calculations and templates. I encourage each of you to use Excel, as I have demonstrated for each of the problem types. You should have a separate tab, clearly labeled for each of the problems. NO WRITTEN ANSWERS ACCEPTED IN EXCEL! Second, you should have a MS Word file for your written 6 problems. YOU MUST USE THE ANSWER SHEET PROVIDED. Please use a separate page for each of the problems (1 through 6). For each of the problems you should have the letters A through G listed (as shown above). Place your answer next to the letter. For example, if I were working a problem I would have the following in a MS Word file. Problem A A) I am using the 2 sample t-test since I am testing for the difference between the means for 2 independent groups, in terms of their annual salaries. B) Ho: µ1 – µ2 = 0 vs Ha: µ1 – µ2 ≠ 0 (I should use the insert symbol for Mu as well as other symbols that I need.) C) Based on 15 degrees of freedom and alpha = .05, I will reject Ho if my test statistic is greater than 2.131 in absolute value. D) My t-statistic is equal to 3.89 (You would get this value from your Excel output) E) The p-value for this test is .034 (Again, this number is shown in the Excel output) F) Since 3.89 > 2.131, I would Reject Ho and conclude that the mean annual salaries for the 2 groups are not equal to each other. (You MUST use the specific information from the problem in the wording of your answer here.) G) Since I rejected Ho, there is a chance that I made a Type I error. Therefore, in your MS Word file you should have 6 pages total, one for each problem. The format should be like what is shown on the first page for ALL the hypothesis testing questions. You may be asked to calculate other values and you should list those values in your MS Word file as well. You should make your answers as clear as possible.
Background image of page 1
Sign up to view the entire interaction

Top Answer

No problems. Here... View the full answer

8411187.xlsx

The mayor's commission, in a large city, feels that all 6 of the high schools in the district have students with similar IQ scores.
Given the samples of IQ scores from 6 classes, one from each high...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online