Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

What is the sample size? How is it determined with Excel? The question of whethe

ID: 3049775 • Letter: W

Question

What is the sample size? How is it determined with Excel?

The question of whether Friday the 13th is an unusually unlucky day or whether this idea is just superstition was evaluated. Researchers in the United Kingdom examined the relation between (a) numbers of traffic accidents on past Friday the 13ths versus (b) numbers of accidents occurring on Friday the 6ths (all between July 1990 and November 1992)." The data shown below were collected (also found in the Data Set Scenario 5 Excel file). Friday the 6th Friday the 13th 138,548 132,908 136,018 139,246 134,012 137,055 133,732 131,843 123,552 121,139 128,293 124,631 124,609 117,584 121,641 118,723 125,532 120,249 122,770 117,263

Explanation / Answer

The sample size is 10 for each of Friday the 6th and Friday the 13th. Excel cannot evaluate the dates, and in this case ut is not required as between July 19990 till November 1992 Friday the 6th came 10 times and since 13 happens 1 week after the 6th, that also occurred 10 times.

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote