Using R or MS Excel

Complete the following problems using R and/or MS Excel. Be sure to show your work and include the hypothesis tests, the critical values, the computed test values, and the resulting decisions where applicable.

Section 13-2

Perform these steps:

Don't use plagiarized sources. Get Your Custom Essay on
Using R or MS Excel
Just from $13/Page
Order Essay
    1. State the hypotheses and identify the claim.
    2. Find the critical value(s).
    3. Compute the test value.
    4. Make the decision.
    5. Summarize the results.

Use the traditional method of hypothesis testing unless otherwise specified. Assume all assumptions are met.

  1. Game Attendance An athletic director suggests the median number for the paid attendance at 20 local football games is 3000. The data for a random sample are shown. At α = 0.05, is there enough evidence to reject the claim? If you were printing the programs for the games, would you use this figure as a guide?
6210 3150 2700 3012 4875
3540 6127 2581 2642 2573
2792 2800 2500 3700 6030
5437 2758 3490 2851 2720

Source: Pittsburgh Post Gazette.

  1. Lottery Ticket Sales A lottery outlet owner hypothesizes that she sells 200 lottery tickets a day. She randomly sampled 40 days and found that on 15 days she sold fewer than 200 tickets. At α = 0.05, is there sufficient evidence to conclude that the median is below 200 tickets?

Section 13-3

Use the Wilcoxon rank sum test. Assume that the samples are independent. Also perform each of these steps.

    1. State the hypotheses and identify the claim.
    2. Find the critical value.
    3. Compute the test value.
    4. Make the decision.
    5. Summarize the results.

Use the traditional method of hypothesis testing unless otherwise specified. Assume all assumptions are valid.

  1. Lengths of Prison Sentences A random sample of men and women in prison was asked to give the length of sentence each received for a certain type of crime. At α = 0.05, test the claim that there is no difference in the sentence received by each gender. The data (in months) are shown here.
Males 8 12 6 14 22 27 32 24 26
Females 7 5 2 3 21 26 30 9 4
Males 19 15 13
Females 17 23 12 11 16

Source: Based on information from the National Highway Traffic Safety Administration.

  1. Winning Baseball Games For the years 1970–1993 the National League (NL) and the American League (AL) (major league baseball) were each divided into two divisions: East and West. Below are random samples of the number of games won by each league’s Eastern Division. At α = 0.05, is there sufficient evidence to conclude a difference in the number of wins?
NL 89 96 88 101 90 91 92 96 108 100 95
AL 108 86 91 97 100 102 95 104 95 89 88 101

Source: World Almanac.

Section 13-4

Use Table K to determine whether the null hypothesis should be rejected.

  1. ws= 13, n = 15, α = 0.01, two-tailed
  2. ws= 32, n = 28, α = 0.025, one-tailed
  3. ws= 65, n = 20, α = 0.05, one-tailed
  4. ws= 22, n = 14, α = 0.10, two-tailed

Section 13-5

Use the Kruskal-Wallis test and perform these steps.

    1. State the hypotheses and identify the claim.
    2. Find the critical value.
    3. Compute the test value.
    4. Make the decision.
    5. Summarize the results.
  1. Mathematics Literacy Scores Through the Organization for Economic Cooperation and Development (OECD), 15-year-olds are tested in member countries in mathematics, reading, and science literacy. Listed are randomly selected total mathematics literacy scores (i.e., both genders) for selected countries in different parts of the world. Test, using the Kruskal-Wallis test, to see if there is a difference in means at α = 0.05.
Western Hemisphere Europe Eastern Asia
527 520 523
406 510 547
474 513 547
381 548 391
411 496 549

Source: www.nces.ed.gov (链接到外部网站。)

Section 13-6

Perform these steps.

    1. Find the Spearman rank correlation coefficient.
    2. State the hypotheses.
    3. Find the critical value. Use α = 0.05.
    4. Make the decision.
    5. Summarize the results.
  1. Subway and Commuter Rail Passengers Six cities are randomly selected, and the number of daily passenger trips (in thousands) for subways and commuter rail service is obtained. At α = 0.05, is there a relationship between the variables? Suggest one reason why the transportation authority might use the results of this study.
City 1 2 3 4 5 6
Subway 845 494 425 313 108 41
Rail 39 291 142 103 33 38

Source: American Public Transportation Association.

Section 14-3

Use random numbers to simulate the experiments. The number in parentheses is the number of times the experiment should be repeated.

  1. Prizes in Caramel Corn Boxes A caramel corn company gives four different prizes, one in each box. They are placed in the boxes at random. Find the average number of boxes a person needs to buy to get all four prizes. (40)
  2. Lottery Winner To win a certain lotto, a person must spell the word big. Sixty percent of the tickets contain the letter b, 30% contain the letter i, and 10% contain the letter g. Find the average number of tickets a person must buy to win the prize. (30)

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

Our Advantages

Plagiarism Free Papers

All our papers are original and written from scratch. We will email you a plagiarism report alongside your completed paper once done.

Free Revisions

All papers are submitted ahead of time. We do this to allow you time to point out any area you would need revision on, and help you for free.

Title-page

A title page preceeds all your paper content. Here, you put all your personal information and this we give out for free.

Bibliography

Without a reference/bibliography page, any academic paper is incomplete and doesnt qualify for grading. We also offer this for free.

Originality & Security

At Essay Assign, we take confidentiality seriously and all your personal information is stored safely and do not share it with third parties for any reasons whatsoever. Our work is original and we send plagiarism reports alongside every paper.

24/7 Customer Support

Our agents are online 24/7. Feel free to contact us through email or talk to our live agents.

Try it now!

Calculate the price of your order

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 Services

We work around the clock to see best customer experience.

Pricing

Flexible Pricing

Our prices are pocket friendly and you can do partial payments. When that is not enough, we have a free enquiry service.

Communication

Admission help & Client-Writer Contact

When you need to elaborate something further to your writer, we provide that button.

Deadlines

Paper Submission

We take deadlines seriously and our papers are submitted ahead of time. We are happy to assist you in case of any adjustments needed.

Reviews

Customer Feedback

Your feedback, good or bad is of great concern to us and we take it very seriously. We are, therefore, constantly adjusting our policies to ensure best customer/writer experience.