Use the ncbirths.xls data file(variables bweight, agem, gest, educm, agef, and educf)

a. Create HO: and HA

b. Determine whether to reject or retain Ho using the critical value approach and p-value approach

c. State your administrative conclusion

1. For the mother’s age variable, agem:

a. Is the average age of the mothers in the population greater than 25 years? α=.05

b. Does this change if α=.01

2. For the fathers age variable, agef:

a. Is the average age of fathers in the population great than 25 years? α=.05

b. Does this change if α=.01

3. For birth weight variable, bweight:

a. Is the average birth weight of babies in the population less than 7 pounds (112 ounces)? α=.05

b. Does this change if α=.01

ANOVA

Use the ncbirths.xls data file(variables bweight and agemcat)

1. Which is the response variable

2. Which is the factor

3. How many treatments are considered

4. Formulate the null and alternative hypothesis

5. Use excel to compute the ANOVA table

6. At a 5% level of significance would you reject or retain the null? Why?

Regression Analysis

Suppose a company manufactures washing machines. The managers believe that the quantity of washing machines sold depends on the price of their washing machine and the price of competitor’s washing machines. Management’s goal is to estimate the relationship using regression analysis. You are hired to complete the analysis, and are given the following data:

Own Price ($/unit)

Quantity Sold (in 1000)

Competitor Price ($/unit)

500

95

625

540

110

480

380

280

600

750

46

500

750

82

470

525

196

550

450

231

400

470

187

560

590

164

590

610

96

620

3. In Excel, obtain the descriptive statistics for each variable, and create a scatterplot for the two variables, Quantity Sold and Own Price. Be sure to pay attention to the axes. Based on the scatterplot, make a statement on the relationship between the variables.

4. Explain the causal relationship between Own Price and Quantity Sold. In this statement, identify the dependent variable (Y) and the independent variable (X).

5. Use Excel to estimate the model that you have developed in part 5, using alpha of 0.01.

6.…