Essay on Midterm guid

Submitted By needanC
Words: 501
Pages: 3

Hypothesis Testing
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.