Complete the problems below from the textbook. You will need to use the "Baseball 2016 Data," "Lincolnville School District Bus Data," and the "Century National Bank Data" files for this assignment.The files are located in the topic materials.

1.Chapter 13 - Problem 63

2.Chapter 13 - Problem 64

3.Chapter 14 - Problem 35

4.Chapter 14 Case A - Century National Bank

For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output. This information is needed in order to receive full credit on these problems.

63.Refer to the Baseball 2016 data, which reports information on the 2016 Major League

Baseball season. Let attendance be the dependent variable and total team salary, in

millions of dollars be the independent variable. Determine the regression equation and

answer the following questions.

a)Draw a scatter diagram. From the diagram, does there seem to be a direct relationship

between the two variables?

b)What is the expected attendance for a team with a salary of $100.0 million?

c)If the owners pay an additional $30 million, how many more people could they expect to

attend?

d)At the .05 significance level, can we conclude that the slope of the regression line is

positive? Conduct the appropriate test of hypothesis.

e)What percentage of the variation in attendance is accounted for by salary?

f)Determine the correlation between attendance and team batting average and between

attendance and team ERA. Which is stronger? Conduct an appropriate test of hypothesis

for each set of variables.

64.Refer to the Lincolnville School bus data. Develop a regression equation that expresses the relationship between age of the bus and maintenance. The age of the bus is the independent

variable.

a)Draw a scatter diagram. What does this diagram suggest as to the relationship between

the two variables? Is it direct or indirect? Does it appear to be strong or weak?

b)Develop a regression equation. How much does an additional year add to the maintenance

cost. What is the estimated maintenance cost for a 10-year-old bus?

c)Conduct a test of hypothesis to determine whether the slope of the regression line is

greater than zero. Use the .05 significance level. Interpret your findings from parts (a),

(b), and (c) in a brief report.

35.Refer to the Lincolnville School District bus data. First, add a variable to change the type of engine (diesel or gasoline) to a qualitative variable. If the engine type is diesel, then set the qualitative variable to 0. If the bus type is gasoline, then set the qualitative variable to 1. Develop a

regression equation using statistical software with maintenance as the dependent variable

and age, odometer miles, miles since last maintenance and engine type the independent variables.

a)Develop a correlation matrix. Which independent variables have strong or weak correlations

with the dependent variable? Do you see any problems with multicollinearity?

b)Use a statistical software package to determine the multiple regression equation. How did you select the variables to include in the equation? How did you use the information from the correlation analysis? Show that your regression equation shows a significant relationship. Write out the regression equation and interpret its practical application. Report and interpret the R-square.

c)Develop a histogram or a stem-and-leaf display of the residuals from the final regression

equation developed in part (f). Is it reasonable to conclude that the normality assumption

has been met?

d)Plot the residuals against the fitted values from the final regression equation developed

in part (f) against the fitted values ofY.Plot the residuals on the vertical axis and the fitted

values on the horizontal axis.

A. The Century National Bank

Refer to the Century National Bank data. Using checking

account balance as the dependent variable and using as

independent variables the number of ATM transactions, the

number of other services used, whether the individual has a

debit card, and whether interest is paid on the particular account,

write report indicating which of the variables seem

related to the account balance and how well they explain

the variation in account balances. Should all of the independent

variables proposed be used in the analysis or can

some be dropped.

