Question

Asked Dec 1, 2019

4 views

Using the Retirement funds spreadsheet, please determine if there is a significant difference between the average rate of return on Large Value and Large Growth stock funds.

a) What are the two variables of interest?

b) Write a null and alternative hypothesis statement

c) At the 95% significance level, is there significant evidence of a difference between fund rate of returns?

1 Rating

Step 1

a).

Here, we want to test if there is a significant difference between the average rate or return on large value and large growth stock funds.

Thus, the two variables of interest are “large value” and “large growth”.

Step 2

b).

The null and alternative hypotheses are stated below:

Step 3

c).

Step-by-step procedure to obtain the test statistic using Excel Mega stat is given below:

- In EXCEL, Select
**Add-Ins**>**Mega Stat**>**Hypothesis Tests**. - Choose
**Compare Two Independent Groups**. - Choose
**Data Input**. - In
**Group 1**, enter the column of**large Growth**. - In
**Group 2**, enter the column of**large value**. - Enter
**0**Under**Hypothesized difference**. - Check
**t-test (pooled variance)**, enter**Con...**

Tagged in

Q: Number 11

A: a.The null and the alternative hypotheses used for testing are given below:

Q: Find the z value that corresponds to the given area in the figure below. Use a graphing calculator a...

A: It is given that Z is the standard normal variable. The required z-value can be obtain using MINITAB...

Q: Suppose the neck size of men is normally distributed, with a mean of 15.5 inches and a standard devi...

A: Hey, since there are multiple subpart questions posted, we will answer first three subpart questions...

Q: You wish to test the following claim (HaHa) at a significance level of α=0.05. Ho:p1=p2 Ha...

A: Null Hypothesis: H0:p1=p2 Alternative Hypothesis: H1:p1<p2

Q: Views on the Death Penalty. The Pew Research group conducted a poll in which they asked," are you in...

A: The appropriate null and alternative hypotheses are shown below:H0: p1 = p2.Ha: p1 ≠ p2.The test sta...

Q: 3) Disney World requires that people employed as mickey mouse characters must have a height between ...

A: Hey, since there are multiple questions posted, we will answer first question. If you want any speci...

Q: In the previous problem, there was a correlation of .62 between hours spent playing video games and ...

A: The percent of the variance in hours spent playing video games is accounted for by hand-eye coordina...

Q: Lester Hollar is vice president for human resources for a large manufacturing company. In recent yea...

A: Degrees of freedom:For student’s t distribution, the degrees of freedom is n –1.The number of observ...

Q: Graph these data. Based on your graph, is there evidence to suggest the distribution is not uniform?

A: Given data