A sociologist is studying the age of the population in Blue Valley. Ten years ago, the population was such that 20% were under 20 years old, 14% were in the 20- to 35-year-old bracket, 30% were between 36 and 50, 24% were between 51 and 65, and 12% were over 65. A study done this year used a random sample of 210 residents. This sample is given below. At the 0.01 level of significance, has the age distribution of the population of Blue Valley changed? Under 20 20 - 35 36 - 50 51 - 65 Over 65 29 26 65 66 24 Please answer using excel A)  Find the sample test statistic. (Round your answer to two decimal places.) B) Find or estimate the P-value of the sample test statistic. C) Reject or Fail to Reject the Null Hypothesis

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Topic Video
Question

A sociologist is studying the age of the population in Blue Valley. Ten years ago, the population was such that 20% were under 20 years old, 14% were in the 20- to 35-year-old bracket, 30% were between 36 and 50, 24% were between 51 and 65, and 12% were over 65. A study done this year used a random sample of 210 residents. This sample is given below. At the 0.01 level of significance, has the age distribution of the population of Blue Valley changed?

Under 20 20 - 35 36 - 50 51 - 65 Over 65
29 26 65 66 24

Please answer using excel

A)  Find the sample test statistic. (Round your answer to two decimal places.)

B) Find or estimate the P-value of the sample test statistic.

C) Reject or Fail to Reject the Null Hypothesis

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Hypothesis Tests and Confidence Intervals for Proportions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman