252x0773 11/19/07 (Page layout view!)
ECO252 QBA2 Name ______
THIRD EXAM Student number______
November 26, 2007 Class Day and hour______
Version 3
I. (8 points) Do all the following (2points each unless noted otherwise).Make Diagrams! Show your work!
1.
2.
3.
4.
II. (22+ points) Do all the following (2points each unless noted otherwise).Do not answer a question ‘yes’ or ‘no’ without giving reasons. Show your work when appropriate. Use a 5% significance level except where indicated otherwise. Note that this is extremely long and that no one will do all the problems, so look them over!
1. Turn in your computer problems 2 and 3 marked as requested in the Take-home. (5 points, 2 point penalty for not doing.)
2. In an ordinary 1-way ANOVA, if the computed F statistic exceeds the value from the F table at the given significance level, we can
a. Reject the null hypothesis because the difference between the means is not significant
b. Reject the null hypothesis because there is evidence of a significant difference between some of the means.
c. Not reject the null hypothesis because the difference between the means is not significant.
d. Not reject the null hypothesis because the difference between the means is significant.
c. Not reject the null hypothesis because the difference between the variances is not significant.
d. Not reject the null hypothesis because the difference between the variances is significant.
e. None of the above.[7]
3. After an analysis if variance, you would use the Tukey-Kramer procedure or similar confidence intervals to check
a. For Normality
b. For equality of variances
c. For independence of error terms
d. For pairwise differences in means
e. For all of the above
f. For none of the above
4. If an ordinary one-way ANOVA has 17 columns 25 rows and , the degrees of freedom for the F test has
a. 400 and 24
b. 408 and 16
c. 24 and 400
d. 16 and 408
e. 400 and 424
f. 408 and 424
g. 424 and 400
h. 424 and 408
i. 16 and 24
j. None of the above. The correct answer is ______.
5. Assuming that your answer to 4 is correct and that the significance level is 5%, the correct value of F from the table is ______. (This may have to be approximate. If so, what did you use?) (1) [12]
Exhibit 1A manager believes that the number of sales that an employee makes is related to the number of years worked and their score on an aptitude test. He runs the data below on Minitab and gets the following
Employee Sales Years Score
1 100 10 70
2 90 3 100
3 80 8 90
4 70 5 40
5 60 5 80
6 50 7 50
7 40 1 40
8 30 1 10
MTB > regress c1 2 c2 c3
Regression Analysis: Sales versus Years, Score
The regression equation is
Sales = 21.3 + 3.10 Years + 0.470 Score
Predictor Coef SE Coef T P
Constant 21.29 13.14 1.62 0.166
Years 3.103 1.984 1.56 0.179
Score 0.4698 0.2133 2.20 0.079
S = 15.1088 R-Sq = 72.8% R-Sq(adj) = 62.0%
Analysis of Variance
Source DF SS MS F P
Regression 2 3058.6 1529.3 6.70 0.038
Residual Error 5 1141.4 228.3
Total 7 4200.0
Source DF Seq SS
Years 1 1951.4
Score 1 1107.3
The sum of the sales column is 520 and the sum of the squared numbers in the sales column is not needed.
The sum of the 'years' column is 40 and the sum of the squared numbers in the years column is 274.
The sum of the score column is 480 and the sum of the squared numbers in the score column is 35200
If Sales is the dependent variable and years and score are the independent variables we have found that the sum of x1y is 2980 and the sum of x1 x2 is 2720. The sum of x2y has not been computed.
6. In the multiple regression, what coefficients are significant at the 10% significance level? (2)
7. In the multiple regression, what coefficients are significant at the 5% significance level? (1)[15]
8. Assuming that the coefficients in the multiple regression are correct, how many sales would we predict for someone with 5 years of experience and a score of 80? (1)
9. Using the information in the multiple regression printout, make your result is 8) into a rough prediction interval. (2)
10. Using the information in the printout, what is the value of R-squared for a regression of ‘sales’ against ‘years’ alone? (2) [20]
1
252x0773 11/19/07 (Page layout view!)
Exhibit 1
Empl Sales Years Score
1 100 10 70
2 90 3 100
3 80 8 90
4 70 5 40
5 60 5 80
6 50 7 50
7 40 1 40
8 30 1 10
Regression Analysis: Sales versus Years, Score
The regression equation is
Sales = 21.3 + 3.10 Years + 0.470 Score
Predictor Coef SE Coef T P
Constant 21.29 13.14 1.62 0.166
Years 3.103 1.984 1.56 0.179
Score 0.4698 0.2133 2.20 0.079
S = 15.1088 R-Sq = 72.8% R-Sq(adj) = 62.0%
Analysis of Variance
Source DF SS MS F P
Regression 2 3058.6 1529.3 6.70 0.038
Residual Error 5 1141.4 228.3
Total 7 4200.0
Source DF Seq SS
Years 1 1951.4
Score 1 1107.3
1
252x0773 11/19/07 (Page layout view!)
The sum of the sales column is 520 and the sum of the squared numbers in the sales column is not needed.
The sum of the years column is 40 and the sum of the squared numbers in the years column is 274.
The sum of the score column is 480 and the sum of the squared numbers in the score column is 35200
If Sales is the dependent variable and years and score are the independent variables we have found that the sum of x1y is 2980 and the sum of x1 x2 is 2720. The sum of x2y has not been computed.
11. Do a simple regression of ‘sales’ against ‘score’ alone.
a) Compute the sum that you will need for this regression. Show your work! (2) Don’t compute stuff that has already been done for you!
b) It says that you do not need to know the sum of squares in the sales column. You do however need the spare part . Without doing any computing, tell what its value is. (1)
c) Compute the coefficients of the equation to predict the value of ‘sales’ on the basis of ‘score.’ (4) [27]
d) Compute . (3)
Exhibit 1
1
252x0773 11/19/07 (Page layout view!)
Empl SalesYearsScore
1 100 10 70
2 90 3 100
3 80 8 90
4 70 5 40
5 60 5 80
6 50 7 50
7 40 1 40
8 30 1 10
Regression Analysis: Sales versus Years, Score
The regression equation is
Sales = 21.3 + 3.10 Years + 0.470 Score
Predictor Coef SE Coef T P
Constant 21.29 13.14 1.62 0.166
Years 3.103 1.984 1.56 0.179
Score 0.4698 0.2133 2.20 0.079
S = 15.1088 R-Sq = 72.8% R-Sq(adj) = 62.0%
Analysis of Variance
Source DF SS MS F P
Regression 2 3058.6 1529.3 6.70 0.038
Residual Error 5 1141.4 228.3
Total 7 4200.0
Source DF Seq SS
Years 1 1951.4
Score 1 1107.3
1
252x0773 11/19/07 (Page layout view!)
The sum of the sales column is 520 and the sum of the squared numbers in the sales column is not needed.
The sum of the years column is 40 and the sum of the squared numbers in the years column is 274.
The sum of the score column is 480 and the sum of the squared numbers in the score column is 35200
If Sales is the dependent variable and years and score are the independent variables we have found that the sum of x1y is 2980 and the sum of x1 x2 is 2720. The sum of x2y has not been computed.
e) Is the slope in this regression significant at the 5% level? Do not answer this question without appropriate calculations! (4)
f) Predict the average number of sales individuals with a score of 75 will make and make your estimate into an appropriate 95% interval. (4)
g) Do an analysis of variance using your SST, SSE and SSR for this equation or using 1, and . What have you already done that makes this table redundant? If you don’t know what redundant means, ask! (3) [43]
h) Using the information on Regression Sums of squares or and in the ANOVA that you just did and from the multiple regression, do an F test to see if adding ‘years’ to the regression of ‘sales’ against ‘score’ is worthwhile. Do not waste our time by repeating stuff that has already been done. (3) [46]
Exhibit 2 (Groebner)A product is being produced on 3 different lines using 3 different layouts for the lines. A sample of 36 observations are taken on various days over a period of four weeks so that there are 12 observations for the daily output for each line evenly divided between the three possible layouts. Assume .
MTB > Twoway c6 c2 c3;
SUBC> Means c2 c3.
Two-way ANOVA: output 3 versus line, layout
Source DF SS MS F P
line 2 188.4 94.2 0.24 0.789
layout 2 27832.1 13916.0 35.29 0.000
Interaction __ 1859.1 _____ 1.18 0.342
Error __ 10648.0 _____
Total 35 40527.6
S = 19.86 R-Sq = 73.73% R-Sq(adj) = 65.94%
Individual 95% CIs For Mean Based on
Pooled StDev
line Mean ------+------+------+------+---
1 132.333 (------*------)
2 127.250 (------*------)
3 127.750 (------*------)
------+------+------+------+---
120.0 128.0 136.0 144.0
Individual 95% Cis For Mean Based on
Pooled StDev
layout Mean ----+------+------+------+-----
1 116.917 (----*---)
2 167.583 (----*----)
3 102.833 (----*----)
----+------+------+------+-----
100 125 150 175
12. Fill in the missing degrees of freedom and the missing mean squares. (2) [48]
13. Is there significant interaction between ‘line’ and ‘layout’? Don’t answer unless you can tell me what the evidence is. (2)
14. Is the difference between lines significant? Why?(1)
15. Do a confidence interval of your choice for the difference between layout 1 and layout 3. Tell what kind of interval you are using , what its characteristics are and whether it shows a significant difference. (4)[55]
16. (Groebner) An industrial firm analyses the amount of breakage (in dollar cost) that occurs using 3 different shipping methods and four products. There is a strong likelihood that the data does not come from the Normal distribution. The purpose of the test is to see if the four shipping methods differ in breakage and the analysis is blocked by product.
RailPlaneTruck
Product 1796080538818
Product 2839977649432
Product 3942991969260
Product 4602258215676
The most appropriate method for doing this test is:
a) The Friedman Test
b) The Kruskal-Wallis Test
c) One-way ANOVA
d) Two-way ANOVA
e) The sign test [57]
f) Another test (Name it!)
17. Assume that your decision is correct in 16. What is your null hypothesis or hypotheses? Be specific! Are you talking about rows or columns or both? Are you comparing means, medians, proportions or variances?
18. OK. Let’s see you do the test. (4)[63]
(Blank)
ECO252 QBA2
THIRD EXAM
Nov 26-29, 2007
TAKE HOME SECTION
Name: ______
Student Number: ______
Class days and time : ______
Please Note: Computer problems 2 and 3 should be turned in with the exam (2). In problem 2, the 2 way ANOVA table should be checked. The three F tests should be done with a 1% significance level and you should note whether there was (i) a significant difference between drivers, (ii) a significant difference between cars and (iii) significant interaction. In problem 3, you should show on your third graph where the regression line is. You should explain whether the coefficients are significant at the 1% level. Check what your text says about normal probability plots and analyze the plot you did. Explain the results of the t and F tests using a 5% significance level. (3)
III Do the following. (22+ points) Note: Look at 252thngs (252thngs) on the syllabus supplement part of the website before you start (and before you take exams). Show your work! State and where appropriate. You have not done a hypothesis test unless you have stated your hypotheses, run the numbers and stated your conclusion. (Use a 95% confidence level unless another level is specified.) Answers without reasons or accompanying calculationsusually are not acceptable. Neatness and clarity of explanation are expected. This must be turned in when you take the in-class exam. Note that from now on neatness means paper neatly trimmed on the left side if it has been torn, multiple pages stapled and paper written on only one side.Show your work!
1) The Lees, in their book on statistics for Finance majors, ask about the relationship of gasoline prices in cents per gallon to crude oil prices in dollars per barrel and present the data for the years 1975 - 1988. I have obtained most of the data for the years 1980 – 2007. It is presented below.
Row Year GasPrice CrudePrice Yr-1979
1 1980 1.25 26.07 1
2 1981 1.38 35.24 2
3 1982 1.30 31.87 3
4 1983 1.24 26.99 4
5 1984 1.21 28.63 5
6 1985 1.20 26.25 6
7 1986 0.93 14.55 7
8 1987 0.95 17.90 8
9 1988 0.96 14.67 9
10 1989 1.02 17.97 10
11 1990 1.16 22.22 11
12 1991 1.14 19.06 12
13 1992 1.13 18.43 13
14 1993 1.11 16.41 14
15 1994 1.11 15.59 15
16 1995 1.15 17.23 16
17 1996 1.23 20.71 17
18 1997 1.23 19.04 18
19 1998 1.06 12.52 19
20 1999 1.17 17.51 20
21 2000 1.51 28.26 21
22 2001 1.46 22.95 22
23 2002 1.36 24.10 23
24 2003 1.59 28.53 24
25 2004 1.88 36.98 25
26 2005 2.30 50.23 26
27 2006 * *
28 2007 3.10 90.00
This data set also contains the year with 1979 subtracted from it . You may need to use this later. Ignore it in Problem 1. Note that the numbers for 2006 have not yet been published in my source, Statistical Abstract of the United States, and that the numbers for 2007 are my estimates for third quarter prices. These are unleaded prices, which the Lees did not use. You are supposed to use only the numbers for 1990 through 2006 and one other observation for your data. You will thus have observations. The other column is the value for the year , where a is the second to last digit of your student number. If you are unsure of the data that you are using or if you want help with the sums that you need to do the regression go to 3takehome072a.
Show your work – it is legitimate to check your results by running the problem on the computer. (In fact, I will give you 2 points extra credit for checking it and annotating the output for significance tests etc.) But I expect to see hand computations for every part of this problem.
a. Compute the regression equation to predict the price of gasoline on the basis of crude oil prices. (3)
b. Compute. (2)
c. Compute . (2)
d. Compute and do a significance test on (2)
e. Compute a confidence interval for . (2)
f. You have a crude price for 2007. Using this, predict the gasoline price for 2007 and create a prediction interval for the price of gasoline for that year. Explain why a confidence interval for the price is inappropriate and check to see if my estimated price is in the interval. (3)
g. Do an ANOVA for this regression. (3)
f) Make a graph of the data. Show the trend line and the data points clearly. If you are not willing to do this neatly and accurately, don’t bother. (2) [19]
2) Now we can use the date to see if there is a trend line in addition to the effect of crude oil.
a. Do a multiple regression of the price of gasoline against crude prices and the data variable, which has been massaged to make 1980 year 1. This involves a simultaneous equation solution. Attempting to recycle from the previous page won’t work. (7)
c. Compute the regression sum of squares and use it in an ANOVA F test to test the usefulness of this regression. (4)
b. Compute and adjusted for degrees of freedom for both this and the previous problem. Compare the values of adjusted between this and the previous problem. Use an F test to compare here with the from the previous problem. The F test here is one to see if adding a new independent variable improves the regression. This can also be done by modifying the ANOVAs in b.(4)
d. Use your regression to predict the price of gasoline in 2007. Is this closer to the estimated gasoline price? Do a confidence interval and a prediction interval. (3) [37]
e. Again there is extra credit for checking your results on the computer. Use the pull-down menu or try Regress GasPrice on 2 CrudePrice Yr-1979 (2)
3) According to Russell Langley, three sopranos were discussing their recent performances. Fifi noted that she got 36 curtain calls at La Scala last week, but Adalina put her down with the fact that she got 39. Could one of the singers really say that she had more curtain calls than another or could the differences just be due to chance?
Personalize the data below by adding the last digit of your student number to each number in the first row. Use a 10% significance level throughout this question.
Row Fifi Adelina Maria
1 36 39 21
2 22 14 32
3 19 20 28
4 16 18 22
a) State your hypothesis and use a method to compare means assuming that each column represents a random sample of curtain calls at La Scala. (4)
b) Still assuming that these are random samples, use a method that compares medians instead. (3)
c) Actually, these were not random samples. Though row 1 represents curtain calls at La Scala (Milan), row 2 was in Venice, row 3 in Naples and row 4 in Rome. Will this affect our results? Does this show anything about audiences on the four cities? Use an appropriate method to compare medians. (5)
d) Do two different types of confidence intervals between Milan and the least enthusiastic opera house.
Explain the difference between the intervals. (2)
e) Assume that we want to compare medians instead. How does the fact that these data were collected at three opera houses affect the results? (3)
f) Do you prefer the methods that compare medians or means? Don’t answer this unless you can demonstrate an informed opinion. (1)
g) (Extra credit) Do a Levine test on these data and explain what it tests and shows.(3)
h) (Extra credit)Check your work on the computer. This is pretty easy to do. Use the same format as in Computer Problem 2, but instead of car and driver numbers use the singers’ and cities’ names. You can use the stat and ANOVA pull-down menus for One-way ANOVA, two-way ANOVA and comparison of variances of the columns. You can use the stat and the non-parametrics pull-down menu for Friedman and Kruskal-Wallis. You also probably ought to test columns for Normality. Use the Statistics pull-down menu and basic statistics to find the normality tests. The Kolmogorov-Smirnov option is actually Lilliefors. The ANOVA menu can check for equality of variances. In light of these tests was ANOVA appropriate? You can get descriptions of unfamiliar tests by using the Help menu and the alphabetic command list or the Stat guide. (Up to 7) [58]
You should note conclusions on the printout – tell what was tested and what your conclusions are using a 10% significance level.
1