AutoSave O OFF ^ H E . 0 7 3 SYM-506-RS-Baseball 2016 Data Home Draw Page Layout Formulas Data Comic Sans MS ap Wrap Text v General Paste Merge & Center v Conditional Format Cell Formatting as Table Styles 433 A B E F G H I J M N O League Opened Team Salary Attendance Wins ERA BA HR Year Average Salary Arizona National 1998 65.80 2080145 79 4.04 0.264 154 2000 1.99 National 1996 67 4.41 0,251 100 2001 Baltimore American 118.90 2281202 81 4.05 0.25 217 2002 2.38 Boston American 1912 168,70 2880694 78 4.31 0.265 161 2003 2.56 7 Chicago Cubs National 117.20 2959812 97 3.36 0.244 171 2004 2.49 8 Chicago White Sox American 1991 110.70 1755810 76 0,25 136 2005 9 Cincinnati National 2003 117.70 2419506 64 4.33 0.248 167 2006 2.87 10 Cleveland American 1994 87.70 1388905 81 3.67 0.256 141 2007 2.94 National 1995 98,30 2506789 68 5.04 0.265 186 2008 3.15 Detroit American 2726048 74 0.27 151 13 Houston American 2000 69.10 2153585 86 3.57 230 2010 3.3 14 Kansas City American 112.90 2708549 95 3.73 139 2011 15 LA Angels American 1966 146.40 3012765 85 0.246 176 2012 3.44 16 LA Dodgers National 230.40 3764815 92 3.44 0,25 187 2013 3.65 17 Miami 84.60 1752235 71 0.26 120 2014 3.95 18 Milwaukee National 98.70 2542558 68 145 2015 4.25 American 2010 108.30 2220054 83 4.07 0.247 156 2016 4.4 20 Ny Mets National 2009 100.10 2569753 90 3,43 0.244 177 21 NY Yankees American 2009 213.50 3193795 87 4.05 0,251 212 22 Oakland American 1966 80.80 1768175 68 4,14 0,251 146 23 Philadelphia National 2004 133.00 1831080 63 0.249 130 24 Pittsburgh National 85.90 2498596 98 0.26 140 25 San Diego National 126.60 74 4.09 0.243 148 26 San Francisco 2000 166.50 3375882 84 3,72 0.267 136 27 Seattle American 123.20 2193581 76 0.249 198 28 St. Louis National 2006 120.30 3520889 137 29 Tampa Bay American 1990 74.80 1287054 80 167 30 Texas American 144.80 2491875 88 2.24 0,257 172 31 Toronto American 116.40 2794891 93 3.8 0.269 232 32 Washington National 2008 174.50 2619843 83 3.62 0.251 177 33AutoSave O OFF # SYM-506-RS-Century National Bank Data-3.xls - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) * 11 AA" ap Wrap Text v General Conditional Format Paste B IUV OvAv Merge & Center v $ ~ % " Formatting as Table A1 X V fx Balance B C F G H K M N 0 P Q R S Balance ATM Services Debit Interest City 1756 1 748 - N 501 0 0 1622 0 1886 0 740 1593 1169 0 1554 1474 -oooo--ooo- N NA U NA - NNNN - A WAS UN - AW - WAN -- ANNNOWNWNW- WA-AWA Sheet1 +Data Set 3 -Lincolnville School District Bus Data Engine Type Maintenance Odometer ID Manufacturer 0=diesel) Capacity Cost Age Miles Miles 10 Keiser 14 4646 54375 11973 396 Thompson 14 1072 21858 11969 122 Bluebird 55 9394 10 116580 11967 751 Keiser 14 1078 22444 11948 279 Bluebird 55 1008 22672 11925 500 Bluebird 55 5329 50765 11922 Variables 520 Bluebird 55 4794 119130 11896 759 Keiser 55 3952 87872 11889 ID = Bus identification number 714 Bluebird 42 3742 73703 11837 875 Bluebird 55 4376 97947 11814 Manufacturer = Source of the bus (Bluebird, Keiser, or Thompson) 600 Bluebird 55 4832 10 119860 11800 953 Bluebird 55 5160 10 117700 11798 Engine type = If the engine is diesel then engine type =0; if the engine is gasoline, then engine type = 1) 101 Bluebird 55 1955 41096 11789 Bluebird 2775 11782 Capacity = number of seats on the bus 358 55 70086 29 Bluebird 55 5352 69438 11781 55 3065 11778 Maintenance cost = dollars spent to maintain a bus last year 365 Keiser 63384 162 Keiser 55 3143 31266 11757 686 Bluebird 55 1569 34674 11707 Age = number of years since the bus left the manufacturer 370 Keiser 55 1766 86528 11704 Odometer Miles = total number of miles traveled by a bus 887 Bluebird 55 3743 93672 11698 464 Bluebird 55 2540 34530 11698 948 Keiser 42 4342 97956 11691 Miles = number of miles traveled since last maintenance 678 Keiser 55 3361 75229 11668 481 Keiser 6 3097 34362 11662 Bluebird 55 8263 102969 11615 704 Bluebird 55 4218 83424 11610 814 Bluebird 55 2028 40824 11576 39 Bluebird 55 5821 69444 11533 699 Bluebird 55 9069 98307 11518 75 Bluebird 55 3011 71970 11462 693 Keiser 55 9193 101889 11461 989 Keiser 55 4795 106605 11418 982 Bluebird 55 505 10276 11359 321 Bluebird 42 2732 70122 11358 724 Keiser 42 3754 91968 11344 732 Keiser 42 4640 101196 11342 880 Keiser 55 8410 97065 11336 193 Thompson 14 5922 128711 11248 884 Bluebird 55 4364 92457 11231 Alnehird 2190 703An