# 1 - Sonoma State University

Document Sample

```					                                                                                             Taxes   Age
An auditor for a county government would like a model to predict the county taxes,            925      1
based on the age of single-family houses. Assuming a quadratic relationship between           870      2
age and taxes develop the model.                                                              809      4
720      4
a. Construct a scatter plot between age and county taxes.                                     694      5
b. State the quadratic regression equation.                                                   630      8
c. Predict the mean county taxes for a house that is 25 years old.                            626     10
d. Perform a residual analysis on the results and determine the adequacy of the model.        562     10
e. At the .05 level of significance, determine whether there is a significant relationship    546     12
between age and taxes.                                                                    523     15
f. At the .05 level of significance, determine whether the quadratic model is superior        480     20
to the linear model.                                                                       486     22
g. Interpret the meaning of the coefficient of multiple determination.                        462     25
441     25
426     30
368     35
350     40
348     50
322     50
Crazy Dave has expanded his analysis to include more variables. He has collected the data below for
baseball teams.

a. Develop the most appropriate regression model to predict a teams wins. Include residual analysis.
Provide a detailed explanation of the results.
b. Develop the most appropriate model to predict a teams ERA on the basis of hits allowed, walks
allowed, errors, and saves.

Team          League Wins E.R.A. Runs Scored Hits Allowed Walks Allowed Saves Errors
Anaheim                  0    95   3.75      761         1520          443        54    87
Baltimore                0    74   4.82      729         1492          580        38   107
Boston                   0    95   4.56      910         1579          440        38   109
Chicago White Sox        0    99   3.75      741         1450          459        54    94
Cleveland                0    93   3.96      790         1522          413        51   106
Detroit                  0    71   4.85      723         1521          461        37   110
Kansas City              0    56   6.00      701         1445          580        25   125
Minnesota                0    83   3.93      688         1441          348        44   102
New York Yankees         0    95   4.59      886         1552          463        46    95
Oakland                  0    88   3.82      772         1476          504        38    88
Seattle                  0    69   4.91      699         1408          496        39    86
Tampa Bay                0    67   5.62      750         1519          615        43   124
Texas                    0    79   5.04      865         1528          522        46   108
Toronto                  0    80   4.20      775         1480          444        55    95
Arizona                  1    77   4.58      696         1419          537        45    94
Atlanta                  1    90   3.65      769         1453          520        38    86
Chicago Cubs             1    79   4.17      703         1506          576        39   101
Cincinnati               1    73   5.38      820         1453          492        31   104
Colorado                 1    67   5.30      740         1477          603        37   118
Florida                  1    83   3.81      717         1499          563        42   103
Houston                  1    89   3.46      693         1400          440        45    89
Los Angeles              1    71   4.36      685         1374          471        40   106
Milwaukee                1    81   4.02      726         1413          569        46   119
New York Mets            1    83   3.71      722         1421          491        38   106
Philadelphia             1    88   4.20      807         1494          487        40    90
Pittsburgh               1    67   4.63      680         1445          612        35   117
St. Louis                1   100 3.61        805         1494          443        48   100
San Diego                1    82   4.49      684         1416          503        45   109
San Francisco            1    75   4.52      649         1427          592        46    90
Washington               1    81   4.03      639         1367          539        51    92
The real estate broker wants you to expand your analysis of appraised value to examin the variables below.

a. Develop the most appropriate multiple regression model to predict appraised value.
b. What conclusions can you reach concerning the difference in value between Glen Cove and Rosyln?

House
Size
Appraised                   Land       (square
Address            Value     Location       (acres)       feet)       Age        Rooms        Baths
9 Sycamore Road            466.0     Glen Cove      0.2297        2448         46           7          3.5
21 Jefferson St            364.0     Glen Cove      0.2192        1942         51           7          2.5
38 Hitching Post Lane      429.0     Glen Cove      0.1630        2073         29           5           3
4 Poppy Lane               548.4     Glen Cove      0.4608        2707         18           8          2.5
5 Daniel Drive             405.9     Glen Cove      0.2549        2042         46           7          1.5
15 Francis Terrace         374.1     Glen Cove      0.2290        2089         88           7           2
23 Guilfoy Street          315.0     Glen Cove      0.1808        1433         48           7           2
17 carlyle Drive           749.7     Glen Cove      0.5015        2991          7           9          2.5
8 Craft Avenue             217.7     Glen Cove      0.2229        1008         52           5           1
22 beechwood Ct.           635.7     Glen Cove      0.1300        3202         15           8          2.5
14 Fox Street              350.7     Glen Cove      0.1763        2230         54           8           2
7 Raynham Road             455.0     Glen Cove      0.4200        1848         48           7           2
2 Jerome Drive             356.2     Glen Cove      0.2520        2100         46           6           2
7 Valentine Street         271.7     Glen Cove      0.1148        1846         12           5           3
38 Jefferson Street        304.3     Glen Cove      0.1693        1331         64           5           1
15 Inwood Road             288.4     Glen Cove      0.1714        1344         52           8           1
29 Meadowfield Lane        396.7     Glen Cove      0.3849        1822         44           6           2
13 Westland Drive          613.5     Glen Cove      0.6545        2479         46           6          2.5
79 Valentine Street        314.1     Glen Cove      0.1722        1605         52           6           3
13 Fairmont Place          363.5     Glen Cove      0.1435        2080         78          11           2
1 Prestwick Terrace        364.3     Glen Cove      0.2755        2410         71           6           1
11 Clement Street          305.1     Glen Cove      0.1148        1753         97           8           2
7 Woodland Road            441.7     Glen Cove      0.3636        1884         45           7           2
36 Elm Avenue              353.1     Glen Cove      0.1474        2050         41          10           2
17 Duke Place              463.3     Glen Cove      0.2281        2978         40           6          2.5
12 Prospect Avenue         320.0     Glen Cove      0.4626        2132         82           7           1
1 Buckeye Road             332.8     Glen Cove      0.1889        1551         54           6           2
30 Ann Street              276.6     Glen Cove      0.1228        1129         44           5           1
26 Broadfield Place        397.0     Glen Cove      0.1492        1674         34           7           2
16 jackson Street          221.9     Glen Cove      0.0852        1184         94           5           1
182 Village Road           681.4      Roslyn        0.2828        2194         54           7          2.5
108 Burnham Avenue         606.0      Roslyn        0.1148        3032         74           8          2.5
143 Powerhouse Road        457.9      Roslyn        0.2169        1970         23           6           3
55 Hummingbird Drive       912.7      Roslyn        0.3761        3356         41           9          4.5
40 Maple Street            416.7      Roslyn        0.1359        2070         31          10           2
47 magnolia lane           726.6      Roslyn        0.2427        2826         54           8           2
35 harding Avenue          393.1      Roslyn        0.1540        1606         76           9           2
100 Crescent lane          612.4      Roslyn        0.2348        2063         54           6          2.5
222 Garden Street          355.4      Roslyn        0.2217        1392         85           7           1
6 Church Street            299.0      Roslyn        0.1750        1120         19           6          1.5
12 Ridge Drive             471.0      Roslyn        0.2130        1817         51           6           2
24 Madison Place           510.7      Roslyn        0.1377        2496         44           7           2
18 Rockhill Road    517.7   Roslyn   0.2497   1615    52   7    2
65 Elm Drive        873.3   Roslyn   0.4116   4067    45   8    4
30 Wren Drive       854.7   Roslyn   0.3372   3130    37   8    3
54 Lambert Street   374.8   Roslyn   0.1503   1423    88   6    2
38 Magnolia lane    543.0   Roslyn   0.2348   1799    54   6   2.5
75 Burnham Avenue   554.0   Roslyn   0.1148   2936    22   8   2.5
19 Oxford Street    365.2   Roslyn   0.1377   1439    53   7    1
215 Elm Drive       811.8   Roslyn   0.4560   4065    43   7   2.5
34 The Oaks         711.8   Roslyn   0.5563   2191    65   8    3
2 Circle lane       598.7   Roslyn   0.2778   2008    54   7   2.5
70 Rugby Road       651.3   Roslyn   0.2775   2070    52   6    2
150 Warner Avenue   511.1   Roslyn   0.2296   2710   104   7   2.5
31 West Court       379.3   Roslyn   0.1377   1416    65   7   1.5
7 The Locusts       786.0   Roslyn   0.2116   3244    72   6    2
65 Starling Court   768.7   Roslyn   0.3535   2493    36   6    3
106 Barberry lane   679.9   Roslyn   0.2348   2473    54   6   2.5
17 South Drive      615.8   Roslyn   0.3329   1968    49   6    2
8 Woodland Road     766.4   Roslyn   0.3606   3136    34   9   3.5
Garage
2
1
2
1
1
0
0
1
0
2
0
1
0
1
1
0
1
2
0
0
1
0
2
2
2
0
0
0
1
0
1
1
2
1
1
1
0
1
0
0
0
1
1
1
1
0
1
1
1
2
1
1
1
0
1
0
2
1
1
1

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 13 posted: 11/2/2011 language: English pages: 6