Excel LAB 1 Research Scenario Average IQ scores for young school children are known to be 100 (SD 15) However, the literature indicates that children's intelligence may be decreased if their mothers have German measles during pregnancy Using hospital records, a researcher obtained a sample of n 25 school children whose mothers all had German measles during their pregnancies Do the data indicate that children born to mothers who had German measles during the pregnancy have significantly lower IQ scores than typical young school children DATA (Fictional) child IQ scr 1 91 2 111 3 97 4 95 5 96 6 95 7 95 8 96 9 94 10 93 11 95 12 92 13 96 14 91 15 97 16 93 17 92 18 99 19 93 20 97 21 85 22 94 23 96 24 95 25 96 Excel Lab 1 Excel Lab 1 Questions What is the independent variable in the research study Is the independent variable categorical or quantitative What is the dependent variable in the research study Is the dependent variable categorical or quantitative What is the mean IQ for the sample What is the sample standard deviation What is the population mean What is the population standard deviation What is the population standard error of the mean ( s M s n ) Using the Excel STANDARDIZE function, calculate a z score for each IQ score What does a z score tell us Looking at the research scenario you will see that it says, literature indicates that children's intelligence may be decreased if their mothers have German measles during pregnancy Does this statement imply a one tail or two tail hypothesis test What is your research hypothesis What is your NULL hypothesis Convert the sample mean to a z score using the following formula z ( M m) s M where s M s n If our level of significance (alpha) was set at p 05 (5 ), the critical s scores would be established so that a 0 05 (5 ) is in the left tail and 0 00 (0 ) is in the right tail b 0 00 (0 ) is in the left tail and 0 05 (5 ) is in the right tail c 0 025 (2 5 ) is in the left tail and 0 0 25 (2 5 ) is in the right tail d None of the above Given that for a one tail test p (z score 1 64) 5 , what is our critical value Comparing our calculated z score (from 14) to the critical value in 16, would we conclude that the children's intelligence is or is not affected if their mothers have German measles during pregnancy Do we reject or fail to reject (accept) the NULL hypothesis

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 08, 2024

Excel LAB #1 Research Scenario Average IQ scores for young school children are known to be 100 (SD = 15).However, the literature indicates that children's

Excel LAB #1

Research Scenario

Average IQ scores for young school children are known to be 100 (SD = 15).However, the literature indicates that children's intelligence may be decreased if their mothers have German measles during pregnancy.Using hospital records, a researcher obtained a sample of n = 25 school children whose mothers all had German measles during their pregnancies.Do the data indicate that children born to mothers who had German measles during the pregnancy have significantly lower IQ scores than typical young school children?

DATA (Fictional)

child

IQ scr

111

Excel Lab # 1

Excel Lab #1 ----- Questions

What is the independent variable in the research study?

Is the independent variable categorical or quantitative?

What is the dependent variable in the research study?

Is the dependent variable categorical or quantitative?

What is the mean IQ for the sample?

What is the sample standard deviation?

What is the population mean?

What is the population standard deviation?

What is the population standard error of the mean? ( s_M = s/n )

Using the Excel STANDARDIZE function, calculate a z-score for each IQ score. What does a z-score tell us?

Looking at the research scenario you will see that it says, " literature indicates that children's intelligence may be decreased if their mothers have German measles during pregnancy"

Does this statement imply a one-tail or two-tail hypothesis test?

What is your research hypothesis?

What is your NULL hypothesis?

Convert the sample mean to a z score using the following formula:

z = (M- m)/s_Mwhere s_M = s/n

If our level of significance (alpha) was set at p< .05 (5%), the critical s-scores would be established so that

a.0.05 (5%) is in the left-tail and 0.00 (0%) is in the right-tail

b.0.00 (0%) is in the left-tail and 0.05 (5%) is in the right-tail

c.0.025 (2.5%) is in the left-tail and 0.0.25 (2.5%) is in the right-tail

d.None of the above

Given that for a one-tail test: p(z-score< -1.64) = 5% , what is our critical value?

Comparing our calculated z score (from # 14) to the critical value in #16, would we conclude that the children's intelligence is or is not affected if their mothers have German measles during pregnancy?