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
icon
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.
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
steps

Step by step

Solved in 8 steps with 2 images

Blurred answer
Recommended textbooks for you
Calculus For The Life Sciences
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…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt