A researcher is interested in determining if the weekend activities people engage in to alleviate stress are uniformly distributed among office workers. They collect data from a sample of 100 office workers to analyze. Using a significance level of a = 0.05, the researcher wants to establish whether there is any preference among these activities or if they are equally preferred. ● ● ● ● ACTIVITY Staying at home Hiking Yoga Attend Mass Shopping NUMBER OF OFFICE WORKERS 37 16 8 10 29 Solve the problem using Microsoft Excel with installed Megastat add-in. State what type of nonparametric test is to be used and explain why you chose such State the null hypothesis. Show how data was placed in Excel. Show your results with the p-value boxed in red. Show the rankings of your data (if applicable). Make a decision and give a conclusion.
A researcher is interested in determining if the weekend activities people engage in to alleviate stress are uniformly distributed among office workers. They collect data from a sample of 100 office workers to analyze. Using a significance level of a = 0.05, the researcher wants to establish whether there is any preference among these activities or if they are equally preferred. ● ● ● ● ACTIVITY Staying at home Hiking Yoga Attend Mass Shopping NUMBER OF OFFICE WORKERS 37 16 8 10 29 Solve the problem using Microsoft Excel with installed Megastat add-in. State what type of nonparametric test is to be used and explain why you chose such State the null hypothesis. Show how data was placed in Excel. Show your results with the p-value boxed in red. Show the rankings of your data (if applicable). Make a decision and give a conclusion.
Calculus For The Life Sciences
2nd Edition
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Chapter1: Functions
Section1.2: The Least Square Line
Problem 8E
Related questions
Question
![A researcher is interested in determining if the weekend activities people engage in to alleviate stress
are uniformly distributed among office workers. They collect data from a sample of 100 office workers
to analyze. Using a significance level of a = 0.05, the researcher wants to establish whether there is any
preference among these activities or if they are equally preferred.
●
●
●
●
●
●
ACTIVITY
Staying at home
Hiking
Yoga
Attend Mass
Shopping
NUMBER OF OFFICE WORKERS
37
16
8
10
29
Solve the problem using Microsoft Excel with installed Megastat add-in.
State what type of nonparametric test is to be used and explain why you chose such
State the null hypothesis.
Show how data was placed in Excel.
Show your results with the p-value boxed in red.
Show the rankings of your data (if applicable).
Make a decision and give a conclusion.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F9e0f646f-784a-403b-86ab-d94e408073e3%2F541d4fa1-1431-4cf2-9213-81b2bb884b30%2Foo72hs8_processed.jpeg&w=3840&q=75)
Transcribed Image Text:A researcher is interested in determining if the weekend activities people engage in to alleviate stress
are uniformly distributed among office workers. They collect data from a sample of 100 office workers
to analyze. Using a significance level of a = 0.05, the researcher wants to establish whether there is any
preference among these activities or if they are equally preferred.
●
●
●
●
●
●
ACTIVITY
Staying at home
Hiking
Yoga
Attend Mass
Shopping
NUMBER OF OFFICE WORKERS
37
16
8
10
29
Solve the problem using Microsoft Excel with installed Megastat add-in.
State what type of nonparametric test is to be used and explain why you chose such
State the null hypothesis.
Show how data was placed in Excel.
Show your results with the p-value boxed in red.
Show the rankings of your data (if applicable).
Make a decision and give a conclusion.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 8 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Calculus For The Life Sciences](https://www.bartleby.com/isbn_cover_images/9780321964038/9780321964038_smallCoverImage.gif)
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
![Calculus For The Life Sciences](https://www.bartleby.com/isbn_cover_images/9780321964038/9780321964038_smallCoverImage.gif)
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
![Glencoe Algebra 1, Student Edition, 9780079039897…](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
![Big Ideas Math A Bridge To Success Algebra 1: Stu…](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt