Question

1. A car dealer believes that average daily sales for four different dealerships in four separate states are equal. A random sample of days results in the following data on daily sales:

Ohio                New York       West Virginia              Pennsylvania

               3                          10                         3                                  20

               2                            0                         4                                  11

               6                            7                         5                                  8

               4                            8                                                             2

               4                            0                                                             14

               7

               2

Use ANOVA to test this claim at the 0.05 level.

2. Use Excel to support your answers to Question 1. Submit your completed Excel spreadsheet.

3. Suppose we have the following data on variable X (independent) and variable Y (dependent):

X         Y

2          70

0          70

4          130

1. By hand, determine the simple regression equation relating Y and X.

2. Calculate the R-Square measure and interpret the result.

3. Calculate the adjusted R-Square.

4. Test to see whether X and Y are significantly related using a test on the population correlation. Test this at the 0.05 level.

5. Test to see whether X and Y are significantly related using a t-test on the slope of X. Test this at the 0.05 level.

6. Test to see whether X and Y are significantly related using an F-test on the slope of X. Test this at the 0.05 level.

4. Suppose we have the following values for a dependent variable, Y, and three independent variables, X1, X2, and X3. The variable X3 is a dummy variable where 1 = male and 2 = female:

X1       X2       X3       Y

0          40        1          30

0          50        0          10

2          20        0          40

2          50        1          50

4          90        0          60

4          60        0          70

4          70        1          80

4          40        1          90

6          40        0          70

6          50        1          90

8          80        1          100

9          90        0          80

9          20        1          150

1. Run the multiple regression in Excel and provide the resulting multiple regression equation.
2. Provide the R-Square measure. Is this a good regression model? Explain. Use a level of significance of 0.05 in any tests you consider.

3. Which variables are important in explaining Y when the level of significance is 0.05? Is the dummy variable important at this level of significance? Discuss what the coefficients mean regarding the effect of each variable on Y.

4. Suppose a female with X1 = 5 and X2 = 80 is selecte What would be her predicted value of Y?

5. What types of problems might exist in this multiple regression?

Answer 1

Kindly post the other questions separately.